require "spec_helper"

describe RSpec::SQLimit::Reporter do
  subject { described_class.new(counter) }

  context 'no params were passed to the query' do
    let(:counter) { RSpec::SQLimit::Counter[/CREATE/, Proc.new{ User.create }] }

    it "doesn't print binds" do
      # INSERT INTO "users" DEFAULT VALUES (0.284 ms)
      expect(subject.call).to include("DEFAULT VALUES")
    end
  end

  context 'query contains params' do
    context 'nil was passed as param' do
      let(:counter) { RSpec::SQLimit::Counter[/CREATE/, Proc.new{ User.create(id: nil) }] }

      it "doesn't print binds" do
        # INSERT INTO "users" DEFAULT VALUES (0.284 ms)
        expect(subject.call).to include("DEFAULT VALUES")
      end
    end

    context 'single param was passed' do
      let(:counter) { RSpec::SQLimit::Counter[/CREATE/, Proc.new{ User.create(id: 1) }] }

      it 'prints param as an array with one element' do
        # INSERT INTO "users" ("id") VALUES (?); [1]  (0.234 ms)
        expect(subject.call).to include("VALUES (?); [1]")
      end
    end

    context 'array was passed as a param' do
      let(:counter) { RSpec::SQLimit::Counter[/SELECT/, Proc.new{ User.where(id: [1, 2, 3]).to_a }] }

      it 'prints all params' do
        # SELECT "users".* FROM "users" WHERE "users"."id" IN (1, 2, 3) (0.17 ms))
        expect(subject.call).to include("IN (1, 2, 3)")
      end
    end
  end
end