Added Sybase database adapter that relies on the Sybase Open Client bindings (see http://raa.ruby-lang.org/project/sybase-ctlib) (closes #3765) [John Sheets]

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3734 5ecf4fe2-1ee6-0310-87b1-e25e094e27de

5 files changed, 245 insertions, 1 deletions

diff --git a/activerecord/test/fixtures/db_definitions/sybase.drop.sql b/activerecord/test/fixtures/db_definitions/sybase.drop.sql
new file mode 100644
index 0000000000..f843a80f7a
--- /dev/null
+++ b/activerecord/test/fixtures/db_definitions/sybase.drop.sql
@@ -0,0 +1,31 @@
+DROP TABLE accounts
+DROP TABLE funny_jokes
+DROP TABLE companies
+DROP TABLE topics
+DROP TABLE developers
+DROP TABLE projects
+DROP TABLE developers_projects
+DROP TABLE customers
+DROP TABLE orders
+DROP TABLE movies
+DROP TABLE subscribers
+DROP TABLE booleantests
+DROP TABLE auto_id_tests
+DROP TABLE entrants
+DROP TABLE colnametests
+DROP TABLE mixins
+DROP TABLE people
+DROP TABLE readers
+DROP TABLE binaries
+DROP TABLE computers
+DROP TABLE tasks
+DROP TABLE posts
+DROP TABLE comments
+DROP TABLE authors
+DROP TABLE categories
+DROP TABLE categories_posts
+DROP TABLE fk_test_has_fk
+DROP TABLE fk_test_has_pk
+DROP TABLE keyboards
+DROP TABLE legacy_things
+go
diff --git a/activerecord/test/fixtures/db_definitions/sybase.sql b/activerecord/test/fixtures/db_definitions/sybase.sql
new file mode 100644
index 0000000000..28164d8a14
--- /dev/null
+++ b/activerecord/test/fixtures/db_definitions/sybase.sql
@@ -0,0 +1,204 @@
+CREATE TABLE accounts (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  firm_id int NULL,
+  credit_limit int NULL
+)
+
+CREATE TABLE funny_jokes (
+id numeric(9,0) IDENTITY PRIMARY KEY,
+  name varchar(50) NULL
+)
+
+CREATE TABLE companies (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  type varchar(50) NULL,
+  ruby_type varchar(50) NULL,
+  firm_id int NULL,
+  name varchar(50) NULL,
+  client_of int NULL,
+  rating int default 1
+)
+
+
+CREATE TABLE topics (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  title varchar(255) NULL,
+  author_name varchar(255) NULL,
+  author_email_address varchar(255) NULL,
+  written_on datetime NULL,
+  bonus_time time NULL,
+  last_read datetime NULL,
+  content varchar(255) NULL,
+  approved tinyint default 1 NULL,
+  replies_count int default 0 NULL,
+  parent_id int NULL,
+  type varchar(50) NULL
+)
+
+CREATE TABLE developers (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  name varchar(100) NULL,
+  salary int default 70000,
+  created_at datetime NULL,
+  updated_at datetime NULL
+)
+
+CREATE TABLE projects (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  name varchar(100) NULL,
+  type VARCHAR(255) NULL
+)
+
+CREATE TABLE developers_projects (
+  developer_id int NOT NULL,
+  project_id int NOT NULL,
+  joined_on datetime NULL,
+  access_level smallint default 1
+)
+
+CREATE TABLE orders (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  name varchar(100) NULL,
+  billing_customer_id int NULL,
+  shipping_customer_id int NULL
+)
+
+CREATE TABLE customers (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  name varchar(100) NULL,
+  balance int default 0,
+  address_street varchar(100) NULL,
+  address_city varchar(100) NULL,
+  address_country varchar(100) NULL,
+  gps_location varchar(100) NULL
+)
+
+CREATE TABLE movies (
+  movieid numeric(9,0) IDENTITY PRIMARY KEY,
+  name varchar(100) NULL
+)
+
+CREATE TABLE subscribers (
+  nick varchar(100) PRIMARY KEY,
+  name varchar(100) NULL
+)
+
+CREATE TABLE booleantests (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  value integer NULL
+)
+
+CREATE TABLE auto_id_tests (
+  auto_id numeric(9,0) IDENTITY PRIMARY KEY,
+  value integer NULL
+)
+
+CREATE TABLE entrants (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  name VARCHAR(255) NOT NULL,
+  course_id INTEGER NOT NULL
+)
+
+CREATE TABLE colnametests (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  [references] int NOT NULL
+)
+
+CREATE TABLE mixins (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  parent_id int NULL,
+  pos int NULL,
+  created_at datetime NULL,
+  updated_at datetime NULL,
+  lft int NULL,
+  rgt int NULL,
+  root_id int NULL,
+  type varchar(40) NULL
+)
+
+CREATE TABLE people (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  first_name VARCHAR(40) NOT NULL,
+  lock_version INTEGER DEFAULT 0
+)
+
+CREATE TABLE readers (
+    id numeric(9,0) IDENTITY PRIMARY KEY,
+    post_id int NOT NULL,
+    person_id int NOT NULL
+)
+
+CREATE TABLE binaries (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  data image NULL
+)
+
+CREATE TABLE computers (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  developer INTEGER NOT NULL,
+  extendedWarranty INTEGER NOT NULL
+)
+
+CREATE TABLE posts (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  author_id INTEGER NULL,
+  title VARCHAR(255) NOT NULL,
+  body VARCHAR(2048) NOT NULL,
+  type VARCHAR(255) NOT NULL
+)
+
+CREATE TABLE comments (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  post_id INTEGER NOT NULL,
+  body VARCHAR(2048) NOT NULL,
+  type VARCHAR(255) NOT NULL
+)
+
+CREATE TABLE authors (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  name VARCHAR(255) NOT NULL
+)
+
+CREATE TABLE tasks (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  starting datetime NULL,
+  ending datetime NULL
+)
+
+CREATE TABLE categories (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  name VARCHAR(255) NOT NULL,
+  type VARCHAR(255) NOT NULL
+)
+
+CREATE TABLE categories_posts (
+  category_id int NOT NULL,
+  post_id int NOT NULL
+)
+
+CREATE TABLE fk_test_has_pk (
+  id numeric(9,0) IDENTITY PRIMARY KEY
+)
+
+CREATE TABLE fk_test_has_fk (
+  id    numeric(9,0) PRIMARY KEY,
+  fk_id numeric(9,0) NOT NULL,
+
+  FOREIGN KEY (fk_id) REFERENCES fk_test_has_pk(id)
+)
+
+
+CREATE TABLE keyboards (
+  key_number numeric(9,0) IDENTITY PRIMARY KEY,
+  name varchar(50) NULL
+)
+
+--This table has an altered lock_version column name.
+CREATE TABLE legacy_things (
+  id numeric(9,0) IDENTITY PRIMARY KEY,
+  tps_report_number int default NULL,
+  version int default 0,
+)
+
+go
+
diff --git a/activerecord/test/fixtures/db_definitions/sybase2.drop.sql b/activerecord/test/fixtures/db_definitions/sybase2.drop.sql
new file mode 100644
index 0000000000..f4ce96fec0
--- /dev/null
+++ b/activerecord/test/fixtures/db_definitions/sybase2.drop.sql
@@ -0,0 +1,4 @@
+DROP TABLE courses
+go
+
+
diff --git a/activerecord/test/fixtures/db_definitions/sybase2.sql b/activerecord/test/fixtures/db_definitions/sybase2.sql
new file mode 100644
index 0000000000..88f9d329a3
--- /dev/null
+++ b/activerecord/test/fixtures/db_definitions/sybase2.sql
@@ -0,0 +1,5 @@
+CREATE TABLE courses (
+ id int NOT NULL PRIMARY KEY,
+ name varchar(255) NOT NULL
+)
+go
diff --git a/activerecord/test/fixtures/mixin.rb b/activerecord/test/fixtures/mixin.rb
index 0411c0d87e..78cdbef9b3 100644
--- a/activerecord/test/fixtures/mixin.rb
+++ b/activerecord/test/fixtures/mixin.rb
@@ -30,7 +30,7 @@ class ListWithStringScopeMixin < ActiveRecord::Base
 end
 
 class NestedSet < Mixin
-  acts_as_nested_set :scope => "ROOT_ID IS NULL"
+  acts_as_nested_set :scope => "root_id IS NULL"
   
   def self.table_name() "mixins" end
 end