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