blob: fae776a39dbaa79dd915c097a24a95f374c6420a (
plain) (
tree)
|
|
require 'spec_helper'
module Arel
describe 'insert manager' do
describe 'new' do
it 'takes an engine' do
Arel::InsertManager.new Table.engine
end
end
describe 'into' do
it 'takes an engine' do
manager = Arel::InsertManager.new Table.engine
manager.into(Table.new(:users)).should == manager
end
it 'converts to sql' do
table = Table.new :users
manager = Arel::InsertManager.new Table.engine
manager.into table
manager.to_sql.should be_like %{
INSERT INTO "users"
}
end
end
describe 'columns' do
it "converts to sql" do
table = Table.new :users
manager = Arel::InsertManager.new Table.engine
manager.into table
manager.columns << table[:id]
manager.to_sql.should be_like %{
INSERT INTO "users" ("users"."id")
}
end
end
describe "values" do
it "converts to sql" do
table = Table.new :users
manager = Arel::InsertManager.new Table.engine
manager.into table
manager.values << 1
manager.to_sql.should be_like %{
INSERT INTO "users" VALUES (1)
}
end
end
describe "combo" do
it "puts shit together" do
table = Table.new :users
manager = Arel::InsertManager.new Table.engine
manager.into table
manager.values << 1
manager.values << "aaron"
manager.columns << table[:id]
manager.columns << table[:name]
manager.to_sql.should be_like %{
INSERT INTO "users" ("users"."id", "users"."name") VALUES (1, 'aaron')
}
end
end
end
end
|