module JunglePath::SQL::QueryFilter

Public Class Methods

by_user(db, user) click to toggle source
# 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