Move Documents between collections in ArangoDB

Question

Is there a simple way to move documents between collections in ArangoDB? I tried the cheap approach to just alter the _id, but as feared that's not supposed to be done or possible:

FOR i IN collection_A
UPDATE { _key: i._key, _id: CONCAT('collection_B/',i._key) } IN collection_A

Are there useful ways how I can move my document from collection_A to collection_B with AQL?

score 4 · Answer 1 · answered Sep 27 '19 at 08:34

4

You could try something like

FOR i IN collection_A
    LET i_b = UNSET(i, "_id") // Remove the id that is not valid before insert
    INSERT i_b INTO collection_B
    REMOVE i IN collection_A

answered Sep 27 '19 at 08:34

darkheir

8,844
6
45
66

Gladly upvote as it's working code which helps. Yet I'm rather curious if there's some quicker or more efficient way – Qohelet Oct 03 '19 at 09:35

score 0 · Answer 2 · answered Sep 23 '19 at 01:41

0

Just do an insert instead of an update For I in collection_A Insert into collection_B

answered Sep 23 '19 at 01:41

camba1

1,795
2
12
18

It's about efficiency. If there are ways to do it with as little as possible modifications – Qohelet Sep 23 '19 at 08:58

score 0 · Answer 3 · answered Oct 14 '20 at 14:32

0

https://www.arangodb.com/docs/stable/aql/examples-data-modification-queries.html#copying-data-from-one-collection-into-another

FOR u IN collection_A
   INSERT u IN collection_B

answered Oct 14 '20 at 14:32

Borislav Markov

1,495
11
12

Move Documents between collections in ArangoDB

3 Answers3