ifad/eaco

module Eaco
  module Cucumber
    module ActiveRecord

      # @!method clean
      #
      # Drops all tables currently instantiated in the database.
      #
      # @see Eaco::Cucumber::World
      #
      ::ActiveRecord::Base.connection.tap do |connection|
        connection.tables.each do |table_name|
          connection.drop_table table_name
        end
      end

      # @!method schema
      #
      # Defines the database schema for the {Eaco::Cucumber::World} scenario.
      #
      # @see Eaco::Cucumber::World
      #
      ::ActiveRecord::Schema.define(version: '2015022301') do
        # Resource
        create_table 'documents', force: true do |t|
          t.string :name
          t.column :acl, :jsonb
        end

        # Actor
        create_table 'users', force: true do |t|
          t.string :name
          t.boolean :admin, default: false
        end

        # Designator source
        create_table 'departments', force: true do |t|
          t.string :name
        end
        add_index :departments, :name, unique: true

        # Designator source
        create_table 'positions', force: true do |t|
          t.string :name

          t.references :user
          t.references :department
        end
      end

    end
  end
end