require '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 "inserts false" do table = Table.new(:users) manager = Arel::InsertManager.new Table.engine table[:id].column.extend(Module.new { def type; :boolean; end }) manager.insert [[table[:id], false]] manager.to_sql.must_be_like %{ INSERT INTO "users" ("id") VALUES ('f') } end it "inserts null" do table = Table.new(:users) manager = Arel::InsertManager.new Table.engine manager.insert [[table[:id], nil]] manager.to_sql.must_be_like %{ INSERT INTO "users" ("id") VALUES (NULL) } end it "inserts time" do table = Table.new(:users) manager = Arel::InsertManager.new Table.engine time = Time.now attribute = table[:id] attribute.column.type = :date manager.insert [[attribute, time]] manager.to_sql.must_be_like %{ INSERT INTO "users" ("id") VALUES (#{Table.engine.connection.quote time}) } end 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.must_be_like %{ INSERT INTO "users" ("id", "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.must_be_like %{ INSERT INTO "users" ("id", "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)).must_equal manager end it 'converts to sql' do table = Table.new :users manager = Arel::InsertManager.new Table.engine manager.into table manager.to_sql.must_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.must_be_like %{ INSERT INTO "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 = Nodes::Values.new [1] manager.to_sql.must_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 = Nodes::Values.new [1, 'aaron'] manager.columns << table[:id] manager.columns << table[:name] manager.to_sql.must_be_like %{ INSERT INTO "users" ("id", "name") VALUES (1, 'aaron') } end end end end