class HPgSql

Public Class Methods

new(host, port, dbname, user, password, timezone, connectionName) click to toggle source
Calls superclass method HDB::new
# File lib/hdb/hpgsql.rb, line 5
def initialize(host, port, dbname, user, password, timezone, connectionName)

  super(host, port, dbname, user, password, timezone, connectionName, "hpgsql")
  @result = nil

end

Public Instance Methods

_execute(queryStr = self.queryStr) click to toggle source
# File lib/hdb/hpgsql.rb, line 28
def _execute(queryStr = self.queryStr) 

  @table = []
  @result = @connection.query(queryStr)
  @result.each do |row|  
    @table << row
  end
  return self

end
connect() click to toggle source
# File lib/hdb/hpgsql.rb, line 12
def connect()

  @connection = PGconn.new(@host, @port, "", "", @dbname, @user, @password)
  hl << "Server version: #{self.execute("SHOW server_version").firstData.to_s}"
  self.execute("SET TIME ZONE '#{@timezone}'") if @timezone
  return @connection

end
disconnect() click to toggle source
# File lib/hdb/hpgsql.rb, line 21
def disconnect()

  @connection.close()
  @connection = nil

end
fieldNameList() click to toggle source
# File lib/hdb/hpgsql.rb, line 39
def fieldNameList()

  fieldList = {}
  
  @result.fields.each { |fieldName| fieldList[fieldName] = nil }
  
  return fieldList

end
rowsAffected() click to toggle source
# File lib/hdb/hpgsql.rb, line 49
def rowsAffected
  return @result.cmd_tuples()
end