Recently i was building a microservice which has RethinkDB used. Its a great choice if you are looking to quickly build a realtime service. The service i built had a new table for each user account, while testing i had added some records with missing keys. Obviously it would be hard to remove them and add again for each table, so i used this snippet to update each record in all of the tables -
Hope this helps!
r.db("test_db")
.tableList()
.do(tables => tables.forEach(name => r.db("test_db").table(name)
.update({ visits: "3" })));
The above query will find all of the available tables, loop on them and on each record it will update the visits
to 3
, Just like this you can use filter, delete and other methods across multiple tables.
Hope this helps!
Comments
Post a Comment