Contents

require 'spec_helper'

describe PedantMysql2 do

  let(:connection) { ActiveRecord::Base.connection }

  before :each do
    connection.execute('SET SESSION binlog_format = "STATEMENT"')
    connection.execute('CREATE TABLE IF NOT EXISTS comment (id int)')
    connection.execute('TRUNCATE TABLE comment')
    @original_callback = PedantMysql2.on_warning
  end

  after :each do
    PedantMysql2.on_warning = @original_callback
  end

  it 'just do nothing by default' do
    expect {
      connection.execute('SELECT 1 + "foo"')
    }.to_not raise_error
  end

  it 'do not change the returned value' do
    result = connection.execute('SELECT 1 + "foo"')
    expect(result.to_a).to be == [[1.0]]
  end

  it 'do not change the returned value of exec_update' do
    result = connection.update('UPDATE comment SET id = 1 LIMIT 1')
    expect(result).to be_zero
  end

  it 'do not change the returned value of exec_delete' do
    result = connection.delete('DELETE FROM comment LIMIT 1')
    expect(result).to be_zero
  end

  it 'can easily be raised' do
    PedantMysql2.on_warning = lambda { |warning| raise warning }
    expect {
      connection.execute('SELECT 1 + "foo"')
    }.to raise_error(MysqlWarning)
  end

  describe MysqlWarning do

    subject do
      begin
        PedantMysql2.on_warning = lambda { |warning| raise warning }
        connection.execute('SELECT 1 + "foo"')
      rescue MysqlWarning => exception
        exception
      end
    end

    its(:message) { should be == "Truncated incorrect DOUBLE value: 'foo'" }

    its(:code) { should be == 1292 }

    its(:level) { should be == 'Warning' }

    its(:query) { should be == 'SELECT 1 + "foo"' }
  end

end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
activerecord-pedantmysql2-adapter-0.0.3	spec/adapter_spec.rb