Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

Inherits:
AbstractAdapter show all
Defined in:
lib/active_record/connection_adapters/postgresql_adapter.rb

Overview

:nodoc:

Instance Method Summary collapse

Methods inherited from AbstractAdapter

#add_limit!, #initialize, #quote, #quote_string, #reset_runtime, #structure_dump, #transaction

Constructor Details

This class inherits a constructor from ActiveRecord::ConnectionAdapters::AbstractAdapter

Instance Method Details

#begin_db_transaction ⇒ Object 



75
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 75

def begin_db_transaction()    execute "BEGIN" end

#columns(table_name, name = nil) ⇒ Object 



50
51
52
53
54
55
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 50

def columns(table_name, name = nil)
  table_structure(table_name).inject([]) do |columns, field|
    columns << Column.new(field[0], field[2], field[1])
    columns
  end
end

#commit_db_transaction ⇒ Object 



76
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 76

def commit_db_transaction()   execute "COMMIT" end

#execute(sql, name = nil) ⇒ Object 



63
64
65
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 63

def execute(sql, name = nil)
  log(sql, name, @connection) { |connection| connection.query(sql) }
end

#insert(sql, name = nil, pk = nil, id_value = nil) ⇒ Object 



57
58
59
60
61
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 57

def insert(sql, name = nil, pk = nil, id_value = nil)
  execute(sql, name = nil)
  table = sql.split(" ", 4)[2]
  return id_value || last_insert_id(table, pk)
end

#quote_column_name(name) ⇒ Object 



79
80
81
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 79

def quote_column_name(name)
  return "\"#{name}\""
end

#rollback_db_transaction ⇒ Object 



77
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 77

def rollback_db_transaction() execute "ROLLBACK" end

#select_all(sql, name = nil) ⇒ Object 



41
42
43
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 41

def select_all(sql, name = nil)
  select(sql, name)
end

#select_one(sql, name = nil) ⇒ Object 



45
46
47
48
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 45

def select_one(sql, name = nil)
  result = select(sql, name)
  result.nil? ? nil : result.first
end

#update(sql, name = nil) ⇒ Object Also known as: delete 



67
68
69
70
71
 
# File 'lib/active_record/connection_adapters/postgresql_adapter.rb', line 67

def update(sql, name = nil)
  result = nil
  log(sql, name, @connection) { |connection| result = connection.exec(sql) }
  result.cmdtuples
end