Sha256: 56c4d1eeae60800c7056f2780a4a5336c65bbc0dd5078b94665f6762726ab87d
Contents?: true
Size: 1.32 KB
Versions: 9
Compression:
Stored size: 1.32 KB
Contents
module PactBroker
module Repositories
module Helpers
extend self
def name_like column_name, value
Sequel.like(column_name, value, case_sensitivity_options)
end
def case_sensitivity_options
{case_insensitive: !PactBroker.configuration.use_case_sensitive_resource_names}
end
def order_ignore_case column_name = :name
order(Sequel.function(:lower, column_name))
end
def mysql?
Sequel::Model.db.adapter_scheme.to_s =~ /mysql/
end
def postgres?
Sequel::Model.db.adapter_scheme.to_s == "postgres"
end
def select_all_qualified
select(Sequel[model.table_name].*)
end
def select_for_subquery column
if mysql? #stoopid mysql doesn't allow subqueries
select(column).collect{ | it | it[column] }
else
select(column)
end
end
def upsert row, key_names
if postgres?
insert_conflict(update: row, target: key_names).insert(row)
elsif mysql?
on_duplicate_key_update.insert(row)
else
# Sqlite
key = row.reject{ |k, v| !key_names.include?(k) }
if where(key).count == 0
insert(row)
else
where(key).update(row)
end
end
end
end
end
end
Version data entries
9 entries across 9 versions & 1 rubygems