| <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_v2.html">Fusion Tables API</a> . <a href="fusiontables_v2.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 a Fusion Tables SQL statement, which can be any of </p> |
| <p class="toc_element"> |
| <code><a href="#sqlGet">sqlGet(sql, hdrs=None, typed=None)</a></code></p> |
| <p class="firstline">Executes a SQL statement which can be any of </p> |
| <p class="toc_element"> |
| <code><a href="#sqlGet_media">sqlGet_media(sql, hdrs=None, typed=None)</a></code></p> |
| <p class="firstline">Executes a SQL statement which can be any of </p> |
| <p class="toc_element"> |
| <code><a href="#sql_media">sql_media(sql, hdrs=None, typed=None)</a></code></p> |
| <p class="firstline">Executes a Fusion Tables SQL statement, which can be any of </p> |
| <h3>Method Details</h3> |
| <div class="method"> |
| <code class="details" id="sql">sql(sql, hdrs=None, typed=None)</code> |
| <pre>Executes a Fusion Tables SQL statement, which can be any of |
| - SELECT |
| - INSERT |
| - UPDATE |
| - DELETE |
| - SHOW |
| - DESCRIBE |
| - CREATE statement. |
| |
| Args: |
| sql: string, A Fusion Tables SQL statement, which can be any of |
| - SELECT |
| - INSERT |
| - UPDATE |
| - DELETE |
| - SHOW |
| - DESCRIBE |
| - CREATE (required) |
| hdrs: boolean, Whether column names are included in the first row. Default is true. |
| typed: boolean, Whether typed values are 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 a SQL statement. |
| "kind": "fusiontables#sqlresponse", # The kind of item this is. For responses to SQL queries, this is always fusiontables#sqlresponse. |
| "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 a SQL statement which can be any of |
| - SELECT |
| - SHOW |
| - DESCRIBE |
| |
| Args: |
| sql: string, A SQL statement which can be any of |
| - SELECT |
| - SHOW |
| - DESCRIBE (required) |
| hdrs: boolean, Whether column names are included (in the first row). Default is true. |
| typed: boolean, Whether typed values are 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 a SQL statement. |
| "kind": "fusiontables#sqlresponse", # The kind of item this is. For responses to SQL queries, this is always fusiontables#sqlresponse. |
| "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 a SQL statement which can be any of |
| - SELECT |
| - SHOW |
| - DESCRIBE |
| |
| Args: |
| sql: string, A SQL statement which can be any of |
| - SELECT |
| - SHOW |
| - DESCRIBE (required) |
| hdrs: boolean, Whether column names are included (in the first row). Default is true. |
| typed: boolean, Whether typed values are 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 a Fusion Tables SQL statement, which can be any of |
| - SELECT |
| - INSERT |
| - UPDATE |
| - DELETE |
| - SHOW |
| - DESCRIBE |
| - CREATE statement. |
| |
| Args: |
| sql: string, A Fusion Tables SQL statement, which can be any of |
| - SELECT |
| - INSERT |
| - UPDATE |
| - DELETE |
| - SHOW |
| - DESCRIBE |
| - CREATE (required) |
| hdrs: boolean, Whether column names are included in the first row. Default is true. |
| typed: boolean, Whether typed values are 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> |
