Gitiles
Code Review Sign In
gerrit-public.fairphone.software / platform / external / python / google-api-python-client / 0915761b342e18fdf56f7e1ac174ca736f679ed1 / . / docs / dyn / fusiontables_v1.query.html
blob: a0420783da0d0aba66eec9486b6d04d5a15723a9 [file] [log] [blame]
John Asmuth614db982014-04-24 15:46:26 -0400[diff] [blame]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_v1.html">Fusion Tables API</a> . <a href="fusiontables_v1.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 an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.</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 an SQL SELECT/SHOW/DESCRIBE statement.</p>
Craig Citro065b5302014-08-14 00:47:23 -0700[diff] [blame]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 an SQL SELECT/SHOW/DESCRIBE statement.</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 an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.</p>
John Asmuth614db982014-04-24 15:46:26 -0400[diff] [blame]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 an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.
93
94Args:
95 sql: string, An SQL SELECT/SHOW/DESCRIBE/INSERT/UPDATE/DELETE/CREATE statement. (required)
96 hdrs: boolean, Should column names be included (in the first row)?. Default is true.
97 typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true.
98
99Returns:
100 An object of the form:
101
102 { # Represents a response to an sql statement.
103 "kind": "fusiontables#sqlresponse", # Type name: a template for an individual table.
104 "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.
105 [
106 "",
107 ],
108 ],
109 "columns": [ # Columns in the table.
110 "A String",
111 ],
112 }</pre>
113</div>
114
115<div class="method">
116 <code class="details" id="sqlGet">sqlGet(sql, hdrs=None, typed=None)</code>
117 <pre>Executes an SQL SELECT/SHOW/DESCRIBE statement.
118
119Args:
120 sql: string, An SQL SELECT/SHOW/DESCRIBE statement. (required)
121 hdrs: boolean, Should column names be included (in the first row)?. Default is true.
122 typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true.
123
124Returns:
125 An object of the form:
126
127 { # Represents a response to an sql statement.
128 "kind": "fusiontables#sqlresponse", # Type name: a template for an individual table.
129 "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.
130 [
131 "",
132 ],
133 ],
134 "columns": [ # Columns in the table.
135 "A String",
136 ],
137 }</pre>
138</div>
139
Craig Citro065b5302014-08-14 00:47:23 -0700[diff] [blame]140<div class="method">
141 <code class="details" id="sqlGet_media">sqlGet_media(sql, hdrs=None, typed=None)</code>
142 <pre>Executes an SQL SELECT/SHOW/DESCRIBE statement.
143
144Args:
145 sql: string, An SQL SELECT/SHOW/DESCRIBE statement. (required)
146 hdrs: boolean, Should column names be included (in the first row)?. Default is true.
147 typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true.
148
149Returns:
150 The media object as a string.
151
152 </pre>
153</div>
154
155<div class="method">
156 <code class="details" id="sql_media">sql_media(sql, hdrs=None, typed=None)</code>
157 <pre>Executes an SQL SELECT/INSERT/UPDATE/DELETE/SHOW/DESCRIBE/CREATE statement.
158
159Args:
160 sql: string, An SQL SELECT/SHOW/DESCRIBE/INSERT/UPDATE/DELETE/CREATE statement. (required)
161 hdrs: boolean, Should column names be included (in the first row)?. Default is true.
162 typed: boolean, Should typed values be returned in the (JSON) response -- numbers for numeric values and parsed geometries for KML values? Default is true.
163
164Returns:
165 The media object as a string.
166
167 </pre>
168</div>
169
John Asmuth614db982014-04-24 15:46:26 -0400[diff] [blame]170</body></html>