Contents

# connect to the database and setup the schema
require "active_record"
require "yaml"
abc = YAML.load_file("config/database.yml")
ActiveRecord::Base.establish_connection(abc["test"])

# Remove after migration to Rails 5
ActiveRecord::Base.raise_in_transactional_callbacks = true

ActiveRecord::Base.logger = Logger.new("log/test.log")

ActiveRecord::Schema.define do
  self.verbose = false

  execute <<~SQL
    DROP SCHEMA public CASCADE;
    CREATE SCHEMA public;
    CREATE EXTENSION IF NOT EXISTS hstore;

    DROP TYPE IF EXISTS access_level;
    CREATE TYPE access_level AS ENUM (
        'private',
        'company',
        'viewable',
        'accessible'
    );

    CREATE TABLE organizations (
      id SERIAL PRIMARY KEY,
      name VARCHAR
    );

    CREATE TABLE users (
      id SERIAL PRIMARY KEY,
      organization_id INTEGER REFERENCES organizations (id),
      role_id INTEGER,
      first_name VARCHAR,
      last_name VARCHAR,
      metadata JSONB,
      access_level access_level,
      created_at timestamp,
      updated_at timestamp
    );

    CREATE TABLE unique_users (
      id SERIAL PRIMARY KEY,
      first_name VARCHAR,
      last_name VARCHAR
    );

    CREATE UNIQUE INDEX unique_users_ix1 ON unique_users(first_name, last_name)
  SQL
end

Version data entries

53 entries across 53 versions & 1 rubygems

Version	Path
simple-sql-0.5.23	spec/support/001_database.rb
simple-sql-0.5.22	spec/support/001_database.rb
simple-sql-0.5.21	spec/support/001_database.rb
simple-sql-0.5.20	spec/support/001_database.rb
simple-sql-0.5.19	spec/support/001_database.rb
simple-sql-0.5.18	spec/support/001_database.rb
simple-sql-0.5.17	spec/support/001_database.rb
simple-sql-0.5.16	spec/support/001_database.rb
simple-sql-0.5.15	spec/support/001_database.rb
simple-sql-0.5.14	spec/support/001_database.rb
simple-sql-0.5.13	spec/support/001_database.rb
simple-sql-0.5.12	spec/support/001_database.rb
simple-sql-0.5.11	spec/support/001_database.rb
simple-sql-0.5.10	spec/support/001_database.rb
simple-sql-0.5.9	spec/support/001_database.rb
simple-sql-0.5.8	spec/support/001_database.rb
simple-sql-0.5.7	spec/support/001_database.rb
simple-sql-0.5.6	spec/support/001_database.rb
simple-sql-0.5.5	spec/support/001_database.rb
simple-sql-0.5.4	spec/support/001_database.rb