From 9fc70e22f9bf7df8485b90b3d7e4a5c58cb0ebbb Mon Sep 17 00:00:00 2001 From: Aaron Patterson Date: Fri, 13 Aug 2010 18:28:38 -0700 Subject: insert manager implements "insert" --- spec/arel/insert_manager.rb | 68 ----------------------------- spec/arel/insert_manager_spec.rb | 94 ++++++++++++++++++++++++++++++++++++++++ spec/arel/select_manager.rb | 87 ------------------------------------- spec/arel/select_manager_spec.rb | 87 +++++++++++++++++++++++++++++++++++++ 4 files changed, 181 insertions(+), 155 deletions(-) delete mode 100644 spec/arel/insert_manager.rb create mode 100644 spec/arel/insert_manager_spec.rb delete mode 100644 spec/arel/select_manager.rb create mode 100644 spec/arel/select_manager_spec.rb (limited to 'spec') diff --git a/spec/arel/insert_manager.rb b/spec/arel/insert_manager.rb deleted file mode 100644 index fae776a39d..0000000000 --- a/spec/arel/insert_manager.rb +++ /dev/null @@ -1,68 +0,0 @@ -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 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 diff --git a/spec/arel/select_manager.rb b/spec/arel/select_manager.rb deleted file mode 100644 index 928db49c52..0000000000 --- a/spec/arel/select_manager.rb +++ /dev/null @@ -1,87 +0,0 @@ -require 'spec_helper' - -module Arel - describe 'select manager' do - describe 'project' do - it 'takes strings' do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - manager.project '*' - manager.to_sql.should be_like %{ - SELECT * - } - end - - it "takes sql literals" do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - manager.project Nodes::SqlLiteral.new '*' - manager.to_sql.should be_like %{ - SELECT * - } - end - end - - describe 'take' do - it "knows take" do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - manager.from(table).project(table['id']) - manager.where(table['id'].eq(1)) - manager.take 1 - - manager.to_sql.should be_like %{ - SELECT "users"."id" - FROM "users" - WHERE "users"."id" = 1 - LIMIT 1 - } - end - - it "chains" do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - manager.take(1).should == manager - end - end - - describe 'where' do - it "knows where" do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - manager.from(table).project(table['id']) - manager.where(table['id'].eq(1)) - manager.to_sql.should be_like %{ - SELECT "users"."id" - FROM "users" - WHERE "users"."id" = 1 - } - end - - it "chains" do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - manager.from(table) - manager.project(table['id']).where(table['id'].eq 1).should == manager - end - end - - describe 'from' do - it "makes sql" do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - - manager.from table - manager.project table['id'] - manager.to_sql.should be_like 'SELECT "users"."id" FROM "users"' - end - - it "chains" do - table = Table.new :users - manager = Arel::SelectManager.new Table.engine - manager.from(table).project(table['id']).should == manager - manager.to_sql.should be_like 'SELECT "users"."id" FROM "users"' - end - end - end -end diff --git a/spec/arel/select_manager_spec.rb b/spec/arel/select_manager_spec.rb new file mode 100644 index 0000000000..928db49c52 --- /dev/null +++ b/spec/arel/select_manager_spec.rb @@ -0,0 +1,87 @@ +require 'spec_helper' + +module Arel + describe 'select manager' do + describe 'project' do + it 'takes strings' do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + manager.project '*' + manager.to_sql.should be_like %{ + SELECT * + } + end + + it "takes sql literals" do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + manager.project Nodes::SqlLiteral.new '*' + manager.to_sql.should be_like %{ + SELECT * + } + end + end + + describe 'take' do + it "knows take" do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + manager.from(table).project(table['id']) + manager.where(table['id'].eq(1)) + manager.take 1 + + manager.to_sql.should be_like %{ + SELECT "users"."id" + FROM "users" + WHERE "users"."id" = 1 + LIMIT 1 + } + end + + it "chains" do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + manager.take(1).should == manager + end + end + + describe 'where' do + it "knows where" do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + manager.from(table).project(table['id']) + manager.where(table['id'].eq(1)) + manager.to_sql.should be_like %{ + SELECT "users"."id" + FROM "users" + WHERE "users"."id" = 1 + } + end + + it "chains" do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + manager.from(table) + manager.project(table['id']).where(table['id'].eq 1).should == manager + end + end + + describe 'from' do + it "makes sql" do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + + manager.from table + manager.project table['id'] + manager.to_sql.should be_like 'SELECT "users"."id" FROM "users"' + end + + it "chains" do + table = Table.new :users + manager = Arel::SelectManager.new Table.engine + manager.from(table).project(table['id']).should == manager + manager.to_sql.should be_like 'SELECT "users"."id" FROM "users"' + end + end + end +end -- cgit v1.2.3