You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
170 lines
4.8 KiB
170 lines
4.8 KiB
<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> |