• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1<html><body>
2<style>
3
4body, h1, h2, h3, div, span, p, pre, a {
5  margin: 0;
6  padding: 0;
7  border: 0;
8  font-weight: inherit;
9  font-style: inherit;
10  font-size: 100%;
11  font-family: inherit;
12  vertical-align: baseline;
13}
14
15body {
16  font-size: 13px;
17  padding: 1em;
18}
19
20h1 {
21  font-size: 26px;
22  margin-bottom: 1em;
23}
24
25h2 {
26  font-size: 24px;
27  margin-bottom: 1em;
28}
29
30h3 {
31  font-size: 20px;
32  margin-bottom: 1em;
33  margin-top: 1em;
34}
35
36pre, code {
37  line-height: 1.5;
38  font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace;
39}
40
41pre {
42  margin-top: 0.5em;
43}
44
45h1, h2, h3, p {
46  font-family: Arial, sans serif;
47}
48
49h1, h2, h3 {
50  border-bottom: solid #CCC 1px;
51}
52
53.toc_element {
54  margin-top: 0.5em;
55}
56
57.firstline {
58  margin-left: 2 em;
59}
60
61.method  {
62  margin-top: 1em;
63  border: solid 1px #CCC;
64  padding: 1em;
65  background: #EEE;
66}
67
68.details {
69  font-weight: bold;
70  font-size: 14px;
71}
72
73</style>
74
75<h1><a href="fusiontables_v2.html">Fusion Tables API</a> . <a href="fusiontables_v2.query.html">query</a></h1>
76<h2>Instance Methods</h2>
77<p class="toc_element">
78  <code><a href="#sql">sql(sql, hdrs=None, typed=None)</a></code></p>
79<p class="firstline">Executes a Fusion Tables SQL statement, which can be any of </p>
80<p class="toc_element">
81  <code><a href="#sqlGet">sqlGet(sql, hdrs=None, typed=None)</a></code></p>
82<p class="firstline">Executes a SQL statement which can be any of </p>
83<p class="toc_element">
84  <code><a href="#sqlGet_media">sqlGet_media(sql, hdrs=None, typed=None)</a></code></p>
85<p class="firstline">Executes a SQL statement which can be any of </p>
86<p class="toc_element">
87  <code><a href="#sql_media">sql_media(sql, hdrs=None, typed=None)</a></code></p>
88<p class="firstline">Executes a Fusion Tables SQL statement, which can be any of </p>
89<h3>Method Details</h3>
90<div class="method">
91    <code class="details" id="sql">sql(sql, hdrs=None, typed=None)</code>
92  <pre>Executes a Fusion Tables SQL statement, which can be any of
93- SELECT
94- INSERT
95- UPDATE
96- DELETE
97- SHOW
98- DESCRIBE
99- CREATE statement.
100
101Args:
102  sql: string, A Fusion Tables SQL statement, which can be any of
103- SELECT
104- INSERT
105- UPDATE
106- DELETE
107- SHOW
108- DESCRIBE
109- CREATE (required)
110  hdrs: boolean, Whether column names are included in the first row. Default is true.
111  typed: boolean, Whether typed values are returned in the (JSON) response: numbers for numeric values and parsed geometries for KML values. Default is true.
112
113Returns:
114  An object of the form:
115
116    { # Represents a response to a SQL statement.
117    "kind": "fusiontables#sqlresponse", # The kind of item this is. For responses to SQL queries, this is always fusiontables#sqlresponse.
118    "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.
119      [
120        "",
121      ],
122    ],
123    "columns": [ # Columns in the table.
124      "A String",
125    ],
126  }</pre>
127</div>
128
129<div class="method">
130    <code class="details" id="sqlGet">sqlGet(sql, hdrs=None, typed=None)</code>
131  <pre>Executes a SQL statement which can be any of
132- SELECT
133- SHOW
134- DESCRIBE
135
136Args:
137  sql: string, A SQL statement which can be any of
138- SELECT
139- SHOW
140- DESCRIBE (required)
141  hdrs: boolean, Whether column names are included (in the first row). Default is true.
142  typed: boolean, Whether typed values are returned in the (JSON) response: numbers for numeric values and parsed geometries for KML values. Default is true.
143
144Returns:
145  An object of the form:
146
147    { # Represents a response to a SQL statement.
148    "kind": "fusiontables#sqlresponse", # The kind of item this is. For responses to SQL queries, this is always fusiontables#sqlresponse.
149    "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.
150      [
151        "",
152      ],
153    ],
154    "columns": [ # Columns in the table.
155      "A String",
156    ],
157  }</pre>
158</div>
159
160<div class="method">
161    <code class="details" id="sqlGet_media">sqlGet_media(sql, hdrs=None, typed=None)</code>
162  <pre>Executes a SQL statement which can be any of
163- SELECT
164- SHOW
165- DESCRIBE
166
167Args:
168  sql: string, A SQL statement which can be any of
169- SELECT
170- SHOW
171- DESCRIBE (required)
172  hdrs: boolean, Whether column names are included (in the first row). Default is true.
173  typed: boolean, Whether typed values are returned in the (JSON) response: numbers for numeric values and parsed geometries for KML values. Default is true.
174
175Returns:
176  The media object as a string.
177
178    </pre>
179</div>
180
181<div class="method">
182    <code class="details" id="sql_media">sql_media(sql, hdrs=None, typed=None)</code>
183  <pre>Executes a Fusion Tables SQL statement, which can be any of
184- SELECT
185- INSERT
186- UPDATE
187- DELETE
188- SHOW
189- DESCRIBE
190- CREATE statement.
191
192Args:
193  sql: string, A Fusion Tables SQL statement, which can be any of
194- SELECT
195- INSERT
196- UPDATE
197- DELETE
198- SHOW
199- DESCRIBE
200- CREATE (required)
201  hdrs: boolean, Whether column names are included in the first row. Default is true.
202  typed: boolean, Whether typed values are returned in the (JSON) response: numbers for numeric values and parsed geometries for KML values. Default is true.
203
204Returns:
205  The media object as a string.
206
207    </pre>
208</div>
209
210</body></html>