class Jennifer::Postgres::Adapter

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

Included Modules

• Jennifer::Adapter::RequestMethods

Defined in:

Constant Summary

DEFAULT_SIZES = {:string => 254}

TABLE_LOCK_TYPES = {"as" => "ACCESS SHARE", "rs" => "ROW SHARE", "re" => "ROW EXCLUSIVE", "sue" => "SHARE UPDATE EXCLUSIVE", "s" => "SHARE", "sre" => "SHARE ROW EXCLUSIVE", "e" => "EXCLUSIVE", "ae" => "ACCESS EXCLUSIVE", "default" => "SHARE"}

TYPE_TRANSLATIONS = {:bool => "boolean", :integer => "int", :short => "SMALLINT", :bigint => "BIGINT", :oid => "oid", :float => "real", :double => "double precision", :numeric => "numeric", :decimal => "decimal", :string => "varchar", :char => "char", :text => "text", :varchar => "varchar", :blchar => "blchar", :uuid => "uuid", :timestamp => "timestamp", :timestamptz => "timestamptz", :date_time => "timestamp", :date => "date", :bytea => "bytea", :json => "json", :jsonb => "jsonb", :xml => "xml", :point => "point", :lseg => "lseg", :path => "path", :box => "box", :polygon => "polygon", :line => "line", :circle => "circle"}

Class Method Summary

• .default_max_bind_vars_count
• .protocol : String

Instance Method Summary

• #column_exists?(table, name)

  Returns whether column of table with name exists.

• #command_interface
• #default_type_size(name)
• #enum_exists?(name)
• #enum_values(name)
• #exists?(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.

• #index_exists?(_table, name : String)
• #insert(obj : Model::Base)
• #material_view_exists?(name)
• #refresh_materialized_view(name)
• #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.

• #view_exists?(name) : Bool

  Check whether view with given name exists.

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

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")

adapter.table_exists?(:developers)

adapter.view_exists?(:youth_contacts)