docs/dyn/fusiontables_v1.query.html

<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>