diff options
| author | Andi Albrecht <albrecht.andi@gmail.com> | 2011-08-09 16:04:40 +0200 |
|---|---|---|
| committer | Andi Albrecht <albrecht.andi@gmail.com> | 2011-08-09 16:04:40 +0200 |
| commit | 5d015084e5bf640f41c8d93c89d2ff70c0967c2b (patch) | |
| tree | cfa3b58e11e49a6266a2a05ab9e477c5d62c5024 /extras/appengine/sqlformat/templates/python-client-example.html | |
| parent | a8b46d3b96ead22263de782b36090f2f1bc7c15d (diff) | |
| parent | 530da46905753a1e950bcc7e736d72a7309033c6 (diff) | |
| download | sqlparse-5d015084e5bf640f41c8d93c89d2ff70c0967c2b.tar.gz | |
merge
Diffstat (limited to 'extras/appengine/sqlformat/templates/python-client-example.html')
| -rw-r--r-- | extras/appengine/sqlformat/templates/python-client-example.html | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/extras/appengine/sqlformat/templates/python-client-example.html b/extras/appengine/sqlformat/templates/python-client-example.html new file mode 100644 index 0000000..68bf820 --- /dev/null +++ b/extras/appengine/sqlformat/templates/python-client-example.html @@ -0,0 +1,17 @@ +<div class="highlight example"><pre><span class="c">#!/usr/bin/env python</span> + +<span class="k">import</span> <span class="nn">urllib</span> +<span class="k">import</span> <span class="nn">urllib2</span> + +<span class="n">payload</span> <span class="o">=</span> <span class="p">(</span> + <span class="p">(</span><span class="s">'data'</span><span class="p">,</span> <span class="s">'select * from foo join bar on val1 = val2 where id = 123;'</span><span class="p">),</span> + <span class="p">(</span><span class="s">'format'</span><span class="p">,</span> <span class="s">'text'</span><span class="p">),</span> + <span class="p">(</span><span class="s">'keyword_case'</span><span class="p">,</span> <span class="s">'upper'</span><span class="p">),</span> + <span class="p">(</span><span class="s">'reindent'</span><span class="p">,</span> <span class="bp">True</span><span class="p">),</span> + <span class="p">(</span><span class="s">'n_indents'</span><span class="p">,</span> <span class="mf">2</span><span class="p">),</span> + <span class="p">)</span> + +<span class="n">response</span> <span class="o">=</span> <span class="n">urllib2</span><span class="o">.</span><span class="n">urlopen</span><span class="p">(</span><span class="s">'http://sqlformat.appspot.com/format/'</span><span class="p">,</span> + <span class="n">urllib</span><span class="o">.</span><span class="n">urlencode</span><span class="p">(</span><span class="n">payload</span><span class="p">))</span> +<span class="k">print</span> <span class="n">response</span><span class="o">.</span><span class="n">read</span><span class="p">()</span> +</pre></div> |