Class: PostgresDatabaseConnection

Inherits:
Object
  • Object
show all
Defined in:
lib/live_sql/psql_dbconnection.rb

Instance Method Summary collapse

Constructor Details

#initialize(db) ⇒ PostgresDatabaseConnection

Returns a new instance of PostgresDatabaseConnection.



5
6
7
8
 
# File 'lib/live_sql/psql_dbconnection.rb', line 5

def initialize(db)
  @connection = PG.connect(dbname: db)
  @connection.type_map_for_results = PG::BasicTypeMapForResults.new @connection
end

Instance Method Details

#execute(arg) ⇒ Object 



10
11
12
13
14
15
16
17
 
# File 'lib/live_sql/psql_dbconnection.rb', line 10

def execute(arg)
  results = []
  result = @connection.exec(arg)
  result.each_row do |row|
    results << Hash[result.fields.zip(row)]
  end
  results
end