Other

* Replace Django by Flask in App Engine frontend (issue11).

gae-sqlformat - An SQL formatting tool runnging on App Engine

=============================================================

To set up this application run

make all

This command fetches Django from Subversion and symlinks Pygments

and sqlparse. Note: You'll need Pygments installed somewhere in your

PYTHONPATH.

For a manual setup have a look at the Makefile ;-)

To run the development server run

make serve

Homepage: http://sqlformat.appspot.com

application: sqlformat

version: 2

runtime: python

api_version: 1

default_expiration: 7d # This is good for images, which never change

handlers:

- url: /(robots.txt|favicon.ico|sitemap.xml)

static_files: static/\1

upload: static/(robots.txt|favicon.ico|sitemap.xml)

- url: /google7a062e78b56854c0.html

static_files: static/robots.txt

upload: static/robots.txt

- url: /static/(script.js|styles.css|upload.py)

static_files: static/\1

upload: static/(script.js|styles.css|upload.py)

expiration: 1h # Shorter expiration, these change often

- url: /static

static_dir: static

- url: .*

script: main.py

derived_file_type:

- python_precompiled

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;

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');

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;

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);