ArangoDB - Create AQL INSERT Scripts

Question

I would like to prepare scripts for completing databases. How can I do this?

Something like that:

 INSERT { _class: 'Entity', name: 'First'} IN wholesales
 INSERT { _class: 'Entity', name: 'Second' } IN wholesales
 INSERT { _class: 'Entity', name: 'Three' } IN wholesales
 INSERT { _class: 'Entity', name: 'Four' } IN wholesales

CodeManX · Accepted Answer · 2018-12-28 00:01:26Z

2

Only one INSERT operation per collection and query is allowed in AQL.

You can use a loop to make this work however:

FOR doc IN [
    { _class: 'Entity', name: 'First'},
    { _class: 'Entity', name: 'Second' },
    { _class: 'Entity', name: 'Third' },
    { _class: 'Entity', name: 'Fourth' }
]
INSERT doc INTO wholesales

The documents as well as the collection name can also be passed as bind parameters.

Query:

FOR doc IN @docs INSERT doc INTO @@coll

Bind parameters:

{ "docs": [ { ... }, { ... } ], "@coll": "wholesales" }

Another way to import data is to use arangoimport.

edited Dec 28, 2018 at 0:01

answered Jun 27, 2018 at 1:38

CodeManX

12.1k5 gold badges55 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ArangoDB - Create AQL INSERT Scripts

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related