gmadar
Reputation: 1904
Upsert & increment in RethinkDB
Is it possible to do an "upsert" with an increment? So if the query is an insert the counter will initialize with 1 and if it an update it will increment the counter by 1
Upvotes: 1
Views: 780
Answers (1)
Kludge
Reputation: 2835
table.insert({id: 1, counter: 1}, {conflict: function(id, oldVal, newVal) {
return newVal.merge({counter: oldVal('counter').add(1)})
}})
Introduced in v2.3.0 IIUC: https://github.com/rethinkdb/rethinkdb/releases/tag/v2.3.0
Upvotes: 1
Related Questions
- Increment or Decrement value using Sequelize upsert()
- mongodb query - Upsert a value and then get the incremented value
- Upsert with counter
- Auto increment in Rethinkdb
- Update statement rethinkdb
- How can I upsert a document in rethinkdb (reql) by an arbitrary property?
- Increment and decrement RethinkDB Single Value
- Proper Upsert (Atomic Update Counter Field or Insert Document) with RethinkDB
- RethinkDB - Integer Increment in Document (Python)
- MongoDB Increment or Upsert