sql(sql, hdrs=None, typed=None)
Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.
sqlGet(sql, hdrs=None, typed=None)
Executes an SQL SELECT/SHOW/DESCRIBE statement.
sqlGet_media(sql, hdrs=None, typed=None)
Executes an SQL SELECT/SHOW/DESCRIBE statement.
sql_media(sql, hdrs=None, typed=None)
Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.
sql(sql, hdrs=None, typed=None)
Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement. Args: sql: string, An SQL SELECT/SHOW/DESCRIBE/INSERT/UPDATE/DELETE/CREATE statement. (required) hdrs: boolean, Should column names be included (in the first row)?. Default is true. typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true. Returns: An object of the form: { # Represents a response to an sql statement. "kind": "fusiontables#sqlresponse", # Type name: a template for an individual table. "rows": [ # The rows in the table. For each cell we print out whatever cell value (e.g., numeric, string) exists. Thus it is important that each cell contains only one value. [ "", ], ], "columns": [ # Columns in the table. "A String", ], }
sqlGet(sql, hdrs=None, typed=None)
Executes an SQL SELECT/SHOW/DESCRIBE statement. Args: sql: string, An SQL SELECT/SHOW/DESCRIBE statement. (required) hdrs: boolean, Should column names be included (in the first row)?. Default is true. typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true. Returns: An object of the form: { # Represents a response to an sql statement. "kind": "fusiontables#sqlresponse", # Type name: a template for an individual table. "rows": [ # The rows in the table. For each cell we print out whatever cell value (e.g., numeric, string) exists. Thus it is important that each cell contains only one value. [ "", ], ], "columns": [ # Columns in the table. "A String", ], }
sqlGet_media(sql, hdrs=None, typed=None)
Executes an SQL SELECT/SHOW/DESCRIBE statement. Args: sql: string, An SQL SELECT/SHOW/DESCRIBE statement. (required) hdrs: boolean, Should column names be included (in the first row)?. Default is true. typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true. Returns: The media object as a string.
sql_media(sql, hdrs=None, typed=None)
Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement. Args: sql: string, An SQL SELECT/SHOW/DESCRIBE/INSERT/UPDATE/DELETE/CREATE statement. (required) hdrs: boolean, Should column names be included (in the first row)?. Default is true. typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true. Returns: The media object as a string.