module JunglePath::SQL::Role

Public Class Methods

by_user(db, user) click to toggle source
# File lib/jungle_path/sql/role.rb, line 6
def self.by_user db, user
                    sql = JunglePath::SQL::Helpers.sql("
                            select
                                    a.id,
                                    a.name,
                                    a.description
                            from role a
                            join user_role b on a.id = b.role_id
                            where b.user_id = ?
                    ")

                    ds = db.base[sql, user.id]
                    result = ds.all
                    array = []
                    result.each do |row|
                            array << ({id: row[:id], name: row[:name], description: row[:description]})
                    end
                    array
            end