diff options
author | Aaron Patterson <aaron.patterson@gmail.com> | 2010-08-13 18:28:38 -0700 |
---|---|---|
committer | Aaron Patterson <aaron.patterson@gmail.com> | 2010-08-13 18:28:38 -0700 |
commit | 9fc70e22f9bf7df8485b90b3d7e4a5c58cb0ebbb (patch) | |
tree | a237455c0390c59b9b8a7fabb2b811141c4d76d9 /spec/arel/insert_manager_spec.rb | |
parent | 3eeed18e0cb71f5a56995c2d6a67eff0af618deb (diff) | |
download | rails-9fc70e22f9bf7df8485b90b3d7e4a5c58cb0ebbb.tar.gz rails-9fc70e22f9bf7df8485b90b3d7e4a5c58cb0ebbb.tar.bz2 rails-9fc70e22f9bf7df8485b90b3d7e4a5c58cb0ebbb.zip |
insert manager implements "insert"
Diffstat (limited to 'spec/arel/insert_manager_spec.rb')
-rw-r--r-- | spec/arel/insert_manager_spec.rb | 94 |
1 files changed, 94 insertions, 0 deletions
diff --git a/spec/arel/insert_manager_spec.rb b/spec/arel/insert_manager_spec.rb new file mode 100644 index 0000000000..073c9c30cb --- /dev/null +++ b/spec/arel/insert_manager_spec.rb @@ -0,0 +1,94 @@ +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 'insert' do + it 'takes a list of lists' do + table = Table.new(:users) + manager = Arel::InsertManager.new Table.engine + manager.into table + manager.insert [[table[:id], 1], [table[:name], 'aaron']] + manager.to_sql.should be_like %{ + INSERT INTO "users" ("users"."id", "users"."name") VALUES (1, 'aaron') + } + end + + it 'defaults the table' do + table = Table.new(:users) + manager = Arel::InsertManager.new Table.engine + manager.insert [[table[:id], 1], [table[:name], 'aaron']] + manager.to_sql.should be_like %{ + INSERT INTO "users" ("users"."id", "users"."name") VALUES (1, 'aaron') + } + end + + it 'takes an empty list' do + manager = Arel::InsertManager.new Table.engine + manager.insert [] + 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 |