INSERT/UPDATE/DELETE/UPSERT

Be able to run basic DML statements.

"A": { "val" : "A", "f1": "stuff", "f2": "other" }

"B": { "val" : "B", "f1": 2 }

"C": { "val" : "C", "f2": true }

Setup: Standard.

Action: Run statement INSERT INTO myBucket.myScope.myCollection VALUES ("foo", { "val" : "D", "f1" : "new" })

Expected Result: New document appears in collection.

Setup: Standard

Action: Run statement UPDATE myBucket.myScope.myCollection SET f2 = "created" WHERE val = "B"

Expected Result: Document B gets a new field f2:"created"

Setup: Standard

Action: Run statement DELETE FROM myBucket.myScope.myCollection WHERE val = "B"

Expected Result: Document B is deleted.

Setup: Standard.

Action: Run statement UPSERT INTO myBucket.myScope.myCollection VALUES ("foo", { "val" : "D", "f1" : "upserted" })

Expected Result: New document appears in collection.