Module: JunglePath::SQL::User

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

Class Method Summary collapse

Class Method Details

.by_key(db, key) ⇒ Object 



19
20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/jungle_path/sql/user.rb', line 19

def self.by_key(db, key)
  sql = JunglePath::SQL::Helpers.sql("
    #{base_sql}
    join key b on a.id = b.user_id
    where b.key = ?
  ")
  puts "sql:\n#{sql}."
  puts "key: #{key}."
  ds = db.base[sql, key]
  row = ds.first
  puts "row: #{row}."
  row
end

.by_user_name(db, user_name) ⇒ Object 



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

def self.by_user_name(db, user_name)
  sql = JunglePath::SQL::Helpers.sql("
    #{base_sql}
    where a.user_name = ?
  ")
  puts "sql:\n#{sql}."
  puts "user_name: #{user_name}."
  ds = db.base[sql, user_name]
  row = ds.first
  puts "row: #{row}."
  row
end