From 71803320501604f19dc3312ebcf1bab91d9c5f4c Mon Sep 17 00:00:00 2001 From: Aaron Patterson Date: Fri, 13 Aug 2010 15:43:32 -0700 Subject: inserts are starting to take shape --- spec/arel/insert_manager.rb | 43 +++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 41 insertions(+), 2 deletions(-) (limited to 'spec/arel/insert_manager.rb') diff --git a/spec/arel/insert_manager.rb b/spec/arel/insert_manager.rb index 8d49556fa9..fae776a39d 100644 --- a/spec/arel/insert_manager.rb +++ b/spec/arel/insert_manager.rb @@ -13,9 +13,7 @@ module Arel manager = Arel::InsertManager.new Table.engine manager.into(Table.new(:users)).should == manager end - end - describe 'to_sql' do it 'converts to sql' do table = Table.new :users manager = Arel::InsertManager.new Table.engine @@ -25,5 +23,46 @@ module Arel } 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 -- cgit v1.2.3