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_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 94 Args: 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 99 Returns: 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 119 Args: 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 124 Returns: 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 144 Args: 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 149 Returns: 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 159 Args: 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 164 Returns: 165 The media object as a string. 166 167 </pre> 168 </div> 169 170 </body></html>
