blob: 04597bbe0bf9b682183687583ad20b9d11207352 [file] [log] [blame]
Craig Citroe633be12015-03-02 13:40:36 -08001<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">
Nathaniel Manista4f877e52015-06-15 16:44:50 +000078 <code><a href="#sql">sql(sql=None, hdrs=None, typed=None)</a></code></p>
79<p class="firstline">Executes a Fusion Tables SQL statement, which can be any of </p>
Craig Citroe633be12015-03-02 13:40:36 -080080<p class="toc_element">
Nathaniel Manista4f877e52015-06-15 16:44:50 +000081 <code><a href="#sqlGet">sqlGet(sql=None, hdrs=None, typed=None)</a></code></p>
82<p class="firstline">Executes a SQL statement which can be any of </p>
Craig Citroe633be12015-03-02 13:40:36 -080083<p class="toc_element">
Nathaniel Manista4f877e52015-06-15 16:44:50 +000084 <code><a href="#sqlGet_media">sqlGet_media(sql=None, hdrs=None, typed=None)</a></code></p>
85<p class="firstline">Executes a SQL statement which can be any of </p>
Craig Citroe633be12015-03-02 13:40:36 -080086<p class="toc_element">
Nathaniel Manista4f877e52015-06-15 16:44:50 +000087 <code><a href="#sql_media">sql_media(sql=None, hdrs=None, typed=None)</a></code></p>
88<p class="firstline">Executes a Fusion Tables SQL statement, which can be any of </p>
Craig Citroe633be12015-03-02 13:40:36 -080089<h3>Method Details</h3>
90<div class="method">
Nathaniel Manista4f877e52015-06-15 16:44:50 +000091 <code class="details" id="sql">sql(sql=None, 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.
Craig Citroe633be12015-03-02 13:40:36 -0800100
101Args:
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000102 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.
Craig Citroe633be12015-03-02 13:40:36 -0800112
113Returns:
114 An object of the form:
115
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000116 { # 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.
Craig Citroe633be12015-03-02 13:40:36 -0800118 "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">
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000130 <code class="details" id="sqlGet">sqlGet(sql=None, hdrs=None, typed=None)</code>
131 <pre>Executes a SQL statement which can be any of
132- SELECT
133- SHOW
134- DESCRIBE
Craig Citroe633be12015-03-02 13:40:36 -0800135
136Args:
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000137 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.
Craig Citroe633be12015-03-02 13:40:36 -0800143
144Returns:
145 An object of the form:
146
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000147 { # 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.
Craig Citroe633be12015-03-02 13:40:36 -0800149 "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">
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000161 <code class="details" id="sqlGet_media">sqlGet_media(sql=None, hdrs=None, typed=None)</code>
162 <pre>Executes a SQL statement which can be any of
163- SELECT
164- SHOW
165- DESCRIBE
Craig Citroe633be12015-03-02 13:40:36 -0800166
167Args:
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000168 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.
Craig Citroe633be12015-03-02 13:40:36 -0800174
175Returns:
176 The media object as a string.
177
178 </pre>
179</div>
180
181<div class="method">
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000182 <code class="details" id="sql_media">sql_media(sql=None, 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.
Craig Citroe633be12015-03-02 13:40:36 -0800191
192Args:
Nathaniel Manista4f877e52015-06-15 16:44:50 +0000193 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.
Craig Citroe633be12015-03-02 13:40:36 -0800203
204Returns:
205 The media object as a string.
206
207 </pre>
208</div>
209
210</body></html>