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