DB::DriverSpecs(DBAnyType)

Helper class to ensure behaviour of custom drivers

require "db/spec"

DB::DriverSpecs(DB::Any).run do
  # How to connect to database
  connection_string "scheme://database_url"

  # Clean up database if needed using before/after callbacks
  before do
    # ...
  end

  after do
    # ...
  end

  # Sample values that will be stored, retrieved across many specs
  sample_value "hello", "varchar(25)", "'hello'"

  it "custom spec with a db initialized" do |db|
    # assert something using *db*
  end

  # Configure the appropiate syntax for different commands needed to run the specs
  binding_syntax do |index|
    "?"
  end

  create_table_1column_syntax do |table_name, col1|
    "create table #{table_name} (#{col1.name} #{col1.sql_type} #{col1.null ? "NULL" : "NOT NULL"})"
  end
end

The following methods needs to be called to configure the appropiate syntax for different commands and allow all the specs to run: binding_syntax, create_table_1column_syntax, create_table_2columns_syntax, select_1column_syntax, select_2columns_syntax, select_count_syntax, select_scalar_syntax, insert_1column_syntax, insert_2columns_syntax, drop_table_if_exists_syntax.