Fix Cloud SQL example (MySQL) (GoogleCloudPlatform#2309)

joangro · gguuss · commit ff9a856c4905 · 2019-08-15T17:00:17.000-07:00
The sample has the wrong format for `unix_socket` inside the query parameter in sqlalchemy.create_engine.

Doing:

    '/cloudsql/{}/'.format(cloud_sql_connection_name)

takes the path as a directory so the ending slash needs to be removed:

    '/cloudsql/{}'.format(cloud_sql_connection_name)
diff --git a/cloud-sql/mysql/sqlalchemy/main.py b/cloud-sql/mysql/sqlalchemy/main.py
@@ -43,7 +43,7 @@
         password=db_pass,
         database=db_name,
         query={
-            'unix_socket': '/cloudsql/{}/'.format(cloud_sql_connection_name)
+            'unix_socket': '/cloudsql/{}'.format(cloud_sql_connection_name)
         }
     ),
     # ... Specify additional properties here.

Original file line number	Diff line number	Diff line change
`@@ -43,7 +43,7 @@`
`43`	`43`	`password=db_pass,`
`44`	`44`	`database=db_name,`
`45`	`45`	`query={`
`46`		`- 'unix_socket': '/cloudsql/{}/'.format(cloud_sql_connection_name)`
	`46`	`+ 'unix_socket': '/cloudsql/{}'.format(cloud_sql_connection_name)`
`47`	`47`	`}`
`48`	`48`	`),`
`49`	`49`	`# ... Specify additional properties here.`