|
// Classic Neo4j Movie Graph Dataset - Using Individual MERGE Pattern |
|
// This pattern ensures all nodes exist before relationships are created |
|
|
|
// ============================================================================= |
|
// MERGE ALL PERSON NODES FIRST |
|
// ============================================================================= |
|
|
|
MERGE (Keanu:Person {name:'Keanu Reeves', born:1964}) |
|
MERGE (Carrie:Person {name:'Carrie-Anne Moss', born:1967}) |
|
MERGE (Laurence:Person {name:'Laurence Fishburne', born:1961}) |
|
MERGE (Hugo:Person {name:'Hugo Weaving', born:1960}) |
|
MERGE (LillyW:Person {name:'Lilly Wachowski', born:1967}) |
|
MERGE (LanaW:Person {name:'Lana Wachowski', born:1965}) |
|
MERGE (JoelS:Person {name:'Joel Silver', born:1952}) |
|
MERGE (Charlize:Person {name:'Charlize Theron', born:1975}) |
|
MERGE (Al:Person {name:'Al Pacino', born:1940}) |
|
MERGE (Taylor:Person {name:'Taylor Hackford', born:1944}) |
|
MERGE (TomC:Person {name:'Tom Cruise', born:1962}) |
|
MERGE (JackN:Person {name:'Jack Nicholson', born:1937}) |
|
MERGE (DemiM:Person {name:'Demi Moore', born:1962}) |
|
MERGE (KevinB:Person {name:'Kevin Bacon', born:1958}) |
|
MERGE (KieferS:Person {name:'Kiefer Sutherland', born:1966}) |
|
MERGE (NoahW:Person {name:'Noah Wyle', born:1971}) |
|
MERGE (CubaG:Person {name:'Cuba Gooding Jr.', born:1968}) |
|
MERGE (KevinP:Person {name:'Kevin Pollak', born:1957}) |
|
MERGE (JTW:Person {name:'J.T. Walsh', born:1943}) |
|
MERGE (JamesM:Person {name:'James Marshall', born:1967}) |
|
MERGE (ChristopherG:Person {name:'Christopher Guest', born:1948}) |
|
MERGE (RobR:Person {name:'Rob Reiner', born:1947}) |
|
MERGE (AaronS:Person {name:'Aaron Sorkin', born:1961}) |
|
MERGE (KellyM:Person {name:'Kelly McGillis', born:1957}) |
|
MERGE (ValK:Person {name:'Val Kilmer', born:1959}) |
|
MERGE (AnthonyE:Person {name:'Anthony Edwards', born:1962}) |
|
MERGE (TomS:Person {name:'Tom Skerritt', born:1933}) |
|
MERGE (MegR:Person {name:'Meg Ryan', born:1961}) |
|
MERGE (TonyS:Person {name:'Tony Scott', born:1944}) |
|
MERGE (JimC:Person {name:'Jim Cash', born:1941}) |
|
MERGE (ReneeZ:Person {name:'Renee Zellweger', born:1969}) |
|
MERGE (KellyP:Person {name:'Kelly Preston', born:1962}) |
|
MERGE (JayM:Person {name:'Jay Mohr', born:1970}) |
|
MERGE (BonnieH:Person {name:'Bonnie Hunt', born:1961}) |
|
MERGE (ReginaK:Person {name:'Regina King', born:1971}) |
|
MERGE (JonathanL:Person {name:'Jonathan Lipnicki', born:1996}) |
|
MERGE (CameronC:Person {name:'Cameron Crowe', born:1957}) |
|
MERGE (RiverP:Person {name:'River Phoenix', born:1970}) |
|
MERGE (CoreyF:Person {name:'Corey Feldman', born:1971}) |
|
MERGE (WilW:Person {name:'Wil Wheaton', born:1972}) |
|
MERGE (JohnC:Person {name:'John Cusack', born:1966}) |
|
MERGE (MarshallB:Person {name:'Marshall Bell', born:1942}) |
|
MERGE (TomH:Person {name:'Tom Hanks', born:1956}) |
|
MERGE (SallyF:Person {name:'Sally Field', born:1946}) |
|
MERGE (RobinWright:Person {name:'Robin Wright', born:1966}) |
|
MERGE (MykeltiW:Person {name:'Mykelti Williamson', born:1957}) |
|
MERGE (MichaelC:Person {name:'Michael Conner Humphreys', born:1985}) |
|
MERGE (GaryS:Person {name:'Gary Sinise', born:1955}) |
|
MERGE (RobertZ:Person {name:'Robert Zemeckis', born:1951}) |
|
MERGE (HelenH:Person {name:'Helen Hunt', born:1963}) |
|
MERGE (EdH:Person {name:'Ed Harris', born:1950}) |
|
MERGE (BillPax:Person {name:'Bill Paxton', born:1955}) |
|
MERGE (RonH:Person {name:'Ron Howard', born:1954}) |
|
MERGE (MichaelD:Person {name:'Michael Clarke Duncan', born:1957}) |
|
MERGE (DavidM:Person {name:'David Morse', born:1953}) |
|
MERGE (SamR:Person {name:'Sam Rockwell', born:1968}) |
|
MERGE (PatriciaC:Person {name:'Patricia Clarkson', born:1959}) |
|
MERGE (FrankD:Person {name:'Frank Darabont', born:1959}) |
|
MERGE (JamesC:Person {name:'James Cromwell', born:1940}) |
|
MERGE (MattD:Person {name:'Matt Damon', born:1970}) |
|
MERGE (TomSizemore:Person {name:'Tom Sizemore', born:1961}) |
|
MERGE (BarryP:Person {name:'Barry Pepper', born:1970}) |
|
MERGE (AdamG:Person {name:'Adam Goldberg', born:1970}) |
|
MERGE (VinD:Person {name:'Vin Diesel', born:1967}) |
|
MERGE (StevenS:Person {name:'Steven Spielberg', born:1946}) |
|
MERGE (EdwardB:Person {name:'Edward Burns', born:1968}) |
|
MERGE (ParkerP:Person {name:'Parker Posey', born:1968}) |
|
MERGE (DaveC:Person {name:'Dave Chappelle', born:1973}) |
|
MERGE (SteveZ:Person {name:'Steve Zahn', born:1967}) |
|
MERGE (NoraE:Person {name:'Nora Ephron', born:1941}) |
|
MERGE (GregK:Person {name:'Greg Kinnear', born:1963}) |
|
MERGE (RitaW:Person {name:'Rita Wilson', born:1956}) |
|
MERGE (BillPull:Person {name:'Bill Pullman', born:1953}) |
|
MERGE (VictorG:Person {name:'Victor Garber', born:1949}) |
|
MERGE (DenzelW:Person {name:'Denzel Washington', born:1954}) |
|
MERGE (AntonioB:Person {name:'Antonio Banderas', born:1960}) |
|
MERGE (JonathanD:Person {name:'Jonathan Demme', born:1944}) |
|
MERGE (BillyC:Person {name:'Billy Crystal', born:1948}) |
|
MERGE (CarrieF:Person {name:'Carrie Fisher', born:1956}) |
|
MERGE (BrunoK:Person {name:'Bruno Kirby', born:1949}) |
|
MERGE (JamesB:Person {name:'James L. Brooks', born:1940}) |
|
MERGE (AnnabellaS:Person {name:'Annabella Sciorra', born:1960}) |
|
MERGE (MaxS:Person {name:'Max von Sydow', born:1929}) |
|
MERGE (WernerH:Person {name:'Werner Herzog', born:1942}) |
|
MERGE (Robin:Person {name:'Robin Williams', born:1951}) |
|
MERGE (VincentW:Person {name:'Vincent Ward', born:1956}) |
|
MERGE (EthanH:Person {name:'Ethan Hawke', born:1970}) |
|
MERGE (RickY:Person {name:'Rick Yune', born:1971}) |
|
MERGE (ScottH:Person {name:'Scott Hicks', born:1953}) |
|
MERGE (Takeshi:Person {name:'Takeshi Kitano', born:1947}) |
|
MERGE (Dina:Person {name:'Dina Meyer', born:1968}) |
|
MERGE (IceT:Person {name:'Ice-T', born:1958}) |
|
MERGE (RobertL:Person {name:'Robert Longo', born:1953}) |
|
MERGE (Brooke:Person {name:'Brooke Langton', born:1970}) |
|
MERGE (Gene:Person {name:'Gene Hackman', born:1930}) |
|
MERGE (Orlando:Person {name:'Orlando Jones', born:1968}) |
|
MERGE (Howard:Person {name:'Howard Deutch', born:1950}) |
|
MERGE (DianeK:Person {name:'Diane Keaton', born:1946}) |
|
MERGE (NancyM:Person {name:'Nancy Meyers', born:1949}) |
|
MERGE (HalleB:Person {name:'Halle Berry', born:1966}) |
|
MERGE (JimB:Person {name:'Jim Broadbent', born:1949}) |
|
MERGE (TomT:Person {name:'Tom Tykwer', born:1965}) |
|
MERGE (DavidMitchell:Person {name:'David Mitchell', born:1969}) |
|
MERGE (StefanArndt:Person {name:'Stefan Arndt', born:1961}) |
|
MERGE (IanM:Person {name:'Ian McKellen', born:1939}) |
|
MERGE (AudreyT:Person {name:'Audrey Tautou', born:1976}) |
|
MERGE (PaulB:Person {name:'Paul Bettany', born:1971}) |
|
MERGE (NatalieP:Person {name:'Natalie Portman', born:1981}) |
|
MERGE (StephenR:Person {name:'Stephen Rea', born:1946}) |
|
MERGE (JohnH:Person {name:'John Hurt', born:1940}) |
|
MERGE (BenM:Person {name:'Ben Miles', born:1967}) |
|
MERGE (EmileH:Person {name:'Emile Hirsch', born:1985}) |
|
MERGE (JohnG:Person {name:'John Goodman', born:1960}) |
|
MERGE (SusanS:Person {name:'Susan Sarandon', born:1946}) |
|
MERGE (MatthewF:Person {name:'Matthew Fox', born:1966}) |
|
MERGE (ChristinaR:Person {name:'Christina Ricci', born:1980}) |
|
MERGE (Rain:Person {name:'Rain', born:1982}) |
|
MERGE (NaomieH:Person {name:'Naomie Harris'}) |
|
MERGE (JohnS:Person {name:'John Patrick Stanley', born:1950}) |
|
MERGE (PennyM:Person {name:'Penny Marshall', born:1943}) |
|
MERGE (ElizabethP:Person {name:'Elizabeth Perkins', born:1960}) |
|
MERGE (RobertL2:Person {name:'Robert Loggia', born:1930}) |
|
MERGE (DarylH:Person {name:'Daryl Hannah', born:1960}) |
|
MERGE (JohnCandy:Person {name:'John Candy', born:1950}) |
|
MERGE (EugeneL:Person {name:'Eugene Levy', born:1946}) |
|
MERGE (LeonardoD:Person {name:'Leonardo DiCaprio', born:1974}) |
|
MERGE (ChristopherW:Person {name:'Christopher Walken', born:1943}) |
|
MERGE (AmyA:Person {name:'Amy Adams', born:1974}) |
|
MERGE (CatherineZ:Person {name:'Catherine Zeta-Jones', born:1969}) |
|
MERGE (StanleyT:Person {name:'Stanley Tucci', born:1960}) |
|
MERGE (TimA:Person {name:'Tim Allen', born:1953}) |
|
MERGE (DonR:Person {name:'Don Rickles', born:1926}) |
|
MERGE (JohnL:Person {name:'John Lasseter', born:1957}); |
|
|
|
// ============================================================================= |
|
// MERGE ALL MOVIE NODES |
|
// ============================================================================= |
|
|
|
MERGE (TheMatrix:Movie {title:'The Matrix', released:1999, tagline:'Welcome to the Real World'}) |
|
MERGE (TheMatrixReloaded:Movie {title:'The Matrix Reloaded', released:2003, tagline:'Free your mind'}) |
|
MERGE (TheMatrixRevolutions:Movie {title:'The Matrix Revolutions', released:2003, tagline:'Everything that has a beginning has an end'}) |
|
MERGE (AFewGoodMen:Movie {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."}) |
|
MERGE (TopGun:Movie {title:"Top Gun", released:1986, tagline:'I feel the need, the need for speed.'}) |
|
MERGE (JerryMaguire:Movie {title:'Jerry Maguire', released:2000, tagline:'The rest of his life begins now.'}) |
|
MERGE (StandByMe:Movie {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."}) |
|
MERGE (ForrestGump:Movie {title:'Forrest Gump', released:1994, tagline:'Life is like a box of chocolates, you never know what you are gonna get.'}) |
|
MERGE (CastAway:Movie {title:'Cast Away', released:2000, tagline:'At the edge of the world, his journey begins.'}) |
|
MERGE (Apollo13:Movie {title:'Apollo 13', released:1995, tagline:'Houston, we have a problem.'}) |
|
MERGE (TheGreenMile:Movie {title:'The Green Mile', released:1999, tagline:"Walk a mile you'll never forget."}) |
|
MERGE (SavingPrivateRyan:Movie {title:'Saving Private Ryan', released:1998, tagline:'The mission is a man.'}) |
|
MERGE (SleeplessInSeattle:Movie {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?'}) |
|
MERGE (Philadelphia:Movie {title:'Philadelphia', released:1993, tagline:'No one would take on his case... until one man was willing to take on the system.'}) |
|
MERGE (WhenHarryMetSally:Movie {title:'When Harry Met Sally', released:1989, tagline:'Can two friends sleep together and still love each other in the morning?'}) |
|
MERGE (AsGoodAsItGets:Movie {title:'As Good as It Gets', released:1997, tagline:'A comedy from the heart that goes for the throat.'}) |
|
MERGE (WhatDreamsMayCome:Movie {title:'What Dreams May Come', released:1998, tagline:'After life there is more. The end is just the beginning.'}) |
|
MERGE (SnowFallingonCedars:Movie {title:'Snow Falling on Cedars', released:1999, tagline:'First loves last. Forever.'}) |
|
MERGE (JohnnyMnemonic:Movie {title:'Johnny Mnemonic', released:1995, tagline:'The hottest data on earth. In the coolest head in town'}) |
|
MERGE (TheReplacements:Movie {title:'The Replacements', released:2000, tagline:'Throw the ball. Catch the ball. Tackle the guy with the ball.'}) |
|
MERGE (CloudAtlas:Movie {title:'Cloud Atlas', released:2012, tagline:'Everything is connected'}) |
|
MERGE (TheDaVinciCode:Movie {title:'The Da Vinci Code', released:2006, tagline:'Break The Codes'}) |
|
MERGE (VforVendetta:Movie {title:'V for Vendetta', released:2006, tagline:'Freedom! Forever!'}) |
|
MERGE (SpeedRacer:Movie {title:'Speed Racer', released:2008, tagline:'Speed has no limits'}) |
|
MERGE (NinjaAssassin:Movie {title:'Ninja Assassin', released:2009, tagline:'Prepare to enter a secret world of assassins'}) |
|
MERGE (JoeVersustheVolcano:Movie {title:'Joe Versus the Volcano', released:1990, tagline:'A story of love, lava and burning desire.'}) |
|
MERGE (Big:Movie {title:'Big', released:1988, tagline:'You are what you wish for.'}) |
|
MERGE (Splash:Movie {title:'Splash', released:1984, tagline:'A different kind of love story.'}) |
|
MERGE (CatchMeIfYouCan:Movie {title:'Catch Me If You Can', released:2002, tagline:'The true story of a real fake.'}) |
|
MERGE (TheTerminal:Movie {title:'The Terminal', released:2004, tagline:'Life is waiting.'}) |
|
MERGE (ToyStory:Movie {title:'Toy Story', released:1995, tagline:'Hang on for the comedy that goes to infinity and beyond!'}) |
|
MERGE (ToyStory2:Movie {title:'Toy Story 2', released:1999, tagline:'The toys are back!'}); |
|
|
|
// ============================================================================= |
|
// MERGE ALL RELATIONSHIPS INDIVIDUALLY |
|
// ============================================================================= |
|
|
|
// The Matrix relationships |
|
MATCH (a:Person {name: 'Keanu Reeves'}) MATCH (b:Movie {title: 'The Matrix'}) MERGE (a)-[:ACTED_IN {roles:['Neo']}]->(b); |
|
MATCH (a:Person {name: 'Carrie-Anne Moss'}) MATCH (b:Movie {title: 'The Matrix'}) MERGE (a)-[:ACTED_IN {roles:['Trinity']}]->(b); |
|
MATCH (a:Person {name: 'Laurence Fishburne'}) MATCH (b:Movie {title: 'The Matrix'}) MERGE (a)-[:ACTED_IN {roles:['Morpheus']}]->(b); |
|
MATCH (a:Person {name: 'Hugo Weaving'}) MATCH (b:Movie {title: 'The Matrix'}) MERGE (a)-[:ACTED_IN {roles:['Agent Smith']}]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'The Matrix'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'The Matrix'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Joel Silver'}) MATCH (b:Movie {title: 'The Matrix'}) MERGE (a)-[:PRODUCED]->(b); |
|
|
|
// The Matrix Reloaded relationships |
|
MATCH (a:Person {name: 'Keanu Reeves'}) MATCH (b:Movie {title: 'The Matrix Reloaded'}) MERGE (a)-[:ACTED_IN {roles:['Neo']}]->(b); |
|
MATCH (a:Person {name: 'Carrie-Anne Moss'}) MATCH (b:Movie {title: 'The Matrix Reloaded'}) MERGE (a)-[:ACTED_IN {roles:['Trinity']}]->(b); |
|
MATCH (a:Person {name: 'Laurence Fishburne'}) MATCH (b:Movie {title: 'The Matrix Reloaded'}) MERGE (a)-[:ACTED_IN {roles:['Morpheus']}]->(b); |
|
MATCH (a:Person {name: 'Hugo Weaving'}) MATCH (b:Movie {title: 'The Matrix Reloaded'}) MERGE (a)-[:ACTED_IN {roles:['Agent Smith']}]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'The Matrix Reloaded'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'The Matrix Reloaded'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Joel Silver'}) MATCH (b:Movie {title: 'The Matrix Reloaded'}) MERGE (a)-[:PRODUCED]->(b); |
|
|
|
// The Matrix Revolutions relationships |
|
MATCH (a:Person {name: 'Keanu Reeves'}) MATCH (b:Movie {title: 'The Matrix Revolutions'}) MERGE (a)-[:ACTED_IN {roles:['Neo']}]->(b); |
|
MATCH (a:Person {name: 'Carrie-Anne Moss'}) MATCH (b:Movie {title: 'The Matrix Revolutions'}) MERGE (a)-[:ACTED_IN {roles:['Trinity']}]->(b); |
|
MATCH (a:Person {name: 'Laurence Fishburne'}) MATCH (b:Movie {title: 'The Matrix Revolutions'}) MERGE (a)-[:ACTED_IN {roles:['Morpheus']}]->(b); |
|
MATCH (a:Person {name: 'Hugo Weaving'}) MATCH (b:Movie {title: 'The Matrix Revolutions'}) MERGE (a)-[:ACTED_IN {roles:['Agent Smith']}]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'The Matrix Revolutions'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'The Matrix Revolutions'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Joel Silver'}) MATCH (b:Movie {title: 'The Matrix Revolutions'}) MERGE (a)-[:PRODUCED]->(b); |
|
|
|
// The Devil's Advocate relationships |
|
MATCH (a:Person {name: 'Keanu Reeves'}) MATCH (b:Movie {title: 'The Devil\'s Advocate'}) MERGE (a)-[:ACTED_IN {roles:['Kevin Lomax']}]->(b); |
|
MATCH (a:Person {name: 'Charlize Theron'}) MATCH (b:Movie {title: 'The Devil\'s Advocate'}) MERGE (a)-[:ACTED_IN {roles:['Mary Ann Lomax']}]->(b); |
|
MATCH (a:Person {name: 'Al Pacino'}) MATCH (b:Movie {title: 'The Devil\'s Advocate'}) MERGE (a)-[:ACTED_IN {roles:['John Milton']}]->(b); |
|
MATCH (a:Person {name: 'Taylor Hackford'}) MATCH (b:Movie {title: 'The Devil\'s Advocate'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// A Few Good Men relationships |
|
MATCH (a:Person {name: 'Tom Cruise'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Lt. Daniel Kaffee']}]->(b); |
|
MATCH (a:Person {name: 'Jack Nicholson'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Col. Nathan R. Jessup']}]->(b); |
|
MATCH (a:Person {name: 'Demi Moore'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Lt. Cdr. JoAnne Galloway']}]->(b); |
|
MATCH (a:Person {name: 'Kevin Bacon'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Capt. Jack Ross']}]->(b); |
|
MATCH (a:Person {name: 'Kiefer Sutherland'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Lt. Jonathan Kendrick']}]->(b); |
|
MATCH (a:Person {name: 'Noah Wyle'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Cpl. Jeffrey Barnes']}]->(b); |
|
MATCH (a:Person {name: 'Cuba Gooding Jr.'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Cpl. Carl Hammaker']}]->(b); |
|
MATCH (a:Person {name: 'Kevin Pollak'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Lt. Sam Weinberg']}]->(b); |
|
MATCH (a:Person {name: 'J.T. Walsh'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Lt. Col. Matthew Andrew Markinson']}]->(b); |
|
MATCH (a:Person {name: 'James Marshall'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Pfc. Louden Downey']}]->(b); |
|
MATCH (a:Person {name: 'Christopher Guest'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Dr. Stone']}]->(b); |
|
MATCH (a:Person {name: 'Aaron Sorkin'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:ACTED_IN {roles:['Man in Bar']}]->(b); |
|
MATCH (a:Person {name: 'Rob Reiner'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Aaron Sorkin'}) MATCH (b:Movie {title: 'A Few Good Men'}) MERGE (a)-[:WROTE]->(b); |
|
|
|
// Top Gun relationships |
|
MATCH (a:Person {name: 'Tom Cruise'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:ACTED_IN {roles:['Maverick']}]->(b); |
|
MATCH (a:Person {name: 'Kelly McGillis'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:ACTED_IN {roles:['Charlie']}]->(b); |
|
MATCH (a:Person {name: 'Val Kilmer'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:ACTED_IN {roles:['Iceman']}]->(b); |
|
MATCH (a:Person {name: 'Anthony Edwards'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:ACTED_IN {roles:['Goose']}]->(b); |
|
MATCH (a:Person {name: 'Tom Skerritt'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:ACTED_IN {roles:['Viper']}]->(b); |
|
MATCH (a:Person {name: 'Meg Ryan'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:ACTED_IN {roles:['Carole']}]->(b); |
|
MATCH (a:Person {name: 'Tony Scott'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Jim Cash'}) MATCH (b:Movie {title: 'Top Gun'}) MERGE (a)-[:WROTE]->(b); |
|
|
|
// Jerry Maguire relationships |
|
MATCH (a:Person {name: 'Tom Cruise'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Jerry Maguire']}]->(b); |
|
MATCH (a:Person {name: 'Cuba Gooding Jr.'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Rod Tidwell']}]->(b); |
|
MATCH (a:Person {name: 'Renee Zellweger'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Dorothy Boyd']}]->(b); |
|
MATCH (a:Person {name: 'Kelly Preston'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Avery Bishop']}]->(b); |
|
MATCH (a:Person {name: 'Jerry O\'Connell'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Frank Cushman']}]->(b); |
|
MATCH (a:Person {name: 'Jay Mohr'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Bob Sugar']}]->(b); |
|
MATCH (a:Person {name: 'Bonnie Hunt'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Laurel Boyd']}]->(b); |
|
MATCH (a:Person {name: 'Regina King'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Marcee Tidwell']}]->(b); |
|
MATCH (a:Person {name: 'Jonathan Lipnicki'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:ACTED_IN {roles:['Ray Boyd']}]->(b); |
|
MATCH (a:Person {name: 'Cameron Crowe'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Cameron Crowe'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Cameron Crowe'}) MATCH (b:Movie {title: 'Jerry Maguire'}) MERGE (a)-[:WROTE]->(b); |
|
|
|
// Stand By Me relationships |
|
MATCH (a:Person {name: 'Wil Wheaton'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:ACTED_IN {roles:['Gordie Lachance']}]->(b); |
|
MATCH (a:Person {name: 'River Phoenix'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:ACTED_IN {roles:['Chris Chambers']}]->(b); |
|
MATCH (a:Person {name: 'Jerry O\'Connell'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:ACTED_IN {roles:['Vern Tessio']}]->(b); |
|
MATCH (a:Person {name: 'Corey Feldman'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:ACTED_IN {roles:['Teddy Duchamp']}]->(b); |
|
MATCH (a:Person {name: 'John Cusack'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:ACTED_IN {roles:['Denny Lachance']}]->(b); |
|
MATCH (a:Person {name: 'Kiefer Sutherland'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:ACTED_IN {roles:['Ace Merrill']}]->(b); |
|
MATCH (a:Person {name: 'Marshall Bell'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:ACTED_IN {roles:['Mr. Lachance']}]->(b); |
|
MATCH (a:Person {name: 'Rob Reiner'}) MATCH (b:Movie {title: 'Stand By Me'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Forrest Gump relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Forrest Gump'}) MERGE (a)-[:ACTED_IN {roles:['Forrest Gump']}]->(b); |
|
MATCH (a:Person {name: 'Robin Wright'}) MATCH (b:Movie {title: 'Forrest Gump'}) MERGE (a)-[:ACTED_IN {roles:['Jenny Curran']}]->(b); |
|
MATCH (a:Person {name: 'Gary Sinise'}) MATCH (b:Movie {title: 'Forrest Gump'}) MERGE (a)-[:ACTED_IN {roles:['Lt. Dan Taylor']}]->(b); |
|
MATCH (a:Person {name: 'Sally Field'}) MATCH (b:Movie {title: 'Forrest Gump'}) MERGE (a)-[:ACTED_IN {roles:['Mrs. Gump']}]->(b); |
|
MATCH (a:Person {name: 'Mykelti Williamson'}) MATCH (b:Movie {title: 'Forrest Gump'}) MERGE (a)-[:ACTED_IN {roles:['Bubba Blue']}]->(b); |
|
MATCH (a:Person {name: 'Michael Conner Humphreys'}) MATCH (b:Movie {title: 'Forrest Gump'}) MERGE (a)-[:ACTED_IN {roles:['Young Forrest']}]->(b); |
|
MATCH (a:Person {name: 'Robert Zemeckis'}) MATCH (b:Movie {title: 'Forrest Gump'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Cast Away relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Cast Away'}) MERGE (a)-[:ACTED_IN {roles:['Chuck Noland']}]->(b); |
|
MATCH (a:Person {name: 'Helen Hunt'}) MATCH (b:Movie {title: 'Cast Away'}) MERGE (a)-[:ACTED_IN {roles:['Kelly Frears']}]->(b); |
|
MATCH (a:Person {name: 'Robert Zemeckis'}) MATCH (b:Movie {title: 'Cast Away'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Apollo 13 relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Apollo 13'}) MERGE (a)-[:ACTED_IN {roles:['Jim Lovell']}]->(b); |
|
MATCH (a:Person {name: 'Kevin Bacon'}) MATCH (b:Movie {title: 'Apollo 13'}) MERGE (a)-[:ACTED_IN {roles:['Jack Swigert']}]->(b); |
|
MATCH (a:Person {name: 'Ed Harris'}) MATCH (b:Movie {title: 'Apollo 13'}) MERGE (a)-[:ACTED_IN {roles:['Gene Kranz']}]->(b); |
|
MATCH (a:Person {name: 'Bill Paxton'}) MATCH (b:Movie {title: 'Apollo 13'}) MERGE (a)-[:ACTED_IN {roles:['Fred Haise']}]->(b); |
|
MATCH (a:Person {name: 'Gary Sinise'}) MATCH (b:Movie {title: 'Apollo 13'}) MERGE (a)-[:ACTED_IN {roles:['Ken Mattingly']}]->(b); |
|
MATCH (a:Person {name: 'Ron Howard'}) MATCH (b:Movie {title: 'Apollo 13'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// The Green Mile relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['Paul Edgecomb']}]->(b); |
|
MATCH (a:Person {name: 'Michael Clarke Duncan'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['John Coffey']}]->(b); |
|
MATCH (a:Person {name: 'David Morse'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['Brutus "Brutal" Howell']}]->(b); |
|
MATCH (a:Person {name: 'Bonnie Hunt'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['Jan Edgecomb']}]->(b); |
|
MATCH (a:Person {name: 'James Cromwell'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['Warden Hal Moores']}]->(b); |
|
MATCH (a:Person {name: 'Sam Rockwell'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['"Wild Bill" Wharton']}]->(b); |
|
MATCH (a:Person {name: 'Gary Sinise'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['Burt Hammersmith']}]->(b); |
|
MATCH (a:Person {name: 'Patricia Clarkson'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:ACTED_IN {roles:['Melinda Moores']}]->(b); |
|
MATCH (a:Person {name: 'Frank Darabont'}) MATCH (b:Movie {title: 'The Green Mile'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Saving Private Ryan relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:ACTED_IN {roles:['Captain John H. Miller']}]->(b); |
|
MATCH (a:Person {name: 'Matt Damon'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:ACTED_IN {roles:['Private James Francis Ryan']}]->(b); |
|
MATCH (a:Person {name: 'Tom Sizemore'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:ACTED_IN {roles:['Sergeant Mike Horvath']}]->(b); |
|
MATCH (a:Person {name: 'Edward Burns'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:ACTED_IN {roles:['Private Richard Reiben']}]->(b); |
|
MATCH (a:Person {name: 'Barry Pepper'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:ACTED_IN {roles:['Private Daniel Jackson']}]->(b); |
|
MATCH (a:Person {name: 'Adam Goldberg'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:ACTED_IN {roles:['Private Stanley Mellish']}]->(b); |
|
MATCH (a:Person {name: 'Vin Diesel'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:ACTED_IN {roles:['Private Adrian Caparzo']}]->(b); |
|
MATCH (a:Person {name: 'Steven Spielberg'}) MATCH (b:Movie {title: 'Saving Private Ryan'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// You've Got Mail relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'You\'ve Got Mail'}) MERGE (a)-[:ACTED_IN {roles:['Joe Fox']}]->(b); |
|
MATCH (a:Person {name: 'Meg Ryan'}) MATCH (b:Movie {title: 'You\'ve Got Mail'}) MERGE (a)-[:ACTED_IN {roles:['Kathleen Kelly']}]->(b); |
|
MATCH (a:Person {name: 'Greg Kinnear'}) MATCH (b:Movie {title: 'You\'ve Got Mail'}) MERGE (a)-[:ACTED_IN {roles:['Frank Navasky']}]->(b); |
|
MATCH (a:Person {name: 'Parker Posey'}) MATCH (b:Movie {title: 'You\'ve Got Mail'}) MERGE (a)-[:ACTED_IN {roles:['Patricia Eden']}]->(b); |
|
MATCH (a:Person {name: 'Dave Chappelle'}) MATCH (b:Movie {title: 'You\'ve Got Mail'}) MERGE (a)-[:ACTED_IN {roles:['Kevin Jackson']}]->(b); |
|
MATCH (a:Person {name: 'Steve Zahn'}) MATCH (b:Movie {title: 'You\'ve Got Mail'}) MERGE (a)-[:ACTED_IN {roles:['George Pappas']}]->(b); |
|
MATCH (a:Person {name: 'Nora Ephron'}) MATCH (b:Movie {title: 'You\'ve Got Mail'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Sleepless in Seattle relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Sleepless in Seattle'}) MERGE (a)-[:ACTED_IN {roles:['Sam Baldwin']}]->(b); |
|
MATCH (a:Person {name: 'Meg Ryan'}) MATCH (b:Movie {title: 'Sleepless in Seattle'}) MERGE (a)-[:ACTED_IN {roles:['Annie Reed']}]->(b); |
|
MATCH (a:Person {name: 'Rita Wilson'}) MATCH (b:Movie {title: 'Sleepless in Seattle'}) MERGE (a)-[:ACTED_IN {roles:['Suzy']}]->(b); |
|
MATCH (a:Person {name: 'Bill Pullman'}) MATCH (b:Movie {title: 'Sleepless in Seattle'}) MERGE (a)-[:ACTED_IN {roles:['Walter']}]->(b); |
|
MATCH (a:Person {name: 'Victor Garber'}) MATCH (b:Movie {title: 'Sleepless in Seattle'}) MERGE (a)-[:ACTED_IN {roles:['Greg']}]->(b); |
|
MATCH (a:Person {name: 'Rosie O\'Donnell'}) MATCH (b:Movie {title: 'Sleepless in Seattle'}) MERGE (a)-[:ACTED_IN {roles:['Becky']}]->(b); |
|
MATCH (a:Person {name: 'Nora Ephron'}) MATCH (b:Movie {title: 'Sleepless in Seattle'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Philadelphia relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Philadelphia'}) MERGE (a)-[:ACTED_IN {roles:['Andrew Beckett']}]->(b); |
|
MATCH (a:Person {name: 'Denzel Washington'}) MATCH (b:Movie {title: 'Philadelphia'}) MERGE (a)-[:ACTED_IN {roles:['Joe Miller']}]->(b); |
|
MATCH (a:Person {name: 'Antonio Banderas'}) MATCH (b:Movie {title: 'Philadelphia'}) MERGE (a)-[:ACTED_IN {roles:['Miguel Alvarez']}]->(b); |
|
MATCH (a:Person {name: 'Jonathan Demme'}) MATCH (b:Movie {title: 'Philadelphia'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// When Harry Met Sally relationships |
|
MATCH (a:Person {name: 'Billy Crystal'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:ACTED_IN {roles:['Harry Burns']}]->(b); |
|
MATCH (a:Person {name: 'Meg Ryan'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:ACTED_IN {roles:['Sally Albright']}]->(b); |
|
MATCH (a:Person {name: 'Carrie Fisher'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:ACTED_IN {roles:['Marie']}]->(b); |
|
MATCH (a:Person {name: 'Bruno Kirby'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:ACTED_IN {roles:['Jess']}]->(b); |
|
MATCH (a:Person {name: 'Rob Reiner'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Rob Reiner'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Nora Ephron'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Nora Ephron'}) MATCH (b:Movie {title: 'When Harry Met Sally'}) MERGE (a)-[:WROTE]->(b); |
|
|
|
// As Good as It Gets relationships |
|
MATCH (a:Person {name: 'Jack Nicholson'}) MATCH (b:Movie {title: 'As Good as It Gets'}) MERGE (a)-[:ACTED_IN {roles:['Melvin Udall']}]->(b); |
|
MATCH (a:Person {name: 'Helen Hunt'}) MATCH (b:Movie {title: 'As Good as It Gets'}) MERGE (a)-[:ACTED_IN {roles:['Carol Connelly']}]->(b); |
|
MATCH (a:Person {name: 'Greg Kinnear'}) MATCH (b:Movie {title: 'As Good as It Gets'}) MERGE (a)-[:ACTED_IN {roles:['Simon Bishop']}]->(b); |
|
MATCH (a:Person {name: 'Cuba Gooding Jr.'}) MATCH (b:Movie {title: 'As Good as It Gets'}) MERGE (a)-[:ACTED_IN {roles:['Frank Sachs']}]->(b); |
|
MATCH (a:Person {name: 'James L. Brooks'}) MATCH (b:Movie {title: 'As Good as It Gets'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// What Dreams May Come relationships |
|
MATCH (a:Person {name: 'Robin Williams'}) MATCH (b:Movie {title: 'What Dreams May Come'}) MERGE (a)-[:ACTED_IN {roles:['Chris Nielsen']}]->(b); |
|
MATCH (a:Person {name: 'Cuba Gooding Jr.'}) MATCH (b:Movie {title: 'What Dreams May Come'}) MERGE (a)-[:ACTED_IN {roles:['Albert Lewis']}]->(b); |
|
MATCH (a:Person {name: 'Annabella Sciorra'}) MATCH (b:Movie {title: 'What Dreams May Come'}) MERGE (a)-[:ACTED_IN {roles:['Annie Collins-Nielsen']}]->(b); |
|
MATCH (a:Person {name: 'Max von Sydow'}) MATCH (b:Movie {title: 'What Dreams May Come'}) MERGE (a)-[:ACTED_IN {roles:['The Tracker']}]->(b); |
|
MATCH (a:Person {name: 'Werner Herzog'}) MATCH (b:Movie {title: 'What Dreams May Come'}) MERGE (a)-[:ACTED_IN {roles:['The Face']}]->(b); |
|
MATCH (a:Person {name: 'Vincent Ward'}) MATCH (b:Movie {title: 'What Dreams May Come'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Snow Falling on Cedars relationships |
|
MATCH (a:Person {name: 'Ethan Hawke'}) MATCH (b:Movie {title: 'Snow Falling on Cedars'}) MERGE (a)-[:ACTED_IN {roles:['Ishmael Chambers']}]->(b); |
|
MATCH (a:Person {name: 'Rick Yune'}) MATCH (b:Movie {title: 'Snow Falling on Cedars'}) MERGE (a)-[:ACTED_IN {roles:['Kazuo Miyamoto']}]->(b); |
|
MATCH (a:Person {name: 'Max von Sydow'}) MATCH (b:Movie {title: 'Snow Falling on Cedars'}) MERGE (a)-[:ACTED_IN {roles:['Nels Gudmundsson']}]->(b); |
|
MATCH (a:Person {name: 'James Cromwell'}) MATCH (b:Movie {title: 'Snow Falling on Cedars'}) MERGE (a)-[:ACTED_IN {roles:['Judge Fielding']}]->(b); |
|
MATCH (a:Person {name: 'Scott Hicks'}) MATCH (b:Movie {title: 'Snow Falling on Cedars'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Johnny Mnemonic relationships |
|
MATCH (a:Person {name: 'Keanu Reeves'}) MATCH (b:Movie {title: 'Johnny Mnemonic'}) MERGE (a)-[:ACTED_IN {roles:['Johnny Mnemonic']}]->(b); |
|
MATCH (a:Person {name: 'Takeshi Kitano'}) MATCH (b:Movie {title: 'Johnny Mnemonic'}) MERGE (a)-[:ACTED_IN {roles:['Takahashi']}]->(b); |
|
MATCH (a:Person {name: 'Dina Meyer'}) MATCH (b:Movie {title: 'Johnny Mnemonic'}) MERGE (a)-[:ACTED_IN {roles:['Jane']}]->(b); |
|
MATCH (a:Person {name: 'Ice-T'}) MATCH (b:Movie {title: 'Johnny Mnemonic'}) MERGE (a)-[:ACTED_IN {roles:['J-Bone']}]->(b); |
|
MATCH (a:Person {name: 'Robert Longo'}) MATCH (b:Movie {title: 'Johnny Mnemonic'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// The Replacements relationships |
|
MATCH (a:Person {name: 'Keanu Reeves'}) MATCH (b:Movie {title: 'The Replacements'}) MERGE (a)-[:ACTED_IN {roles:['Shane Falco']}]->(b); |
|
MATCH (a:Person {name: 'Brooke Langton'}) MATCH (b:Movie {title: 'The Replacements'}) MERGE (a)-[:ACTED_IN {roles:['Annabelle Farrell']}]->(b); |
|
MATCH (a:Person {name: 'Gene Hackman'}) MATCH (b:Movie {title: 'The Replacements'}) MERGE (a)-[:ACTED_IN {roles:['Jimmy McGinty']}]->(b); |
|
MATCH (a:Person {name: 'Orlando Jones'}) MATCH (b:Movie {title: 'The Replacements'}) MERGE (a)-[:ACTED_IN {roles:['Clifford Franklin']}]->(b); |
|
MATCH (a:Person {name: 'Howard Deutch'}) MATCH (b:Movie {title: 'The Replacements'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Something's Gotta Give relationships |
|
MATCH (a:Person {name: 'Jack Nicholson'}) MATCH (b:Movie {title: 'Something\'s Gotta Give'}) MERGE (a)-[:ACTED_IN {roles:['Harry Sanborn']}]->(b); |
|
MATCH (a:Person {name: 'Diane Keaton'}) MATCH (b:Movie {title: 'Something\'s Gotta Give'}) MERGE (a)-[:ACTED_IN {roles:['Erica Barry']}]->(b); |
|
MATCH (a:Person {name: 'Keanu Reeves'}) MATCH (b:Movie {title: 'Something\'s Gotta Give'}) MERGE (a)-[:ACTED_IN {roles:['Julian Mercer']}]->(b); |
|
MATCH (a:Person {name: 'Nancy Meyers'}) MATCH (b:Movie {title: 'Something\'s Gotta Give'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Nancy Meyers'}) MATCH (b:Movie {title: 'Something\'s Gotta Give'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Nancy Meyers'}) MATCH (b:Movie {title: 'Something\'s Gotta Give'}) MERGE (a)-[:WROTE]->(b); |
|
|
|
// Cloud Atlas relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:ACTED_IN {roles:['Zachry', 'Dr. Henry Goose', 'Isaac Sachs', 'Dermot Hoggins']}]->(b); |
|
MATCH (a:Person {name: 'Hugo Weaving'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:ACTED_IN {roles:['Bill Smoke', 'Haskell Moore', 'Tadeusz Kesselring', 'Nurse Noakes', 'Boardman Mephi', 'Old Georgie']}]->(b); |
|
MATCH (a:Person {name: 'Halle Berry'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:ACTED_IN {roles:['Luisa Rey', 'Jocasta Ayrs', 'Ovid', 'Meronym']}]->(b); |
|
MATCH (a:Person {name: 'Jim Broadbent'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:ACTED_IN {roles:['Vyvyan Ayrs', 'Captain Molyneux', 'Timothy Cavendish']}]->(b); |
|
MATCH (a:Person {name: 'Tom Tykwer'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'David Mitchell'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:WROTE]->(b); |
|
MATCH (a:Person {name: 'Stefan Arndt'}) MATCH (b:Movie {title: 'Cloud Atlas'}) MERGE (a)-[:PRODUCED]->(b); |
|
|
|
// The Da Vinci Code relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'The Da Vinci Code'}) MERGE (a)-[:ACTED_IN {roles:['Dr. Robert Langdon']}]->(b); |
|
MATCH (a:Person {name: 'Ian McKellen'}) MATCH (b:Movie {title: 'The Da Vinci Code'}) MERGE (a)-[:ACTED_IN {roles:['Sir Leight Teabing']}]->(b); |
|
MATCH (a:Person {name: 'Audrey Tautou'}) MATCH (b:Movie {title: 'The Da Vinci Code'}) MERGE (a)-[:ACTED_IN {roles:['Sophie Neveu']}]->(b); |
|
MATCH (a:Person {name: 'Paul Bettany'}) MATCH (b:Movie {title: 'The Da Vinci Code'}) MERGE (a)-[:ACTED_IN {roles:['Silas']}]->(b); |
|
MATCH (a:Person {name: 'Ron Howard'}) MATCH (b:Movie {title: 'The Da Vinci Code'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// V for Vendetta relationships |
|
MATCH (a:Person {name: 'Hugo Weaving'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:ACTED_IN {roles:['V']}]->(b); |
|
MATCH (a:Person {name: 'Natalie Portman'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:ACTED_IN {roles:['Evey Hammond']}]->(b); |
|
MATCH (a:Person {name: 'Stephen Rea'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:ACTED_IN {roles:['Eric Finch']}]->(b); |
|
MATCH (a:Person {name: 'John Hurt'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:ACTED_IN {roles:['High Chancellor Adam Sutler']}]->(b); |
|
MATCH (a:Person {name: 'Ben Miles'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:ACTED_IN {roles:['Dascomb']}]->(b); |
|
MATCH (a:Person {name: 'James Marshall'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Joel Silver'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:WROTE]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'V for Vendetta'}) MERGE (a)-[:WROTE]->(b); |
|
|
|
// Speed Racer relationships |
|
MATCH (a:Person {name: 'Emile Hirsch'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:ACTED_IN {roles:['Speed Racer']}]->(b); |
|
MATCH (a:Person {name: 'John Goodman'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:ACTED_IN {roles:['Pops']}]->(b); |
|
MATCH (a:Person {name: 'Susan Sarandon'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:ACTED_IN {roles:['Mom']}]->(b); |
|
MATCH (a:Person {name: 'Matthew Fox'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:ACTED_IN {roles:['Racer X']}]->(b); |
|
MATCH (a:Person {name: 'Christina Ricci'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:ACTED_IN {roles:['Trixie']}]->(b); |
|
MATCH (a:Person {name: 'Rain'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:ACTED_IN {roles:['Taejo Togokahn']}]->(b); |
|
MATCH (a:Person {name: 'Ben Miles'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:ACTED_IN {roles:['Cass Jones']}]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:WROTE]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:WROTE]->(b); |
|
MATCH (a:Person {name: 'Joel Silver'}) MATCH (b:Movie {title: 'Speed Racer'}) MERGE (a)-[:PRODUCED]->(b); |
|
|
|
// Ninja Assassin relationships |
|
MATCH (a:Person {name: 'Rain'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:ACTED_IN {roles:['Raizo']}]->(b); |
|
MATCH (a:Person {name: 'Naomie Harris'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:ACTED_IN {roles:['Mika Coretti']}]->(b); |
|
MATCH (a:Person {name: 'Rick Yune'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:ACTED_IN {roles:['Takeshi']}]->(b); |
|
MATCH (a:Person {name: 'Ben Miles'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:ACTED_IN {roles:['Ryan Maslow']}]->(b); |
|
MATCH (a:Person {name: 'James Marshall'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:DIRECTED]->(b); |
|
MATCH (a:Person {name: 'Lilly Wachowski'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Lana Wachowski'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:PRODUCED]->(b); |
|
MATCH (a:Person {name: 'Joel Silver'}) MATCH (b:Movie {title: 'Ninja Assassin'}) MERGE (a)-[:PRODUCED]->(b); |
|
|
|
// Toy Story relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Toy Story'}) MERGE (a)-[:ACTED_IN {roles:['Woody']}]->(b); |
|
MATCH (a:Person {name: 'Tim Allen'}) MATCH (b:Movie {title: 'Toy Story'}) MERGE (a)-[:ACTED_IN {roles:['Buzz Lightyear']}]->(b); |
|
MATCH (a:Person {name: 'Don Rickles'}) MATCH (b:Movie {title: 'Toy Story'}) MERGE (a)-[:ACTED_IN {roles:['Mr. Potato Head']}]->(b); |
|
MATCH (a:Person {name: 'John Lasseter'}) MATCH (b:Movie {title: 'Toy Story'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Toy Story 2 relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Toy Story 2'}) MERGE (a)-[:ACTED_IN {roles:['Woody']}]->(b); |
|
MATCH (a:Person {name: 'Tim Allen'}) MATCH (b:Movie {title: 'Toy Story 2'}) MERGE (a)-[:ACTED_IN {roles:['Buzz Lightyear']}]->(b); |
|
MATCH (a:Person {name: 'John Lasseter'}) MATCH (b:Movie {title: 'Toy Story 2'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Splash relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Splash'}) MERGE (a)-[:ACTED_IN {roles:['Allen Bauer']}]->(b); |
|
MATCH (a:Person {name: 'Daryl Hannah'}) MATCH (b:Movie {title: 'Splash'}) MERGE (a)-[:ACTED_IN {roles:['Madison']}]->(b); |
|
MATCH (a:Person {name: 'John Candy'}) MATCH (b:Movie {title: 'Splash'}) MERGE (a)-[:ACTED_IN {roles:['Freddie Bauer']}]->(b); |
|
MATCH (a:Person {name: 'Eugene Levy'}) MATCH (b:Movie {title: 'Splash'}) MERGE (a)-[:ACTED_IN {roles:['Dr. Walter Kornbluth']}]->(b); |
|
MATCH (a:Person {name: 'Ron Howard'}) MATCH (b:Movie {title: 'Splash'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Joe Versus the Volcano relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Joe Versus the Volcano'}) MERGE (a)-[:ACTED_IN {roles:['Joe Banks']}]->(b); |
|
MATCH (a:Person {name: 'Meg Ryan'}) MATCH (b:Movie {title: 'Joe Versus the Volcano'}) MERGE (a)-[:ACTED_IN {roles:['DeDe', 'Angelica Graynamore', 'Patricia Graynamore']}]->(b); |
|
MATCH (a:Person {name: 'John Patrick Stanley'}) MATCH (b:Movie {title: 'Joe Versus the Volcano'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Big relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Big'}) MERGE (a)-[:ACTED_IN {roles:['Josh Baskin']}]->(b); |
|
MATCH (a:Person {name: 'Elizabeth Perkins'}) MATCH (b:Movie {title: 'Big'}) MERGE (a)-[:ACTED_IN {roles:['Susan Lawrence']}]->(b); |
|
MATCH (a:Person {name: 'Robert Loggia'}) MATCH (b:Movie {title: 'Big'}) MERGE (a)-[:ACTED_IN {roles:['MacMillan']}]->(b); |
|
MATCH (a:Person {name: 'Penny Marshall'}) MATCH (b:Movie {title: 'Big'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Catch Me If You Can relationships |
|
MATCH (a:Person {name: 'Leonardo DiCaprio'}) MATCH (b:Movie {title: 'Catch Me If You Can'}) MERGE (a)-[:ACTED_IN {roles:['Frank Abagnale Jr.']}]->(b); |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'Catch Me If You Can'}) MERGE (a)-[:ACTED_IN {roles:['Carl Hanratty']}]->(b); |
|
MATCH (a:Person {name: 'Christopher Walken'}) MATCH (b:Movie {title: 'Catch Me If You Can'}) MERGE (a)-[:ACTED_IN {roles:['Frank Abagnale Senior']}]->(b); |
|
MATCH (a:Person {name: 'Amy Adams'}) MATCH (b:Movie {title: 'Catch Me If You Can'}) MERGE (a)-[:ACTED_IN {roles:['Brenda Strong']}]->(b); |
|
MATCH (a:Person {name: 'Steven Spielberg'}) MATCH (b:Movie {title: 'Catch Me If You Can'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// The Terminal relationships |
|
MATCH (a:Person {name: 'Tom Hanks'}) MATCH (b:Movie {title: 'The Terminal'}) MERGE (a)-[:ACTED_IN {roles:['Viktor Navorski']}]->(b); |
|
MATCH (a:Person {name: 'Catherine Zeta-Jones'}) MATCH (b:Movie {title: 'The Terminal'}) MERGE (a)-[:ACTED_IN {roles:['Amelia Warren']}]->(b); |
|
MATCH (a:Person {name: 'Stanley Tucci'}) MATCH (b:Movie {title: 'The Terminal'}) MERGE (a)-[:ACTED_IN {roles:['Frank Dixon']}]->(b); |
|
MATCH (a:Person {name: 'Steven Spielberg'}) MATCH (b:Movie {title: 'The Terminal'}) MERGE (a)-[:DIRECTED]->(b); |
|
|
|
// Dataset complete - all relationships use individual MERGE statements |
|
// This pattern ensures proper node creation and cross-linking without gray nodes |