shared_examples_for 'a Result' do

  before :all do
    setup_test_environment
  end

  before do
    @connection = DataObjects::Connection.new(CONFIG.uri)
    @result    = @connection.create_command("INSERT INTO users (name) VALUES (?)").execute_non_query("monkey")
  end

  after do
    @connection.close
  end

  it { expect(@result).to respond_to(:affected_rows) }

  describe 'affected_rows' do

    it 'should return the number of affected rows' do
      expect(@result.affected_rows).to eq(1)
    end

  end

end

shared_examples_for 'a Result which returns inserted key with sequences' do

  describe 'insert_id' do

    before do
      setup_test_environment
      @connection = DataObjects::Connection.new(CONFIG.uri)
      command = @connection.create_command("INSERT INTO users (name) VALUES (?)")
      # execute the command twice and expose the second result
      command.execute_non_query("monkey")
      @result = command.execute_non_query("monkey")
    end

    after do
      @connection.close
    end

    it { expect(@result).to respond_to(:affected_rows) }

    it 'should return the insert_id' do
      # This is actually the 2nd record inserted
      expect(@result.insert_id).to eq(2)
    end

  end

end

shared_examples_for 'a Result which returns nil without sequences' do

  describe 'insert_id' do

    before do
      setup_test_environment
      @connection = DataObjects::Connection.new(CONFIG.uri)
      command = @connection.create_command("INSERT INTO invoices (invoice_number) VALUES (?)")
      # execute the command twice and expose the second result
      @result = command.execute_non_query("monkey")
    end

    after do
      @connection.close
    end

    it 'should return the insert_id' do
      # This is actually the 2nd record inserted
      expect(@result.insert_id).to be_nil
    end

  end

end