Class: JunglePath::DBAccess::IO::Select

Inherits:
Object
  • Object
show all
Includes:
InitDB
Defined in:
lib/jungle_path/db_access/io/select.rb

Instance Method Summary collapse

Methods included from InitDB

#handle_json_columns, #initialize

Instance Method Details

#_model(model) ⇒ Object 



9
10
11
12
13
14
15
16
 
# File 'lib/jungle_path/db_access/io/select.rb', line 9

def _model(model)
	# select based on a model's primary key.
	ds = @db[model._table_name].where(model._primary_key)
	#puts ds.sql
	hash = ds.first
	return nil unless hash
	new_model = model.class.new(hash, false) # false since row (initial values) from db is considered unmodified.
end

#_model_by_any(model) ⇒ Object 



18
19
20
21
22
23
24
25
 
# File 'lib/jungle_path/db_access/io/select.rb', line 18

def _model_by_any(model)
	ds = @db[model._table_name].where(handle_json_columns(model, model._modified_hash))
	#puts ds.sql
	hash = ds.first
	#puts "hash: #{hash}. Nil? #{hash == nil}."
	return nil unless hash
	new_model = model.class.new(hash, false) # false since row (initial values) from db is considered unmodified.
end

#_models(model, *order_by) ⇒ Object 



27
28
29
30
31
32
33
34
35
36
37
38
39
40
 
# File 'lib/jungle_path/db_access/io/select.rb', line 27

def _models(model, *order_by)
	# select all of a given model.
	ds = @db[model._table_name]
	ds = ds.where(handle_json_columns(model, model._has_value_hash)) if model._has_value_hash.length > 0
	ds = ds.order(*order_by) if order_by.length > 0
	ds = ds.order(model._primary_key_columns.keys) unless order_by.length > 0
	#puts ds.sql
	rows = ds.all
	models = []
	rows.each do |row|
		models << model.class.new(row, false)
	end
	models
end