07_add_aux_to_author_nodes.aql

// AQL query to execute IN arangodb QUERIES
// or /usr/bin/arangosh on DB host machine
// to add aux to author nodes

// LET ptypes = (
//     FOR ptype IN pub_type
//         RETURN DISTINCT ptype.name
// )
//
// LET all_authors_unformatted = (
//     FOR ptype IN ptypes
//         FOR doc IN dblp
//             // LIMIT 4000000
//             FILTER doc[ptype].author != null
//             RETURN DISTINCT doc[ptype].author
// )
//        
// LET all_authors_formatted_mixed = (
//     FOR author_list IN all_authors_unformatted
//         FOR author IN author_list[*]
//         RETURN DISTINCT author
// )
//
// FOR a IN all_authors_formatted_mixed
//     INSERT { author_data: a } INTO authors_formatted_mixed
//
// LET all_authors_formatted_mixed_with_aux = (
//     FOR auth_moredata IN authors_formatted_mixed
//         FILTER auth_moredata.author_data["@aux"] != null
//         RETURN DISTINCT auth_moredata
// )
//
// FOR au IN all_authors_formatted_mixed_with_aux
//     INSERT { name: au.author_data["#text"], aux: au.author_data["@aux"] } INTO authors_formatted_mixed_with_aux

FOR auth1 IN authors_formatted_mixed_with_aux
    FOR auth2 IN author
        FILTER auth2.name == auth1.name
        UPDATE auth2 WITH { aux: auth1.aux } IN author