abstract class Jennifer::Adapter::Base

• Jennifer::Adapter::Base
• Reference
• Object

Included Modules

• Jennifer::Adapter::ResultParsers
• Jennifer::Adapter::Transactions

Extended Modules

• Jennifer::Adapter::Base::AbstractClassMethods

Direct Known Subclasses

• Jennifer::Mysql::Adapter
• Jennifer::Postgres::Adapter

Defined in:

Constructors

• .new(config : Config)

Class Method Summary

• .foreign_key_name(from_table, to_table = nil, column = nil, name : String? = nil) : String

  Generates foreign key name for given tables.

• .join_table_name(table1 : String | Symbol, table2 : String | Symbol)

  Generates name for join table.

• .t(field : Nil)

  filter out value; should be refactored

• .t(field : String)
• .t(field)

Instance Method Summary

• #bulk_insert(table : String, fields : Array(String), values : Array(ArgsType))
• #bulk_insert(collection : Array(Model::Base))
• #column_exists?(table, name)

  Returns whether column of table with name exists.

• #command_interface
• #config : Config
• #connection_string(type : ConnectionType)
• #count(query : QueryBuilder::Query)
• #create_database
• #database_exists?
• #db : DB::Database
• #db_connection(&)

  Yields to block connection to the database main schema.

• #default_type_size(name)
• #delete(query : QueryBuilder::Query)
• #drop_database
• #exec(query : String, args : ArgsType = [] of DBAny) : DB::ExecResult
• #exists?(query : QueryBuilder::Query) : Bool
• #explain(q)
• #foreign_key_exists?(from_table, to_table = nil, column = nil, name : String? = nil) : Bool

  Checks to see if a foreign key exists on a table for a given foreign key definition.

• #generate_schema
• #index_exists?(table, fields : Array)

  Returns whether index for the *table` with name or fields exists.

• #index_exists?(table, name : String)
• #insert(obj : Model::Base)
• #load_schema
• #log_query(query : String, args : Enumerable, &)
• #log_query(query : String, &)
• #max_bind_vars_count
• #parse_query(q : String, args : ArgsType)
• #parse_query(q : String)
• #prepare
• #query(query : String, args : ArgsType = [] of DBAny, &)
• #query_array(_query : String, klass : T.class, field_count : Int32 = 1) forall T
• #ready_to_migrate!
• #refresh_materialized_view(name)
• #scalar(query : String, args : ArgsType = [] of DBAny)
• #schema_processor
• #sql_generator
• #table_column_count(table)
• #table_exists?(table)

  Returns where table with given table name exists.

• #tables_column_count(tables : Array(String))
• #translate_type(name)

  Translates symbol data type name to database-specific data type.

• #truncate(klass : Class)
• #truncate(table_name : String)
• #upsert(table : String, fields : Array(String), values : Array(ArgsType), unique_fields : Array, on_conflict : Hash)
• #upsert(collection : Array(Model::Base), unique_fields : Array, definition : Hash = {} of Nil => Nil)
• #view_exists?(name) : Bool

  Check whether view with given name exists.

• #with_table_lock(table : String, type : String = "default", &block : DB::Transaction -> Void)

Constructor Detail

Class Method Detail

Instance Method Detail

# Check a column exists
column_exists?(:suppliers, :name)

# Checks to see if a foreign key exists.
adapter.foreign_key_exists?(:accounts, :branches)

# Checks to see if a foreign key on a specified column exists.
adapter.foreign_key_exists?(:accounts, column: :owner_id)

# Checks to see if a foreign key with a custom name exists.
adapter.foreign_key_exists?(:accounts, name: "special_fk_name")

# Check an index exists
adapter.index_exists?(:suppliers, :company_id)

# Check an index on multiple columns exists
adapter.index_exists?(:suppliers, [:company_id, :company_type])

# Check an index with a custom name exists
adapter.index_exists?(:suppliers, "idx_company_id")

adapter.table_exists?(:developers)

adapter.view_exists?(:youth_contacts)