Module: JunglePath::SQL::Key

Defined in:
lib/jungle_path/sql/key.rb

Class Method Summary collapse

Class Method Details

.by_key(db, key) ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
18
 
# File 'lib/jungle_path/sql/key.rb', line 6

def self.by_key(db, key)
	sql = JunglePath::SQL::Helpers.sql("
		#{base_sql}
		where a.key = ?
		order by a.id
	")
	#puts "sql:\n#{sql}"
	#puts "key: #{key}"
	ds = db.base[sql, key]
	all = ds.all
	#puts "count: #{all.length}"
	all
end

.by_user_id(db, user_id) ⇒ Object 



20
21
22
23
24
25
26
27
28
 
# File 'lib/jungle_path/sql/key.rb', line 20

def self.by_user_id(db, user_id)
	sql = JunglePath::SQL::Helpers.sql("
		#{base_sql}
		where a.user_id = ?
		order by a.id
	")
	ds = db.base[sql, user_id]
	ds.all
end

.by_user_id_key_name(db, user_id, key_name) ⇒ Object 



30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
 
# File 'lib/jungle_path/sql/key.rb', line 30

def self.by_user_id_key_name(db, user_id, key_name)
	sql = JunglePath::SQL::Helpers.sql("
		select
			a.id,
			a.key,
			a.name,
			a.user_id,
			a.expires_at,
			a.is_default,
			a.created_at,
			a.created_by_key_id,
			a.updated_at,
			a.updated_by_key_id
		from key a
		where a.user_id = ?
		and a.name = ?
	")
	puts "db.class: #{db.class}."
	ds = db.base[sql, user_id, key_name]
	#puts "sql: #{ds.sql}."
	ds.all
end

.default_by_user_id(db, user_id) ⇒ Object 



53
54
55
56
57
58
59
60
61
62
 
# File 'lib/jungle_path/sql/key.rb', line 53

def self.default_by_user_id(db, user_id)
	sql = JunglePath::SQL::Helpers.sql("
		#{base_sql}
		where a.user_id = ?
		and a.is_default = true
		order by a.id
	")
	ds = db.base[sql, user_id]
	ds.all
end