require "sequel"
require "pact_broker/domain/verification"
require "pact_broker/verifications/latest_verification_for_pact_version"
require "pact_broker/verifications/sequence"
require "pact_broker/verifications/latest_verification_id_for_pact_version_and_provider_version"

module PactBroker
  module Verifications
    class Repository

      include PactBroker::Repositories::Helpers
      include PactBroker::Repositories

      # Ideally this would just be a sequence, but Sqlite and MySQL don't support sequences
      # in the way we need to use them ie. determining what the next number will be before we
      # create the record, because Webmachine wants to set the URL of the resource that is about
      # to be created *before* we actually create it.
      def next_number
        Sequence.next_val
      end

      def create verification, provider_version_number, pact
        provider = pacticipant_repository.find_by_name(pact.provider_name)
        consumer = pacticipant_repository.find_by_name(pact.consumer_name)
        version = version_repository.find_by_pacticipant_id_and_number_or_create(provider.id, provider_version_number)
        verification.pact_version_id = pact_version_id_for(pact)
        verification.provider_version = version
        verification.provider_id = provider.id
        verification.consumer_id = consumer.id
        verification.save
        update_latest_verification_id(verification)
        verification
      end

      def delete(verification_id)
        PactBroker::Domain::Verification.where(id: verification_id).delete
      end

      def update_latest_verification_id verification
        params = {
          pact_version_id: verification.pact_version_id,
          provider_version_id: verification.provider_version_id,
          provider_id: verification.provider_version.pacticipant_id,
          verification_id: verification.id,
          consumer_id: verification.consumer_id,
          created_at: verification.created_at
        }
        LatestVerificationIdForPactVersionAndProviderVersion.new(params).upsert
      end

      def find consumer_name, provider_name, pact_version_sha, verification_number
        PactBroker::Domain::Verification
          .select_all_qualified
          .join(:all_pact_publications, pact_version_id: :pact_version_id)
          .consumer(consumer_name)
          .provider(provider_name)
          .pact_version_sha(pact_version_sha)
          .verification_number(verification_number).single_record
      end

      def find_latest_for_pact(pact)
        PactBroker::Pacts::PactPublication.where(id: pact.id).single_record.latest_verification
      end

      def any_verifications?(consumer, provider)
        PactBroker::Domain::Verification.where(consumer_id: consumer.id, provider_id: provider.id).any?
      end

      def search_for_latest consumer_name, provider_name
        query = LatestVerificationForPactVersion
                  .select_all_qualified
                  .join(:all_pact_publications, pact_version_id: :pact_version_id)
        query = query.consumer(consumer_name) if consumer_name
        query = query.provider(provider_name) if provider_name
        query.reverse(:execution_date, :id).first
      end

      def find_latest_verifications_for_consumer_version consumer_name, consumer_version_number
        # Use LatestPactPublicationsByConsumerVersion not AllPactPublcations because we don't
        # want verifications for shadowed revisions as it would be misleading.
        LatestVerificationForPactVersion
          .select_all_qualified
          .join(:latest_pact_publications_by_consumer_versions, pact_version_id: :pact_version_id)
          .consumer(consumer_name)
          .consumer_version_number(consumer_version_number)
          .order(:provider_name)
          .all
      end

      # The most recent verification for the latest revision of the pact
      # belonging to the version with the largest consumer_version_order.

      def find_latest_verification_for consumer_name, provider_name, consumer_version_tag = nil
        consumer = pacticipant_repository.find_by_name!(consumer_name)
        provider = pacticipant_repository.find_by_name!(provider_name)
        join_cols = {
          Sequel[:lp][:pact_version_id] => Sequel[:verifications][:pact_version_id],
          Sequel[:lp][:consumer_id] => consumer.id,
          Sequel[:lp][:provider_id] => provider.id
        }
        query = PactBroker::Domain::Verification
          .select_all_qualified
          .join(:latest_verification_ids_for_pact_versions, { Sequel[:verifications][:id] => Sequel[:lv][:latest_verification_id] }, { table_alias: :lv })
          .join(:latest_pact_publication_ids_for_consumer_versions, join_cols, { table_alias: :lp })
          .join(:versions, { Sequel[:cv][:id] => Sequel[:lp][:consumer_version_id] }, { table_alias: :cv })
        if consumer_version_tag == :untagged
          query = query.left_outer_join(:tags, { Sequel[:cv][:id] => Sequel[:tags][:version_id] })
                        .where(Sequel[:tags][:name] => nil)
        elsif consumer_version_tag
          query = query.join(:tags, { Sequel[:cv][:id] => Sequel[:tags][:version_id], Sequel[:tags][:name] => consumer_version_tag })
        end
        query.reverse_order(
          Sequel[:cv][:order],
          Sequel[:verifications][:number]
        ).limit(1).single_record
      end

      def find_latest_verification_for_tags consumer_name, provider_name, consumer_version_tag, provider_version_tag
        view_name = PactBroker::Domain::Verification.table_name
        consumer = pacticipant_repository.find_by_name!(consumer_name)
        provider = pacticipant_repository.find_by_name!(provider_name)

        consumer_tag_filter = PactBroker::Repositories::Helpers.name_like(Sequel.qualify(:consumer_tags, :name), consumer_version_tag)
        provider_tag_filter = PactBroker::Repositories::Helpers.name_like(Sequel.qualify(:provider_tags, :name), provider_version_tag)

        query = PactBroker::Domain::Verification
          .select_all_qualified
          .join(:versions, { Sequel[:provider_versions][:id] => Sequel[view_name][:provider_version_id] }, { table_alias: :provider_versions })
          .join(:latest_verification_id_for_pact_version_and_provider_version, { Sequel[:lv][:verification_id] => Sequel[view_name][:id] }, { table_alias: :lv })
          .join(:latest_pact_publication_ids_for_consumer_versions, { Sequel[view_name][:pact_version_id] => Sequel[:lp][:pact_version_id] }, { table_alias: :lp })
          .join(:versions, { Sequel[:consumer_versions][:id] => Sequel[:lp][:consumer_version_id] }, { table_alias: :consumer_versions })
          .join(:tags, { Sequel[:consumer_tags][:version_id] => Sequel[:lp][:consumer_version_id]}, { table_alias: :consumer_tags })
          .join(:tags, { Sequel[:provider_tags][:version_id] => Sequel[view_name][:provider_version_id]}, { table_alias: :provider_tags })
          .where(consumer: consumer, provider: provider)
          .where(consumer_tag_filter)
          .where(provider_tag_filter)

        query.reverse_order(
          Sequel[:consumer_versions][:order],
          Sequel[:provider_versions][:order],
          Sequel[view_name][:execution_date]
        ).limit(1).single_record
      end

      def delete_by_provider_version_id version_id
        PactBroker::Domain::Verification.where(provider_version_id: version_id).delete
      end

      def delete_all_verifications_between(consumer_name, options)
        consumer = pacticipant_repository.find_by_name!(consumer_name)
        provider = pacticipant_repository.find_by_name!(options.fetch(:and))
        PactBroker::Domain::Verification.where(provider: provider, consumer: consumer).delete
      end

      def pact_version_id_for pact
        PactBroker::Pacts::PactPublication.select(:pact_version_id).where(id: pact.id)
      end
    end
  end
end