sql_for_insert(sql, pk, id_value, sequence_name, binds) Instance Public methods

select_rows(sql, name = nil, binds = []) Instance Public methods Executes a SELECT query and returns an array of rows. Each row is an array of field values.

rollback_db_transaction() Instance Public methods Aborts a transaction.

insert_sql(sql, name = nil, pk = nil, id_value = nil, sequence_name = nil) Instance Public methods Executes an INSERT query and returns the new record's ID

explain(arel, binds = []) Instance Public methods

execute(sql, name = nil) Instance Public methods Executes an SQL statement, returning a PGresult object on success or raising a PGError exception otherwise.

exec_update(sql, name = 'SQL', binds = []) Instance Public methods Alias for: exec_delete

exec_query(sql, name = 'SQL', binds = []) Instance Public methods

exec_insert(sql, name, binds, pk = nil, sequence_name = nil) Instance Public methods

exec_delete(sql, name = 'SQL', binds = []) Instance Public methods Also aliased as: exec_update