Contents

Sequel.extension :escaped_like

module PactBroker
  module Repositories
    module Helpers

      extend self

      def name_like column_name, value
        if PactBroker.configuration.use_case_sensitive_resource_names
          if mysql?
            # sigh, mysql, this is the only way to perform a case sensitive search
            Sequel.like(column_name, value.gsub("_", "\\_"), { case_insensitive: false })
          else
            { column_name => value }
          end
        else
          Sequel.like(column_name, value.gsub("_", "\\_"), { case_insensitive: true })
        end
      end

      def pacticipant_id_for_name pacticipant_name
        Sequel::Model.db[:pacticipants].select(:id).where(name_like(:name, pacticipant_name)).limit(1)
      end

      def order_ignore_case column_name = :name
        order(Sequel.function(:lower, column_name))
      end

      def order_append_ignore_case column_name = :name
        order_append(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_append_all_qualified
        select_append(Sequel[model.table_name].*)
      end

      def select_for_subquery column
        if mysql? #stoopid mysql doesn't allow you to modify datasets with subqueries
          column_name = column.respond_to?(:alias) ? column.alias : column
          select(column).collect{ | it | it[column_name] }
        else
          select(column)
        end
      end
    end
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
pact_broker-2.80.0	lib/pact_broker/repositories/helpers.rb
pact_broker-2.79.1	lib/pact_broker/repositories/helpers.rb
pact_broker-2.79.0	lib/pact_broker/repositories/helpers.rb
pact_broker-2.78.1	lib/pact_broker/repositories/helpers.rb
pact_broker-2.78.0	lib/pact_broker/repositories/helpers.rb
pact_broker-2.77.0	lib/pact_broker/repositories/helpers.rb