Neo4j-电影图谱

电影图谱

–创建节点

CREATE

(m1:movie {name:'国产凌凌漆',pubyear:1994,info:'周星驰、袁咏仪'}),

(m2:movie {name:'破坏之王',pubyear:1994,info:'周星驰、钟丽缇'}),

(m3:movie {name:'大内密探零零发',pubyear:1996,info:'周星驰、刘嘉玲、李若彤'}),

(m4:movie {name:'食神',pubyear:1996,info:'周星驰、莫文蔚'}),

(m5:movie {name:'喜剧之王',pubyear:1999,info:'周星驰、张柏芝、莫文蔚'}),

(m6:movie {name:'少林足球',pubyear:2001,info:'周星驰、赵薇、吴孟达'}),

(m7:movie {name:'功夫',pubyear:2004,info:'周星驰、黄圣依'}),

(m8:movie {name:'长江7号',pubyear:2008,info:'周星驰、徐娇、张雨绮'}),

(m9:movie {name:'西游降魔篇',pubyear:2013,info:'文章、舒淇、黄渤'}),

(m10:movie {name:'美人鱼',pubyear:2016,info:'邓超、林允、张雨绮、罗志祥'}),

(m11:movie {name:'新喜剧之王',pubyear:2019,info:'王宝强、鄂靖文'}),

(m12:movie {name:'美人鱼2',pubyear:2020,info:'林允'}),


(p1:Person {name:'周星驰',birth:'中国', age:58}),

(p2:Person {name:'邓超',birth:'中国', age:45}),

(p3:Person {name:'罗志祥',birth:'中国', age:40}),

(p4:Person {name:'张雨绮',birth:'中国', age:32}),

(p5:Person {name:'林允',birth:'中国', age:20}),

(p6:Person {name:'徐克',birth:'中国', age:60}),

(p7:Person {name:'吴亦凡',birth:'新加坡', age:26}),


(p1)-[:导演]->(m1),

(p1)-[:导演]->(m2),

(p1)-[:导演]->(m3),

(p1)-[:导演]->(m4),

(p1)-[:导演]->(m5),

(p1)-[:导演]->(m6),

(p1)-[:导演]->(m7),

(p1)-[:导演]->(m8),

(p1)-[:导演]->(m9),

(p1)-[:导演]->(m10),

(p1)-[:导演]->(m11),

(p1)-[:导演]->(m12),

(p2)-[:参演]->(m10),

(p3)-[:参演]->(m10),

(p4)-[:参演]->(m10),

(p5)-[:参演]->(m10),

(p6)-[:参演]->(m10),

(p7)-[:参演]->(m10)

return *

–查询所有电影

MATCH (x:movie) RETURN x

–查询所有演员

MATCH (y:Person) RETURN y

–查找食神的电影

MATCH (x:movie) WHERE x.name= "食神" RETURN x

–查询电影在2018-2020上映的电影

MATCH (x:movie) WHERE x.pubyear>= 2018 and x.pubyear <= 2020 RETURN x.name

–查询所有参与美人鱼的演员

MATCH (y:Person)-[:参演]->(x:movie {name: "美人鱼"}) RETURN x,y

–查询周星驰导演的所有电影

MATCH (y:Person {name: "周星驰"})-[:导演]->(movie) RETURN y,movie

–查询所有人和电影的关系

MATCH (Person)-[:参演]->(movie) RETURN movie,Person

MATCH (Person)-[:导演]->(movie) RETURN movie,Person

–新增属性关系

MATCH (x:movie),(y:Person)

WHERE x.name="美人鱼2" and y.name="林允"

CREATE (y)-[:参演]->(x)

–查询林允参演过的电影

MATCH (y:Person {name: "林允"})-[:参演]->(movie) RETURN y,movie

–删除节点

MATCH (x:movie) DELETE x

MATCH (y:Person) DELETE y

–删除节点个关系

MATCH (x:movie)-[r]-(y:Person) RETURN r

MATCH (x:movie)-[r]-(y:Person) DELETE x,y,r