1 <html><body> 2 <style> 3 4 body, 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 15 body { 16 font-size: 13px; 17 padding: 1em; 18 } 19 20 h1 { 21 font-size: 26px; 22 margin-bottom: 1em; 23 } 24 25 h2 { 26 font-size: 24px; 27 margin-bottom: 1em; 28 } 29 30 h3 { 31 font-size: 20px; 32 margin-bottom: 1em; 33 margin-top: 1em; 34 } 35 36 pre, code { 37 line-height: 1.5; 38 font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace; 39 } 40 41 pre { 42 margin-top: 0.5em; 43 } 44 45 h1, h2, h3, p { 46 font-family: Arial, sans serif; 47 } 48 49 h1, 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 101 Args: 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 113 Returns: 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 136 Args: 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 144 Returns: 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 167 Args: 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 175 Returns: 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 192 Args: 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 204 Returns: 205 The media object as a string. 206 207 </pre> 208 </div> 209 210 </body></html>
