require 'sequel'
require 'pact_broker/db'
require 'pact_broker/repositories/helpers'


module PactBroker
  module Webhooks
    class Execution < Sequel::Model(
      PactBroker::DB.connection[:webhook_executions].select(
        Sequel[:webhook_executions][:id],
        :triggered_webhook_id,
        :success,
        :logs,
        Sequel[:webhook_executions][:created_at])
      )

      dataset_module do
        include PactBroker::Repositories::Helpers
      end

      associate(:many_to_one, :triggered_webhook, :class => "PactBroker::Webhooks::TriggeredWebhook", :key => :triggered_webhook_id, :primary_key => :id)

      def <=> other
        comp = created_date <=> other.created_date
        comp = id <=> other.id if comp == 0
        comp
      end
    end

    # For a brief time, the code was released with a direct relationship between
    # webhook and execution. Need to make sure any existing data is handled properly.
    class DeprecatedExecution < Sequel::Model(:webhook_executions)
      associate(:many_to_one, :provider, :class => "PactBroker::Domain::Pacticipant", :key => :provider_id, :primary_key => :id)
      associate(:many_to_one, :consumer, :class => "PactBroker::Domain::Pacticipant", :key => :consumer_id, :primary_key => :id)
    end

    Execution.plugin :timestamps

  end
end