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