LET data = [
    { "name": "Robert", "surname": "Baratheon", "alive": false, "traits": ["A","H","C"] },
    { "name": "Jaime", "surname": "Lannister", "alive": true, "age": 36, "traits": ["A","F","B"] },
    { "name": "Catelyn", "surname": "Stark", "alive": false, "age": 40, "traits": ["D","H","C"] },
    { "name": "Cersei", "surname": "Lannister", "alive": true, "age": 36, "traits": ["H","E","F"] },
    { "name": "Daenerys", "surname": "Targaryen", "alive": true, "age": 16, "traits": ["D","H","C"] },
    { "name": "Jorah", "surname": "Mormont", "alive": false, "traits": ["A","B","C","F"] },
    { "name": "Petyr", "surname": "Baelish", "alive": false, "traits": ["E","G","F"] },
    { "name": "Viserys", "surname": "Targaryen", "alive": false, "traits": ["O","L","N"] },
    { "name": "Jon", "surname": "Snow", "alive": true, "age": 16, "traits": ["A","B","C","F"] },
    { "name": "Sansa", "surname": "Stark", "alive": true, "age": 13, "traits": ["D","I","J"] },
    { "name": "Arya", "surname": "Stark", "alive": true, "age": 11, "traits": ["C","K","L"] },
    { "name": "Robb", "surname": "Stark", "alive": false, "traits": ["A","B","C","K"] },
    { "name": "Theon", "surname": "Greyjoy", "alive": true, "age": 16, "traits": ["E","R","K"] },
    { "name": "Bran", "surname": "Stark", "alive": true, "age": 10, "traits": ["L","J"] },
    { "name": "Joffrey", "surname": "Baratheon", "alive": false, "age": 19, "traits": ["I","L","O"] },
    { "name": "Sandor", "surname": "Clegane", "alive": true, "traits": ["A","P","K","F"] },
    { "name": "Tyrion", "surname": "Lannister", "alive": true, "age": 32, "traits": ["F","K","M","N"] },
    { "name": "Khal", "surname": "Drogo", "alive": false, "traits": ["A","C","O","P"] },
    { "name": "Tywin", "surname": "Lannister", "alive": false, "traits": ["O","M","H","F"] },
    { "name": "Davos", "surname": "Seaworth", "alive": true, "age": 49, "traits": ["C","K","P","F"] },
    { "name": "Samwell", "surname": "Tarly", "alive": true, "age": 17, "traits": ["C","L","I"] },
    { "name": "Stannis", "surname": "Baratheon", "alive": false, "traits": ["H","O","P","M"] },
    { "name": "Melisandre", "alive": true, "traits": ["G","E","H"] },
    { "name": "Margaery", "surname": "Tyrell", "alive": false, "traits": ["M","D","B"] },
    { "name": "Jeor", "surname": "Mormont", "alive": false, "traits": ["C","H","M","P"] },
    { "name": "Bronn", "alive": true, "traits": ["K","E","C"] },
    { "name": "Varys", "alive": true, "traits": ["M","F","N","E"] },
    { "name": "Shae", "alive": false, "traits": ["M","D","G"] },
    { "name": "Talisa", "surname": "Maegyr", "alive": false, "traits": ["D","C","B"] },
    { "name": "Gendry", "alive": false, "traits": ["K","C","A"] },
    { "name": "Ygritte", "alive": false, "traits": ["A","P","K"] },
    { "name": "Tormund", "surname": "Giantsbane", "alive": true, "traits": ["C","P","A","I"] },
    { "name": "Gilly", "alive": true, "traits": ["L","J"] },
    { "name": "Brienne", "surname": "Tarth", "alive": true, "age": 32, "traits": ["P","C","A","K"] },
    { "name": "Ramsay", "surname": "Bolton", "alive": true, "traits": ["E","O","G","A"] },
    { "name": "Ellaria", "surname": "Sand", "alive": true, "traits": ["P","O","A","E"] },
    { "name": "Daario", "surname": "Naharis", "alive": true, "traits": ["K","P","A"] },
    { "name": "Missandei", "alive": true, "traits": ["D","L","C","M"] },
    { "name": "Tommen", "surname": "Baratheon", "alive": true, "traits": ["I","L","B"] },
    { "name": "Jaqen", "surname": "H'ghar", "alive": true, "traits": ["H","F","K"] },
    { "name": "Roose", "surname": "Bolton", "alive": true, "traits": ["H","E","F","A"] },
    { "name": "The High Sparrow", "alive": true, "traits": ["H","M","F","O"] }
]

