6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
# File 'lib/jungle_path/sql/query_filter.rb', line 6
def self.by_user db, user
sql = JunglePath::SQL::Helpers.sql("
select
a.id,
a.name,
a.base_table_name,
a.sub_select
from query_filter a
join user_query_filter b on a.id = b.query_filter_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], base_table_name: row[:base_table_name], sub_select: row[:sub_select]})
end
array
end
|