class Makanai::Dbms::Postgres

Attributes

db[R]

Public Class Methods

new(config) click to toggle source
Calls superclass method
# File lib/makanai/dbms/postgres.rb, line 8
def initialize(config)
  super()
  @db = PG.connect(config || default_config)
  db.type_map_for_results = PG::BasicTypeMapForResults.new(db)
end

Public Instance Methods

execute_sql(sql) click to toggle source
# File lib/makanai/dbms/postgres.rb, line 16
def execute_sql(sql)
  db.exec(sql).each.to_a.tap { close_db }
end

Private Instance Methods

close_db() click to toggle source
# File lib/makanai/dbms/postgres.rb, line 31
def close_db
  db.finish
end
default_config() click to toggle source
# File lib/makanai/dbms/postgres.rb, line 22
def default_config
  {
    host: 'localhost',
    password: nil,
    dbname: 'makanai',
    port: 5432
  }
end