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> 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> 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 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 170</body></html>