diff options
| author | Andi Albrecht <albrecht.andi@gmail.com> | 2015-10-26 19:51:54 +0100 |
|---|---|---|
| committer | Andi Albrecht <albrecht.andi@gmail.com> | 2015-10-26 19:51:54 +0100 |
| commit | dce6100348f92663f855b3c791031fd5a991844a (patch) | |
| tree | 41d2d3824c9548ca58ba672cdadbba011f9fea83 /extras/appengine/examples | |
| parent | 4aff8c729adc8363ffd23b593b9d4b729487cde8 (diff) | |
| download | sqlparse-dce6100348f92663f855b3c791031fd5a991844a.tar.gz | |
Remove old Appengine application.
Diffstat (limited to 'extras/appengine/examples')
| -rw-r--r-- | extras/appengine/examples/customers.sql | 1 | ||||
| -rw-r--r-- | extras/appengine/examples/multiple_inserts.sql | 1 | ||||
| -rw-r--r-- | extras/appengine/examples/pg_view.sql | 1 | ||||
| -rw-r--r-- | extras/appengine/examples/subquery.sql | 1 | ||||
| -rw-r--r-- | extras/appengine/examples/subquery2.sql | 1 |
5 files changed, 0 insertions, 5 deletions
diff --git a/extras/appengine/examples/customers.sql b/extras/appengine/examples/customers.sql deleted file mode 100644 index 8b73850..0000000 --- a/extras/appengine/examples/customers.sql +++ /dev/null @@ -1 +0,0 @@ -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/examples/multiple_inserts.sql b/extras/appengine/examples/multiple_inserts.sql deleted file mode 100644 index cf49d5d..0000000 --- a/extras/appengine/examples/multiple_inserts.sql +++ /dev/null @@ -1 +0,0 @@ -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/examples/pg_view.sql b/extras/appengine/examples/pg_view.sql deleted file mode 100644 index edf9f06..0000000 --- a/extras/appengine/examples/pg_view.sql +++ /dev/null @@ -1 +0,0 @@ -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/examples/subquery.sql b/extras/appengine/examples/subquery.sql deleted file mode 100644 index dd4bbc1..0000000 --- a/extras/appengine/examples/subquery.sql +++ /dev/null @@ -1 +0,0 @@ -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/examples/subquery2.sql b/extras/appengine/examples/subquery2.sql deleted file mode 100644 index 6c00a87..0000000 --- a/extras/appengine/examples/subquery2.sql +++ /dev/null @@ -1 +0,0 @@ -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 |
