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