describe "using pact publications (migrate 31-32)", migration: true do
  before do
    PactBroker::Database.migrate(34)
  end

  let(:now) { DateTime.new(2017, 1, 1) }
  let!(:consumer_1) { create(:pacticipants, {name: "Consumer 1", created_at: now, updated_at: now}) }
  let!(:provider_1) { create(:pacticipants, {name: "Provider 1", created_at: now, updated_at: now}) }
  let!(:consumer_version_1) { create(:versions, {number: "1.2.3", order: 1, pacticipant_id: consumer_1[:id], created_at: now, updated_at: now}) }
  let!(:consumer_version_2) { create(:versions, {number: "4.5.6", order: 2, pacticipant_id: consumer_1[:id], created_at: now, updated_at: now}) }
  let!(:pact_version_content_1) { create(:pact_versions, {content: {some: "json"}.to_json, sha: "1234", consumer_id: consumer_1[:id], provider_id: provider_1[:id], created_at: now}) }
  let!(:pact_version_1_revision_1) { create(:pact_publications, {consumer_version_id: consumer_version_1[:id], provider_id: provider_1[:id], pact_version_id: pact_version_content_1[:id], created_at: now, revision_number: 1}) }
  let!(:pact_version_2_revision_1) { create(:pact_publications, {consumer_version_id: consumer_version_2[:id], provider_id: provider_1[:id], pact_version_id: pact_version_content_1[:id], created_at: now, revision_number: 1}) }
  let!(:pact_version_2_revision_2) { create(:pact_publications, {consumer_version_id: consumer_version_2[:id], provider_id: provider_1[:id], pact_version_id: pact_version_content_1[:id], created_at: now, revision_number: 2}) }

  let!(:consumer_2) { create(:pacticipants, {name: "Consumer 2", created_at: now, updated_at: now}) }
  let!(:provider_2) { create(:pacticipants, {name: "Provider 2", created_at: now, updated_at: now}) }
  let!(:consumer_version_3) { create(:versions, {number: "7.8.9", order: 1, pacticipant_id: consumer_2[:id], created_at: now, updated_at: now}) }
  let!(:pact_version_content_2) { create(:pact_versions, {content: {some: "json"}.to_json, sha: "4567", consumer_id: consumer_2[:id], provider_id: provider_2[:id], created_at: now}) }
  let!(:pact_version_3_revision_1) { create(:pact_publications, {consumer_version_id: consumer_version_3[:id], provider_id: provider_2[:id], pact_version_id: pact_version_content_2[:id], created_at: now, revision_number: 1}) }

  # Consumer 1/Provider 1 version 1.2.3
  let!(:tag_1) { create(:tags, {version_id: consumer_version_1[:id], name: "master", created_at: now, updated_at: now}, :created_at) } #not included

  # Consumer 1/Provider 1 version 4.5.6
  let!(:tag_2) { create(:tags, {version_id: consumer_version_2[:id], name: "master", created_at: now, updated_at: now}, :created_at) } #included
  let!(:tag_3) { create(:tags, {version_id: consumer_version_2[:id], name: "prod", created_at: now, updated_at: now}, :created_at) } #included

  # Consumer 2/Provider 2 version 7.8.9
  let!(:tag_4) { create(:tags, {version_id: consumer_version_3[:id], name: "prod", created_at: now, updated_at: now}, :created_at) } #included

  describe "latest_tagged_pact_consumer_version_orders" do
    it "contains a row with the latest consumer version order for each consumer/provider/tag combination" do
      expect(database[:latest_tagged_pact_consumer_version_orders].where(
        provider_id: provider_1[:id], consumer_id: consumer_1[:id], tag_name: "master"
        ).count
      ).to eq 1

      expect(database[:latest_tagged_pact_consumer_version_orders].where(
        provider_id: provider_1[:id], consumer_id: consumer_1[:id], tag_name: "prod"
        ).count
      ).to eq 1

      expect(database[:latest_tagged_pact_consumer_version_orders].where(
        provider_id: provider_2[:id], consumer_id: consumer_2[:id], tag_name: "prod"
        ).count
      ).to eq 1

      expect(database[:latest_tagged_pact_consumer_version_orders].count).to eq 3
    end
  end

  describe "latest_tagged_pact_publications" do
    it "only contains the latest revision of the pact for the latest consumer version with each tag" do
      expect(database[:latest_tagged_pact_publications].where(
        provider_name: "Provider 1", consumer_name: "Consumer 1",
        consumer_version_number: "4.5.6", revision_number: 2, tag_name: "prod"
        ).count
      ).to eq 1

      expect(database[:latest_tagged_pact_publications].where(
        provider_name: "Provider 1", consumer_name: "Consumer 1",
        consumer_version_number: "4.5.6", revision_number: 2, tag_name: "master"
        ).count
      ).to eq 1

      expect(database[:latest_tagged_pact_publications].where(
        provider_name: "Provider 2", consumer_name: "Consumer 2",
        consumer_version_number: "7.8.9", revision_number: 1,  tag_name: "prod"
        ).count
      ).to eq 1

      expect(database[:latest_tagged_pact_publications].count).to eq 3
    end

    it "has a created_at column" do
      expect(database[:latest_tagged_pact_publications].order(:id).first).to have_key(:created_at)
    end

    it "doesn't have an updated_at column" do
      expect(database[:latest_tagged_pact_publications].order(:id).first).to_not have_key(:updated_at)
    end
  end
end