summaryrefslogtreecommitdiff
path: root/extras/appengine-django/examples
diff options
context:
space:
mode:
authorAndi Albrecht <albrecht.andi@gmail.com>2011-07-29 21:03:28 +0200
committerAndi Albrecht <albrecht.andi@gmail.com>2011-07-29 21:03:28 +0200
commit92c142623d9b4ad806f51dd79e3842396ac464d8 (patch)
treee56384484801edcd417901e485474914a98ea4a1 /extras/appengine-django/examples
parentc918cc9dc30b3a7684a96feae95fc5c05638360e (diff)
downloadsqlparse-92c142623d9b4ad806f51dd79e3842396ac464d8.tar.gz
Replace Django by Flask in App Engine frontend (fixes issue11).
--HG-- rename : extras/appengine/Makefile => extras/appengine-django/Makefile rename : extras/appengine/README => extras/appengine-django/README rename : extras/appengine/__init__.py => extras/appengine-django/__init__.py rename : extras/appengine/app.yaml => extras/appengine-django/app.yaml rename : extras/appengine/examples/customers.sql => extras/appengine-django/examples/customers.sql rename : extras/appengine/examples/multiple_inserts.sql => extras/appengine-django/examples/multiple_inserts.sql rename : extras/appengine/examples/pg_view.sql => extras/appengine-django/examples/pg_view.sql rename : extras/appengine/examples/subquery.sql => extras/appengine-django/examples/subquery.sql rename : extras/appengine/examples/subquery2.sql => extras/appengine-django/examples/subquery2.sql rename : extras/appengine/index.yaml => extras/appengine-django/index.yaml rename : extras/appengine/main.py => extras/appengine-django/main.py rename : extras/appengine/settings.py => extras/appengine-django/settings.py rename : extras/appengine/sqlformat/__init__.py => extras/appengine-django/sqlformat/__init__.py rename : extras/appengine/sqlformat/urls.py => extras/appengine-django/sqlformat/urls.py rename : extras/appengine/sqlformat/views.py => extras/appengine-django/sqlformat/views.py rename : extras/appengine/static/bg_options.png => extras/appengine-django/static/bg_options.png rename : extras/appengine/static/bgfieldset.png => extras/appengine-django/static/bgfieldset.png rename : extras/appengine/static/bgfooter.png => extras/appengine-django/static/bgfooter.png rename : extras/appengine/static/bgtop.png => extras/appengine-django/static/bgtop.png rename : extras/appengine/static/blank.gif => extras/appengine-django/static/blank.gif rename : extras/appengine/static/canvas.html => extras/appengine-django/static/canvas.html rename : extras/appengine/static/hotkeys.js => extras/appengine-django/static/hotkeys.js rename : extras/appengine/static/img_loading.gif => extras/appengine-django/static/img_loading.gif rename : extras/appengine/static/jquery.textarearesizer.compressed.js => extras/appengine-django/static/jquery.textarearesizer.compressed.js rename : extras/appengine/static/loading.gif => extras/appengine-django/static/loading.gif rename : extras/appengine/static/lynx_screenshot.png => extras/appengine-django/static/lynx_screenshot.png rename : extras/appengine/static/pygments.css => extras/appengine-django/static/pygments.css rename : extras/appengine/static/resize-grip.png => extras/appengine-django/static/resize-grip.png rename : extras/appengine/static/robots.txt => extras/appengine-django/static/robots.txt rename : extras/appengine/static/rpc_relay.html => extras/appengine-django/static/rpc_relay.html rename : extras/appengine/static/script.js => extras/appengine-django/static/script.js rename : extras/appengine/static/sitemap.xml => extras/appengine-django/static/sitemap.xml rename : extras/appengine/static/sqlformat_client_example.py => extras/appengine-django/static/sqlformat_client_example.py rename : extras/appengine/static/styles.css => extras/appengine-django/static/styles.css rename : extras/appengine/templates/404.html => extras/appengine-django/templates/404.html rename : extras/appengine/templates/500.html => extras/appengine-django/templates/500.html rename : extras/appengine/templates/about.html => extras/appengine-django/templates/about.html rename : extras/appengine/templates/api.html => extras/appengine-django/templates/api.html rename : extras/appengine/templates/index.html => extras/appengine-django/templates/index.html rename : extras/appengine/templates/master.html => extras/appengine-django/templates/master.html rename : extras/appengine/templates/python-client-example.html => extras/appengine-django/templates/python-client-example.html rename : extras/appengine/templates/source.html => extras/appengine-django/templates/source.html
Diffstat (limited to 'extras/appengine-django/examples')
-rw-r--r--extras/appengine-django/examples/customers.sql1
-rw-r--r--extras/appengine-django/examples/multiple_inserts.sql1
-rw-r--r--extras/appengine-django/examples/pg_view.sql1
-rw-r--r--extras/appengine-django/examples/subquery.sql1
-rw-r--r--extras/appengine-django/examples/subquery2.sql1
5 files changed, 5 insertions, 0 deletions
diff --git a/extras/appengine-django/examples/customers.sql b/extras/appengine-django/examples/customers.sql
new file mode 100644
index 0000000..8b73850
--- /dev/null
+++ b/extras/appengine-django/examples/customers.sql
@@ -0,0 +1 @@
+USE mydatabase;SELECT orders.customer, orders.day_of_order, orders.product, orders.quantity as number_ordered, inventory.quantity as number_instock, inventory.price FROM orders JOIN inventory ON orders.product = inventory.product; \ No newline at end of file
diff --git a/extras/appengine-django/examples/multiple_inserts.sql b/extras/appengine-django/examples/multiple_inserts.sql
new file mode 100644
index 0000000..cf49d5d
--- /dev/null
+++ b/extras/appengine-django/examples/multiple_inserts.sql
@@ -0,0 +1 @@
+insert into customer (id, name) values (1, 'John');insert into customer (id, name) values (2, 'Jack');insert into customer (id, name) values (3, 'Jane');insert into customer (id, name) values (4, 'Jim');insert into customer (id, name) values (5, 'Jerry');insert into customer (id, name) values (1, 'Joe'); \ No newline at end of file
diff --git a/extras/appengine-django/examples/pg_view.sql b/extras/appengine-django/examples/pg_view.sql
new file mode 100644
index 0000000..edf9f06
--- /dev/null
+++ b/extras/appengine-django/examples/pg_view.sql
@@ -0,0 +1 @@
+SELECT DISTINCT (current_database())::information_schema.sql_identifier AS view_catalog, (nv.nspname)::information_schema.sql_identifier AS view_schema, (v.relname)::information_schema.sql_identifier AS view_name, (current_database())::information_schema.sql_identifier AS table_catalog, (nt.nspname)::information_schema.sql_identifier AS table_schema, (t.relname)::information_schema.sql_identifier AS table_name FROM pg_namespace nv, pg_class v, pg_depend dv, pg_depend dt, pg_class t, pg_namespace nt WHERE ((((((((((((((nv.oid = v.relnamespace) AND (v.relkind = 'v'::"char")) AND (v.oid = dv.refobjid)) AND (dv.refclassid = ('pg_class'::regclass)::oid)) AND (dv.classid = ('pg_rewrite'::regclass)::oid)) AND (dv.deptype = 'i'::"char")) AND (dv.objid = dt.objid)) AND (dv.refobjid <> dt.refobjid)) AND (dt.classid = ('pg_rewrite'::regclass)::oid)) AND (dt.refclassid = ('pg_class'::regclass)::oid)) AND (dt.refobjid = t.oid)) AND (t.relnamespace = nt.oid)) AND (t.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND pg_has_role(t.relowner, 'USAGE'::text)) ORDER BY (current_database())::information_schema.sql_identifier, (nv.nspname)::information_schema.sql_identifier, (v.relname)::information_schema.sql_identifier, (current_database())::information_schema.sql_identifier, (nt.nspname)::information_schema.sql_identifier, (t.relname)::information_schema.sql_identifier;
diff --git a/extras/appengine-django/examples/subquery.sql b/extras/appengine-django/examples/subquery.sql
new file mode 100644
index 0000000..dd4bbc1
--- /dev/null
+++ b/extras/appengine-django/examples/subquery.sql
@@ -0,0 +1 @@
+select sum(a1.Sales) from Store_Information a1 where a1.Store_name in (select store_name from Geography a2 where a2.store_name = a1.store_name); \ No newline at end of file
diff --git a/extras/appengine-django/examples/subquery2.sql b/extras/appengine-django/examples/subquery2.sql
new file mode 100644
index 0000000..6c00a87
--- /dev/null
+++ b/extras/appengine-django/examples/subquery2.sql
@@ -0,0 +1 @@
+select user_id, count(*) as how_many from bboard where not exists (select 1 from bboard_authorized_maintainers bam where bam.user_id = bboard.user_id) and posting_time + 60 > sysdate group by user_id order by how_many desc; \ No newline at end of file