Class: ROM::SQL::Gateway

Inherits:
Gateway
  • Object
show all
Includes:
Options, Migration
Defined in:
lib/rom/sql/gateway.rb

Overview

SQL gateway

Examples:

db = Sequel.connect(:sqlite)
gateway = ROM::SQL::Gateway.new(db)

users = gateway.dataset(:users)

Class Attribute Summary collapse

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Migration

create, included, #migration, #pending_migrations?, run, #run_migrations

Constructor Details

#connect(uri, options) ⇒ Gateway #connect(connection) ⇒ Gateway

SQL gateway interface

Examples:

gateway = ROM::SQL::Gateway.new('postgres://localhost/rom')

# or reuse connection
DB = Sequel.connect('postgres://localhost/rom')
gateway = ROM::SQL::Gateway.new(DB)

Overloads:

  • #connect(uri, options) ⇒ Gateway

    Connects to database via uri passing options

    Parameters:

    • uri (String, Symbol) —

      connection URI

    • options (Hash) —

      connection options

  • #connect(connection) ⇒ Gateway

    Re-uses connection instance

    Parameters:

    • connection (Sequel::Database) —

      a connection instance



54
55
56
57
58
59
60
61
62
63
64
 
# File 'lib/rom/sql/gateway.rb', line 54

def initialize(uri, options = {})
  repo_options = self.class.option_definitions.names
  conn_options = options.reject { |k, _| repo_options.include?(k) }

  @connection = connect(uri, conn_options)
  add_extensions(Array(options[:extensions])) if options[:extensions]

  super(uri, options.reject { |k, _| conn_options.keys.include?(k) })

  self.class.instance = self
end

Class Attribute Details

.instance ⇒ Object 



23
24
25
 
# File 'lib/rom/sql/gateway.rb', line 23

def instance
  @instance
end

Instance Attribute Details

#logger ⇒ Object (readonly)

Return optionally configured logger

Returns:

  • (Object) —

    logger



31
32
33
 
# File 'lib/rom/sql/gateway.rb', line 31

def logger
  @logger
end

Instance Method Details

#[](name) ⇒ Dataset

Return dataset with the given name

Parameters:

  • name (String) —

    dataset name

Returns:

  • (Dataset) 


80
81
82
 
# File 'lib/rom/sql/gateway.rb', line 80

def [](name)
  connection[name]
end

#create_table(*args, &block) ⇒ Object

Create a table using the configured connection



144
145
146
 
# File 'lib/rom/sql/gateway.rb', line 144

def create_table(*args, &block)
  connection.create_table(*args, &block)
end

#dataset(name) ⇒ Dataset

Return dataset with the given name

Parameters:

  • name (String) —

    a dataset name

Returns:

  • (Dataset) 


103
104
105
 
# File 'lib/rom/sql/gateway.rb', line 103

def dataset(name)
  connection[name]
end

#dataset?(name) ⇒ Boolean

Check if dataset exists

Parameters:

  • name (String) —

    dataset name

Returns:

  • (Boolean) 


112
113
114
 
# File 'lib/rom/sql/gateway.rb', line 112

def dataset?(name)
  schema.include?(name)
end

#disconnect ⇒ Object

Disconnect from database



69
70
71
 
# File 'lib/rom/sql/gateway.rb', line 69

def disconnect
  connection.disconnect
end

#drop_table(*args, &block) ⇒ Object

Drops a table



151
152
153
 
# File 'lib/rom/sql/gateway.rb', line 151

def drop_table(*args, &block)
  connection.drop_table(*args, &block)
end

#extend_command_class(klass, dataset) ⇒ Object

Extend database-specific behavior

Note: Currently, only postgres is supported.

Parameters:

  • klass (Class) —

    command class

  • dataset (Object) —

    a dataset that will be used



124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
 
# File 'lib/rom/sql/gateway.rb', line 124

def extend_command_class(klass, dataset)
  type = dataset.db.database_type

  if type == :postgres
    ext =
      if klass < Commands::Create
        Commands::Postgres::Create
      elsif klass < Commands::Update
        Commands::Postgres::Update
      end

    klass.send(:include, ext) if ext
  end

  klass
end

#schema ⇒ Array

Returns a list of datasets inferred from table names

Returns:

  • (Array) —

    array with table names



160
161
162
 
# File 'lib/rom/sql/gateway.rb', line 160

def schema
  @schema ||= connection.tables
end

#use_logger(logger) ⇒ Object

Setup a logger

Parameters:

  • logger (Object)

See Also:

  • Sequel::Database#loggers


91
92
93
94
 
# File 'lib/rom/sql/gateway.rb', line 91

def use_logger(logger)
  @logger = logger
  connection.loggers << logger
end