<html><body> <style> body, h1, h2, h3, div, span, p, pre, a { margin: 0; padding: 0; border: 0; font-weight: inherit; font-style: inherit; font-size: 100%; font-family: inherit; vertical-align: baseline; } body { font-size: 13px; padding: 1em; } h1 { font-size: 26px; margin-bottom: 1em; } h2 { font-size: 24px; margin-bottom: 1em; } h3 { font-size: 20px; margin-bottom: 1em; margin-top: 1em; } pre, code { line-height: 1.5; font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace; } pre { margin-top: 0.5em; } h1, h2, h3, p { font-family: Arial, sans serif; } h1, h2, h3 { border-bottom: solid #CCC 1px; } .toc_element { margin-top: 0.5em; } .firstline { margin-left: 2 em; } .method { margin-top: 1em; border: solid 1px #CCC; padding: 1em; background: #EEE; } .details { font-weight: bold; font-size: 14px; } </style> <h1><a href="fusiontables_v1.html">Fusion Tables API</a> . <a href="fusiontables_v1.query.html">query</a></h1> <h2>Instance Methods</h2> <p class="toc_element"> <code><a href="#sql">sql(sql, hdrs=None, typed=None)</a></code></p> <p class="firstline">Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.</p> <p class="toc_element"> <code><a href="#sqlGet">sqlGet(sql, hdrs=None, typed=None)</a></code></p> <p class="firstline">Executes an SQL SELECT/SHOW/DESCRIBE statement.</p> <p class="toc_element"> <code><a href="#sqlGet_media">sqlGet_media(sql, hdrs=None, typed=None)</a></code></p> <p class="firstline">Executes an SQL SELECT/SHOW/DESCRIBE statement.</p> <p class="toc_element"> <code><a href="#sql_media">sql_media(sql, hdrs=None, typed=None)</a></code></p> <p class="firstline">Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.</p> <h3>Method Details</h3> <div class="method"> <code class="details" id="sql">sql(sql, hdrs=None, typed=None)</code> <pre>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", ], }</pre> </div> <div class="method"> <code class="details" id="sqlGet">sqlGet(sql, hdrs=None, typed=None)</code> <pre>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", ], }</pre> </div> <div class="method"> <code class="details" id="sqlGet_media">sqlGet_media(sql, hdrs=None, typed=None)</code> <pre>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. </pre> </div> <div class="method"> <code class="details" id="sql_media">sql_media(sql, hdrs=None, typed=None)</code> <pre>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. </pre> </div> </body></html>