Change gitignore to ignore generated sql;

diff --git a/.gitignore b/.gitignore
index 6193840..e3fe75e 100644 (file)
--- 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 (file)
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 (file)
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;
-