{"id":3232,"date":"2016-03-06T21:37:35","date_gmt":"2016-03-06T21:37:35","guid":{"rendered":"http:\/\/www.garysieling.com\/blog\/?p=3232"},"modified":"2016-03-06T21:37:35","modified_gmt":"2016-03-06T21:37:35","slug":"3232-2","status":"publish","type":"post","link":"https:\/\/www.garysieling.com\/blog\/3232-2\/","title":{"rendered":"RethinkDB: Insert Example"},"content":{"rendered":"
\nr.db('test')\n .table('users')\n .insert({\n   'first_name': 'gary', \n   'last_name': 'sieling',\n   'user_name': 'gsieling'\n })\n<\/pre>\n
By default, this returns you the IDs you requested:<\/p>\n
\n{\n  \"deleted\": 0 ,\n  \"errors\": 0 ,\n  \"generated_keys\": [\n    \"903e0943-8ffe-41ca-a22f-7b1a964b399d\"\n  ] ,\n  \"inserted\": 1 ,\n  \"replaced\": 0 ,\n  \"skipped\": 0 ,\n  \"unchanged\": 0\n}\n<\/pre>\n
If you request the changes back, this will return you the values you inserted, in addition to the data inserted:<\/p>\n
\nr.db('test')\n .table('users')\n .insert({\n   'first_name': 'gary', \n   'last_name': 'sieling',\n   'user_name': 'gsieling'\n }, {returnChanges: true})\n<\/pre>\n
This is what you get:<\/p>\n
\n{\n  \"changes\": [\n    {\n      \"new_val\": {\n        \"first_name\":  \"gary\" ,\n        \"id\":  \"947a3ce6-d419-4d31-bd1e-874c721a9e6c\" ,\n        \"last_name\":  \"sieling\" ,\n        \"user_name\":  \"gsieling\"\n      } ,\n      \"old_val\": null\n    }\n  ] ,\n  \"deleted\": 0 ,\n  \"errors\": 0 ,\n  \"generated_keys\": [\n    \"947a3ce6-d419-4d31-bd1e-874c721a9e6c\"\n  ],\n  \"inserted\": 1 ,\n  \"replaced\": 0 ,\n  \"skipped\": 0 ,\n  \"unchanged\": 0\n}\n<\/pre>\n
By default this sets durability to “hard” and doesn’t return the results, which should be a little faster. You can set durability to “soft” and it will insert a little faster, but risk losing data in a crash scenario:<\/p>\n
\nr.db('test')\n .table('users')\n .insert({\n   'first_name': 'gary', \n   'last_name': 'sieling',\n   'user_name': 'gsieling'\n }, \n {\n    durability: 'soft'\n })\n<\/pre>\n
If instead of an insert, you want to replace an existing object, you can use ‘replace’:<\/p>\n
\nr.db('test')\n .table('users')\n  .get('1b223750-799d-402a-b378-74c993a9c10c')\n  .replace(\n    {\n       user_name: 'test', \n       last_name: 'test', \n       first_name: 'test', \n       id: '1b223750-799d-402a-b378-74c993a9c10c'\n    })\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
r.db(‘test’) .table(‘users’) .insert({ ‘first_name’: ‘gary’, ‘last_name’: ‘sieling’, ‘user_name’: ‘gsieling’ }) By default, this returns you the IDs you requested: { “deleted”: 0 , “errors”: 0 , “generated_keys”: [ “903e0943-8ffe-41ca-a22f-7b1a964b399d” ] , “inserted”: 1 , “replaced”: 0 , “skipped”: 0 , “unchanged”: 0 } If you request the changes back, this will return you the values … <\/p>\n
Continue reading “RethinkDB: Insert Example”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[4],"tags":[160,466,523],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t