diff options
author | Kir Shatrov <shatrov@me.com> | 2017-04-30 22:19:09 -0400 |
---|---|---|
committer | Kir Shatrov <shatrov@me.com> | 2017-05-01 08:21:58 -0400 |
commit | 5d6d14cb6be217abc04253da0fe49721d09e9575 (patch) | |
tree | b3ca61f5ff9a083f0b64611788554480d94d36dd /test/test_insert_manager.rb | |
parent | 437aa3a4bb8ad4f3f4eba299dbb1112852f9c7ac (diff) | |
download | rails-5d6d14cb6be217abc04253da0fe49721d09e9575.tar.gz rails-5d6d14cb6be217abc04253da0fe49721d09e9575.tar.bz2 rails-5d6d14cb6be217abc04253da0fe49721d09e9575.zip |
Support multiple inserts
Diffstat (limited to 'test/test_insert_manager.rb')
-rw-r--r-- | test/test_insert_manager.rb | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/test/test_insert_manager.rb b/test/test_insert_manager.rb index b9ee6f76ac..46549c1ae4 100644 --- a/test/test_insert_manager.rb +++ b/test/test_insert_manager.rb @@ -28,6 +28,25 @@ module Arel } end + it 'inserts multiple values' do + table = Table.new(:users) + manager = Arel::InsertManager.new + manager.into table + + manager.columns << table[:id] + manager.columns << table[:name] + + manager.values = manager.create_tuple([ + manager.create_values(%w{ 1 david }), + manager.create_values(%w{ 2 kirs }), + manager.create_values(["3", Arel.sql('DEFAULT')], []), + ]) + + manager.to_sql.must_be_like %{ + INSERT INTO \"users\" (\"id\", \"name\") VALUES ('1', 'david'), ('2', 'kirs'), ('3', DEFAULT) + } + end + it "inserts false" do table = Table.new(:users) manager = Arel::InsertManager.new |