class Sequel::Mock::Database

Database class for Sequel’s mock adapter.

Attributes

columns[W]

Set the columns to set in the dataset when the dataset fetches rows. Argument types supported:

nil

Set no columns

Array of Symbols: Used for all datasets Array (otherwise): First retrieval gets the first value in the

array, second gets the second value, etc.
Proc

Called with the select SQL query, uses the value returned, which should be an array of symbols

fetch[W]

Set the hashes to yield by execute when retrieving rows. Argument types supported:

nil

Yield no rows

Hash

Always yield a single row with this hash

Array of Hashes

Yield separately for each hash in this array

Array (otherwise)

First retrieval gets the first value in the array, second gets the second value, etc.

Proc

Called with the select SQL query, uses the value returned, which should be a hash or array of hashes.

Class

Should be an Exception subclass, will create a new instance an raise it wrapped in a DatabaseError.

numrows[W]

Set the number of rows to return from update or delete. Argument types supported:

nil

Return 0 for all updates and deletes

Integer

Used for all updates and deletes

Array

First update/delete gets the first value in the array, second gets the second value, etc.

Proc

Called with the update/delete SQL query, uses the value returned.

Class

Should be an Exception subclass, will create a new instance an raise it wrapped in a DatabaseError.

server_version[RW]

Mock the server version, useful when using the shared adapters

Public Instance Methods

autoid=(v) click to toggle source

Set the autogenerated primary key integer to be returned when running an insert query. Argument types supported:

nil

Return nil for all inserts

Integer

Starting integer for next insert, with futher inserts getting an incremented value

Array

First insert gets the first value in the array, second gets the second value, etc.

Proc

Called with the insert SQL query, uses the value returned

Class

Should be an Exception subclass, will create a new instance an raise it wrapped in a DatabaseError.

# File lib/sequel/adapters/mock.rb, line 51
def autoid=(v)
  @autoid = case v
  when Integer
    i = v - 1
    proc{Sequel.synchronize{i+=1}}
  else
    v
  end
end
connect(server) click to toggle source

Return a related Connection option connecting to the given shard.

# File lib/sequel/adapters/mock.rb, line 103
def connect(server)
  Connection.new(self, server, server_opts(server))
end
disconnect_connection(c) click to toggle source
# File lib/sequel/adapters/mock.rb, line 107
def disconnect_connection(c)
end
execute(sql, opts=OPTS, &block) click to toggle source

Store the sql used for later retrieval with sqls, and return the appropriate value using either the autoid, fetch, or numrows methods.

# File lib/sequel/adapters/mock.rb, line 113
def execute(sql, opts=OPTS, &block)
  synchronize(opts[:server]){|c| _execute(c, sql, opts, &block)} 
end
Also aliased as: execute_ddl
execute_ddl(sql, opts=OPTS, &block) click to toggle source
Alias for: execute
execute_dui(sql, opts=OPTS) click to toggle source

Store the sql used, and return the value of the numrows method.

# File lib/sequel/adapters/mock.rb, line 119
def execute_dui(sql, opts=OPTS)
  execute(sql, opts.merge(:meth=>:numrows))
end
execute_insert(sql, opts=OPTS) click to toggle source

Store the sql used, and return the value of the autoid method.

# File lib/sequel/adapters/mock.rb, line 124
def execute_insert(sql, opts=OPTS)
  execute(sql, opts.merge(:meth=>:autoid))
end
sqls() click to toggle source

Return all stored SQL queries, and clear the cache of SQL queries.

# File lib/sequel/adapters/mock.rb, line 130
def sqls
  s = @sqls.dup
  @sqls.clear
  s
end
supports_savepoints?() click to toggle source

Enable use of savepoints.

# File lib/sequel/adapters/mock.rb, line 137
def supports_savepoints?
  shared_adapter? ? super : true
end