[limb-svn] r6701 - 3.x/trunk/limb/active_record/tests/cases/.fixture

[svn at limb-project.com]

Author: serega
Date: 2008-01-18 12:36:14 +0300 (Fri, 18 Jan 2008)
New Revision: 6701
URL: http://fisheye.limb-project.com/changelog/limb/?cs=6701

Modified:
   3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.oci
   3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql
   3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.sqlite
Log:
-- updated test fixtures for all db vendors in ACTIVE_RECORD package

Modified: 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.oci
===================================================================
--- 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.oci	2008-01-18 09:27:02 UTC (rev 6700)
+++ 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.oci	2008-01-18 09:36:14 UTC (rev 6701)
@@ -119,6 +119,22 @@
 BEFORE INSERT ON person_for_test REFERENCING NEW AS NEW FOR EACH ROW
 BEGIN IF :NEW.ID IS NULL THEN SELECT person_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
 /
+BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE program_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
+/
+CREATE SEQUENCE program_for_test_seq;
+/
+BEGIN EXECUTE IMMEDIATE 'DROP TABLE program_for_test'; EXCEPTION WHEN OTHERS THEN NULL; END;
+/
+CREATE TABLE program_for_test (
+  id number NOT NULL,
+  title varchar(255) default NULL,
+  PRIMARY KEY  (id)
+);
+/
+CREATE OR REPLACE TRIGGER program_for_test_trigger
+BEFORE INSERT ON program_for_test REFERENCING NEW AS NEW FOR EACH ROW
+BEGIN IF :NEW.ID IS NULL THEN SELECT program_for_test_seq.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
+/
 BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE course_for_test_seq'; EXCEPTION WHEN OTHERS THEN NULL; END;
 /
 CREATE SEQUENCE course_for_test_seq;
@@ -128,6 +144,7 @@
 CREATE TABLE course_for_test (
   id number NOT NULL,
   title varchar(255) default NULL,
+  program_id number default NULL,
   PRIMARY KEY  (id)
 );
 /

Modified: 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql
===================================================================
--- 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql	2008-01-18 09:27:02 UTC (rev 6700)
+++ 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.pgsql	2008-01-18 09:36:14 UTC (rev 6701)
@@ -64,11 +64,21 @@
 PRIMARY   KEY  (id)
 )  ;
 
+DROP TABLE program_for_test CASCADE;
+
+CREATE TABLE program_for_test (
+ "id" SERIAL,
+ "title" varchar(255) default NULL,
+ PRIMARY KEY  (id)
+)  ;
+
+
 DROP TABLE course_for_test CASCADE;
 
 CREATE TABLE course_for_test (
  "id" SERIAL,
  "title" varchar(255) default NULL,
+ "program_id" int8 default NULL,
  PRIMARY KEY  (id)
 )  ;
 

Modified: 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.sqlite
===================================================================
--- 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.sqlite	2008-01-18 09:27:02 UTC (rev 6700)
+++ 3.x/trunk/limb/active_record/tests/cases/.fixture/init_tests.sqlite	2008-01-18 09:36:14 UTC (rev 6701)
@@ -23,6 +23,7 @@
   "kind" varchar(255) NOT NULL
 );
 
+
 DROP TABLE "course_for_typed_test";
 CREATE TABLE "course_for_typed_test" (
  "id" INTEGER PRIMARY KEY,
@@ -51,9 +52,16 @@
 "ss_id" bigint(20) default NULL
 );
 
+DROP TABLE "program_for_test";
+CREATE TABLE "program_for_test" (
+ "id" INTEGER PRIMARY KEY,
+ "title" varchar(255) default NULL
+);
+
 DROP TABLE "course_for_test";
 CREATE TABLE "course_for_test" (
  "id" INTEGER PRIMARY KEY,
+ "program_id" bigint(20) default NULL,
  "title" varchar(255) default NULL
 );