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 "DROP SCHEMA public CASCADE;"
  execute "CREATE SCHEMA public;"
  execute "CREATE EXTENSION IF NOT EXISTS hstore;"

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

  create_table :users, force: true do |t|
    t.integer   :role_id
    t.string    :first_name
    t.string    :last_name
    t.hstore    :meta_data
    t.column    :access_level, :access_level

    t.timestamps null: true
  end

  create_table :unique_users, force: true do |t|
    t.string    :first_name
    t.string    :last_name
  end

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

Version data entries

14 entries across 14 versions & 1 rubygems

Version	Path
simple-sql-0.4.5	spec/support/001_database.rb
simple-sql-0.4.4	spec/support/001_database.rb
simple-sql-0.4.3	spec/support/001_database.rb
simple-sql-0.4.2	spec/support/001_database.rb
simple-sql-0.4.1	spec/support/001_database.rb
simple-sql-0.4.0	spec/support/001_database.rb
simple-sql-0.3.7	spec/support/001_database.rb
simple-sql-0.3.6	spec/support/001_database.rb
simple-sql-0.3.5	spec/support/001_database.rb
simple-sql-0.3.4	spec/support/001_database.rb
simple-sql-0.3.3	spec/support/001_database.rb
simple-sql-0.2.10	spec/support/001_database.rb
simple-sql-0.3.2	spec/support/001_database.rb
simple-sql-0.2.9	spec/support/001_database.rb