From: Amiri Barksdale at Home Date: Mon, 12 Jul 2010 03:10:50 +0000 (-0700) Subject: Change gitignore to ignore generated sql; X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FDBIx-Class-ResultSource-MultipleTableInheritance.git;a=commitdiff_plain;h=bee7195e0ca325dd13963faea19317b2108b5a06 Change gitignore to ignore generated sql; --- diff --git a/.gitignore b/.gitignore index 6193840..e3fe75e 100644 --- a/.gitignore +++ b/.gitignore @@ -7,3 +7,4 @@ pm_to_blib *.sw? *.tmp src +t/sql diff --git a/t/sql/Cafe-0.1-PostgreSQL.sql b/t/sql/Cafe-0.1-PostgreSQL.sql deleted file mode 100644 index a9d68b5..0000000 --- a/t/sql/Cafe-0.1-PostgreSQL.sql +++ /dev/null @@ -1,152 +0,0 @@ --- --- Created by SQL::Translator::Producer::PostgreSQL --- Created on Sun Jul 11 20:05:37 2010 --- --- --- Table: _coffee --- -DROP TABLE "_coffee" CASCADE; -CREATE TABLE "_coffee" ( - "id" serial NOT NULL, - "flavor" text DEFAULT 'good' NOT NULL, - PRIMARY KEY ("id") -); - --- --- Table: _sumatra --- -DROP TABLE "_sumatra" CASCADE; -CREATE TABLE "_sumatra" ( - "id" integer NOT NULL, - "aroma" text NOT NULL, - PRIMARY KEY ("id") -); - --- --- Table: sugar --- -DROP TABLE "sugar" CASCADE; -CREATE TABLE "sugar" ( - "id" serial NOT NULL, - "sweetness" integer NOT NULL, - PRIMARY KEY ("id") -); - --- --- View: "coffee" --- -DROP VIEW IF EXISTS "coffee"; -CREATE VIEW "coffee" ( "id", "flavor" ) AS - SELECT _coffee.id, flavor FROM _coffee; - -CREATE OR REPLACE FUNCTION coffee_insert - (_flavor TEXT) - RETURNS VOID AS $function$ - BEGIN - INSERT INTO _coffee ( flavor) VALUES ( _flavor ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION coffee_update - (_id INTEGER, _flavor TEXT) - RETURNS VOID AS $function$ - BEGIN - UPDATE _coffee SET flavor = _flavor WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION coffee_delete - (_id INTEGER) - RETURNS VOID AS $function$ - BEGIN - DELETE FROM _coffee WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE RULE _coffee_insert_rule AS - ON INSERT TO coffee - DO INSTEAD ( - SELECT coffee_insert(NEW.flavor) - ); - - -CREATE RULE _coffee_update_rule AS - ON UPDATE TO coffee - DO INSTEAD ( - SELECT coffee_update(OLD.id, NEW.flavor) - ); - - -CREATE RULE _coffee_delete_rule AS - ON DELETE TO coffee - DO INSTEAD ( - SELECT coffee_delete(OLD.id) - ); - -; - --- --- View: "sumatra" --- -DROP VIEW IF EXISTS "sumatra"; -CREATE VIEW "sumatra" ( "id", "flavor", "sweetness", "aroma" ) AS - SELECT _sumatra.id, aroma, sweetness, flavor FROM _sumatra _sumatra JOIN sugar sugar ON sugar.id = _sumatra.id JOIN coffee coffee ON coffee.id = _sumatra.id; - -CREATE OR REPLACE FUNCTION sumatra_insert - (_aroma TEXT, _sweetness INTEGER, _flavor TEXT) - RETURNS VOID AS $function$ - BEGIN - INSERT INTO coffee ( flavor) VALUES ( _flavor ); - INSERT INTO _sumatra ( aroma, id) VALUES ( _aroma, currval('_coffee_id_seq') ); - INSERT INTO sugar ( id, sweetness) VALUES ( currval('_coffee_id_seq'), _sweetness ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION sumatra_update - (_id INTEGER, _aroma TEXT, _sweetness INTEGER, _flavor TEXT) - RETURNS VOID AS $function$ - BEGIN - UPDATE _sumatra SET aroma = _aroma WHERE ( id = _id ); - UPDATE sugar SET sweetness = _sweetness WHERE ( id = _id ); - UPDATE coffee SET flavor = _flavor WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION sumatra_delete - (_id INTEGER) - RETURNS VOID AS $function$ - BEGIN - DELETE FROM _sumatra WHERE ( id = _id ); - DELETE FROM sugar WHERE ( id = _id ); - DELETE FROM coffee WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE RULE _sumatra_insert_rule AS - ON INSERT TO sumatra - DO INSTEAD ( - SELECT sumatra_insert(NEW.aroma, NEW.sweetness, NEW.flavor) - ); - - -CREATE RULE _sumatra_update_rule AS - ON UPDATE TO sumatra - DO INSTEAD ( - SELECT sumatra_update(OLD.id, NEW.aroma, NEW.sweetness, NEW.flavor) - ); - - -CREATE RULE _sumatra_delete_rule AS - ON DELETE TO sumatra - DO INSTEAD ( - SELECT sumatra_delete(OLD.id) - ); - -; - diff --git a/t/sql/MTITest-0.1-PostgreSQL.sql b/t/sql/MTITest-0.1-PostgreSQL.sql deleted file mode 100644 index 049d4bc..0000000 --- a/t/sql/MTITest-0.1-PostgreSQL.sql +++ /dev/null @@ -1,174 +0,0 @@ --- --- Created by SQL::Translator::Producer::PostgreSQL --- Created on Sun Jul 11 20:05:31 2010 --- --- --- Table: just_a_table --- -DROP TABLE "just_a_table" CASCADE; -CREATE TABLE "just_a_table" ( - "id" serial NOT NULL, - "name" character varying(255) NOT NULL, - PRIMARY KEY ("id") -); - --- --- Table: mixin --- -DROP TABLE "mixin" CASCADE; -CREATE TABLE "mixin" ( - "id" serial NOT NULL, - "words" text NOT NULL, - PRIMARY KEY ("id") -); - --- --- Table: _bar --- -DROP TABLE "_bar" CASCADE; -CREATE TABLE "_bar" ( - "id" integer NOT NULL, - "b" integer NOT NULL, - PRIMARY KEY ("id") -); -CREATE INDEX "_bar_idx_b" on "_bar" ("b"); - --- --- Table: _foo --- -DROP TABLE "_foo" CASCADE; -CREATE TABLE "_foo" ( - "id" serial NOT NULL, - "a" integer, - PRIMARY KEY ("id") -); -CREATE INDEX "_foo_idx_a" on "_foo" ("a"); - --- --- View: "bar" --- -DROP VIEW IF EXISTS "bar"; -CREATE VIEW "bar" ( "id", "a", "words", "b" ) AS - SELECT _bar.id, b, words, a FROM _bar _bar JOIN mixin mixin ON mixin.id = _bar.id JOIN foo foo ON foo.id = _bar.id; - -CREATE OR REPLACE FUNCTION bar_insert - (_b INTEGER, _words TEXT, _a INTEGER) - RETURNS VOID AS $function$ - BEGIN - INSERT INTO foo ( a) VALUES ( _a ); - INSERT INTO _bar ( b, id) VALUES ( _b, currval('_foo_id_seq') ); - INSERT INTO mixin ( id, words) VALUES ( currval('_foo_id_seq'), _words ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION bar_update - (_id INTEGER, _b INTEGER, _words TEXT, _a INTEGER) - RETURNS VOID AS $function$ - BEGIN - UPDATE _bar SET b = _b WHERE ( id = _id ); - UPDATE mixin SET words = _words WHERE ( id = _id ); - UPDATE foo SET a = _a WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION bar_delete - (_id INTEGER) - RETURNS VOID AS $function$ - BEGIN - DELETE FROM _bar WHERE ( id = _id ); - DELETE FROM mixin WHERE ( id = _id ); - DELETE FROM foo WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE RULE _bar_insert_rule AS - ON INSERT TO bar - DO INSTEAD ( - SELECT bar_insert(NEW.b, NEW.words, NEW.a) - ); - - -CREATE RULE _bar_update_rule AS - ON UPDATE TO bar - DO INSTEAD ( - SELECT bar_update(OLD.id, NEW.b, NEW.words, NEW.a) - ); - - -CREATE RULE _bar_delete_rule AS - ON DELETE TO bar - DO INSTEAD ( - SELECT bar_delete(OLD.id) - ); - -; - --- --- View: "foo" --- -DROP VIEW IF EXISTS "foo"; -CREATE VIEW "foo" ( "id", "a" ) AS - SELECT _foo.id, a FROM _foo; - -CREATE OR REPLACE FUNCTION foo_insert - (_a INTEGER) - RETURNS VOID AS $function$ - BEGIN - INSERT INTO _foo ( a) VALUES ( _a ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION foo_update - (_id INTEGER, _a INTEGER) - RETURNS VOID AS $function$ - BEGIN - UPDATE _foo SET a = _a WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE OR REPLACE FUNCTION foo_delete - (_id INTEGER) - RETURNS VOID AS $function$ - BEGIN - DELETE FROM _foo WHERE ( id = _id ); - END; -$function$ LANGUAGE plpgsql; - - -CREATE RULE _foo_insert_rule AS - ON INSERT TO foo - DO INSTEAD ( - SELECT foo_insert(NEW.a) - ); - - -CREATE RULE _foo_update_rule AS - ON UPDATE TO foo - DO INSTEAD ( - SELECT foo_update(OLD.id, NEW.a) - ); - - -CREATE RULE _foo_delete_rule AS - ON DELETE TO foo - DO INSTEAD ( - SELECT foo_delete(OLD.id) - ); - -; - --- --- Foreign Key Definitions --- - -ALTER TABLE "_bar" ADD FOREIGN KEY ("b") - REFERENCES "just_a_table" ("id") ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE; - -ALTER TABLE "_foo" ADD FOREIGN KEY ("a") - REFERENCES "_bar" ("id") ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE; -