diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2005-02-07 14:06:00 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2005-02-07 14:06:00 +0000 |
commit | 336c2cbb8f728825139f2ab94b96726935ea18a1 (patch) | |
tree | 1943ecb94336aae84d458a97bd376306dac1118d /activerecord/test/fixtures/db_definitions | |
parent | 8382e6e50681fef860fb2856af12fa72853a8488 (diff) | |
download | rails-336c2cbb8f728825139f2ab94b96726935ea18a1.tar.gz rails-336c2cbb8f728825139f2ab94b96726935ea18a1.tar.bz2 rails-336c2cbb8f728825139f2ab94b96726935ea18a1.zip |
Added an Oracle adapter that works with the Oracle bindings by Yoshida (http://raa.ruby-lang.org/project/oracle/) #564 [Maik Schmidt]
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@522 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
6 files changed, 204 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/create_oracle_db.bat b/activerecord/test/fixtures/db_definitions/create_oracle_db.bat new file mode 100644 index 0000000000..25c7e18856 --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/create_oracle_db.bat @@ -0,0 +1,5 @@ +sqlplus arunit/arunit @ drop_oracle_tables +sqlplus arunit/arunit @ oracle +sqlplus arunit2/arunit2 @ drop_oracle_tables2 +sqlplus arunit2/arunit2 @ oracle2 + diff --git a/activerecord/test/fixtures/db_definitions/create_oracle_db.sh b/activerecord/test/fixtures/db_definitions/create_oracle_db.sh new file mode 100644 index 0000000000..25c7e18856 --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/create_oracle_db.sh @@ -0,0 +1,5 @@ +sqlplus arunit/arunit @ drop_oracle_tables +sqlplus arunit/arunit @ oracle +sqlplus arunit2/arunit2 @ drop_oracle_tables2 +sqlplus arunit2/arunit2 @ oracle2 + diff --git a/activerecord/test/fixtures/db_definitions/drop_oracle_tables.sql b/activerecord/test/fixtures/db_definitions/drop_oracle_tables.sql new file mode 100644 index 0000000000..b300d13485 --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/drop_oracle_tables.sql @@ -0,0 +1,35 @@ +DROP TABLE accounts; +DROP SEQUENCE accounts_id; +DROP TABLE companies; +DROP SEQUENCE companies_id; +DROP TABLE topics; +DROP SEQUENCE topics_id; +DROP TABLE developers; +DROP SEQUENCE developers_id; +DROP TABLE projects; +DROP SEQUENCE projects_id; +DROP TABLE developers_projects; +DROP SEQUENCE developers_projects_id; +DROP TABLE customers; +DROP SEQUENCE customers_id; +DROP TABLE movies; +DROP SEQUENCE movies_id; +DROP TABLE subscribers; +DROP SEQUENCE subscribers_id; +DROP TABLE booleantests; +DROP SEQUENCE booleantests_id; +DROP TABLE auto_id_tests; +DROP SEQUENCE auto_id_tests_id; +DROP TABLE entrants; +DROP SEQUENCE entrants_id; +DROP TABLE colnametests; +DROP SEQUENCE colnametests_id; +DROP TABLE mixins; +DROP SEQUENCE mixins_id; +DROP TABLE people; +DROP SEQUENCE people_id; +DROP TABLE binaries; +DROP SEQUENCE binaries_id; +DROP TABLE computers; +DROP SEQUENCE computers_id; +EXIT; diff --git a/activerecord/test/fixtures/db_definitions/drop_oracle_tables2.sql b/activerecord/test/fixtures/db_definitions/drop_oracle_tables2.sql new file mode 100644 index 0000000000..934026dc89 --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/drop_oracle_tables2.sql @@ -0,0 +1,3 @@ +DROP TABLE courses; +DROP SEQUENCE courses_id; +EXIT; diff --git a/activerecord/test/fixtures/db_definitions/oracle.sql b/activerecord/test/fixtures/db_definitions/oracle.sql new file mode 100644 index 0000000000..31e66e8532 --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/oracle.sql @@ -0,0 +1,149 @@ +CREATE TABLE accounts ( + id int NOT NULL, + firm_id int default NULL, + credit_limit int default NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE accounts_id MINVALUE 10000; + +CREATE TABLE companies ( + id int NOT NULL, + type varchar(50) default NULL, + ruby_type varchar(50) default NULL, + firm_id int default NULL, + name varchar(50) default NULL, + client_of int default NULL, + rating int default 1, + PRIMARY KEY (id) +); +CREATE SEQUENCE companies_id MINVALUE 10000; + +CREATE TABLE topics ( + id int NOT NULL, + title varchar(255) default NULL, + author_name varchar(255) default NULL, + author_email_address varchar(255) default NULL, + written_on timestamp default NULL, + bonus_time timestamp default NULL, + last_read date default NULL, + content varchar(3000), + approved smallint default 1, + replies_count int default 0, + parent_id int default NULL, + type varchar(50) default NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE topics_id MINVALUE 10000; + +CREATE TABLE developers ( + id int NOT NULL, + name varchar(100) default NULL, + salary int default 70000, + PRIMARY KEY (id) +); +CREATE SEQUENCE developers_id MINVALUE 10000; + +CREATE TABLE projects ( + id int NOT NULL, + name varchar(100) default NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE projects_id MINVALUE 10000; + +CREATE TABLE developers_projects ( + developer_id int NOT NULL, + project_id int NOT NULL, + joined_on date default NULL +); +CREATE SEQUENCE developers_projects_id MINVALUE 10000; + +CREATE TABLE customers ( + id int NOT NULL, + name varchar(100) default NULL, + balance int default 0, + address_street varchar(100) default NULL, + address_city varchar(100) default NULL, + address_country varchar(100) default NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE customers_id MINVALUE 10000; + +CREATE TABLE movies ( + movieid int NOT NULL, + name varchar(100) default NULL, + PRIMARY KEY (movieid) +); +CREATE SEQUENCE movies_id MINVALUE 10000; + +CREATE TABLE subscribers ( + nick varchar(100) NOT NULL, + name varchar(100) default NULL, + PRIMARY KEY (nick) +); +CREATE SEQUENCE subscribers_id MINVALUE 10000; + +CREATE TABLE booleantests ( + id int NOT NULL, + value int default NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE booleantests_id MINVALUE 10000; + +CREATE TABLE auto_id_tests ( + auto_id int NOT NULL, + value int default NULL, + PRIMARY KEY (auto_id) +); +CREATE SEQUENCE auto_id_tests_id MINVALUE 10000; + +CREATE TABLE entrants ( + id int NOT NULL PRIMARY KEY, + name varchar(255) NOT NULL, + course_id int NOT NULL +); +CREATE SEQUENCE entrants_id MINVALUE 10000; + +CREATE TABLE colnametests ( + id int NOT NULL, + references int NOT NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE colnametests_id MINVALUE 10000; + +CREATE TABLE mixins ( + id int NOT NULL, + parent_id int default NULL, + pos int default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL, + lft int default NULL, + rgt int default NULL, + root_id int default NULL, + type varchar(40) default NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE mixins_id MINVALUE 10000; + +CREATE TABLE people ( + id int NOT NULL, + first_name varchar(40) NOT NULL, + lock_version int default 0, + PRIMARY KEY (id) +); +CREATE SEQUENCE people_id MINVALUE 10000; + +CREATE TABLE binaries ( + id int NOT NULL, + data blob, + PRIMARY KEY (id) +); +CREATE SEQUENCE binaries_id MINVALUE 10000; + +CREATE TABLE computers ( + id int, + developer int NOT NULL, + PRIMARY KEY (id) +); +CREATE SEQUENCE computers_id MINVALUE 10000; + +EXIT; diff --git a/activerecord/test/fixtures/db_definitions/oracle2.sql b/activerecord/test/fixtures/db_definitions/oracle2.sql new file mode 100644 index 0000000000..e0bfde022c --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/oracle2.sql @@ -0,0 +1,7 @@ +CREATE TABLE courses ( + id int NOT NULL PRIMARY KEY, + name varchar(255) NOT NULL +); +CREATE SEQUENCE courses_id MINVALUE 10000; + +EXIT; |