FOR d IN data
    INSERT d INTO Characters

LET data =[
    { "_key": "A", "en": "strong", "de": "stark" },
    { "_key": "B", "en": "polite", "de": "freundlich" },
    { "_key": "C", "en": "loyal", "de": "loyal" },
    { "_key": "D", "en": "beautiful", "de": "schön" },
    { "_key": "E", "en": "sneaky", "de": "hinterlistig" },
    { "_key": "F", "en": "experienced", "de": "erfahren" },
    { "_key": "G", "en": "corrupt", "de": "korrupt" },
    { "_key": "H", "en": "powerful", "de": "einflussreich" },
    { "_key": "I", "en": "naive", "de": "naiv" },
    { "_key": "J", "en": "unmarried", "de": "unverheiratet" },
    { "_key": "K", "en": "skillful", "de": "geschickt" },
    { "_key": "L", "en": "young", "de": "jung" },
    { "_key": "M", "en": "smart", "de": "klug" },
    { "_key": "N", "en": "rational", "de": "rational" },
    { "_key": "O", "en": "ruthless", "de": "skrupellos" },
    { "_key": "P", "en": "brave", "de": "mutig" },
    { "_key": "Q", "en": "mighty", "de": "mächtig" },
    { "_key": "R", "en": "weak", "de": "schwach" }
]

for d in data
 INSERT d INTO Traits

FOR c IN Characters
    limit 2 
    RETURN DOCUMENT("Traits", c.traits)

FOR c IN Characters
limit 2
    RETURN MERGE(c, { traits: DOCUMENT("Traits", c.traits)[*].en } )

LET data = [
    {
        "parent": { "name": "Ned", "surname": "Stark" },
        "child": { "name": "Robb", "surname": "Stark" }
    }, {
        "parent": { "name": "Ned", "surname": "Stark" },
        "child": { "name": "Sansa", "surname": "Stark" }
    }, {
        "parent": { "name": "Ned", "surname": "Stark" },
        "child": { "name": "Arya", "surname": "Stark" }
    }, {
        "parent": { "name": "Ned", "surname": "Stark" },
        "child": { "name": "Bran", "surname": "Stark" }
    }, {
        "parent": { "name": "Catelyn", "surname": "Stark" },
        "child": { "name": "Robb", "surname": "Stark" }
    }, {
        "parent": { "name": "Catelyn", "surname": "Stark" },
        "child": { "name": "Sansa", "surname": "Stark" }
    }, {
        "parent": { "name": "Catelyn", "surname": "Stark" },
        "child": { "name": "Arya", "surname": "Stark" }
    }, {
        "parent": { "name": "Catelyn", "surname": "Stark" },
        "child": { "name": "Bran", "surname": "Stark" }
    }, {
        "parent": { "name": "Ned", "surname": "Stark" },
        "child": { "name": "Jon", "surname": "Snow" }
    }, {
        "parent": { "name": "Tywin", "surname": "Lannister" },
        "child": { "name": "Jaime", "surname": "Lannister" }
    }, {
        "parent": { "name": "Tywin", "surname": "Lannister" },
        "child": { "name": "Cersei", "surname": "Lannister" }
    }, {
        "parent": { "name": "Tywin", "surname": "Lannister" },
        "child": { "name": "Tyrion", "surname": "Lannister" }
    }, {
        "parent": { "name": "Cersei", "surname": "Lannister" },
        "child": { "name": "Joffrey", "surname": "Baratheon" }
    }, {
        "parent": { "name": "Jaime", "surname": "Lannister" },
        "child": { "name": "Joffrey", "surname": "Baratheon" }
    }
]

