Class: NetSystem::SqliteClient

Inherits:
Client show all
Defined in:
lib/net_system/subsystems/database/clients/sqlite_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(*args) ⇒ SqliteClient

https://www.sqlite.org/ https://github.com/sparklemotion/sqlite3-ruby



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

def initialize *args
  self.class.call({})
  t = Time.now
  if args.empty?
    h = NetBox[:client].get(:sqlite_hash)
    args = [h[:path]]
  end
  @conn = SQLite3::Database.new(*args)
ensure
  log "#{t.diff}s | Connecting to #{args}"
end

Instance Attribute Details

#conn ⇒ Object (readonly)

Returns the value of attribute conn.



18
19
20
 
# File 'lib/net_system/subsystems/database/clients/sqlite_client.rb', line 18

def conn
  @conn
end

Instance Method Details

#call(sql, *args) ⇒ Object 



20
21
22
23
24
25
26
27
 
# File 'lib/net_system/subsystems/database/clients/sqlite_client.rb', line 20

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

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

#now ⇒ Object 



29
30
31
 
# File 'lib/net_system/subsystems/database/clients/sqlite_client.rb', line 29

def now
  call "SELECT strftime('%Y-%m-%dT%H:%M:%S.%f', 'now', 'localtime');"
end