Skip to content

Instantly share code, notes, and snippets.

@peterneubauer

peterneubauer/Cineasts.cql

Last active October 12, 2015 19:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save peterneubauer/4077922 to your computer and use it in GitHub Desktop.
Save peterneubauer/4077922 to your computer and use it in GitHub Desktop.
Download ZIP
Cineasts Cypher script
Raw
Cineasts.cql
begin
start root=node(0)
create unique
root-[:GENRES]->({type:'GENRES'}),
root-[:MOVIES]->({type:'MOVIES'}),
root-[:PEOPLE]->({type:'PEOPLE'});
{:actors=>[{:role=>"Jake Sully", :name=>"Sam Worthington", :id=>65731}, {:role=>"Neytiri", :name=>"Zoe Saldana", :id=>8691}, {:role=>"Dr. Grace Augustine", :name=>"Sigourney Weaver", :id=>10205}, {:role=>"Col. Quaritch", :name=>"Stephen Lang", :id=>32747}, {:role=>"Trudy Chacon", :name=>"Michelle Rodriguez", :id=>17647}, {:role=>"Norm Spellman", :name=>"Joel Moore", :id=>59231}, {:role=>"Selfridge", :name=>"Giovanni Ribisi", :id=>1771}, {:role=>"Moha", :name=>"CCH Pounder", :id=>30485}, {:role=>"TsuTey", :name=>"Laz Alonso", :id=>10964}, {:role=>"Eytukan", :name=>"Wes Studi", :id=>15853}, {:role=>"Dr. Max Patel", :name=>"Dileep Rao", :id=>95697}, {:role=>"Lyle Wainfleet", :name=>"Matt Gerald", :id=>98215}, {:role=>"Samson Pilot", :name=>"Dean Knowsley", :id=>98216}], :movie_id=>19995, :directors=>[{:name=>"James Cameron", :id=>2710}], :tagline=>"Enter the World of Pandora.", :title=>"Avatar", :released=>"2009-12-18", :genres=>["Action", "Adventure", "Fantasy", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '19995', title : 'Avatar', tagline : 'Enter the World of Pandora.', released : '2009-12-18'}
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Jake Sully'}]-({id : '65731', name: 'Sam Worthington'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Neytiri'}]-({id : '8691', name: 'Zoe Saldana'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Grace Augustine'}]-({id : '10205', name: 'Sigourney Weaver'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Col. Quaritch'}]-({id : '32747', name: 'Stephen Lang'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Trudy Chacon'}]-({id : '17647', name: 'Michelle Rodriguez'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Norm Spellman'}]-({id : '59231', name: 'Joel Moore'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Selfridge'}]-({id : '1771', name: 'Giovanni Ribisi'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Moha'}]-({id : '30485', name: 'CCH Pounder'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'TsuTey'}]-({id : '10964', name: 'Laz Alonso'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Eytukan'}]-({id : '15853', name: 'Wes Studi'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Max Patel'}]-({id : '95697', name: 'Dileep Rao'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lyle Wainfleet'}]-({id : '98215', name: 'Matt Gerald'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Samson Pilot'}]-({id : '98216', name: 'Dean Knowsley'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '2710', name: 'James Cameron'})-[:PERSON]->people
;
{:actors=>[{:role=>"Am\303\251lie Poulain", :name=>"Audrey Tautou", :id=>2405}, {:role=>"Rapha\303\253l Poulain", :name=>"Rufus", :id=>2407}, {:role=>"Lucien", :name=>"Jamel Debbouze", :id=>2408}, {:role=>"Suzanne", :name=>"Claire Maurier", :id=>1654}, {:role=>"Georgette", :name=>"Isabelle Nanty", :id=>2412}, {:role=>"Joseph", :name=>"Dominique Pinon", :id=>2413}, {:role=>"Hipolito", :name=>"Artus de Penguern", :id=>2414}, {:role=>"Madeleine Wallace", :name=>"Yolande Moreau", :id=>2415}, {:role=>"Amandine Poulain", :name=>"Lorella Cravotta", :id=>2409}, {:role=>"Raymond Dufayel", :name=>"Serge Merlin", :id=>2410}, {:role=>"Gina", :name=>"Clotilde Mollet", :id=>2411}, {:role=>"Mr. Collignon", :name=>"Urbain Cancelier", :id=>2416}, {:role=>"Dominique Bretodeau", :name=>"Maurice B\303\251nichou", :id=>2417}, {:role=>"Nino Quincampoix", :name=>"Mathieu Kassovitz", :id=>2406}], :movie_id=>194, :directors=>[{:name=>"Jean-Pierre Jeunet", :id=>2419}], :tagline=>"One person can change your life forever.", :title=>"Am\303\251lie", :released=>"2001-11-02", :genres=>["Fantasy", "Drama", "Comedy", "Romance", "Foreign"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '194', title : 'Amélie', tagline : 'One person can change your life forever.', released : '2001-11-02'}
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Romance'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Foreign'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Amélie Poulain'}]-({id : '2405', name: 'Audrey Tautou'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Raphaël Poulain'}]-({id : '2407', name: 'Rufus'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lucien'}]-({id : '2408', name: 'Jamel Debbouze'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Suzanne'}]-({id : '1654', name: 'Claire Maurier'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Georgette'}]-({id : '2412', name: 'Isabelle Nanty'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Joseph'}]-({id : '2413', name: 'Dominique Pinon'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Hipolito'}]-({id : '2414', name: 'Artus de Penguern'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Madeleine Wallace'}]-({id : '2415', name: 'Yolande Moreau'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Amandine Poulain'}]-({id : '2409', name: 'Lorella Cravotta'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Raymond Dufayel'}]-({id : '2410', name: 'Serge Merlin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gina'}]-({id : '2411', name: 'Clotilde Mollet'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mr. Collignon'}]-({id : '2416', name: 'Urbain Cancelier'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dominique Bretodeau'}]-({id : '2417', name: 'Maurice Bénichou'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Nino Quincampoix'}]-({id : '2406', name: 'Mathieu Kassovitz'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '2419', name: 'Jean-Pierre Jeunet'})-[:PERSON]->people
;
{:actors=>[{:role=>"Pvt. Joker", :name=>"Matthew Modine", :id=>8654}, {:role=>"Animal Mother", :name=>"Adam Baldwin", :id=>2059}, {:role=>"Pvt. Pyle", :name=>"Vincent DOnofrio", :id=>7132}, {:role=>"Gny. Sgt. Hartman", :name=>"R. Lee Ermey", :id=>8655}, {:role=>"Eightball", :name=>"Dorian Harewood", :id=>8656}, {:role=>"Rafterman", :name=>"Kevyn Major Howard", :id=>8657}, {:role=>"Pvt. Cowboy", :name=>"Arliss Howard", :id=>3229}, {:role=>"Lt. Touchdown", :name=>"Ed ORoss", :id=>8658}, {:role=>"Lt. Lockhart", :name=>"John Terry", :id=>8659}, {:role=>"Crazy Earl", :name=>"Kieron Jecchinis", :id=>8660}, {:role=>"Payback", :name=>"Kirk Taylor", :id=>8661}, {:role=>"Doorgunner", :name=>"Tim Colceri", :id=>8662}, {:role=>"Doc Jay", :name=>"Jon Stafford", :id=>8663}, {:role=>"Poge Colonel", :name=>"Bruce Boa", :id=>8664}, {:role=>"Lt. Cleves", :name=>"Ian Tyler", :id=>8665}, {:role=>"T.H.E. Rock", :name=>"Sal Lopez", :id=>8666}, {:role=>"Donlon", :name=>"Gary Landon Mills", :id=>8667}, {:role=>"Da Nang Hooker", :name=>"Papillon Soo", :id=>8668}, {:role=>"Snowball", :name=>"Peter Edmund", :id=>8669}, {:role=>"VC Sniper", :name=>"Ngoc Le", :id=>8670}, {:role=>"ARVN Pimp", :name=>"Tan Hung Francione", :id=>8671}, {:role=>"Chili", :name=>"Costas Dino Chimona", :id=>8672}], :movie_id=>600, :directors=>[{:name=>"Stanley Kubrick", :id=>240}], :tagline=>"Vietnam can kill me, but it can\342\200\231t make me care.", :title=>"Full Metal Jacket", :released=>"1987-06-01", :genres=>["Drama", "History", "War", "Foreign"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '600', title : 'Full Metal Jacket', tagline : 'Vietnam can kill me, but it can’t make me care.', released : '1987-06-01'}
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'History'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'War'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Foreign'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Pvt. Joker'}]-({id : '8654', name: 'Matthew Modine'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Animal Mother'}]-({id : '2059', name: 'Adam Baldwin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pvt. Pyle'}]-({id : '7132', name: 'Vincent DOnofrio'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gny. Sgt. Hartman'}]-({id : '8655', name: 'R. Lee Ermey'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Eightball'}]-({id : '8656', name: 'Dorian Harewood'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Rafterman'}]-({id : '8657', name: 'Kevyn Major Howard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pvt. Cowboy'}]-({id : '3229', name: 'Arliss Howard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Touchdown'}]-({id : '8658', name: 'Ed ORoss'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Lockhart'}]-({id : '8659', name: 'John Terry'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Crazy Earl'}]-({id : '8660', name: 'Kieron Jecchinis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Payback'}]-({id : '8661', name: 'Kirk Taylor'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Doorgunner'}]-({id : '8662', name: 'Tim Colceri'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Doc Jay'}]-({id : '8663', name: 'Jon Stafford'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Poge Colonel'}]-({id : '8664', name: 'Bruce Boa'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Cleves'}]-({id : '8665', name: 'Ian Tyler'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'T.H.E. Rock'}]-({id : '8666', name: 'Sal Lopez'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Donlon'}]-({id : '8667', name: 'Gary Landon Mills'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Da Nang Hooker'}]-({id : '8668', name: 'Papillon Soo'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Snowball'}]-({id : '8669', name: 'Peter Edmund'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'VC Sniper'}]-({id : '8670', name: 'Ngoc Le'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'ARVN Pimp'}]-({id : '8671', name: 'Tan Hung Francione'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Chili'}]-({id : '8672', name: 'Costas Dino Chimona'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '240', name: 'Stanley Kubrick'})-[:PERSON]->people
;
{:actors=>[{:role=>"Elliott", :name=>"Henry Thomas", :id=>9976}, {:role=>"Keys", :name=>"Peter Coyote", :id=>9979}, {:role=>"Gertie", :name=>"Drew Barrymore", :id=>69597}, {:role=>"Pretty Girl", :name=>"Erika Eleniak", :id=>23764}, {:role=>"Tyler", :name=>"C. Thomas Howell", :id=>2878}, {:role=>"Steve", :name=>"Sean Frye", :id=>9981}, {:role=>"Michael", :name=>"Robert MacNaughton", :id=>9978}, {:role=>"Schoolboy", :name=>"David M. ODell", :id=>9982}, {:role=>"Greg", :name=>"K.C. Martel", :id=>9980}, {:role=>"Science Teacher", :name=>"Richard Swingler", :id=>9983}, {:role=>"Policeman", :name=>"Frank Toth", :id=>9984}, {:role=>"E.T. (voice)", :name=>"Pat Welsh", :id=>9985}, {:role=>"Mary", :name=>"Dee Wallace", :id=>101763}], :movie_id=>601, :directors=>[{:name=>"Steven Spielberg", :id=>488}], :tagline=>"He is afraid. He is alone. He is three million light years from home.", :title=>"E.T. the Extra-Terrestrial", :released=>"1982-06-11", :genres=>["Drama", "Family", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '601', title : 'E.T. the Extra-Terrestrial', tagline : 'He is afraid. He is alone. He is three million light years from home.', released : '1982-06-11'}
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Elliott'}]-({id : '9976', name: 'Henry Thomas'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Keys'}]-({id : '9979', name: 'Peter Coyote'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gertie'}]-({id : '69597', name: 'Drew Barrymore'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pretty Girl'}]-({id : '23764', name: 'Erika Eleniak'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tyler'}]-({id : '2878', name: 'C. Thomas Howell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Steve'}]-({id : '9981', name: 'Sean Frye'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Michael'}]-({id : '9978', name: 'Robert MacNaughton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Schoolboy'}]-({id : '9982', name: 'David M. ODell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Greg'}]-({id : '9980', name: 'K.C. Martel'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Science Teacher'}]-({id : '9983', name: 'Richard Swingler'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Policeman'}]-({id : '9984', name: 'Frank Toth'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'E.T. (voice)'}]-({id : '9985', name: 'Pat Welsh'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mary'}]-({id : '101763', name: 'Dee Wallace'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '488', name: 'Steven Spielberg'})-[:PERSON]->people
;
{:actors=>[{:role=>"Captain Steven Hiller", :name=>"Will Smith", :id=>2888}, {:role=>"President Thomas J. Whitmore", :name=>"Bill Pullman", :id=>8984}, {:role=>"David Levinson", :name=>"Jeff Goldblum", :id=>4785}, {:role=>"First Lady Marilyn Whitmore", :name=>"Mary McDonnell", :id=>1581}, {:role=>"Julius Levinson", :name=>"Judd Hirsch", :id=>6167}, {:role=>"General William Grey", :name=>"Robert Loggia", :id=>1162}, {:role=>"Russell Casse", :name=>"Randy Quaid", :id=>1811}, {:role=>"Constance Spano", :name=>"Margaret Colin", :id=>8985}, {:role=>"Jasmine Dubrow", :name=>"Vivica A. Fox", :id=>2535}, {:role=>"Albert Nimzicki", :name=>"James Rebhorn", :id=>8986}, {:role=>"Marty Gilbert", :name=>"Harvey Fierstein", :id=>7420}, {:role=>"Major Mitchell", :name=>"Adam Baldwin", :id=>2059}, {:role=>"Dr. Brackish Okun", :name=>"Brent Spiner", :id=>2389}, {:role=>"Miguel Casse", :name=>"James Duval", :id=>1582}, {:role=>"Alicia Casse", :name=>"Lisa Jakub", :id=>8987}, {:role=>"Troy Casse", :name=>"Giuseppe Andrews", :id=>4133}, {:role=>"Captain Jimmy Wilder", :name=>"Harry Connick Jr.", :id=>18688}], :movie_id=>602, :directors=>[{:name=>"Roland Emmerich", :id=>6046}], :tagline=>"Earth. Take a good look. It might be your last.", :title=>"Independence Day", :released=>"1996-07-03", :genres=>["Action", "Adventure", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '602', title : 'Independence Day', tagline : 'Earth. Take a good look. It might be your last.', released : '1996-07-03'}
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Captain Steven Hiller'}]-({id : '2888', name: 'Will Smith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'President Thomas J. Whitmore'}]-({id : '8984', name: 'Bill Pullman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'David Levinson'}]-({id : '4785', name: 'Jeff Goldblum'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'First Lady Marilyn Whitmore'}]-({id : '1581', name: 'Mary McDonnell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Julius Levinson'}]-({id : '6167', name: 'Judd Hirsch'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'General William Grey'}]-({id : '1162', name: 'Robert Loggia'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Russell Casse'}]-({id : '1811', name: 'Randy Quaid'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Constance Spano'}]-({id : '8985', name: 'Margaret Colin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jasmine Dubrow'}]-({id : '2535', name: 'Vivica A. Fox'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Albert Nimzicki'}]-({id : '8986', name: 'James Rebhorn'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Marty Gilbert'}]-({id : '7420', name: 'Harvey Fierstein'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Major Mitchell'}]-({id : '2059', name: 'Adam Baldwin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Brackish Okun'}]-({id : '2389', name: 'Brent Spiner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Miguel Casse'}]-({id : '1582', name: 'James Duval'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Alicia Casse'}]-({id : '8987', name: 'Lisa Jakub'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Troy Casse'}]-({id : '4133', name: 'Giuseppe Andrews'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Jimmy Wilder'}]-({id : '18688', name: 'Harry Connick Jr.'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '6046', name: 'Roland Emmerich'})-[:PERSON]->people
;
{:actors=>[{:role=>"Neo", :name=>"Keanu Reeves", :id=>6384}, {:role=>"Morpheus", :name=>"Laurence Fishburne", :id=>2975}, {:role=>"Trinity", :name=>"Carrie-Anne Moss", :id=>530}, {:role=>"Agent Smith", :name=>"Hugo Weaving", :id=>1331}, {:role=>"Cypher", :name=>"Joe Pantoliano", :id=>532}, {:role=>"Tank", :name=>"Marcus Chong", :id=>9372}, {:role=>"Oracle", :name=>"Gloria Foster", :id=>9364}, {:role=>"Apoc", :name=>"Julian Arahanga", :id=>7244}, {:role=>"Switch", :name=>"Belinda McClory", :id=>9376}, {:role=>"Mouse", :name=>"Matt Doran", :id=>9374}, {:role=>"Dozer", :name=>"Anthony Ray Parker", :id=>9378}, {:role=>"Agent Brown", :name=>"Paul Goddard", :id=>9380}, {:role=>"Rhineheart", :name=>"David Aston", :id=>9383}, {:role=>"Choi", :name=>"Marc Aden", :id=>9384}, {:role=>"Agent Jones", :name=>"Robert Taylor", :id=>39545}, {:role=>"White Rabbit Girl", :name=>"Ada Nicodemou", :id=>181214}, {:role=>"Priestess", :name=>"Denni Gordon", :id=>1090466}, {:role=>"Spoon Boy", :name=>"Rowan Witt", :id=>218366}], :movie_id=>603, :directors=>[{:name=>"Lana Wachowski", :id=>9340}, {:name=>"Andy Wachowski", :id=>9339}], :tagline=>"Welcome to the Real World.", :title=>"The Matrix", :released=>"1999-03-31", :genres=>["Adventure", "Action", "Thriller", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '603', title : 'The Matrix', tagline : 'Welcome to the Real World.', released : '1999-03-31'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Thriller'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Neo'}]-({id : '6384', name: 'Keanu Reeves'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Morpheus'}]-({id : '2975', name: 'Laurence Fishburne'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Trinity'}]-({id : '530', name: 'Carrie-Anne Moss'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Smith'}]-({id : '1331', name: 'Hugo Weaving'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cypher'}]-({id : '532', name: 'Joe Pantoliano'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tank'}]-({id : '9372', name: 'Marcus Chong'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Oracle'}]-({id : '9364', name: 'Gloria Foster'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Apoc'}]-({id : '7244', name: 'Julian Arahanga'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Switch'}]-({id : '9376', name: 'Belinda McClory'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mouse'}]-({id : '9374', name: 'Matt Doran'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dozer'}]-({id : '9378', name: 'Anthony Ray Parker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Brown'}]-({id : '9380', name: 'Paul Goddard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Rhineheart'}]-({id : '9383', name: 'David Aston'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Choi'}]-({id : '9384', name: 'Marc Aden'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Jones'}]-({id : '39545', name: 'Robert Taylor'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'White Rabbit Girl'}]-({id : '181214', name: 'Ada Nicodemou'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Priestess'}]-({id : '1090466', name: 'Denni Gordon'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Spoon Boy'}]-({id : '218366', name: 'Rowan Witt'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '9340', name: 'Lana Wachowski'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '9339', name: 'Andy Wachowski'})-[:PERSON]->people
;
{:actors=>[{:role=>"Neo", :name=>"Keanu Reeves", :id=>6384}, {:role=>"Morpheus", :name=>"Laurence Fishburne", :id=>2975}, {:role=>"Trinity", :name=>"Carrie-Anne Moss", :id=>530}, {:role=>"Agent Smith", :name=>"Hugo Weaving", :id=>1331}, {:role=>"Oracle", :name=>"Gloria Foster", :id=>9364}, {:role=>"The Architect", :name=>"Helmut Bakaitis", :id=>9443}, {:role=>"The Merovingian", :name=>"Lambert Wilson", :id=>2192}, {:role=>"Persephone", :name=>"Monica Bellucci", :id=>28782}, {:role=>"Twin #2", :name=>"Adrian Rayment", :id=>9448}, {:role=>"Twin #1", :name=>"Neil Rayment", :id=>9450}, {:role=>"Agent Johnson", :name=>"Daniel Bernhardt", :id=>9452}, {:role=>"Captain Ballard", :name=>"Roy Jones Jr.", :id=>9457}, {:role=>"Agent Jackson", :name=>"David Kilde", :id=>9459}, {:role=>"The Keymaker", :name=>"Randall Duk Kim", :id=>9462}, {:role=>"Commander Lock", :name=>"Harry Lennix", :id=>9464}, {:role=>"Agent Thompson", :name=>"Matt McColm", :id=>9466}, {:role=>"Seraph", :name=>"Collin Chou", :id=>52908}, {:role=>"Councillor West", :name=>"Cornel West", :id=>537506}, {:role=>"Niobe", :name=>"Jada Pinkett Smith", :id=>9575}, {:role=>"Zee", :name=>"Nona Gaye", :id=>18286}], :movie_id=>604, :directors=>[{:name=>"Lana Wachowski", :id=>9340}, {:name=>"Andy Wachowski", :id=>9339}], :tagline=>"Free your mind.", :title=>"The Matrix Reloaded", :released=>"2003-05-07", :genres=>["Adventure", "Action", "Thriller", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '604', title : 'The Matrix Reloaded', tagline : 'Free your mind.', released : '2003-05-07'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Thriller'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Neo'}]-({id : '6384', name: 'Keanu Reeves'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Morpheus'}]-({id : '2975', name: 'Laurence Fishburne'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Trinity'}]-({id : '530', name: 'Carrie-Anne Moss'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Smith'}]-({id : '1331', name: 'Hugo Weaving'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Oracle'}]-({id : '9364', name: 'Gloria Foster'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Architect'}]-({id : '9443', name: 'Helmut Bakaitis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Merovingian'}]-({id : '2192', name: 'Lambert Wilson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Persephone'}]-({id : '28782', name: 'Monica Bellucci'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Twin #2'}]-({id : '9448', name: 'Adrian Rayment'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Twin #1'}]-({id : '9450', name: 'Neil Rayment'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Johnson'}]-({id : '9452', name: 'Daniel Bernhardt'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Ballard'}]-({id : '9457', name: 'Roy Jones Jr.'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Jackson'}]-({id : '9459', name: 'David Kilde'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Keymaker'}]-({id : '9462', name: 'Randall Duk Kim'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Commander Lock'}]-({id : '9464', name: 'Harry Lennix'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Thompson'}]-({id : '9466', name: 'Matt McColm'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Seraph'}]-({id : '52908', name: 'Collin Chou'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Councillor West'}]-({id : '537506', name: 'Cornel West'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Niobe'}]-({id : '9575', name: 'Jada Pinkett Smith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Zee'}]-({id : '18286', name: 'Nona Gaye'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '9340', name: 'Lana Wachowski'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '9339', name: 'Andy Wachowski'})-[:PERSON]->people
;
{:actors=>[{:role=>"Neo", :name=>"Keanu Reeves", :id=>6384}, {:role=>"Morpheus", :name=>"Laurence Fishburne", :id=>2975}, {:role=>"Trinity", :name=>"Carrie-Anne Moss", :id=>530}, {:role=>"Agent Smith", :name=>"Hugo Weaving", :id=>1331}, {:role=>"Oracle", :name=>"Mary Alice", :id=>9572}, {:role=>"The Architect", :name=>"Helmut Bakaitis", :id=>9443}, {:role=>"The Merovingian", :name=>"Lambert Wilson", :id=>2192}, {:role=>"Captain Ballard", :name=>"Roy Jones Jr.", :id=>9457}, {:role=>"The Keymaker", :name=>"Randall Duk Kim", :id=>9462}, {:role=>"Commander Lock", :name=>"Harry Lennix", :id=>9464}, {:role=>"Agent Thompson", :name=>"Matt McColm", :id=>9466}, {:role=>"Link", :name=>"Harold Perrineau Jr.", :id=>6195}, {:role=>"Niobe", :name=>"Jada Pinkett Smith", :id=>9575}, {:role=>"Cas", :name=>"Gina Torres", :id=>9576}, {:role=>"Seraph", :name=>"Collin Chou", :id=>52908}, {:role=>"Councillor West", :name=>"Cornel West", :id=>537506}, {:role=>"Zee", :name=>"Nona Gaye", :id=>18286}, {:role=>"Persephone", :name=>"Monica Bellucci", :id=>28782}], :movie_id=>605, :directors=>[{:name=>"Andy Wachowski", :id=>9339}, {:name=>"Lana Wachowski", :id=>9340}], :tagline=>"Everything that has a beginning has an end.", :title=>"The Matrix Revolutions", :released=>"2003-10-27", :genres=>["Adventure", "Action", "Thriller", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '605', title : 'The Matrix Revolutions', tagline : 'Everything that has a beginning has an end.', released : '2003-10-27'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Thriller'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Neo'}]-({id : '6384', name: 'Keanu Reeves'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Morpheus'}]-({id : '2975', name: 'Laurence Fishburne'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Trinity'}]-({id : '530', name: 'Carrie-Anne Moss'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Smith'}]-({id : '1331', name: 'Hugo Weaving'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Oracle'}]-({id : '9572', name: 'Mary Alice'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Architect'}]-({id : '9443', name: 'Helmut Bakaitis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Merovingian'}]-({id : '2192', name: 'Lambert Wilson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Ballard'}]-({id : '9457', name: 'Roy Jones Jr.'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Keymaker'}]-({id : '9462', name: 'Randall Duk Kim'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Commander Lock'}]-({id : '9464', name: 'Harry Lennix'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Thompson'}]-({id : '9466', name: 'Matt McColm'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Link'}]-({id : '6195', name: 'Harold Perrineau Jr.'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Niobe'}]-({id : '9575', name: 'Jada Pinkett Smith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cas'}]-({id : '9576', name: 'Gina Torres'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Seraph'}]-({id : '52908', name: 'Collin Chou'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Councillor West'}]-({id : '537506', name: 'Cornel West'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Zee'}]-({id : '18286', name: 'Nona Gaye'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Persephone'}]-({id : '28782', name: 'Monica Bellucci'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '9339', name: 'Andy Wachowski'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '9340', name: 'Lana Wachowski'})-[:PERSON]->people
;
{:actors=>[{:role=>"Karen Christence Dinesen Blixen", :name=>"Meryl Streep", :id=>5064}, {:role=>"Denys George Finch Hatton", :name=>"Robert Redford", :id=>4135}, {:role=>"Baron Bror Blixen/Baron Hans Blixen", :name=>"Klaus Maria Brandauer", :id=>10647}, {:role=>"Berkeley Cole", :name=>"Michael Kitchen", :id=>10648}, {:role=>"Farah", :name=>"Malick Bowens", :id=>10649}, {:role=>"Kamante", :name=>"Joseph Thiaka", :id=>10650}, {:role=>"Kinanjui", :name=>"Stephen Kinyanjui", :id=>10651}, {:role=>"Lord Delamere", :name=>"Michael Gough", :id=>3796}, {:role=>"Felicity", :name=>"Suzanna Hamilton", :id=>10652}, {:role=>"Lady Belfield", :name=>"Rachel Kempson", :id=>10653}, {:role=>"Lord Belfield", :name=>"Graham Crowden", :id=>10654}, {:role=>"Sir Joseph", :name=>"Leslie Phillips", :id=>10655}, {:role=>"Juma", :name=>"Mike Bugara", :id=>10656}, {:role=>"Belknap, farm manager", :name=>"Shane Rimmer", :id=>10657}, {:role=>"Kanuthia", :name=>"Job Seda", :id=>10658}], :movie_id=>606, :directors=>[{:name=>"Sydney Pollack", :id=>2226}], :title=>"Out of Africa", :released=>"1985-12-10", :genres=>["Drama", "Romance"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '606', title : 'Out of Africa', released : '1985-12-10'}
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Romance'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Karen Christence Dinesen Blixen'}]-({id : '5064', name: 'Meryl Streep'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Denys George Finch Hatton'}]-({id : '4135', name: 'Robert Redford'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Baron Bror Blixen/Baron Hans Blixen'}]-({id : '10647', name: 'Klaus Maria Brandauer'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Berkeley Cole'}]-({id : '10648', name: 'Michael Kitchen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Farah'}]-({id : '10649', name: 'Malick Bowens'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Kamante'}]-({id : '10650', name: 'Joseph Thiaka'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Kinanjui'}]-({id : '10651', name: 'Stephen Kinyanjui'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lord Delamere'}]-({id : '3796', name: 'Michael Gough'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Felicity'}]-({id : '10652', name: 'Suzanna Hamilton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lady Belfield'}]-({id : '10653', name: 'Rachel Kempson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lord Belfield'}]-({id : '10654', name: 'Graham Crowden'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Sir Joseph'}]-({id : '10655', name: 'Leslie Phillips'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Juma'}]-({id : '10656', name: 'Mike Bugara'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Belknap, farm manager'}]-({id : '10657', name: 'Shane Rimmer'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Kanuthia'}]-({id : '10658', name: 'Job Seda'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '2226', name: 'Sydney Pollack'})-[:PERSON]->people
;
{:actors=>[{:role=>"Agent K", :name=>"Tommy Lee Jones", :id=>2176}, {:role=>"James Edwards / Agent J", :name=>"Will Smith", :id=>2888}, {:role=>"Dr. Laurel Weaver / Agent L", :name=>"Linda Fiorentino", :id=>9625}, {:role=>"Edgar / The Bug", :name=>"Vincent DOnofrio", :id=>7132}, {:role=>"Chief Zed", :name=>"Rip Torn", :id=>9626}, {:role=>"Jack Jeebs", :name=>"Tony Shalhoub", :id=>4252}, {:role=>"Gentle Rosenburg the Arquillian Jeweler", :name=>"Mike Nussbaum", :id=>9628}, {:role=>"Van driver", :name=>"Jon Gries", :id=>9629}, {:role=>"Jose", :name=>"Sergio Calder\303\263n", :id=>9630}, {:role=>"Arquillian", :name=>"Carel Struycken", :id=>9631}, {:role=>"INS agent Janus", :name=>"Fredric Lehne", :id=>9632}, {:role=>"Agent D", :name=>"Richard Hamilton", :id=>9633}, {:role=>"2nd Lt. Jake Jensen", :name=>"Kent Faulcon", :id=>9634}, {:role=>"Beatrice", :name=>"Siobhan Fallon", :id=>6751}, {:role=>"Mikey", :name=>"John Alexander", :id=>443770}], :movie_id=>607, :directors=>[{:name=>"Barry Sonnenfeld", :id=>5174}], :tagline=>"Protecting the Earth from the scum of the universe.", :title=>"Men in Black", :released=>"1997-07-04", :genres=>["Action", "Adventure", "Comedy", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '607', title : 'Men in Black', tagline : 'Protecting the Earth from the scum of the universe.', released : '1997-07-04'}
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Agent K'}]-({id : '2176', name: 'Tommy Lee Jones'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'James Edwards / Agent J'}]-({id : '2888', name: 'Will Smith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Laurel Weaver / Agent L'}]-({id : '9625', name: 'Linda Fiorentino'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Edgar / The Bug'}]-({id : '7132', name: 'Vincent DOnofrio'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Chief Zed'}]-({id : '9626', name: 'Rip Torn'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jack Jeebs'}]-({id : '4252', name: 'Tony Shalhoub'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gentle Rosenburg the Arquillian Jeweler'}]-({id : '9628', name: 'Mike Nussbaum'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Van driver'}]-({id : '9629', name: 'Jon Gries'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jose'}]-({id : '9630', name: 'Sergio Calderón'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Arquillian'}]-({id : '9631', name: 'Carel Struycken'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'INS agent Janus'}]-({id : '9632', name: 'Fredric Lehne'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent D'}]-({id : '9633', name: 'Richard Hamilton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : '2nd Lt. Jake Jensen'}]-({id : '9634', name: 'Kent Faulcon'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Beatrice'}]-({id : '6751', name: 'Siobhan Fallon'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mikey'}]-({id : '443770', name: 'John Alexander'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '5174', name: 'Barry Sonnenfeld'})-[:PERSON]->people
;
{:actors=>[{:role=>"Kevin Brown, Agent Kay", :name=>"Tommy Lee Jones", :id=>2176}, {:role=>"Agent Jay", :name=>"Will Smith", :id=>2888}, {:role=>"Zed", :name=>"Rip Torn", :id=>9626}, {:role=>"Serleena", :name=>"Lara Flynn Boyle", :id=>6684}, {:role=>"Scrad/Charlie", :name=>"Johnny Knoxville", :id=>9656}, {:role=>"Laura Vasquez", :name=>"Rosario Dawson", :id=>5916}, {:role=>"Jack Jeebs", :name=>"Tony Shalhoub", :id=>4252}, {:role=>"Agent Tee", :name=>"Patrick Warburton", :id=>9657}, {:role=>"Ben", :name=>"Jack Kehler", :id=>1240}, {:role=>"Newton", :name=>"David Cross", :id=>212}, {:role=>"Hailey", :name=>"Colombe Jacobsen-Derstine", :id=>9658}, {:role=>"Captain Larry Bridgewater, The Motorman", :name=>"Peter Spellos", :id=>9659}, {:role=>"Cameo", :name=>"Jaden Smith", :id=>120724}], :movie_id=>608, :directors=>[{:name=>"Barry Sonnenfeld", :id=>5174}], :tagline=>"Same Planet. New Scum.", :title=>"Men In Black II", :released=>"2002-07-03", :genres=>["Action", "Adventure", "Comedy", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '608', title : 'Men In Black II', tagline : 'Same Planet. New Scum.', released : '2002-07-03'}
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Kevin Brown, Agent Kay'}]-({id : '2176', name: 'Tommy Lee Jones'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Jay'}]-({id : '2888', name: 'Will Smith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Zed'}]-({id : '9626', name: 'Rip Torn'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Serleena'}]-({id : '6684', name: 'Lara Flynn Boyle'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Scrad/Charlie'}]-({id : '9656', name: 'Johnny Knoxville'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Laura Vasquez'}]-({id : '5916', name: 'Rosario Dawson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jack Jeebs'}]-({id : '4252', name: 'Tony Shalhoub'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Agent Tee'}]-({id : '9657', name: 'Patrick Warburton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ben'}]-({id : '1240', name: 'Jack Kehler'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Newton'}]-({id : '212', name: 'David Cross'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Hailey'}]-({id : '9658', name: 'Colombe Jacobsen-Derstine'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Larry Bridgewater, The Motorman'}]-({id : '9659', name: 'Peter Spellos'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cameo'}]-({id : '120724', name: 'Jaden Smith'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '5174', name: 'Barry Sonnenfeld'})-[:PERSON]->people
;
{:actors=>[{:role=>"Steve Freeling", :name=>"Craig T. Nelson", :id=>8977}, {:role=>"Diane Freeling", :name=>"JoBeth Williams", :id=>10080}, {:role=>"Dr. Lesh", :name=>"Beatrice Straight", :id=>10083}, {:role=>"Dana Freeling", :name=>"Dominique Dunne", :id=>10084}, {:role=>"Robbie Freeling", :name=>"Oliver Robins", :id=>10085}, {:role=>"Carol Anne Freeling", :name=>"Heather ORourke", :id=>10086}, {:role=>"Ben Tuthill", :name=>"Michael McManus", :id=>10087}, {:role=>"Mrs. Tuthill", :name=>"Virginia Kiser", :id=>10088}, {:role=>"Dr. Marty Casey", :name=>"Martin Casella", :id=>10089}, {:role=>"Ryan", :name=>"Richard Lawson", :id=>10090}, {:role=>"Tangina Barrons", :name=>"Zelda Rubinstein", :id=>10091}, {:role=>"Pugsley", :name=>"Lou Perryman", :id=>2851}], :movie_id=>609, :directors=>[{:name=>"Tobe Hooper", :id=>10051}], :tagline=>"It knows what scares you.", :title=>"Poltergeist", :released=>"1982-06-04", :genres=>["Horror"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '609', title : 'Poltergeist', tagline : 'It knows what scares you.', released : '1982-06-04'}
create unique movie-[:GENRE]->({genre : 'Horror'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Steve Freeling'}]-({id : '8977', name: 'Craig T. Nelson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Diane Freeling'}]-({id : '10080', name: 'JoBeth Williams'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Lesh'}]-({id : '10083', name: 'Beatrice Straight'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dana Freeling'}]-({id : '10084', name: 'Dominique Dunne'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Robbie Freeling'}]-({id : '10085', name: 'Oliver Robins'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Carol Anne Freeling'}]-({id : '10086', name: 'Heather ORourke'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ben Tuthill'}]-({id : '10087', name: 'Michael McManus'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mrs. Tuthill'}]-({id : '10088', name: 'Virginia Kiser'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Marty Casey'}]-({id : '10089', name: 'Martin Casella'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ryan'}]-({id : '10090', name: 'Richard Lawson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tangina Barrons'}]-({id : '10091', name: 'Zelda Rubinstein'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pugsley'}]-({id : '2851', name: 'Lou Perryman'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '10051', name: 'Tobe Hooper'})-[:PERSON]->people
;
{:actors=>[{:role=>"Forrest Gump", :name=>"Tom Hanks", :id=>31}, {:role=>"Jenny Curran", :name=>"Robin Wright", :id=>32}, {:role=>"Lt. Dan Taylor", :name=>"Gary Sinise", :id=>33}, {:role=>"Pvt. Benjamin Buford Bubba Blue", :name=>"Mykelti Williamson", :id=>34}, {:role=>"Mrs. Gump", :name=>"Sally Field", :id=>35}, {:role=>"Young Forrest Gump", :name=>"Michael Conner Humphreys", :id=>37821}, {:role=>"Elvis Presley", :name=>"Peter Dobson", :id=>37822}, {:role=>"Coach", :name=>"Sonny Shroyer", :id=>37823}, {:role=>"President John F. Kennedy", :name=>"Jed Gillin", :id=>37824}, {:role=>"Drill Sergeant", :name=>"Afemo Omilami", :id=>37825}, {:role=>"Tex", :name=>"Steven Griffith", :id=>37826}, {:role=>"President Johnson", :name=>"John William Galt", :id=>37827}, {:role=>"Elderly Southern Woman on Park Bench", :name=>"Nora Dunfee", :id=>37828}, {:role=>"Taxi Driver", :name=>"Michael Mattison", :id=>37829}, {:role=>"Forrest Gump Jr.", :name=>"Haley Joel Osment", :id=>9640}, {:role=>"Bubbas Great-Grandmother", :name=>"Kitty K. Green", :id=>37830}, {:role=>"Mrs. Blue, Bubbas Mother", :name=>"Marlena Smalls", :id=>37831}, {:role=>"Jennys Father", :name=>"Kevin Mangan", :id=>37832}, {:role=>"Principal", :name=>"Sam Anderson", :id=>36221}, {:role=>"Young Jenny Curran", :name=>"Hanna Hall", :id=>204997}], :movie_id=>13, :directors=>[{:name=>"Robert Zemeckis", :id=>24}], :tagline=>"Life is like a box of chocolates...you never know what you're gonna get.", :title=>"Forrest Gump", :released=>"1994-06-23", :genres=>["Comedy", "Drama", "Romance"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '13', title : 'Forrest Gump', tagline : 'Life is like a box of chocolates...you never know what youre gonna get.', released : '1994-06-23'}
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Romance'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Forrest Gump'}]-({id : '31', name: 'Tom Hanks'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jenny Curran'}]-({id : '32', name: 'Robin Wright'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Dan Taylor'}]-({id : '33', name: 'Gary Sinise'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pvt. Benjamin Buford Bubba Blue'}]-({id : '34', name: 'Mykelti Williamson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mrs. Gump'}]-({id : '35', name: 'Sally Field'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Young Forrest Gump'}]-({id : '37821', name: 'Michael Conner Humphreys'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elvis Presley'}]-({id : '37822', name: 'Peter Dobson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Coach'}]-({id : '37823', name: 'Sonny Shroyer'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'President John F. Kennedy'}]-({id : '37824', name: 'Jed Gillin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Drill Sergeant'}]-({id : '37825', name: 'Afemo Omilami'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tex'}]-({id : '37826', name: 'Steven Griffith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'President Johnson'}]-({id : '37827', name: 'John William Galt'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elderly Southern Woman on Park Bench'}]-({id : '37828', name: 'Nora Dunfee'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Taxi Driver'}]-({id : '37829', name: 'Michael Mattison'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Forrest Gump Jr.'}]-({id : '9640', name: 'Haley Joel Osment'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bubbas Great-Grandmother'}]-({id : '37830', name: 'Kitty K. Green'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mrs. Blue, Bubbas Mother'}]-({id : '37831', name: 'Marlena Smalls'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jennys Father'}]-({id : '37832', name: 'Kevin Mangan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Principal'}]-({id : '36221', name: 'Sam Anderson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Young Jenny Curran'}]-({id : '204997', name: 'Hanna Hall'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '24', name: 'Robert Zemeckis'})-[:PERSON]->people
;
{:actors=>[{:role=>"Sam Flynn", :name=>"Garrett Hedlund", :id=>9828}, {:role=>"Kevin Flynn / Clu", :name=>"Jeff Bridges", :id=>1229}, {:role=>"Quorra", :name=>"Olivia Wilde", :id=>59315}, {:role=>"Alan Bradley / Tron", :name=>"Bruce Boxleitner", :id=>2547}, {:role=>"Siren", :name=>"Yaya DaCosta", :id=>60033}, {:role=>"Siren", :name=>"Serinda Swan", :id=>86268}, {:role=>"Siren", :name=>"Beau Garrett", :id=>20403}, {:role=>"Siren", :name=>"Elizabeth Mathis", :id=>130108}, {:role=>"Jarvis", :name=>"James Frain", :id=>22063}, {:role=>"Young Mrs. Flynn", :name=>"Amy Esterle", :id=>86269}, {:role=>"Sobel", :name=>"Brandon Jay McLaren", :id=>58371}, {:role=>"Castor / Zuse", :name=>"Michael Sheen", :id=>3968}, {:role=>"Young Sam", :name=>"Owen Best", :id=>109205}, {:role=>"Green Light Cycle Rider", :name=>"Michael Teigen", :id=>37980}, {:role=>"Masked DJs", :name=>"Daft Punk", :id=>67931}, {:role=>"Chattering Homeless Man", :name=>"Ron Selmour", :id=>10874}, {:role=>"Bartik", :name=>"Conrad Coates", :id=>43263}, {:role=>"Half Faced Man (as Yurij Kis)", :name=>"Kis Yurij", :id=>145110}], :movie_id=>20526, :directors=>[{:name=>"Joseph Kosinski", :id=>86270}], :tagline=>"The Game Has Changed.", :title=>"TRON: Legacy", :released=>"2010-12-17", :genres=>["Adventure", "Action", "Thriller", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '20526', title : 'TRON: Legacy', tagline : 'The Game Has Changed.', released : '2010-12-17'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Thriller'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Sam Flynn'}]-({id : '9828', name: 'Garrett Hedlund'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Kevin Flynn / Clu'}]-({id : '1229', name: 'Jeff Bridges'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Quorra'}]-({id : '59315', name: 'Olivia Wilde'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Alan Bradley / Tron'}]-({id : '2547', name: 'Bruce Boxleitner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Siren'}]-({id : '60033', name: 'Yaya DaCosta'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Siren'}]-({id : '86268', name: 'Serinda Swan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Siren'}]-({id : '20403', name: 'Beau Garrett'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Siren'}]-({id : '130108', name: 'Elizabeth Mathis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jarvis'}]-({id : '22063', name: 'James Frain'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Young Mrs. Flynn'}]-({id : '86269', name: 'Amy Esterle'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Sobel'}]-({id : '58371', name: 'Brandon Jay McLaren'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Castor / Zuse'}]-({id : '3968', name: 'Michael Sheen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Young Sam'}]-({id : '109205', name: 'Owen Best'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Green Light Cycle Rider'}]-({id : '37980', name: 'Michael Teigen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Masked DJs'}]-({id : '67931', name: 'Daft Punk'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Chattering Homeless Man'}]-({id : '10874', name: 'Ron Selmour'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bartik'}]-({id : '43263', name: 'Conrad Coates'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Half Faced Man (as Yurij Kis)'}]-({id : '145110', name: 'Kis Yurij'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '86270', name: 'Joseph Kosinski'})-[:PERSON]->people
;
{:actors=>[{:role=>"Luke Skywalker", :name=>"Mark Hamill", :id=>2}, {:role=>"Leia Organa", :name=>"Carrie Fisher", :id=>4}, {:role=>"Han Solo", :name=>"Harrison Ford", :id=>3}, {:role=>"Grand Moff Tarkin", :name=>"Peter Cushing", :id=>5}, {:role=>"C-3PO", :name=>"Anthony Daniels", :id=>6}, {:role=>"R2-D2", :name=>"Kenny Baker", :id=>130}, {:role=>"Obi-Wan Kenobi", :name=>"Alec Guinness", :id=>12248}, {:role=>"Chewbacca", :name=>"Peter Mayhew", :id=>24343}, {:role=>"Darth Vader", :name=>"David Prowse", :id=>24342}, {:role=>"Darth Vader (voice)", :name=>"James Earl Jones", :id=>15152}, {:role=>"Uncle Owen", :name=>"Phil Brown", :id=>33032}, {:role=>"Aunt Beru", :name=>"Shelagh Fraser", :id=>131625}, {:role=>"Advisor to Grand Moff Tarkin", :name=>"Roger Lloyd-Pack", :id=>81024}, {:role=>"Jek Tono Porkins (Red Six)", :name=>"William Hootkins", :id=>663}, {:role=>"Lt. Shann Childsen", :name=>"Malcolm Tierney", :id=>166258}], :movie_id=>11, :directors=>[{:name=>"George Lucas", :id=>1}], :tagline=>"A long time ago in a galaxy far, far away...", :title=>"Star Wars: Episode IV - A New Hope", :released=>"1977-05-25", :genres=>["Adventure", "Fantasy", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '11', title : 'Star Wars: Episode IV - A New Hope', tagline : 'A long time ago in a galaxy far, far away...', released : '1977-05-25'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Luke Skywalker'}]-({id : '2', name: 'Mark Hamill'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Leia Organa'}]-({id : '4', name: 'Carrie Fisher'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Han Solo'}]-({id : '3', name: 'Harrison Ford'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Grand Moff Tarkin'}]-({id : '5', name: 'Peter Cushing'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'C-3PO'}]-({id : '6', name: 'Anthony Daniels'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'R2-D2'}]-({id : '130', name: 'Kenny Baker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Obi-Wan Kenobi'}]-({id : '12248', name: 'Alec Guinness'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Chewbacca'}]-({id : '24343', name: 'Peter Mayhew'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Darth Vader'}]-({id : '24342', name: 'David Prowse'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Darth Vader (voice)'}]-({id : '15152', name: 'James Earl Jones'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Uncle Owen'}]-({id : '33032', name: 'Phil Brown'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Aunt Beru'}]-({id : '131625', name: 'Shelagh Fraser'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Advisor to Grand Moff Tarkin'}]-({id : '81024', name: 'Roger Lloyd-Pack'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jek Tono Porkins (Red Six)'}]-({id : '663', name: 'William Hootkins'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Shann Childsen'}]-({id : '166258', name: 'Malcolm Tierney'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1', name: 'George Lucas'})-[:PERSON]->people
;
{:actors=>[{:role=>"Queen Amidala", :name=>"Natalie Portman", :id=>524}, {:role=>"Obi Wan Kenobi", :name=>"Ewan McGregor", :id=>3061}, {:role=>"Qui-Gon Jinn", :name=>"Liam Neeson", :id=>3896}, {:role=>"Senator Palpatine", :name=>"Ian McDiarmid", :id=>27762}, {:role=>"C-3PO", :name=>"Anthony Daniels", :id=>6}, {:role=>"R2-D2", :name=>"Kenny Baker", :id=>130}, {:role=>"Anakin Skywalker", :name=>"Jake Lloyd", :id=>33196}, {:role=>"Shmi Skywalker", :name=>"Pernilla August", :id=>33190}, {:role=>"Yoda (voice)", :name=>"Frank Oz", :id=>7908}, {:role=>"Governor Bibble", :name=>"Oliver Ford Davies", :id=>31923}, {:role=>"Darth Maul", :name=>"Ray Park", :id=>11007}, {:role=>"Capt. Panaka", :name=>"Hugh Quarshie", :id=>31925}, {:role=>"Jar Jar Binks (Voice)", :name=>"Ahmed Best", :id=>33197}, {:role=>"Watto", :name=>"Andrew Secombe", :id=>33198}, {:role=>"Capt. Tarpals", :name=>"Steve Speirs", :id=>25441}, {:role=>"Mace Windu", :name=>"Samuel L. Jackson", :id=>2231}, {:role=>"Sab\303\251", :name=>"Keira Knightley", :id=>116}, {:role=>"Sach\303\251", :name=>"Sofia Coppola", :id=>1769}], :movie_id=>1893, :directors=>[{:name=>"George Lucas", :id=>1}], :tagline=>"Every generation has a legend. Every journey has a first step. Every saga has a beginning.", :title=>"Star Wars: Episode I - The Phantom Menace", :released=>"1999-05-19", :genres=>["Adventure", "Fantasy", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '1893', title : 'Star Wars: Episode I - The Phantom Menace', tagline : 'Every generation has a legend. Every journey has a first step. Every saga has a beginning.', released : '1999-05-19'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Queen Amidala'}]-({id : '524', name: 'Natalie Portman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Obi Wan Kenobi'}]-({id : '3061', name: 'Ewan McGregor'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Qui-Gon Jinn'}]-({id : '3896', name: 'Liam Neeson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Senator Palpatine'}]-({id : '27762', name: 'Ian McDiarmid'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'C-3PO'}]-({id : '6', name: 'Anthony Daniels'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'R2-D2'}]-({id : '130', name: 'Kenny Baker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Anakin Skywalker'}]-({id : '33196', name: 'Jake Lloyd'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Shmi Skywalker'}]-({id : '33190', name: 'Pernilla August'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Yoda (voice)'}]-({id : '7908', name: 'Frank Oz'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Governor Bibble'}]-({id : '31923', name: 'Oliver Ford Davies'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Darth Maul'}]-({id : '11007', name: 'Ray Park'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Capt. Panaka'}]-({id : '31925', name: 'Hugh Quarshie'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jar Jar Binks (Voice)'}]-({id : '33197', name: 'Ahmed Best'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Watto'}]-({id : '33198', name: 'Andrew Secombe'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Capt. Tarpals'}]-({id : '25441', name: 'Steve Speirs'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mace Windu'}]-({id : '2231', name: 'Samuel L. Jackson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Sabé'}]-({id : '116', name: 'Keira Knightley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Saché'}]-({id : '1769', name: 'Sofia Coppola'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1', name: 'George Lucas'})-[:PERSON]->people
;
{:actors=>[{:role=>"Luke Skywalker", :name=>"Mark Hamill", :id=>2}, {:role=>"Han Solo", :name=>"Harrison Ford", :id=>3}, {:role=>"Princess Leia", :name=>"Carrie Fisher", :id=>4}, {:role=>"Lando Calrissian", :name=>"Billy Dee Williams", :id=>3799}, {:role=>"C-3PO", :name=>"Anthony Daniels", :id=>6}, {:role=>"Chewbacca", :name=>"Peter Mayhew", :id=>24343}, {:role=>"Voice of Darth Vader (voice)", :name=>"James Earl Jones", :id=>15152}, {:role=>"Yoda (voice)", :name=>"Frank Oz", :id=>7908}, {:role=>"The Emperor", :name=>"Ian McDiarmid", :id=>27762}, {:role=>"Anakin Skywalker", :name=>"Sebastian Shaw", :id=>28235}, {:role=>"Darth Vader", :name=>"David Prowse", :id=>24342}, {:role=>"Ben Obi-Wan Kenobi", :name=>"Alec Guinness", :id=>12248}, {:role=>"R2-D2 / Paploo", :name=>"Kenny Baker", :id=>130}], :movie_id=>1892, :directors=>[{:name=>"Richard Marquand", :id=>19800}], :tagline=>"The Empire Falls...", :title=>"Star Wars: Episode VI - Return of the Jedi", :released=>"1983-05-25", :genres=>["Adventure", "Fantasy", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '1892', title : 'Star Wars: Episode VI - Return of the Jedi', tagline : 'The Empire Falls...', released : '1983-05-25'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Luke Skywalker'}]-({id : '2', name: 'Mark Hamill'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Han Solo'}]-({id : '3', name: 'Harrison Ford'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Princess Leia'}]-({id : '4', name: 'Carrie Fisher'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lando Calrissian'}]-({id : '3799', name: 'Billy Dee Williams'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'C-3PO'}]-({id : '6', name: 'Anthony Daniels'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Chewbacca'}]-({id : '24343', name: 'Peter Mayhew'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Voice of Darth Vader (voice)'}]-({id : '15152', name: 'James Earl Jones'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Yoda (voice)'}]-({id : '7908', name: 'Frank Oz'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Emperor'}]-({id : '27762', name: 'Ian McDiarmid'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Anakin Skywalker'}]-({id : '28235', name: 'Sebastian Shaw'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Darth Vader'}]-({id : '24342', name: 'David Prowse'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ben Obi-Wan Kenobi'}]-({id : '12248', name: 'Alec Guinness'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'R2-D2 / Paploo'}]-({id : '130', name: 'Kenny Baker'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '19800', name: 'Richard Marquand'})-[:PERSON]->people
;
{:actors=>[{:role=>"Obi Wan Kenobi", :name=>"Ewan McGregor", :id=>3061}, {:role=>"Padm\303\251 Amidala", :name=>"Natalie Portman", :id=>524}, {:role=>"Anakin Skywalker", :name=>"Hayden Christensen", :id=>17244}, {:role=>"Count Dooku", :name=>"Christopher Lee", :id=>113}, {:role=>"Chancellor Palpatine", :name=>"Ian McDiarmid", :id=>27762}, {:role=>"Mace Windu", :name=>"Samuel L. Jackson", :id=>2231}, {:role=>"Dorm\303\251", :name=>"Rose Byrne", :id=>9827}, {:role=>"Yoda (Voice)", :name=>"Frank Oz", :id=>7908}, {:role=>"C-3PO", :name=>"Anthony Daniels", :id=>6}, {:role=>"R2-D2", :name=>"Kenny Baker", :id=>130}, {:role=>"Elan Sleazebaggano", :name=>"Matt Doran", :id=>9374}, {:role=>"Gilramos Libkath", :name=>"Alan Ruscoe", :id=>33186}, {:role=>"Cord\303\251", :name=>"Veronica Segura", :id=>33187}, {:role=>"Ki-Adi-Mundi", :name=>"Silas Carson", :id=>20806}, {:role=>"Viceroy Nute Gunray", :name=>"Silas Carson", :id=>20806}, {:role=>"Govenor Sio Bibble", :name=>"Oliver Ford Davies", :id=>31923}, {:role=>"Dexter Jettster", :name=>"Ron Falk", :id=>33188}, {:role=>"Capt. Typho", :name=>"Jay Lagaaia", :id=>33182}, {:role=>"Senator Bail Organa", :name=>"Jimmy Smits", :id=>33181}, {:role=>"Boba Fett", :name=>"Daniel Logan", :id=>33189}, {:role=>"Jango Fett", :name=>"Temuera Morrison", :id=>7242}, {:role=>"Shmi Skywalker", :name=>"Pernilla August", :id=>33190}, {:role=>"Queen Jamillia", :name=>"Ayesha Dharker", :id=>33191}, {:role=>"Owen Lars", :name=>"Joel Edgerton", :id=>33192}, {:role=>"Cliegg Lars", :name=>"Jack Thompson", :id=>12536}, {:role=>"Beru", :name=>"Bonnie Piesse", :id=>131634}, {:role=>"Watto (voice)", :name=>"Andrew Secombe", :id=>33198}], :movie_id=>1894, :directors=>[{:name=>"George Lucas", :id=>1}], :tagline=>"A Jedi Shall Not Know Anger. Nor Hatred. Nor Love.", :title=>"Star Wars: Episode II - Attack of the Clones", :released=>"2002-05-16", :genres=>["Adventure", "Fantasy", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '1894', title : 'Star Wars: Episode II - Attack of the Clones', tagline : 'A Jedi Shall Not Know Anger. Nor Hatred. Nor Love.', released : '2002-05-16'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Obi Wan Kenobi'}]-({id : '3061', name: 'Ewan McGregor'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Padmé Amidala'}]-({id : '524', name: 'Natalie Portman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Anakin Skywalker'}]-({id : '17244', name: 'Hayden Christensen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Count Dooku'}]-({id : '113', name: 'Christopher Lee'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Chancellor Palpatine'}]-({id : '27762', name: 'Ian McDiarmid'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mace Windu'}]-({id : '2231', name: 'Samuel L. Jackson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dormé'}]-({id : '9827', name: 'Rose Byrne'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Yoda (Voice)'}]-({id : '7908', name: 'Frank Oz'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'C-3PO'}]-({id : '6', name: 'Anthony Daniels'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'R2-D2'}]-({id : '130', name: 'Kenny Baker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elan Sleazebaggano'}]-({id : '9374', name: 'Matt Doran'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gilramos Libkath'}]-({id : '33186', name: 'Alan Ruscoe'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cordé'}]-({id : '33187', name: 'Veronica Segura'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ki-Adi-Mundi'}]-({id : '20806', name: 'Silas Carson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Viceroy Nute Gunray'}]-({id : '20806', name: 'Silas Carson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Govenor Sio Bibble'}]-({id : '31923', name: 'Oliver Ford Davies'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dexter Jettster'}]-({id : '33188', name: 'Ron Falk'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Capt. Typho'}]-({id : '33182', name: 'Jay Lagaaia'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Senator Bail Organa'}]-({id : '33181', name: 'Jimmy Smits'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Boba Fett'}]-({id : '33189', name: 'Daniel Logan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jango Fett'}]-({id : '7242', name: 'Temuera Morrison'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Shmi Skywalker'}]-({id : '33190', name: 'Pernilla August'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Queen Jamillia'}]-({id : '33191', name: 'Ayesha Dharker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Owen Lars'}]-({id : '33192', name: 'Joel Edgerton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cliegg Lars'}]-({id : '12536', name: 'Jack Thompson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Beru'}]-({id : '131634', name: 'Bonnie Piesse'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Watto (voice)'}]-({id : '33198', name: 'Andrew Secombe'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1', name: 'George Lucas'})-[:PERSON]->people
;
{:actors=>[{:role=>"Admiral/Captain James T. Kirk", :name=>"William Shatner", :id=>1748}, {:role=>"Captain Spock", :name=>"Leonard Nimoy", :id=>1749}, {:role=>"Dr. Leonard McCoy", :name=>"DeForest Kelley", :id=>1750}, {:role=>"Montgomery Scott", :name=>"James Doohan", :id=>1751}, {:role=>"Cmdr. Hikaru Sulu", :name=>"George Takei", :id=>1752}, {:role=>"Cmdr. Pavel Chekov", :name=>"Walter Koenig", :id=>1754}, {:role=>"Cmdr. Uhura", :name=>"Nichelle Nichols", :id=>1753}, {:role=>"Amanda", :name=>"Jane Wyatt", :id=>2021}, {:role=>"Dr. Gillian Taylor", :name=>"Catherine Hicks", :id=>2022}, {:role=>"Ambassador Sarek", :name=>"Mark Lenard", :id=>1820}, {:role=>"Lt. Saavik", :name=>"Robin Curtis", :id=>1819}], :movie_id=>168, :directors=>[{:name=>"Leonard Nimoy", :id=>1749}], :tagline=>"The key to saving the future can only be found in the past.", :title=>"Star Trek IV: The Voyage Home", :released=>"1986-11-26", :genres=>["Adventure", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '168', title : 'Star Trek IV: The Voyage Home', tagline : 'The key to saving the future can only be found in the past.', released : '1986-11-26'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Admiral/Captain James T. Kirk'}]-({id : '1748', name: 'William Shatner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Spock'}]-({id : '1749', name: 'Leonard Nimoy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Leonard McCoy'}]-({id : '1750', name: 'DeForest Kelley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Montgomery Scott'}]-({id : '1751', name: 'James Doohan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Hikaru Sulu'}]-({id : '1752', name: 'George Takei'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Pavel Chekov'}]-({id : '1754', name: 'Walter Koenig'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Uhura'}]-({id : '1753', name: 'Nichelle Nichols'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Amanda'}]-({id : '2021', name: 'Jane Wyatt'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Gillian Taylor'}]-({id : '2022', name: 'Catherine Hicks'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ambassador Sarek'}]-({id : '1820', name: 'Mark Lenard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Saavik'}]-({id : '1819', name: 'Robin Curtis'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1749', name: 'Leonard Nimoy'})-[:PERSON]->people
;
{:actors=>[{:role=>"Captain Jean-Luc Picard", :name=>"Patrick Stewart", :id=>2387}, {:role=>"Commander William T. Riker", :name=>"Jonathan Frakes", :id=>2388}, {:role=>"Lt. Commander Data", :name=>"Brent Spiner", :id=>2389}, {:role=>"Lt. Commander Geordi La Forge", :name=>"LeVar Burton", :id=>2390}, {:role=>"Lt. Commander Worf", :name=>"Michael Dorn", :id=>2391}, {:role=>"Dr. Beverly Crusher", :name=>"Gates McFadden", :id=>2392}, {:role=>"Commander Deanna Troi", :name=>"Marina Sirtis", :id=>2393}, {:role=>"james", :name=>"William Shatner", :id=>1748}, {:role=>"", :name=>"James Doohan", :id=>1751}, {:role=>"", :name=>"Walter Koenig", :id=>1754}, {:role=>"Dr. Tolian Soran", :name=>"Malcolm McDowell", :id=>56890}, {:role=>"Capt. John Harriman", :name=>"Alan Ruck", :id=>2394}, {:role=>"Guinan", :name=>"Whoopi Goldberg", :id=>2395}], :movie_id=>193, :directors=>[{:name=>"David Carson", :id=>2380}], :tagline=>"Boldly go.", :title=>"Star Trek: Generations", :released=>"1994-11-18", :genres=>["Science Fiction", "Action", "Mystery"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '193', title : 'Star Trek: Generations', tagline : 'Boldly go.', released : '1994-11-18'}
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Mystery'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Captain Jean-Luc Picard'}]-({id : '2387', name: 'Patrick Stewart'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Commander William T. Riker'}]-({id : '2388', name: 'Jonathan Frakes'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Data'}]-({id : '2389', name: 'Brent Spiner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Geordi La Forge'}]-({id : '2390', name: 'LeVar Burton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Worf'}]-({id : '2391', name: 'Michael Dorn'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Beverly Crusher'}]-({id : '2392', name: 'Gates McFadden'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Commander Deanna Troi'}]-({id : '2393', name: 'Marina Sirtis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'james'}]-({id : '1748', name: 'William Shatner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : ''}]-({id : '1751', name: 'James Doohan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : ''}]-({id : '1754', name: 'Walter Koenig'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Tolian Soran'}]-({id : '56890', name: 'Malcolm McDowell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Capt. John Harriman'}]-({id : '2394', name: 'Alan Ruck'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Guinan'}]-({id : '2395', name: 'Whoopi Goldberg'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '2380', name: 'David Carson'})-[:PERSON]->people
;
{:actors=>[{:role=>"Captain Jean-Luc Picard", :name=>"Patrick Stewart", :id=>2387}, {:role=>"Commander William T. Riker", :name=>"Jonathan Frakes", :id=>2388}, {:role=>"Lt. Commander Data", :name=>"Brent Spiner", :id=>2389}, {:role=>"Lt. Commander Geordi La Forge", :name=>"LeVar Burton", :id=>2390}, {:role=>"Doctor Beverly Crusher", :name=>"Gates McFadden", :id=>2392}, {:role=>"Counselor Deanna Troi", :name=>"Marina Sirtis", :id=>2393}, {:role=>"Adhar Ruafo", :name=>"F. Murray Abraham", :id=>1164}, {:role=>"Vice-Adm. Dougherty", :name=>"Anthony Zerbe", :id=>2516}, {:role=>"Anij", :name=>"Donna Murphy", :id=>2517}, {:role=>"Gallatin", :name=>"Gregg Henry", :id=>2518}, {:role=>"Lt. Commander Worf", :name=>"Michael Dorn", :id=>2391}], :movie_id=>200, :directors=>[{:name=>"Jonathan Frakes", :id=>2388}], :tagline=>"The battle for paradise has begun.", :title=>"Star Trek: Insurrection", :released=>"1998-12-11", :genres=>["Science Fiction", "Action", "Adventure"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '200', title : 'Star Trek: Insurrection', tagline : 'The battle for paradise has begun.', released : '1998-12-11'}
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Captain Jean-Luc Picard'}]-({id : '2387', name: 'Patrick Stewart'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Commander William T. Riker'}]-({id : '2388', name: 'Jonathan Frakes'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Data'}]-({id : '2389', name: 'Brent Spiner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Geordi La Forge'}]-({id : '2390', name: 'LeVar Burton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Doctor Beverly Crusher'}]-({id : '2392', name: 'Gates McFadden'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Counselor Deanna Troi'}]-({id : '2393', name: 'Marina Sirtis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Adhar Ruafo'}]-({id : '1164', name: 'F. Murray Abraham'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Vice-Adm. Dougherty'}]-({id : '2516', name: 'Anthony Zerbe'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Anij'}]-({id : '2517', name: 'Donna Murphy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gallatin'}]-({id : '2518', name: 'Gregg Henry'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Worf'}]-({id : '2391', name: 'Michael Dorn'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '2388', name: 'Jonathan Frakes'})-[:PERSON]->people
;
{:actors=>[{:role=>"Admiral James T. Kirk", :name=>"William Shatner", :id=>1748}, {:role=>"Capt. Spock/Elevator Voice", :name=>"Leonard Nimoy", :id=>1749}, {:role=>"Dr. Leonard McCoy", :name=>"DeForest Kelley", :id=>1750}, {:role=>"Montgomery Scott", :name=>"James Doohan", :id=>1751}, {:role=>"Hikaru Sulu", :name=>"George Takei", :id=>1752}, {:role=>"Cmdr. Uhura", :name=>"Nichelle Nichols", :id=>1753}, {:role=>"Pavel Chekov", :name=>"Walter Koenig", :id=>1754}, {:role=>"Dr. David Marcus", :name=>"Merritt Butrick", :id=>1795}, {:role=>"Cmdr. Kruge", :name=>"Christopher Lloyd", :id=>1062}, {:role=>"Lt. Saavik", :name=>"Robin Curtis", :id=>1819}, {:role=>"Ambassador Sarek", :name=>"Mark Lenard", :id=>1820}, {:role=>"Spock...Age 9", :name=>"Carl Steven", :id=>1829}, {:role=>"Spock...Age 13", :name=>"Vadia Potenza", :id=>1830}, {:role=>"Spock...Age 17", :name=>"Stephen Manley", :id=>1831}, {:role=>"Spock at age 25", :name=>"Joe W. Davis", :id=>1832}, {:role=>"Vulcan High Priestess", :name=>"Judith Anderson", :id=>3362}], :movie_id=>157, :directors=>[{:name=>"Leonard Nimoy", :id=>1749}], :tagline=>"A dying planet. A fight for life. The search for Spock.", :title=>"Star Trek III: The Search for Spock", :released=>"1984-06-01", :genres=>["Adventure", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '157', title : 'Star Trek III: The Search for Spock', tagline : 'A dying planet. A fight for life. The search for Spock.', released : '1984-06-01'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Admiral James T. Kirk'}]-({id : '1748', name: 'William Shatner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Capt. Spock/Elevator Voice'}]-({id : '1749', name: 'Leonard Nimoy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Leonard McCoy'}]-({id : '1750', name: 'DeForest Kelley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Montgomery Scott'}]-({id : '1751', name: 'James Doohan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Hikaru Sulu'}]-({id : '1752', name: 'George Takei'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Uhura'}]-({id : '1753', name: 'Nichelle Nichols'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pavel Chekov'}]-({id : '1754', name: 'Walter Koenig'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. David Marcus'}]-({id : '1795', name: 'Merritt Butrick'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Kruge'}]-({id : '1062', name: 'Christopher Lloyd'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Saavik'}]-({id : '1819', name: 'Robin Curtis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ambassador Sarek'}]-({id : '1820', name: 'Mark Lenard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Spock...Age 9'}]-({id : '1829', name: 'Carl Steven'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Spock...Age 13'}]-({id : '1830', name: 'Vadia Potenza'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Spock...Age 17'}]-({id : '1831', name: 'Stephen Manley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Spock at age 25'}]-({id : '1832', name: 'Joe W. Davis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Vulcan High Priestess'}]-({id : '3362', name: 'Judith Anderson'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1749', name: 'Leonard Nimoy'})-[:PERSON]->people
;
{:actors=>[{:role=>"Captain James T. Kirk", :name=>"William Shatner", :id=>1748}, {:role=>"Mr. Spock", :name=>"Leonard Nimoy", :id=>1749}, {:role=>"Lt. Cmdr. Hikaru Sulu", :name=>"George Takei", :id=>1752}, {:role=>"Montgomery Scott", :name=>"James Doohan", :id=>1751}, {:role=>"Lt. Pavel Chekov", :name=>"Walter Koenig", :id=>1754}, {:role=>"Lt. Cmdr. Uhura", :name=>"Nichelle Nichols", :id=>1753}, {:role=>"Dr. Leonard McCoy", :name=>"DeForest Kelley", :id=>1750}, {:role=>"Dr. Christine Chapel", :name=>"Majel Barrett", :id=>1755}, {:role=>"Capt./Cmdr. Willard Decker", :name=>"Stephen Collins", :id=>1756}, {:role=>"Lieutenant Ilia", :name=>"Persis Khambatta", :id=>1757}, {:role=>"CPO Janice Rand", :name=>"Grace Lee Whitney", :id=>1759}, {:role=>"Klingon Captain", :name=>"Mark Lenard", :id=>1820}, {:role=>"Alien Boy", :name=>"Billy Van Zandt", :id=>168423}, {:role=>"Epsilon Technician", :name=>"Roger Aaron Brown", :id=>44054}, {:role=>"Airlock Technician", :name=>"Gary Faga", :id=>178145}, {:role=>"Crew Member", :name=>"Franklyn Seales", :id=>72658}], :movie_id=>152, :directors=>[{:name=>"Robert Wise", :id=>1744}], :tagline=>"The human adventure is just beginning.", :title=>"Star Trek: The Motion Picture", :released=>"1979-12-06", :genres=>["Adventure", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '152', title : 'Star Trek: The Motion Picture', tagline : 'The human adventure is just beginning.', released : '1979-12-06'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Captain James T. Kirk'}]-({id : '1748', name: 'William Shatner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mr. Spock'}]-({id : '1749', name: 'Leonard Nimoy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Cmdr. Hikaru Sulu'}]-({id : '1752', name: 'George Takei'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Montgomery Scott'}]-({id : '1751', name: 'James Doohan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Pavel Chekov'}]-({id : '1754', name: 'Walter Koenig'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Cmdr. Uhura'}]-({id : '1753', name: 'Nichelle Nichols'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Leonard McCoy'}]-({id : '1750', name: 'DeForest Kelley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Christine Chapel'}]-({id : '1755', name: 'Majel Barrett'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Capt./Cmdr. Willard Decker'}]-({id : '1756', name: 'Stephen Collins'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lieutenant Ilia'}]-({id : '1757', name: 'Persis Khambatta'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'CPO Janice Rand'}]-({id : '1759', name: 'Grace Lee Whitney'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Klingon Captain'}]-({id : '1820', name: 'Mark Lenard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Alien Boy'}]-({id : '168423', name: 'Billy Van Zandt'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Epsilon Technician'}]-({id : '44054', name: 'Roger Aaron Brown'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Airlock Technician'}]-({id : '178145', name: 'Gary Faga'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Crew Member'}]-({id : '72658', name: 'Franklyn Seales'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1744', name: 'Robert Wise'})-[:PERSON]->people
;
{:actors=>[{:role=>"Captain Jean-Luc Picard", :name=>"Patrick Stewart", :id=>2387}, {:role=>"Captain William T. Riker", :name=>"Jonathan Frakes", :id=>2388}, {:role=>"Lt. Commander Data", :name=>"Brent Spiner", :id=>2389}, {:role=>"Lt. Commander Geordi La Forge", :name=>"LeVar Burton", :id=>2390}, {:role=>"Dr. Beverly Crusher", :name=>"Gates McFadden", :id=>2392}, {:role=>"Counselor Deanna Troi-Riker", :name=>"Marina Sirtis", :id=>2393}, {:role=>"Praetor Shinzon", :name=>"Tom Hardy", :id=>2524}, {:role=>"The Reman Viceroy", :name=>"Ron Perlman", :id=>2372}, {:role=>"Senator Talaura", :name=>"Shannon Cochran", :id=>2525}, {:role=>"Commander Donatra", :name=>"Dina Meyer", :id=>2133}, {:role=>"Lt. Commander Worf", :name=>"Michael Dorn", :id=>2391}], :movie_id=>201, :directors=>[{:name=>"Stuart Baird", :id=>2523}], :tagline=>"A generation's final journey... begins.", :title=>"Star Trek: Nemesis", :released=>"2002-12-13", :genres=>["Science Fiction", "Action", "Adventure"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '201', title : 'Star Trek: Nemesis', tagline : 'A generations final journey... begins.', released : '2002-12-13'}
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Captain Jean-Luc Picard'}]-({id : '2387', name: 'Patrick Stewart'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain William T. Riker'}]-({id : '2388', name: 'Jonathan Frakes'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Data'}]-({id : '2389', name: 'Brent Spiner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Geordi La Forge'}]-({id : '2390', name: 'LeVar Burton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Beverly Crusher'}]-({id : '2392', name: 'Gates McFadden'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Counselor Deanna Troi-Riker'}]-({id : '2393', name: 'Marina Sirtis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Praetor Shinzon'}]-({id : '2524', name: 'Tom Hardy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Reman Viceroy'}]-({id : '2372', name: 'Ron Perlman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Senator Talaura'}]-({id : '2525', name: 'Shannon Cochran'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Commander Donatra'}]-({id : '2133', name: 'Dina Meyer'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Commander Worf'}]-({id : '2391', name: 'Michael Dorn'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '2523', name: 'Stuart Baird'})-[:PERSON]->people
;
{:actors=>[{:role=>"Admiral James T. Kirk", :name=>"William Shatner", :id=>1748}, {:role=>"Captain Spock", :name=>"Leonard Nimoy", :id=>1749}, {:role=>"Dr. Leonard McCoy", :name=>"DeForest Kelley", :id=>1750}, {:role=>"Montgomery Scott", :name=>"James Doohan", :id=>1751}, {:role=>"Cmdr. Hikaru Sulu", :name=>"George Takei", :id=>1752}, {:role=>"Cmdr. Uhura", :name=>"Nichelle Nichols", :id=>1753}, {:role=>"Cmdr. Pavel Chekov", :name=>"Walter Koenig", :id=>1754}, {:role=>"Khan Noonien Singh", :name=>"Ricardo Montalban", :id=>1793}, {:role=>"Dr. Carol Marcus", :name=>"Bibi Besch", :id=>1794}, {:role=>"Dr. David Marcus", :name=>"Merritt Butrick", :id=>1795}, {:role=>"Lt. Saavik", :name=>"Kirstie Alley", :id=>1796}, {:role=>"Captain Clark Terrell", :name=>"Paul Winfield", :id=>1818}], :movie_id=>154, :directors=>[{:name=>"Nicholas Meyer", :id=>1788}], :tagline=>"At the end of the universe lies the beginning of vengeance.", :title=>"Star Trek II: The Wrath of Khan", :released=>"1982-06-04", :genres=>["Adventure", "Action", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '154', title : 'Star Trek II: The Wrath of Khan', tagline : 'At the end of the universe lies the beginning of vengeance.', released : '1982-06-04'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Admiral James T. Kirk'}]-({id : '1748', name: 'William Shatner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Spock'}]-({id : '1749', name: 'Leonard Nimoy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Leonard McCoy'}]-({id : '1750', name: 'DeForest Kelley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Montgomery Scott'}]-({id : '1751', name: 'James Doohan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Hikaru Sulu'}]-({id : '1752', name: 'George Takei'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Uhura'}]-({id : '1753', name: 'Nichelle Nichols'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cmdr. Pavel Chekov'}]-({id : '1754', name: 'Walter Koenig'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Khan Noonien Singh'}]-({id : '1793', name: 'Ricardo Montalban'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Carol Marcus'}]-({id : '1794', name: 'Bibi Besch'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. David Marcus'}]-({id : '1795', name: 'Merritt Butrick'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Saavik'}]-({id : '1796', name: 'Kirstie Alley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Clark Terrell'}]-({id : '1818', name: 'Paul Winfield'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1788', name: 'Nicholas Meyer'})-[:PERSON]->people
;
{:actors=>[{:role=>"The Mad Hatter", :name=>"Johnny Depp", :id=>85}, {:role=>"The White Queen", :name=>"Anne Hathaway", :id=>1813}, {:role=>"The Red Queen", :name=>"Helena Bonham Carter", :id=>1283}, {:role=>"The Knave of Hearts", :name=>"Crispin Glover", :id=>1064}, {:role=>"Alice Kingsley", :name=>"Mia Wasikowska", :id=>76070}, {:role=>"Charles Kingsley", :name=>"Marton Csokas", :id=>20982}, {:role=>"Tweedledee / Tweedledum", :name=>"Matt Lucas", :id=>26209}, {:role=>"Helen Kingsley", :name=>"Lindsay Duncan", :id=>30083}, {:role=>"Lord Ascot", :name=>"Tim Pigott-Smith", :id=>11276}, {:role=>"Aunt Imogene", :name=>"Frances de la Tour", :id=>47468}, {:role=>"The White Rabbit (voice)", :name=>"Michael Sheen", :id=>3968}, {:role=>"The Caterpillar (voice)", :name=>"Alan Rickman", :id=>4566}, {:role=>"The Jabberwocky (voice)", :name=>"Christopher Lee", :id=>113}, {:role=>"The Cheshire Cat (voice)", :name=>"Stephen Fry", :id=>11275}, {:role=>"The Bloodhound (voice)", :name=>"Timothy Spall", :id=>9191}, {:role=>"The March Hare (voice)", :name=>"Paul Whitehouse", :id=>34900}, {:role=>"The Dormouse (voice)", :name=>"Barbara Windsor", :id=>40942}, {:role=>"The Dodo (voice)", :name=>"Michael Gough", :id=>3796}, {:role=>"Tall Flower Faces (voice)", :name=>"Imelda Staunton", :id=>11356}], :movie_id=>12155, :directors=>[{:name=>"Tim Burton", :id=>510}], :tagline=>"You've got a very important date.", :title=>"Alice in Wonderland", :released=>"2010-03-05", :genres=>["Adventure", "Fantasy", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '12155', title : 'Alice in Wonderland', tagline : 'Youve got a very important date.', released : '2010-03-05'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'The Mad Hatter'}]-({id : '85', name: 'Johnny Depp'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The White Queen'}]-({id : '1813', name: 'Anne Hathaway'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Red Queen'}]-({id : '1283', name: 'Helena Bonham Carter'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Knave of Hearts'}]-({id : '1064', name: 'Crispin Glover'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Alice Kingsley'}]-({id : '76070', name: 'Mia Wasikowska'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Charles Kingsley'}]-({id : '20982', name: 'Marton Csokas'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tweedledee / Tweedledum'}]-({id : '26209', name: 'Matt Lucas'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Helen Kingsley'}]-({id : '30083', name: 'Lindsay Duncan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lord Ascot'}]-({id : '11276', name: 'Tim Pigott-Smith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Aunt Imogene'}]-({id : '47468', name: 'Frances de la Tour'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The White Rabbit (voice)'}]-({id : '3968', name: 'Michael Sheen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Caterpillar (voice)'}]-({id : '4566', name: 'Alan Rickman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Jabberwocky (voice)'}]-({id : '113', name: 'Christopher Lee'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Cheshire Cat (voice)'}]-({id : '11275', name: 'Stephen Fry'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Bloodhound (voice)'}]-({id : '9191', name: 'Timothy Spall'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The March Hare (voice)'}]-({id : '34900', name: 'Paul Whitehouse'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Dormouse (voice)'}]-({id : '40942', name: 'Barbara Windsor'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Dodo (voice)'}]-({id : '3796', name: 'Michael Gough'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tall Flower Faces (voice)'}]-({id : '11356', name: 'Imelda Staunton'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '510', name: 'Tim Burton'})-[:PERSON]->people
;
{:actors=>[{:role=>"Captain Jack Sparrow", :name=>"Johnny Depp", :id=>85}, {:role=>"Elizabeth Swann", :name=>"Keira Knightley", :id=>116}, {:role=>"Will Turner", :name=>"Orlando Bloom", :id=>114}, {:role=>"James Norrington", :name=>"Jack Davenport", :id=>1709}, {:role=>"Davy Jones", :name=>"Bill Nighy", :id=>2440}, {:role=>"Bootstrap Bill", :name=>"Stellan Skarsg\303\245rd", :id=>1640}, {:role=>"Lord Beckett", :name=>"Tom Hollander", :id=>2441}, {:role=>"Governor Weatherby Swann", :name=>"Jonathan Pryce", :id=>378}, {:role=>"Tia Dalma", :name=>"Naomie Harris", :id=>2038}, {:role=>"Captain Barbossa", :name=>"Geoffrey Rush", :id=>118}, {:role=>"Joshamee Gibbs", :name=>"Kevin McNally", :id=>2449}, {:role=>"Pintel", :name=>"Lee Arenberg", :id=>1710}, {:role=>"Ragetti", :name=>"Mackenzie Crook", :id=>1711}, {:role=>"Cotton", :name=>"David Bailie", :id=>1715}, {:role=>"Captain Bellamy", :name=>"Alex Norton", :id=>2451}, {:role=>"Scarlet", :name=>"Lauren Maher", :id=>2450}, {:role=>"Giselle", :name=>"Vanessa Branch", :id=>2452}, {:role=>"Frightened Sailor", :name=>"Luke de Woolfson", :id=>82636}], :movie_id=>58, :directors=>[{:name=>"Gore Verbinski", :id=>1704}], :tagline=>"Jack is back!", :title=>"Pirates of the Caribbean: Dead Man's Chest", :released=>"2006-07-07", :genres=>["Adventure", "Fantasy", "Action", "Comedy", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '58', title : 'Pirates of the Caribbean: Dead Mans Chest', tagline : 'Jack is back!', released : '2006-07-07'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Captain Jack Sparrow'}]-({id : '85', name: 'Johnny Depp'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elizabeth Swann'}]-({id : '116', name: 'Keira Knightley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Will Turner'}]-({id : '114', name: 'Orlando Bloom'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'James Norrington'}]-({id : '1709', name: 'Jack Davenport'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Davy Jones'}]-({id : '2440', name: 'Bill Nighy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bootstrap Bill'}]-({id : '1640', name: 'Stellan Skarsgård'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lord Beckett'}]-({id : '2441', name: 'Tom Hollander'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Governor Weatherby Swann'}]-({id : '378', name: 'Jonathan Pryce'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tia Dalma'}]-({id : '2038', name: 'Naomie Harris'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Barbossa'}]-({id : '118', name: 'Geoffrey Rush'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Joshamee Gibbs'}]-({id : '2449', name: 'Kevin McNally'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pintel'}]-({id : '1710', name: 'Lee Arenberg'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ragetti'}]-({id : '1711', name: 'Mackenzie Crook'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cotton'}]-({id : '1715', name: 'David Bailie'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Bellamy'}]-({id : '2451', name: 'Alex Norton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Scarlet'}]-({id : '2450', name: 'Lauren Maher'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Giselle'}]-({id : '2452', name: 'Vanessa Branch'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Frightened Sailor'}]-({id : '82636', name: 'Luke de Woolfson'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1704', name: 'Gore Verbinski'})-[:PERSON]->people
;
{:actors=>[{:role=>"Jack Sparrow", :name=>"Johnny Depp", :id=>85}, {:role=>"Will Turner", :name=>"Orlando Bloom", :id=>114}, {:role=>"Elizabeth Swann", :name=>"Keira Knightley", :id=>116}, {:role=>"Captain Sao Feng", :name=>"Chow Yun-Fat", :id=>1619}, {:role=>"Barbossa", :name=>"Geoffrey Rush", :id=>118}, {:role=>"Governor Weatherby Swann", :name=>"Jonathan Pryce", :id=>378}, {:role=>"Davy Jones", :name=>"Bill Nighy", :id=>2440}, {:role=>"Lord Cutler Beckett", :name=>"Tom Hollander", :id=>2441}, {:role=>"Bootstrap Bill Turner", :name=>"Stellan Skarsg\303\245rd", :id=>1640}, {:role=>"Joshamee Gibbs", :name=>"Kevin McNally", :id=>2449}, {:role=>"Admiral James Norrington", :name=>"Jack Davenport", :id=>1709}, {:role=>"Ragetti", :name=>"Mackenzie Crook", :id=>1711}, {:role=>"Pintel", :name=>"Lee Arenberg", :id=>1710}, {:role=>"Marty", :name=>"Martin Klebba", :id=>4030}, {:role=>"Lieutenant Groves", :name=>"Greg Ellis", :id=>4031}, {:role=>"Tia Dalma", :name=>"Naomie Harris", :id=>2038}, {:role=>"Teague Sparrow", :name=>"Keith Richards", :id=>1430}], :movie_id=>285, :directors=>[{:name=>"Gore Verbinski", :id=>1704}], :tagline=>"At the end of the world, the adventure begins.", :title=>"Pirates of the Caribbean: At World's End", :released=>"2007-05-19", :genres=>["Adventure", "Fantasy", "Action", "Comedy", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '285', title : 'Pirates of the Caribbean: At Worlds End', tagline : 'At the end of the world, the adventure begins.', released : '2007-05-19'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Jack Sparrow'}]-({id : '85', name: 'Johnny Depp'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Will Turner'}]-({id : '114', name: 'Orlando Bloom'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elizabeth Swann'}]-({id : '116', name: 'Keira Knightley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Captain Sao Feng'}]-({id : '1619', name: 'Chow Yun-Fat'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Barbossa'}]-({id : '118', name: 'Geoffrey Rush'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Governor Weatherby Swann'}]-({id : '378', name: 'Jonathan Pryce'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Davy Jones'}]-({id : '2440', name: 'Bill Nighy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lord Cutler Beckett'}]-({id : '2441', name: 'Tom Hollander'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bootstrap Bill Turner'}]-({id : '1640', name: 'Stellan Skarsgård'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Joshamee Gibbs'}]-({id : '2449', name: 'Kevin McNally'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Admiral James Norrington'}]-({id : '1709', name: 'Jack Davenport'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ragetti'}]-({id : '1711', name: 'Mackenzie Crook'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pintel'}]-({id : '1710', name: 'Lee Arenberg'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Marty'}]-({id : '4030', name: 'Martin Klebba'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lieutenant Groves'}]-({id : '4031', name: 'Greg Ellis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tia Dalma'}]-({id : '2038', name: 'Naomie Harris'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Teague Sparrow'}]-({id : '1430', name: 'Keith Richards'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1704', name: 'Gore Verbinski'})-[:PERSON]->people
;
{:actors=>[{:role=>"Willy Wonka", :name=>"Johnny Depp", :id=>85}, {:role=>"Charlie Bucket", :name=>"Freddie Highmore", :id=>1281}, {:role=>"Violet Beauregarde", :name=>"AnnaSophia Robb", :id=>1285}, {:role=>"Veruca Salt", :name=>"Julia Winter", :id=>1286}, {:role=>"Grandpa Joe", :name=>"David Kelly", :id=>1282}, {:role=>"Mrs. Bucket", :name=>"Helena Bonham Carter", :id=>1283}, {:role=>"Mr. Bucket", :name=>"Noah Taylor", :id=>1284}, {:role=>"Mike Teavee", :name=>"Jordan Fry", :id=>1290}, {:role=>"Augustus Glupsch", :name=>"Philip Wiegratz", :id=>1291}, {:role=>"Mr. Salt", :name=>"James Fox", :id=>1292}, {:role=>"Mrs. Glupsch", :name=>"Franziska Troegner", :id=>1293}, {:role=>"Mrs. Beauregard", :name=>"Missi Pyle", :id=>1294}, {:role=>"Dr. Wonka", :name=>"Christopher Lee", :id=>113}, {:role=>"Oompa Loompa", :name=>"Deep Roy", :id=>1295}, {:role=>"Shopkeeper", :name=>"Oscar James", :id=>184997}], :movie_id=>118, :directors=>[{:name=>"Tim Burton", :id=>510}], :tagline=>"Willy Wonka is semi-sweet and nuts.", :title=>"Charlie and the Chocolate Factory", :released=>"2005-07-10", :genres=>["Adventure", "Fantasy", "Comedy", "Science Fiction", "Family"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '118', title : 'Charlie and the Chocolate Factory', tagline : 'Willy Wonka is semi-sweet and nuts.', released : '2005-07-10'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Willy Wonka'}]-({id : '85', name: 'Johnny Depp'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Charlie Bucket'}]-({id : '1281', name: 'Freddie Highmore'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Violet Beauregarde'}]-({id : '1285', name: 'AnnaSophia Robb'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Veruca Salt'}]-({id : '1286', name: 'Julia Winter'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Grandpa Joe'}]-({id : '1282', name: 'David Kelly'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mrs. Bucket'}]-({id : '1283', name: 'Helena Bonham Carter'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mr. Bucket'}]-({id : '1284', name: 'Noah Taylor'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mike Teavee'}]-({id : '1290', name: 'Jordan Fry'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Augustus Glupsch'}]-({id : '1291', name: 'Philip Wiegratz'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mr. Salt'}]-({id : '1292', name: 'James Fox'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mrs. Glupsch'}]-({id : '1293', name: 'Franziska Troegner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mrs. Beauregard'}]-({id : '1294', name: 'Missi Pyle'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Wonka'}]-({id : '113', name: 'Christopher Lee'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Oompa Loompa'}]-({id : '1295', name: 'Deep Roy'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Shopkeeper'}]-({id : '184997', name: 'Oscar James'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '510', name: 'Tim Burton'})-[:PERSON]->people
;
{:actors=>[{:role=>"Jack Sparrow", :name=>"Johnny Depp", :id=>85}, {:role=>"Will Turner", :name=>"Orlando Bloom", :id=>114}, {:role=>"Elizabeth Swann", :name=>"Keira Knightley", :id=>116}, {:role=>"Barbossa", :name=>"Geoffrey Rush", :id=>118}, {:role=>"Pintel", :name=>"Lee Arenberg", :id=>1710}, {:role=>"Governor Weatherby Swann", :name=>"Jonathan Pryce", :id=>378}, {:role=>"Norrington", :name=>"Jack Davenport", :id=>1709}, {:role=>"Ragetti", :name=>"Mackenzie Crook", :id=>1711}, {:role=>"Lt. Gillette", :name=>"Damian OHare", :id=>1712}, {:role=>"Murtogg", :name=>"Giles New", :id=>1713}, {:role=>"Mullroy", :name=>"Angus Barnett", :id=>1714}, {:role=>"Cotton", :name=>"David Bailie", :id=>1715}, {:role=>"Twigg", :name=>"Michael Berry Jr.", :id=>1716}, {:role=>"Bosun", :name=>"Isaac C. Singleton Jr.", :id=>1717}, {:role=>"Anamaria", :name=>"Zoe Saldana", :id=>8691}, {:role=>"Frightened Sailor", :name=>"Luke de Woolfson", :id=>82636}, {:role=>"Young Elizabeth Swann", :name=>"Lucinda Dryzek", :id=>82143}], :movie_id=>22, :directors=>[{:name=>"Gore Verbinski", :id=>1704}], :tagline=>"Prepare to be blown out of the water.", :title=>"Pirates of the Caribbean: The Curse of the Black Pearl", :released=>"2003-07-09", :genres=>["Adventure", "Fantasy", "Action", "Comedy", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '22', title : 'Pirates of the Caribbean: The Curse of the Black Pearl', tagline : 'Prepare to be blown out of the water.', released : '2003-07-09'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Jack Sparrow'}]-({id : '85', name: 'Johnny Depp'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Will Turner'}]-({id : '114', name: 'Orlando Bloom'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elizabeth Swann'}]-({id : '116', name: 'Keira Knightley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Barbossa'}]-({id : '118', name: 'Geoffrey Rush'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pintel'}]-({id : '1710', name: 'Lee Arenberg'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Governor Weatherby Swann'}]-({id : '378', name: 'Jonathan Pryce'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Norrington'}]-({id : '1709', name: 'Jack Davenport'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ragetti'}]-({id : '1711', name: 'Mackenzie Crook'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lt. Gillette'}]-({id : '1712', name: 'Damian OHare'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Murtogg'}]-({id : '1713', name: 'Giles New'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mullroy'}]-({id : '1714', name: 'Angus Barnett'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Cotton'}]-({id : '1715', name: 'David Bailie'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Twigg'}]-({id : '1716', name: 'Michael Berry Jr.'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bosun'}]-({id : '1717', name: 'Isaac C. Singleton Jr.'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Anamaria'}]-({id : '8691', name: 'Zoe Saldana'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Frightened Sailor'}]-({id : '82636', name: 'Luke de Woolfson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Young Elizabeth Swann'}]-({id : '82143', name: 'Lucinda Dryzek'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '1704', name: 'Gore Verbinski'})-[:PERSON]->people
;
{:actors=>[{:role=>"Vianne Rocher", :name=>"Juliette Binoche", :id=>1137}, {:role=>"Comte Paul de Reynaud", :name=>"Alfred Molina", :id=>658}, {:role=>"Roux", :name=>"Johnny Depp", :id=>85}, {:role=>"Caroline Clairmont", :name=>"Carrie-Anne Moss", :id=>530}, {:role=>"Armande Voizin", :name=>"Judi Dench", :id=>5309}, {:role=>"Jean-Marc Drou", :name=>"Antonio Gil", :id=>5310}, {:role=>"Francoise Drou", :name=>"H\303\251l\303\250ne Cardona", :id=>5311}, {:role=>"Pere Henri", :name=>"Hugh OConor", :id=>5312}, {:role=>"Josephine Muscat", :name=>"Lena Olin", :id=>5313}, {:role=>"Serge Muscat", :name=>"Peter Stormare", :id=>53}, {:role=>"Luc Clairmont", :name=>"Aurelien Parent Koenig", :id=>5314}, {:role=>"Anouk Rocher", :name=>"Victoire Thivisol", :id=>5315}, {:role=>"Dedou Drou", :name=>"Harrison Pratt", :id=>5316}, {:role=>"Didi Drou", :name=>"Gaelan Connell", :id=>5317}, {:role=>"Yvette Marceau", :name=>"Elisabeth Commelin", :id=>5318}, {:role=>"Alphonse Marceau", :name=>"Ron Cook", :id=>5319}, {:role=>"Madame Audel", :name=>"Leslie Caron", :id=>5320}, {:role=>"Guillaume Blerot", :name=>"John Wood", :id=>5321}], :movie_id=>392, :directors=>[{:name=>"Lasse Hallstr\303\266m", :id=>5306}], :title=>"Chocolat", :released=>"2000-12-15", :genres=>["Comedy", "Drama", "Foreign", "Romance"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '392', title : 'Chocolat', released : '2000-12-15'}
create unique movie-[:GENRE]->({genre : 'Comedy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Foreign'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Romance'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Vianne Rocher'}]-({id : '1137', name: 'Juliette Binoche'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Comte Paul de Reynaud'}]-({id : '658', name: 'Alfred Molina'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Roux'}]-({id : '85', name: 'Johnny Depp'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Caroline Clairmont'}]-({id : '530', name: 'Carrie-Anne Moss'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Armande Voizin'}]-({id : '5309', name: 'Judi Dench'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jean-Marc Drou'}]-({id : '5310', name: 'Antonio Gil'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Francoise Drou'}]-({id : '5311', name: 'Hélène Cardona'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pere Henri'}]-({id : '5312', name: 'Hugh OConor'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Josephine Muscat'}]-({id : '5313', name: 'Lena Olin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Serge Muscat'}]-({id : '53', name: 'Peter Stormare'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Luc Clairmont'}]-({id : '5314', name: 'Aurelien Parent Koenig'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Anouk Rocher'}]-({id : '5315', name: 'Victoire Thivisol'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dedou Drou'}]-({id : '5316', name: 'Harrison Pratt'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Didi Drou'}]-({id : '5317', name: 'Gaelan Connell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Yvette Marceau'}]-({id : '5318', name: 'Elisabeth Commelin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Alphonse Marceau'}]-({id : '5319', name: 'Ron Cook'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Madame Audel'}]-({id : '5320', name: 'Leslie Caron'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Guillaume Blerot'}]-({id : '5321', name: 'John Wood'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '5306', name: 'Lasse Hallström'})-[:PERSON]->people
;
{:actors=>[{:role=>"Hero Boy | Father | Conducter | Santa Clause | Scrooge | Hobo", :name=>"Tom Hanks", :id=>31}, {:role=>"Smokey", :name=>"Michael Jeter", :id=>2169}, {:role=>"Steamer", :name=>"Michael Jeter", :id=>2169}, {:role=>"Know-It-All", :name=>"Eddie Deezen", :id=>42362}, {:role=>"Toothless Boy", :name=>"Chris Coppola", :id=>23791}, {:role=>"Hero Girl", :name=>"Nona Gaye", :id=>18286}, {:role=>"Lonely Boy", :name=>"Peter Scolari", :id=>42363}, {:role=>"Elf General", :name=>"Charles Fleischer", :id=>12826}, {:role=>"Elf Lieutenant", :name=>"Steven Tyler", :id=>37935}, {:role=>"Mother", :name=>"Leslie Zemeckis", :id=>42287}, {:role=>"Red Head Girl", :name=>"Julene Renee", :id=>42286}, {:role=>"Pastry Chef", :name=>"Andy Pellick", :id=>1080274}], :movie_id=>5255, :directors=>[{:name=>"Robert Zemeckis", :id=>24}], :tagline=>"Journey Beyond Your Imagination.", :title=>"The Polar Express", :released=>"2004-11-10", :genres=>["Adventure", "Animation", "Family", "Holiday"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '5255', title : 'The Polar Express', tagline : 'Journey Beyond Your Imagination.', released : '2004-11-10'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Animation'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Family'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Holiday'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Hero Boy | Father | Conducter | Santa Clause | Scrooge | Hobo'}]-({id : '31', name: 'Tom Hanks'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Smokey'}]-({id : '2169', name: 'Michael Jeter'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Steamer'}]-({id : '2169', name: 'Michael Jeter'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Know-It-All'}]-({id : '42362', name: 'Eddie Deezen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Toothless Boy'}]-({id : '23791', name: 'Chris Coppola'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Hero Girl'}]-({id : '18286', name: 'Nona Gaye'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lonely Boy'}]-({id : '42363', name: 'Peter Scolari'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elf General'}]-({id : '12826', name: 'Charles Fleischer'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elf Lieutenant'}]-({id : '37935', name: 'Steven Tyler'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mother'}]-({id : '42287', name: 'Leslie Zemeckis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Red Head Girl'}]-({id : '42286', name: 'Julene Renee'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pastry Chef'}]-({id : '1080274', name: 'Andy Pellick'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '24', name: 'Robert Zemeckis'})-[:PERSON]->people
;
{:actors=>[{:role=>"Jim Lovell", :name=>"Tom Hanks", :id=>31}, {:role=>"Fred Haise", :name=>"Bill Paxton", :id=>2053}, {:role=>"Jack Swigert", :name=>"Kevin Bacon", :id=>4724}, {:role=>"Ken Mattingly", :name=>"Gary Sinise", :id=>33}, {:role=>"Gene Kranz", :name=>"Ed Harris", :id=>228}, {:role=>"Marilyn Lovell", :name=>"Kathleen Quinlan", :id=>8183}, {:role=>"Barbara Lovell", :name=>"Mary Kate Schellhardt", :id=>8184}, {:role=>"Susan Lovell", :name=>"Emily Ann Lloyd", :id=>8185}, {:role=>"Jeffrey Lovell", :name=>"Miko Hughes", :id=>8186}, {:role=>"Jay Lovell", :name=>"Max Elliott Slade", :id=>8187}, {:role=>"Blanch Lovell", :name=>"Jean Speegle Howard", :id=>8188}, {:role=>"Mary Haise", :name=>"Tracy Reiner", :id=>8189}, {:role=>"Pete Conrad", :name=>"David Andrews", :id=>7219}, {:role=>"Jane Conrad", :name=>"Michele Little", :id=>8190}, {:role=>"Deke Slayton", :name=>"Chris Ellis", :id=>8191}, {:role=>"NASA Director", :name=>"Joe Spano", :id=>8192}, {:role=>"Henry Hurt", :name=>"Xander Berkeley", :id=>3982}, {:role=>"Congressman", :name=>"Roger Corman", :id=>102429}], :movie_id=>568, :directors=>[{:name=>"Ron Howard", :id=>6159}], :tagline=>"Houston, we have a problem.", :title=>"Apollo 13", :released=>"1995-06-30", :genres=>["Drama", "History", "Disaster"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '568', title : 'Apollo 13', tagline : 'Houston, we have a problem.', released : '1995-06-30'}
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'History'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Disaster'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Jim Lovell'}]-({id : '31', name: 'Tom Hanks'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Fred Haise'}]-({id : '2053', name: 'Bill Paxton'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jack Swigert'}]-({id : '4724', name: 'Kevin Bacon'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Ken Mattingly'}]-({id : '33', name: 'Gary Sinise'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gene Kranz'}]-({id : '228', name: 'Ed Harris'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Marilyn Lovell'}]-({id : '8183', name: 'Kathleen Quinlan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Barbara Lovell'}]-({id : '8184', name: 'Mary Kate Schellhardt'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Susan Lovell'}]-({id : '8185', name: 'Emily Ann Lloyd'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jeffrey Lovell'}]-({id : '8186', name: 'Miko Hughes'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jay Lovell'}]-({id : '8187', name: 'Max Elliott Slade'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Blanch Lovell'}]-({id : '8188', name: 'Jean Speegle Howard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mary Haise'}]-({id : '8189', name: 'Tracy Reiner'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Pete Conrad'}]-({id : '7219', name: 'David Andrews'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jane Conrad'}]-({id : '8190', name: 'Michele Little'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Deke Slayton'}]-({id : '8191', name: 'Chris Ellis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'NASA Director'}]-({id : '8192', name: 'Joe Spano'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Henry Hurt'}]-({id : '3982', name: 'Xander Berkeley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Congressman'}]-({id : '102429', name: 'Roger Corman'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '6159', name: 'Ron Howard'})-[:PERSON]->people
;
{:actors=>[{:role=>"Judge Tate", :name=>"Roberta Maxwell", :id=>10362}, {:role=>"Crutches", :name=>"Buzz Kilman", :id=>59329}, {:role=>"Miguel Alvarez", :name=>"Antonio Banderas", :id=>3131}, {:role=>"Joe Mille", :name=>"Denzel Washington", :id=>5292}, {:role=>"Andrew Beckett", :name=>"Tom Hanks", :id=>31}, {:role=>"Dr. Gillman", :name=>"Karen Finley", :id=>568363}, {:role=>"Clinic Storyteller", :name=>"Daniel Chapman", :id=>91428}, {:role=>"Clinic Patient", :name=>"Mark Sorensen Jr.", :id=>568364}, {:role=>"Tyrone", :name=>"Jeffrey Williamson", :id=>568365}, {:role=>"Kenneth Killcoyne", :name=>"Charles Glenn", :id=>568366}, {:role=>"Bob Seidman", :name=>"Ron Vawter", :id=>32592}, {:role=>"Anthea Burton", :name=>"Anna Deavere Smith", :id=>63279}, {:role=>"Rachel Smilow", :name=>"Stephanie Roth Haberle", :id=>58539}, {:role=>"Shelby", :name=>"Lisa Talerico", :id=>568367}, {:role=>"Jamey Collins", :name=>"Bradley Whitford", :id=>11367}], :movie_id=>9800, :directors=>[{:name=>"Jonathan Demme", :id=>16294}], :title=>"Philadelphia", :released=>"1993-12-23", :genres=>["Drama", "Mystery"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '9800', title : 'Philadelphia', released : '1993-12-23'}
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Mystery'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Judge Tate'}]-({id : '10362', name: 'Roberta Maxwell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Crutches'}]-({id : '59329', name: 'Buzz Kilman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Miguel Alvarez'}]-({id : '3131', name: 'Antonio Banderas'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Joe Mille'}]-({id : '5292', name: 'Denzel Washington'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Andrew Beckett'}]-({id : '31', name: 'Tom Hanks'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dr. Gillman'}]-({id : '568363', name: 'Karen Finley'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Clinic Storyteller'}]-({id : '91428', name: 'Daniel Chapman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Clinic Patient'}]-({id : '568364', name: 'Mark Sorensen Jr.'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tyrone'}]-({id : '568365', name: 'Jeffrey Williamson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Kenneth Killcoyne'}]-({id : '568366', name: 'Charles Glenn'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bob Seidman'}]-({id : '32592', name: 'Ron Vawter'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Anthea Burton'}]-({id : '63279', name: 'Anna Deavere Smith'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Rachel Smilow'}]-({id : '58539', name: 'Stephanie Roth Haberle'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Shelby'}]-({id : '568367', name: 'Lisa Talerico'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jamey Collins'}]-({id : '11367', name: 'Bradley Whitford'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '16294', name: 'Jonathan Demme'})-[:PERSON]->people
;
{:actors=>[{:role=>"Paul Edgecomb", :name=>"Tom Hanks", :id=>31}, {:role=>"John Coffey", :name=>"Michael Clarke Duncan", :id=>61981}, {:role=>"Jan Edgecomb", :name=>"Bonnie Hunt", :id=>5149}, {:role=>"Brutus Brutal Howell", :name=>"David Morse", :id=>52}, {:role=>"Eduard Delacroix", :name=>"Michael Jeter", :id=>2169}, {:role=>"Arlen Bitterbuck", :name=>"Graham Greene", :id=>6804}, {:role=>"Melinda Moores", :name=>"Patricia Clarkson", :id=>1276}, {:role=>"Old Paul Edgecomb", :name=>"Dabbs Greer", :id=>6805}, {:role=>"Lawyer Burt Hammersmith", :name=>"Gary Sinise", :id=>33}, {:role=>"Percy Wetmore", :name=>"Doug Hutchison", :id=>6806}, {:role=>"Wild Bill Wharton", :name=>"Sam Rockwell", :id=>6807}, {:role=>"Warden Hal Moores", :name=>"James Cromwell", :id=>2505}, {:role=>"Dean Stanton", :name=>"Barry Pepper", :id=>12834}], :movie_id=>497, :directors=>[{:name=>"Frank Darabont", :id=>4027}], :tagline=>"Miracles do happen.", :title=>"The Green Mile", :released=>"1999-12-06", :genres=>["Fantasy", "Drama", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '497', title : 'The Green Mile', tagline : 'Miracles do happen.', released : '1999-12-06'}
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Paul Edgecomb'}]-({id : '31', name: 'Tom Hanks'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'John Coffey'}]-({id : '61981', name: 'Michael Clarke Duncan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Jan Edgecomb'}]-({id : '5149', name: 'Bonnie Hunt'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Brutus Brutal Howell'}]-({id : '52', name: 'David Morse'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Eduard Delacroix'}]-({id : '2169', name: 'Michael Jeter'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Arlen Bitterbuck'}]-({id : '6804', name: 'Graham Greene'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Melinda Moores'}]-({id : '1276', name: 'Patricia Clarkson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Old Paul Edgecomb'}]-({id : '6805', name: 'Dabbs Greer'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lawyer Burt Hammersmith'}]-({id : '33', name: 'Gary Sinise'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Percy Wetmore'}]-({id : '6806', name: 'Doug Hutchison'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Wild Bill Wharton'}]-({id : '6807', name: 'Sam Rockwell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Warden Hal Moores'}]-({id : '2505', name: 'James Cromwell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Dean Stanton'}]-({id : '12834', name: 'Barry Pepper'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '4027', name: 'Frank Darabont'})-[:PERSON]->people
;
{:actors=>[{:role=>"L\303\251on", :name=>"Jean Reno", :id=>1003}, {:role=>"Mathilda", :name=>"Natalie Portman", :id=>524}, {:role=>"Tony", :name=>"Danny Aiello", :id=>1004}, {:role=>"Stansfield", :name=>"Gary Oldman", :id=>64}, {:role=>"Malky", :name=>"Peter Appel", :id=>1005}, {:role=>"1st Stansfield man", :name=>"Willi One Blood", :id=>1006}, {:role=>"3 rd Stansfield man", :name=>"Keith A. Glascoe", :id=>1008}, {:role=>"2nd Stansfield man", :name=>"Don Creech", :id=>1007}, {:role=>"Mathildas Father", :name=>"Michael Badalucco", :id=>1010}], :movie_id=>101, :directors=>[{:name=>"Luc Besson", :id=>59}], :tagline=>"If you want a job done well, hire a professional.", :title=>"Leon: The Professional", :released=>"1994-11-18", :genres=>["Action", "Thriller", "Crime", "Foreign"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '101', title : 'Leon: The Professional', tagline : 'If you want a job done well, hire a professional.', released : '1994-11-18'}
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Thriller'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Crime'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Foreign'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Léon'}]-({id : '1003', name: 'Jean Reno'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mathilda'}]-({id : '524', name: 'Natalie Portman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Tony'}]-({id : '1004', name: 'Danny Aiello'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Stansfield'}]-({id : '64', name: 'Gary Oldman'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Malky'}]-({id : '1005', name: 'Peter Appel'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : '1st Stansfield man'}]-({id : '1006', name: 'Willi One Blood'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : '3 rd Stansfield man'}]-({id : '1008', name: 'Keith A. Glascoe'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : '2nd Stansfield man'}]-({id : '1007', name: 'Don Creech'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mathildas Father'}]-({id : '1010', name: 'Michael Badalucco'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '59', name: 'Luc Besson'})-[:PERSON]->people
;
{:actors=>[{:role=>"Frodo Baggins", :name=>"Elijah Wood", :id=>109}, {:role=>"Gandalf the Grey", :name=>"Ian McKellen", :id=>1327}, {:role=>"Aragorn", :name=>"Viggo Mortensen", :id=>110}, {:role=>"Arwen Evenstar", :name=>"Liv Tyler", :id=>882}, {:role=>"Legolas", :name=>"Orlando Bloom", :id=>114}, {:role=>"Gimli", :name=>"John Rhys-Davies", :id=>655}, {:role=>"Boromir", :name=>"Sean Bean", :id=>48}, {:role=>"Saruman", :name=>"Christopher Lee", :id=>113}, {:role=>"Samwise Sam Gamgee", :name=>"Sean Astin", :id=>1328}, {:role=>"Peregrin Pippin Took", :name=>"Billy Boyd", :id=>1329}, {:role=>"Meriadoc Merry Brandybuck", :name=>"Dominic Monaghan", :id=>1330}, {:role=>"Elrond", :name=>"Hugo Weaving", :id=>1331}, {:role=>"Galadriel", :name=>"Cate Blanchett", :id=>112}, {:role=>"Bilbo Baggins", :name=>"Ian Holm", :id=>65}, {:role=>"Haldir", :name=>"Craig Parker", :id=>1332}, {:role=>"Lurtz", :name=>"Lawrence Makoare", :id=>1365}, {:role=>"Sauron", :name=>"Sala Baker", :id=>1366}, {:role=>"The Ring (voice)", :name=>"Alan Howard", :id=>1367}, {:role=>"Gollum", :name=>"Andy Serkis", :id=>1333}, {:role=>"Rose Rosie Cotton", :name=>"Sarah McLeod", :id=>965278}], :movie_id=>120, :directors=>[{:name=>"Peter Jackson", :id=>108}], :tagline=>"One ring to rule them all", :title=>"The Lord of the Rings: The Fellowship of the Ring", :released=>"2001-12-19", :genres=>["Adventure", "Fantasy", "Action", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '120', title : 'The Lord of the Rings: The Fellowship of the Ring', tagline : 'One ring to rule them all', released : '2001-12-19'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Frodo Baggins'}]-({id : '109', name: 'Elijah Wood'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gandalf the Grey'}]-({id : '1327', name: 'Ian McKellen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Aragorn'}]-({id : '110', name: 'Viggo Mortensen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Arwen Evenstar'}]-({id : '882', name: 'Liv Tyler'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Legolas'}]-({id : '114', name: 'Orlando Bloom'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gimli'}]-({id : '655', name: 'John Rhys-Davies'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Boromir'}]-({id : '48', name: 'Sean Bean'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Saruman'}]-({id : '113', name: 'Christopher Lee'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Samwise Sam Gamgee'}]-({id : '1328', name: 'Sean Astin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Peregrin Pippin Took'}]-({id : '1329', name: 'Billy Boyd'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Meriadoc Merry Brandybuck'}]-({id : '1330', name: 'Dominic Monaghan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elrond'}]-({id : '1331', name: 'Hugo Weaving'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Galadriel'}]-({id : '112', name: 'Cate Blanchett'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bilbo Baggins'}]-({id : '65', name: 'Ian Holm'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Haldir'}]-({id : '1332', name: 'Craig Parker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Lurtz'}]-({id : '1365', name: 'Lawrence Makoare'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Sauron'}]-({id : '1366', name: 'Sala Baker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'The Ring (voice)'}]-({id : '1367', name: 'Alan Howard'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gollum'}]-({id : '1333', name: 'Andy Serkis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Rose Rosie Cotton'}]-({id : '965278', name: 'Sarah McLeod'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '108', name: 'Peter Jackson'})-[:PERSON]->people
;
{:actors=>[{:role=>"Frodo Baggins", :name=>"Elijah Wood", :id=>109}, {:role=>"Gandalf the White", :name=>"Ian McKellen", :id=>1327}, {:role=>"Aragorn", :name=>"Viggo Mortensen", :id=>110}, {:role=>"Arwen Evenstar", :name=>"Liv Tyler", :id=>882}, {:role=>"Legolas", :name=>"Orlando Bloom", :id=>114}, {:role=>"Gimli", :name=>"John Rhys-Davies", :id=>655}, {:role=>"Saruman", :name=>"Christopher Lee", :id=>113}, {:role=>"Sam Gamgee", :name=>"Sean Astin", :id=>1328}, {:role=>"Peregrin Pippin Took", :name=>"Billy Boyd", :id=>1329}, {:role=>"Meriadoc Merry Brandybuck", :name=>"Dominic Monaghan", :id=>1330}, {:role=>"Elrond", :name=>"Hugo Weaving", :id=>1331}, {:role=>"Haldir", :name=>"Craig Parker", :id=>1332}, {:role=>"Th\303\251oden", :name=>"Bernard Hill", :id=>1369}, {:role=>"Gollum", :name=>"Andy Serkis", :id=>1333}, {:role=>"Gr\303\255ma Wormtongue", :name=>"Brad Dourif", :id=>1370}, {:role=>"\303\211owyn", :name=>"Miranda Otto", :id=>502}, {:role=>"Faramir", :name=>"David Wenham", :id=>1371}, {:role=>"\303\211omer", :name=>"Karl Urban", :id=>1372}, {:role=>"Galadriel", :name=>"Cate Blanchett", :id=>112}], :movie_id=>121, :directors=>[{:name=>"Peter Jackson", :id=>108}], :tagline=>"A New Power Is Rising.", :title=>"The Lord of the Rings: The Two Towers", :released=>"2002-12-18", :genres=>["Adventure", "Fantasy", "Action", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '121', title : 'The Lord of the Rings: The Two Towers', tagline : 'A New Power Is Rising.', released : '2002-12-18'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Frodo Baggins'}]-({id : '109', name: 'Elijah Wood'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gandalf the White'}]-({id : '1327', name: 'Ian McKellen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Aragorn'}]-({id : '110', name: 'Viggo Mortensen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Arwen Evenstar'}]-({id : '882', name: 'Liv Tyler'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Legolas'}]-({id : '114', name: 'Orlando Bloom'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gimli'}]-({id : '655', name: 'John Rhys-Davies'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Saruman'}]-({id : '113', name: 'Christopher Lee'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Sam Gamgee'}]-({id : '1328', name: 'Sean Astin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Peregrin Pippin Took'}]-({id : '1329', name: 'Billy Boyd'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Meriadoc Merry Brandybuck'}]-({id : '1330', name: 'Dominic Monaghan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elrond'}]-({id : '1331', name: 'Hugo Weaving'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Haldir'}]-({id : '1332', name: 'Craig Parker'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Théoden'}]-({id : '1369', name: 'Bernard Hill'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gollum'}]-({id : '1333', name: 'Andy Serkis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gríma Wormtongue'}]-({id : '1370', name: 'Brad Dourif'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Éowyn'}]-({id : '502', name: 'Miranda Otto'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Faramir'}]-({id : '1371', name: 'David Wenham'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Éomer'}]-({id : '1372', name: 'Karl Urban'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Galadriel'}]-({id : '112', name: 'Cate Blanchett'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '108', name: 'Peter Jackson'})-[:PERSON]->people
;
{:actors=>[{:role=>"Frodo Baggins", :name=>"Elijah Wood", :id=>109}, {:role=>"Gandalf the White", :name=>"Ian McKellen", :id=>1327}, {:role=>"Aragorn", :name=>"Viggo Mortensen", :id=>110}, {:role=>"Arwen Evenstar", :name=>"Liv Tyler", :id=>882}, {:role=>"Legolas", :name=>"Orlando Bloom", :id=>114}, {:role=>"Gimli & Treebeard (Voice)", :name=>"John Rhys-Davies", :id=>655}, {:role=>"Sam Gamgee", :name=>"Sean Astin", :id=>1328}, {:role=>"Peregrin Pippin Took", :name=>"Billy Boyd", :id=>1329}, {:role=>"Meriadoc Merry Brandybuck", :name=>"Dominic Monaghan", :id=>1330}, {:role=>"Elrond", :name=>"Hugo Weaving", :id=>1331}, {:role=>"Th\303\251oden, King of Rohan", :name=>"Bernard Hill", :id=>1369}, {:role=>"Gollum", :name=>"Andy Serkis", :id=>1333}, {:role=>"\303\211owyn", :name=>"Miranda Otto", :id=>502}, {:role=>"Faramir", :name=>"David Wenham", :id=>1371}, {:role=>"\303\211omer", :name=>"Karl Urban", :id=>1372}, {:role=>"Denethor", :name=>"John Noble", :id=>1381}, {:role=>"Bilbo Baggins", :name=>"Ian Holm", :id=>65}, {:role=>"Galadriel", :name=>"Cate Blanchett", :id=>112}, {:role=>"Gothmog & Witchking of Angmar", :name=>"Lawrence Makoare", :id=>1365}, {:role=>"King of the Dead", :name=>"Paul Norell", :id=>1382}, {:role=>"Deagol", :name=>"Thomas Robins", :id=>1383}, {:role=>"Mercenary On Boat", :name=>"Peter Jackson", :id=>108}, {:role=>"Rosie Cotton", :name=>"Sarah McLeod", :id=>965278}], :movie_id=>122, :directors=>[{:name=>"Peter Jackson", :id=>108}], :tagline=>"The eye of the enemy is moving.", :title=>"The Lord of the Rings: The Return of the King", :released=>"2003-12-17", :genres=>["Adventure", "Fantasy", "Drama", "Action", "Science Fiction"]}
start root=node(0)
match
root-[:GENRES]->genres,
root-[:MOVIES]->movies,
root-[:PEOPLE]->people
create movie={movie_id : '122', title : 'The Lord of the Rings: The Return of the King', tagline : 'The eye of the enemy is moving.', released : '2003-12-17'}
create unique movie-[:GENRE]->({genre : 'Adventure'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Fantasy'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Drama'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Action'})-[:GENRE]->genres
create unique movie-[:GENRE]->({genre : 'Science Fiction'})-[:GENRE]->genres create unique movie<-[:ACTS_IN {role : 'Frodo Baggins'}]-({id : '109', name: 'Elijah Wood'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gandalf the White'}]-({id : '1327', name: 'Ian McKellen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Aragorn'}]-({id : '110', name: 'Viggo Mortensen'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Arwen Evenstar'}]-({id : '882', name: 'Liv Tyler'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Legolas'}]-({id : '114', name: 'Orlando Bloom'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gimli & Treebeard (Voice)'}]-({id : '655', name: 'John Rhys-Davies'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Sam Gamgee'}]-({id : '1328', name: 'Sean Astin'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Peregrin Pippin Took'}]-({id : '1329', name: 'Billy Boyd'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Meriadoc Merry Brandybuck'}]-({id : '1330', name: 'Dominic Monaghan'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Elrond'}]-({id : '1331', name: 'Hugo Weaving'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Théoden, King of Rohan'}]-({id : '1369', name: 'Bernard Hill'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gollum'}]-({id : '1333', name: 'Andy Serkis'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Éowyn'}]-({id : '502', name: 'Miranda Otto'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Faramir'}]-({id : '1371', name: 'David Wenham'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Éomer'}]-({id : '1372', name: 'Karl Urban'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Denethor'}]-({id : '1381', name: 'John Noble'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Bilbo Baggins'}]-({id : '65', name: 'Ian Holm'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Galadriel'}]-({id : '112', name: 'Cate Blanchett'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Gothmog & Witchking of Angmar'}]-({id : '1365', name: 'Lawrence Makoare'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'King of the Dead'}]-({id : '1382', name: 'Paul Norell'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Deagol'}]-({id : '1383', name: 'Thomas Robins'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Mercenary On Boat'}]-({id : '108', name: 'Peter Jackson'})-[:PERSON]->people
create unique movie<-[:ACTS_IN {role : 'Rosie Cotton'}]-({id : '965278', name: 'Sarah McLeod'})-[:PERSON]->people
create unique movie<-[:DIRECTS]-({id : '108', name: 'Peter Jackson'})-[:PERSON]->people
;
commit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment