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