Module: JunglePath::SQL::Role

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

Class Method Summary collapse

Class Method Details

.by_user(db, user) ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# 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