module JunglePath::SQL::User

Public Class Methods

by_key(db, key) click to toggle source
# 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) click to toggle source
# 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

Private Class Methods

base_sql() click to toggle source
# File lib/jungle_path/sql/user.rb, line 35
def self.base_sql
        JunglePath::SQL::Helpers.sql("
                select
                        a.id,
                        a.user_name,
                        a.hash,
                        a.name,
                        a.email,
                        a.organization,
                        a.notes,
                        a.active,
                        a.role,
                        a.created_at,
                        a.created_by_user_id,
                        a.updated_at,
                        a.updated_by_user_id
                from \"user\" a
        ")
end