C8QL Examples¶

Assumptions

Collection Name (should exist): demo_queries

Sample Queries

Insert 10 documents into the demo_queries collection, using a bindvar to pass in a name prefix for the name field of the data in the new documents to be inserted:

FOR i IN 1..10 
    INSERT { name: CONCAT(@user_prefix, i), gender: (i % 2 == 0 ? "f" : "m"), likes: ROUND(RAND()*100), follows: ROUND(RAND() * 100) } 
    INTO demo_queries

View all the docs in the collection, sorted in ascending order of the document key:

FOR doc IN demo_queries 
    SORT doc._key 
    RETURN {"Key":doc._key, "Name":doc.name, "Gender":doc.gender, "Likes":doc.likes, "Follows":doc.follows}

Update all documents in the demo_queries collection. The gender, likes and follows fields are updated with values accepted from the bindvars. If no bindvar values are specified, the fields are blanked. All documents will be updated to have the same value for these fields.
```
FOR doc IN demo_queries 
    UPDATE { _key:doc._key, gender:@gender, likes:@likes, follows:@follows} 
    IN demo_queries
```
Remove all documents in the demo_queries collection. The collection will continue to exist but will be empty.
```
FOR doc IN demo_queries 
    REMOVE doc 
    IN demo_queries
```