FOR rel in data
    LET parentId = FIRST(
        FOR c IN Characters
            FILTER c.name == rel.parent.name
            FILTER c.surname == rel.parent.surname
            LIMIT 1
            RETURN c._id
    )
    LET childId = FIRST(
        FOR c IN Characters
            FILTER c.name == rel.child.name
            FILTER c.surname == rel.child.surname
            LIMIT 1
            RETURN c._id
    )
    FILTER parentId != null AND childId != null
    INSERT { _from: childId, _to: parentId } INTO ChildOf
    RETURN NEW

FOR c IN Characters
    FILTER c.name == "Tywin"
    FOR v IN 2..2 INBOUND c ChildOf
   return COUNT(v)

LET data=[
    {
        "_key": "Keanu",
        "_id": "actors/Keanu",
        "_rev": "_ddo5sIW---",
        "name": "Keanu Reeves",
        "born": 1964
    },
    {
        "_key": "Carrie",
        "_id": "actors/Carrie",
        "_rev": "_ddo5sLO---",
        "name": "Carrie-Anne Moss",
        "born": 1967
    },
    {
        "_key": "Laurence",
        "_id": "actors/Laurence",
        "_rev": "_ddo5sii---",
        "name": "Laurence Fishburne",
        "born": 1961
    },
    {
        "_key": "Hugo",
        "_id": "actors/Hugo",
        "_rev": "_ddo5sk2---",
        "name": "Hugo Weaving",
        "born": 1960
    },
    {
        "_key": "Emil",
        "_id": "actors/Emil",
        "_rev": "_ddo5soC---",
        "name": "Emil Eifrem",
        "born": 1978
    },
    {
        "_key": "Charlize",
        "_id": "actors/Charlize",
        "_rev": "_ddo5ttS---",
        "name": "Charlize Theron",
        "born": 1975
    },
    {
        "_key": "Al",
        "_id": "actors/Al",
        "_rev": "_ddo5tw6---",
        "name": "Al Pacino",
        "born": 1940
    },
    {
        "_key": "TomC",
        "_id": "actors/TomC",
        "_rev": "_ddo5uNe---",
        "name": "Tom Cruise",
        "born": 1962
    },
    {
        "_key": "JackN",
        "_id": "actors/JackN",
        "_rev": "_ddo5uQC---",
        "name": "Jack Nicholson",
        "born": 1937
    },
    {
        "_key": "DemiM",
        "_id": "actors/DemiM",
        "_rev": "_ddo5uTS---",
        "name": "Demi Moore",
        "born": 1962
    },
    {
        "_key": "KevinB",
        "_id": "actors/KevinB",
        "_rev": "_ddo5uV2---",
        "name": "Kevin Bacon",
        "born": 1958
    },
    {
        "_key": "KieferS",
        "_id": "actors/KieferS",
        "_rev": "_ddo5uaK---",
        "name": "Kiefer Sutherland",
        "born": 1966
    },
    {
        "_key": "NoahW",
        "_id": "actors/NoahW",
        "_rev": "_ddo5ucy---",
        "name": "Noah Wyle",
        "born": 1971
    },
    {
        "_key": "CubaG",
        "_id": "actors/CubaG",
        "_rev": "_ddo5ufW---",
        "name": "Cuba Gooding Jr.",
        "born": 1968
    },
    {
        "_key": "KevinP",
        "_id": "actors/KevinP",
        "_rev": "_ddo5uhS---",
        "name": "Kevin Pollak",
        "born": 1957
    },
    {
        "_key": "JTW",
        "_id": "actors/JTW",
        "_rev": "_ddo5ujS---",
        "name": "J.T. Walsh",
        "born": 1943
    },
    {
        "_key": "JamesM",
        "_id": "actors/JamesM",
        "_rev": "_ddo5umG---",
        "name": "James Marshall",
        "born": 1967
    },
    {
        "_key": "ChristopherG",
        "_id": "actors/ChristopherG",
        "_rev": "_ddo5upy---",
        "name": "Christopher Guest",
        "born": 1948
    },
    {
        "_key": "KellyM",
        "_id": "actors/KellyM",
        "_rev": "_ddo5vWu---",
        "name": "Kelly McGillis",
        "born": 1957
    },
    {
        "_key": "ValK",
        "_id": "actors/ValK",
        "_rev": "_ddo5vZS---",
        "name": "Val Kilmer",
        "born": 1959
    },
    {
        "_key": "AnthonyE",
        "_id": "actors/AnthonyE",
        "_rev": "_ddo5vb2---",
        "name": "Anthony Edwards",
        "born": 1962
    },
    {
        "_key": "TomS",
        "_id": "actors/TomS",
        "_rev": "_ddo5veW---",
        "name": "Tom Skerritt",
        "born": 1933
    },
    {
        "_key": "MegR",
        "_id": "actors/MegR",
        "_rev": "_ddo5vhi---",
        "name": "Meg Ryan",
        "born": 1961
    },
    {
        "_key": "ReneeZ",
        "_id": "actors/ReneeZ",
        "_rev": "_ddo5v6m---",
        "name": "Renee Zellweger",
        "born": 1969
    },
    {
        "_key": "KellyP",
        "_id": "actors/KellyP",
        "_rev": "_ddo5v9S---",
        "name": "Kelly Preston",
        "born": 1962
    },
    {
        "_key": "JerryO",
        "_id": "actors/JerryO",
        "_rev": "_ddo5wAG---",
        "name": "Jerry O'Connell",
        "born": 1974
    },
    {
        "_key": "JayM",
        "_id": "actors/JayM",
        "_rev": "_ddo5wCu---",
        "name": "Jay Mohr",
        "born": 1970
    },
    {
        "_key": "BonnieH",
        "_id": "actors/BonnieH",
        "_rev": "_ddo5wHi---",
        "name": "Bonnie Hunt",
        "born": 1961
    },
    {
        "_key": "ReginaK",
        "_id": "actors/ReginaK",
        "_rev": "_ddo5wK2---",
        "name": "Regina King",
        "born": 1971
    },
    {
        "_key": "JonathanL",
        "_id": "actors/JonathanL",
        "_rev": "_ddo5wN2---",
        "name": "Jonathan Lipnicki",
        "born": 1996
    },
    {
        "_key": "RiverP",
        "_id": "actors/RiverP",
        "_rev": "_ddo5w7i---",
        "name": "River Phoenix",
        "born": 1970
    },
    {
        "_key": "CoreyF",
        "_id": "actors/CoreyF",
        "_rev": "_ddo5x-W---",
        "name": "Corey Feldman",
        "born": 1971
    },
    {
        "_key": "WilW",
        "_id": "actors/WilW",
        "_rev": "_ddo5xB----",
        "name": "Wil Wheaton",
        "born": 1972
    },
    {
        "_key": "JohnC",
        "_id": "actors/JohnC",
        "_rev": "_ddo5xDy---",
        "name": "John Cusack",
        "born": 1966
    },
    {
        "_key": "MarshallB",
        "_id": "actors/MarshallB",
        "_rev": "_ddo5xGi---",
        "name": "Marshall Bell",
        "born": 1942
    },
    {
        "_key": "HelenH",
        "_id": "actors/HelenH",
        "_rev": "_ddo5xoi---",
        "name": "Helen Hunt",
        "born": 1963
    },
    {
        "_key": "GregK",
        "_id": "actors/GregK",
        "_rev": "_ddo5xrW---",
        "name": "Greg Kinnear",
        "born": 1963
    },
    {
        "_key": "AnnabellaS",
        "_id": "actors/AnnabellaS",
        "_rev": "_ddo5yGy---",
        "name": "Annabella Sciorra",
        "born": 1960
    },
    {
        "_key": "MaxS",
        "_id": "actors/MaxS",
        "_rev": "_ddo5yKm---",
        "name": "Max von Sydow",
        "born": 1929
    },
    {
        "_key": "WernerH",
        "_id": "actors/WernerH",
        "_rev": "_ddo5yN6---",
        "name": "Werner Herzog",
        "born": 1942
    },
    {
        "_key": "Robin",
        "_id": "actors/Robin",
        "_rev": "_ddo5yQi---",
        "name": "Robin Williams",
        "born": 1951
    },
    {
        "_key": "EthanH",
        "_id": "actors/EthanH",
        "_rev": "_ddo5ypq---",
        "name": "Ethan Hawke",
        "born": 1970
    },
    {
        "_key": "RickY",
        "_id": "actors/RickY",
        "_rev": "_ddo5ys----",
        "name": "Rick Yune",
        "born": 1971
    },
    {
        "_key": "JamesC",
        "_id": "actors/JamesC",
        "_rev": "_ddo5yum---",
        "name": "James Cromwell",
        "born": 1940
    },
    {
        "_key": "ParkerP",
        "_id": "actors/ParkerP",
        "_rev": "_ddo5zHK---",
        "name": "Parker Posey",
        "born": 1968
    },
    {
        "_key": "DaveC",
        "_id": "actors/DaveC",
        "_rev": "_ddo5zKW---",
        "name": "Dave Chappelle",
        "born": 1973
    },
    {
        "_key": "SteveZ",
        "_id": "actors/SteveZ",
        "_rev": "_ddo5zMy---",
        "name": "Steve Zahn",
        "born": 1967
    },
    {
        "_key": "TomH",
        "_id": "actors/TomH",
        "_rev": "_ddo5zO6---",
        "name": "Tom Hanks",
        "born": 1956
    },
    {
        "_key": "RitaW",
        "_id": "actors/RitaW",
        "_rev": "_ddo5zwW---",
        "name": "Rita Wilson",
        "born": 1956
    },
    {
        "_key": "BillPull",
        "_id": "actors/BillPull",
        "_rev": "_ddo5zyu---",
        "name": "Bill Pullman",
        "born": 1953
    },
    {
        "_key": "VictorG",
        "_id": "actors/VictorG",
        "_rev": "_ddo5z1a---",
        "name": "Victor Garber",
        "born": 1949
    },
    {
        "_key": "RosieO",
        "_id": "actors/RosieO",
        "_rev": "_ddo5z5q---",
        "name": "Rosie O'Donnell",
        "born": 1962
    },
    {
        "_key": "Nathan",
        "_id": "actors/Nathan",
        "_rev": "_ddo50V----",
        "name": "Nathan Lane",
        "born": 1956
    },
    {
        "_key": "BillyC",
        "_id": "actors/BillyC",
        "_rev": "_ddo50qW---",
        "name": "Billy Crystal",
        "born": 1948
    },
    {
        "_key": "CarrieF",
        "_id": "actors/CarrieF",
        "_rev": "_ddo50s2---",
        "name": "Carrie Fisher",
        "born": 1956
    },
    {
        "_key": "BrunoK",
        "_id": "actors/BrunoK",
        "_rev": "_ddo50wm---",
        "name": "Bruno Kirby",
        "born": 1949
    }
]

