Methods
- B
- C
- E
- S
Constants
MONEY_COLUMN_TYPE_OID | = | 790 |
The internal PostgreSQL identifier of the money data type. |
||
BYTEA_COLUMN_TYPE_OID | = | 17 |
The internal PostgreSQL identifier of the BYTEA data type. |
Instance Public methods
begin_db_transaction()
Link
Begins a transaction.
begin_isolated_db_transaction(isolation)
Link
commit_db_transaction()
Link
Commits a transaction.
exec_insert(sql, name, binds, pk = nil, sequence_name = nil)
Link
# File activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb, line 134 def exec_insert(sql, name, binds, pk = nil, sequence_name = nil) val = exec_query(sql, name, binds) if !use_insert_returning? && pk unless sequence_name table_ref = extract_table_ref_from_insert_sql(sql) sequence_name = default_sequence_name(table_ref, pk) return val unless sequence_name end last_insert_id_result(sequence_name) else val end end
exec_query(sql, name = 'SQL', binds = [], prepare: false)
Link
# File activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb, line 102 def exec_query(sql, name = 'SQL', binds = [], prepare: false) execute_and_clear(sql, name, binds, prepare: prepare) do |result| types = {} fields = result.fields fields.each_with_index do |fname, i| ftype = result.ftype i fmod = result.fmod i types[fname] = get_oid_type(ftype, fmod, fname) end ActiveRecord::Result.new(fields, result.values, types) end end
exec_rollback_db_transaction()
Link
Aborts a transaction.
execute(sql, name = nil)
Link
Executes an SQL statement, returning a PGresult object on success or raising a PGError exception otherwise. Note: the PGresult object is manually memory managed; if you don't need it specifically, you many want consider the #exec_query wrapper.
explain(arel, binds = [])
Link
select_rows(sql, name = nil, binds = [])
Link
Executes a SELECT query and returns an array of rows. Each row is an array of field values.
select_value(arel, name = nil, binds = [])
Link
# File activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb, line 10 def select_value(arel, name = nil, binds = []) arel, binds = binds_from_relation arel, binds sql = to_sql(arel, binds) execute_and_clear(sql, name, binds) do |result| result.getvalue(0, 0) if result.ntuples > 0 && result.nfields > 0 end end
select_values(arel, name = nil, binds = [])
Link
# File activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb, line 18 def select_values(arel, name = nil, binds = []) arel, binds = binds_from_relation arel, binds sql = to_sql(arel, binds) execute_and_clear(sql, name, binds) do |result| if result.nfields > 0 result.column_values(0) else [] end end end