Sha256: ce481c709d577f09bca54daae79feeb590c5731f3919a9f8da72bf8f2f2a5c8d

Contents?: true

Size: 926 Bytes

Versions: 10

Compression:

Stored size: 926 Bytes

Contents

require 'spec_helper'

describe Riddle::Query::Insert do
  it 'handles inserts' do
    query = Riddle::Query::Insert.new('foo_core', [:id, :deleted], [4, false])
    query.to_sql.should == 'INSERT INTO foo_core (id, deleted) VALUES (4, 0)'
  end
  
  it 'handles replaces' do
    query = Riddle::Query::Insert.new('foo_core', [:id, :deleted], [4, false])
    query.replace!
    query.to_sql.should == 'REPLACE INTO foo_core (id, deleted) VALUES (4, 0)'
  end
  
  it 'encloses strings in single quotes' do
    query = Riddle::Query::Insert.new('foo_core', [:id, :name], [4, 'bar'])
    query.to_sql.should == "INSERT INTO foo_core (id, name) VALUES (4, 'bar')"
  end
  
  it 'handles inserts with more than one set of values' do
    query = Riddle::Query::Insert.new 'foo_core', [:id, :name], [[4, 'bar'], [5, 'baz']]
    query.to_sql.
      should == "INSERT INTO foo_core (id, name) VALUES (4, 'bar'), (5, 'baz')"
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version Path
riddle-1.5.7 spec/riddle/query/insert_spec.rb
riddle-1.5.6 spec/riddle/query/insert_spec.rb
riddle-1.5.5 spec/riddle/query/insert_spec.rb
riddle-1.5.4 spec/riddle/query/insert_spec.rb
riddle-1.5.3 spec/riddle/query/insert_spec.rb
riddle-1.5.2 spec/riddle/query/insert_spec.rb
riddle-1.5.1 spec/riddle/query/insert_spec.rb
riddle-1.5.0 spec/riddle/query/insert_spec.rb
riddle-1.4.0 spec/riddle/query/insert_spec.rb
riddle-1.3.3 spec/riddle/query/insert_spec.rb