Class: MiniSqlMultisiteConnection::CustomBuilder

Inherits:
MiniSql::Builder
  • Object
show all
Defined in:
lib/mini_sql_multisite_connection.rb

Instance Method Summary collapse

Constructor Details

#initialize(connection, sql) ⇒ CustomBuilder

Returns a new instance of CustomBuilder.



5
6
7
# File 'lib/mini_sql_multisite_connection.rb', line 5

def initialize(connection, sql)
  super
end

Instance Method Details

#secure_category(secure_category_ids, category_alias = "c") ⇒ Object



9
10
11
12
13
14
15
16
17
18
19
# File 'lib/mini_sql_multisite_connection.rb', line 9

def secure_category(secure_category_ids, category_alias = "c")
  if secure_category_ids.present?
    where(
      "NOT COALESCE(#{category_alias}.read_restricted, false) OR #{category_alias}.id in (:secure_category_ids)",
      secure_category_ids: secure_category_ids,
    )
  else
    where("NOT COALESCE(#{category_alias}.read_restricted, false)")
  end
  self
end