diff options
author | Emilio Tagua <miloops@gmail.com> | 2010-02-18 18:28:27 -0300 |
---|---|---|
committer | Emilio Tagua <miloops@gmail.com> | 2010-02-18 18:28:27 -0300 |
commit | d51697d2bd2cdd6394cb5e665aab8ab43ce9a14a (patch) | |
tree | 444a5a6c23052dc827979c7fd0f9bd93b77ffcb3 /spec/arel/engines | |
parent | 1c0d7dc7f62e8744b476464f8aefc1867986f0bd (diff) | |
download | rails-d51697d2bd2cdd6394cb5e665aab8ab43ce9a14a.tar.gz rails-d51697d2bd2cdd6394cb5e665aab8ab43ce9a14a.tar.bz2 rails-d51697d2bd2cdd6394cb5e665aab8ab43ce9a14a.zip |
Added support for RETURNING primary key when available, only for
PostgreSQL.
Diffstat (limited to 'spec/arel/engines')
-rw-r--r-- | spec/arel/engines/sql/unit/relations/insert_spec.rb | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/spec/arel/engines/sql/unit/relations/insert_spec.rb b/spec/arel/engines/sql/unit/relations/insert_spec.rb index 1884e32a3d..69c5bb052c 100644 --- a/spec/arel/engines/sql/unit/relations/insert_spec.rb +++ b/spec/arel/engines/sql/unit/relations/insert_spec.rb @@ -43,6 +43,7 @@ module Arel INSERT INTO "users" ("id", "name") VALUES (1, E'nick') + RETURNING "id" }) end end @@ -74,6 +75,7 @@ module Arel INSERT INTO "users" ("name") VALUES (E'nick') + RETURNING "id" }) end end @@ -93,11 +95,20 @@ module Arel }) end - adapter_is_not :mysql do + adapter_is :sqlite3 do + @insertion.to_sql.should be_like(%Q{ + INSERT + INTO "users" + ("id") VALUES (1) + }) + end + + adapter_is :postgresql do @insertion.to_sql.should be_like(%Q{ INSERT INTO "users" ("id") VALUES (1) + RETURNING "id" }) end end |