module JunglePath::SQL::UserRole
Public Class Methods
has_root_role_by_user_id(db, user_id)
click to toggle source
# File lib/jungle_path/sql/user_role.rb, line 6 def self.has_root_role_by_user_id(db, user_id) puts "has_root_role_by_user_id: #{user_id}." sql = JunglePath::SQL::Helpers.sql(" select count(*) from \"user\" a join user_role b on b.user_id = a.id join role c on c.id = b.role_id where c.name = 'root' and a.id = ? ") count = JunglePath::SQL::Helpers.get_count(db, sql, user_id) puts "count: #{count}." puts "(count > 0): #{(count > 0)}." (count > 0) end
is_root_role_by_role_id(db, role_id)
click to toggle source
# File lib/jungle_path/sql/user_role.rb, line 23 def self.is_root_role_by_role_id(db, role_id) puts "has_root_role_by_role_id: #{role_id}." sql = JunglePath::SQL::Helpers.sql(" select count(*) from role a where a.name = 'root' and a.id = ? ") count = JunglePath::SQL::Helpers.get_count(db, sql, role_id) puts "count: #{count}." puts "(count > 0): #{(count > 0)}." (count > 0) end