Module: Sequel::Usable

Defined in:
lib/sequel/extensions/usable.rb

Overview

Usable

Sequel extension that provides a convenient use method for switching the current database/schema context. This is particularly useful for databases that support the USE statement like MySQL, SQL Server, and some big data engines.

Examples:

db.extension :usable
db.use(:my_schema)
# Executes: USE `my_schema`

Instance Method Summary collapse

Instance Method Details

#use(schema_name) ⇒ Object

Switches to the specified database or schema.

Executes a USE statement to change the current database context. The schema name is properly quoted using the database’s identifier quoting rules.

Examples:

db.use(:production_db)
db.use('test_schema')

Parameters:

  • the name of the schema/database to use



26
27
28
 
# File 'lib/sequel/extensions/usable.rb', line 26

def use(schema_name)
  run(use_sql(schema_name))
end