for d in data
	 INSERT d INTO actors

LET data=[
    {
        "_key": "TheMatrix",
        "_id": "movies/TheMatrix",
        "_rev": "_ddo5sFG---",
        "title": "The Matrix",
        "released": 1999,
        "tagline": "Welcome to the Real World"
    },
    {
        "_key": "TheMatrixReloaded",
        "_id": "movies/TheMatrixReloaded",
        "_rev": "_ddo5t-----",
        "title": "The Matrix Reloaded",
        "released": 2003,
        "tagline": "Free your mind"
    },
    {
        "_key": "TheMatrixRevolutions",
        "_id": "movies/TheMatrixRevolutions",
        "_rev": "_ddo5tTW---",
        "title": "The Matrix Revolutions",
        "released": 2003,
        "tagline": "Everything that has a beginning has an end"
    },
    {
        "_key": "TheDevilsAdvocate",
        "_id": "movies/TheDevilsAdvocate",
        "_rev": "_ddo5tqi---",
        "title": "The Devil's Advocate",
        "released": 1997,
        "tagline": "Evil has its winning ways"
    },
    {
        "_key": "AFewGoodMen",
        "_id": "movies/AFewGoodMen",
        "_rev": "_ddo5uKq---",
        "title": "A Few Good Men",
        "released": 1992,
        "tagline": "In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth."
    },
    {
        "_key": "TopGun",
        "_id": "movies/TopGun",
        "_rev": "_ddo5vUG---",
        "title": "Top Gun",
        "released": 1986,
        "tagline": "I feel the need, the need for speed."
    },
    {
        "_key": "JerryMaguire",
        "_id": "movies/JerryMaguire",
        "_rev": "_ddo5v4K---",
        "title": "Jerry Maguire",
        "released": 2000,
        "tagline": "The rest of his life begins now."
    },
    {
        "_key": "StandByMe",
        "_id": "movies/StandByMe",
        "_rev": "_ddo5w3e---",
        "title": "Stand By Me",
        "released": 1986,
        "tagline": "For some, it's the last real taste of innocence, and the first real taste of life. But for everyone, it's the time that memories are made of."
    },
    {
        "_key": "AsGoodAsItGets",
        "_id": "movies/AsGoodAsItGets",
        "_rev": "_ddo5xl2---",
        "title": "As Good as It Gets",
        "released": 1997,
        "tagline": "A comedy from the heart that goes for the throat."
    },
    {
        "_key": "WhatDreamsMayCome",
        "_id": "movies/WhatDreamsMayCome",
        "_rev": "_ddo5yDC---",
        "title": "What Dreams May Come",
        "released": 1998,
        "tagline": "After life there is more. The end is just the beginning."
    },
    {
        "_key": "SnowFallingonCedars",
        "_id": "movies/SnowFallingonCedars",
        "_rev": "_ddo5ymi---",
        "title": "Snow Falling on Cedars",
        "released": 1999,
        "tagline": "First loves last. Forever."
    },
    {
        "_key": "YouveGotMail",
        "_id": "movies/YouveGotMail",
        "_rev": "_ddo5zD2---",
        "title": "You've Got Mail",
        "released": 1998,
        "tagline": "At odds in life... in love on-line."
    },
    {
        "_key": "SleeplessInSeattle",
        "_id": "movies/SleeplessInSeattle",
        "_rev": "_ddo5zuG---",
        "title": "Sleepless in Seattle",
        "released": 1993,
        "tagline": "What if someone you never met, someone you never saw, someone you never knew was the only someone for you?"
    },
    {
        "_key": "JoeVersustheVolcano",
        "_id": "movies/JoeVersustheVolcano",
        "_rev": "_ddo50S2---",
        "title": "Joe Versus the Volcano",
        "released": 1990,
        "tagline": "A story of love, lava and burning desire."
    },
    {
        "_key": "WhenHarryMetSally",
        "_id": "movies/WhenHarryMetSally",
        "_rev": "_ddo50nm---",
        "title": "When Harry Met Sally",
        "released": 1998,
        "tagline": "At odds in life... in love on-line."
    }
]

for d in data
	 INSERT d INTO movies

db.actsIn.ensureIndex({ type: "persistent", fields: ["year"] });