Class: NetSystem::PgsqlClient

Inherits:
Client show all
Defined in:
lib/net_system/subsystems/database/clients/pgsql_client.rb

Instance Attribute Summary collapse

Attributes inherited from Liza::Controller

#menv

Instance Method Summary collapse

Methods inherited from Liza::Controller

#`, `, attr_accessor, attr_reader, attr_writer, #attrs, box, #box, call, color, division, division!, division?, inherited, menv_accessor, menv_reader, menv_writer, on_connected, panel, #panel, plural, require, requirements, sh, #sh, singular, subsystem, subsystem!, subsystem?, subsystem_token, token

Methods inherited from Liza::Unit

_erbs_for, #add, add, cl, #cl, class_methods_defined, const_added, const_missing, constants_defined, define_error, descendants_select, division, erbs_available, erbs_defined, erbs_for, errors, #fetch, fetch, get, #get, instance_methods_defined, log, #log, log?, #log?, #log_array, log_array, log_hash, #log_hash, #log_level, log_level, #log_level?, log_level?, log_levels, #log_levels, #log_render_convert, #log_render_format, #log_render_in, #log_render_out, method_added, methods_defined, namespace, part, raise_error, #raise_error, reload!, #reload!, #render, #render!, #render_stack, renderable_formats_for, renderable_names, section, sections, #set, set, #settings, settings, singleton_method_added, sleep, #sleep, stick, #stick, sticks, #sticks, subclasses_select, subunits, system, #system, system?, test_class, time_diff, #time_diff

Constructor Details

#initialize(hash = {}) ⇒ PgsqlClient

https://www.postgresql.org/ https://github.com/ged/ruby-pg



6
7
8
9
10
11
12
13
 
# File 'lib/net_system/subsystems/database/clients/pgsql_client.rb', line 6

def initialize hash={}
  self.class.call({})
  t = Time.now
  hash = NetBox[:client].get(:pgsql_hash) if hash.empty?
  @conn = PG::Connection.new(hash)
ensure
  log "#{t.diff}s | Connecting to #{hash}"
end

Instance Attribute Details

#conn ⇒ Object (readonly)

Returns the value of attribute conn.



15
16
17
 
# File 'lib/net_system/subsystems/database/clients/pgsql_client.rb', line 15

def conn
  @conn
end

Instance Method Details

#call(sql, *args) ⇒ Object 



17
18
19
20
21
22
23
24
 
# File 'lib/net_system/subsystems/database/clients/pgsql_client.rb', line 17

def call sql, *args
  t = Time.now
  result = @conn.exec sql, args

  result
ensure
  log "#{t.diff}s | #{sql} | #{args}"
end

#now ⇒ Object 



26
27
28
 
# File 'lib/net_system/subsystems/database/clients/pgsql_client.rb', line 26

def now
  call "SELECT NOW();"
end