diff options
| author | Ryuta Kamizono <kamipo@gmail.com> | 2018-09-28 03:38:55 +0900 |
|---|---|---|
| committer | Ryuta Kamizono <kamipo@gmail.com> | 2018-09-28 04:14:15 +0900 |
| commit | e5190acacd1088211cfe6f128b782af216aa6570 (patch) | |
| tree | bc4ef154a3f3dc42e6e0e0166c7d37e6cf884e6d /activerecord/lib/arel/factory_methods.rb | |
| parent | dc47bb5091b058af45081499f67342c3890d6564 (diff) | |
| download | rails-e5190acacd1088211cfe6f128b782af216aa6570.tar.gz rails-e5190acacd1088211cfe6f128b782af216aa6570.tar.bz2 rails-e5190acacd1088211cfe6f128b782af216aa6570.zip | |
Make `update_counters` preparable
Before:
```
Topic Update All (0.4ms) UPDATE `topics` SET `topics`.`replies_count` = COALESCE(`topics`.`replies_count`, 0) + 1, `topics`.`updated_at` = '2018-09-27 18:34:05.068774' WHERE `topics`.`id` = ? [["id", 7]]
```
After:
```
Topic Update All (0.4ms) UPDATE `topics` SET `topics`.`replies_count` = COALESCE(`topics`.`replies_count`, 0) + ?, `topics`.`updated_at` = ? WHERE `topics`.`id` = ? [["replies_count", 1], ["updated_at", 2018-09-27 18:55:05 UTC], ["id", 7]]
```
Diffstat (limited to 'activerecord/lib/arel/factory_methods.rb')
| -rw-r--r-- | activerecord/lib/arel/factory_methods.rb | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/activerecord/lib/arel/factory_methods.rb b/activerecord/lib/arel/factory_methods.rb index b828bc274e..83ec23e403 100644 --- a/activerecord/lib/arel/factory_methods.rb +++ b/activerecord/lib/arel/factory_methods.rb @@ -41,5 +41,9 @@ module Arel # :nodoc: all def lower(column) Nodes::NamedFunction.new "LOWER", [Nodes.build_quoted(column)] end + + def coalesce(*exprs) + Nodes::NamedFunction.new "COALESCE", exprs + end end end |