cypher neo4j 简单的增删改查

ゞ浴缸里的玫瑰 2023-10-02 13:50 9阅读 0赞

>     CREATE (n:User { name: '胡汉三', desc: '组长' }) return n;
>     
>     CREATE (n:User { name: '杨金水', desc: '老板' }) return n;
>     
>     CREATE (n:User { name: '刘武宗', desc: '组员' }) return n;
>     
>     CREATE (n:User { name: '龙追风', desc: '组员' }) return n;
>     
>     CREATE (n:User { name: '林梓阳', desc: '组员' }) return n;
>     CREATE (n:User { name: '王鼎文', desc: '组员' }) return n;
>     
>     
>     CREATE (n:perTask { title: '讨论会记录',type:'周任务' }) return n;
>     CREATE (n:perTask { title: '语雀上撰写使用说明书',type:'周任务' }) return n;
>     CREATE (n:perTask { title: '日报反馈',type:'日任务' }) return n;
>     CREATE (n:perTask { title: 'bug记录',type:'日任务' }) return n;
>     CREATE (n:perTask { title: '每日参与讨论会',type:'日任务' }) return n;
>     CREATE (n:perTask { title: '京东店铺好评',type:'月任务' }) return n;
>     
>     
>     
>     
>     
>     
>     
>     match(n:User{name:"杨金水"}),(m:perTask{title:"京东店铺好评"}) create (n)-[r:负责]->(m) return r;
>     match(n:User{name:"杨金水"}),(m:perTask{title:"讨论会记录"}) create (m)-[r:抄送]->(n) return r;
>     match(n:User{name:"杨金水"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (m)-[r:抄送]->(n) return r;
>     match(n:User{name:"杨金水"}),(m:perTask{title:"日报反馈"}) create (m)-[r:抄送]->(n) return r;
>     match(n:User{name:"杨金水"}),(m:perTask{title:"bug记录"}) create (m)-[r:抄送]->(n) return r;
>     match(n:User{name:"杨金水"}),(m:perTask{title:"每日参与讨论会"}) create (m)-[r:抄送]->(n) return r;
>     
>     
>     match(n:User{name:"龙追风"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"龙追风"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"龙追风"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"龙追风"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"龙追风"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;
>     
>     match(n:User{name:"刘武宗"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"刘武宗"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"刘武宗"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"刘武宗"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"刘武宗"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;
>     
>     match(n:User{name:"林梓阳"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"林梓阳"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"林梓阳"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"林梓阳"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"林梓阳"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;
>     
>     match(n:User{name:"王鼎文"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"王鼎文"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"王鼎文"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"王鼎文"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"王鼎文"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;
>     
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"日报反馈"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"bug记录"}) create (n)-[r:执行]->(m) return r;
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"每日参与讨论会"}) create (n)-[r:执行]->(m) return r;
>     
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"讨论会记录"}) create (n)-[r:负责]->(m) return r;
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"语雀上撰写使用说明书"}) create (n)-[r:负责]->(m) return r;
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"日报反馈"}) create (n)-[r:负责]->(m) return r;
>     match(n:User{name:"胡汉三"}),(m:perTask{title:"bug记录"}) create (n)-[r:负责]->(m) return r;
>     
>     
>     match(n:User{name:"杨金水"}),(m:User{name:"刘武宗"}) create (n)-[r:老板]->(m) return r;
>     match(n:User{name:"杨金水"}),(m:User{name:"龙追风"}) create (n)-[r:老板]->(m) return r;
>     match(n:User{name:"杨金水"}),(m:User{name:"林梓阳"}) create (n)-[r:老板]->(m) return r;
>     match(n:User{name:"杨金水"}),(m:User{name:"胡汉三"}) create (n)-[r:老板]->(m) return r;
>     match(n:User{name:"杨金水"}),(m:User{name:"王鼎文"}) create (n)-[r:老板]->(m) return r;
>     
>     
>     //删除关系
>     MATCH (n:User{name:"杨金水"})-[r:老板]-(m:User{name:"胡汉三"})  DELETE r
>     
>     //删除所以数据
>     match (n) detach delete n
>     
>     
>     //查找所有数据
>     match(n) return n
>     
>     
>     //查询某人负责的任务
>     match (n:User{name:"胡汉三"})-[:负责]->(perTask) return n,perTask
>     
>     //查询某人执行的任务
>     match (n:User{name:"胡汉三"})-[:执行]->(perTask) return n,perTask
>     
>     //查询抄送某人的任务
>     match (n:User{name:"胡汉三"})-[:抄送]->(perTask) return n,perTask
>     
>     //查询所有与某人相关的任务
>     match (n:User{name:"杨金水"})-[:负责|执行|抄送]->(perTask) return n,perTask
>     match(n:User {name:"胡汉三"})-[*]->(m:perTask) return n,m
>     
>     
>     //查询一个任务谁在参与执行
>     match(n:User)-[:执行]->(m:perTask {title:"京东店铺好评"}) return n,m
>     
>     //查询某人负责的任务谁在执行
>     MATCH (a:User {name : '胡汉三'})-[:负责]->(m)<-[:执行]-(b:User) return m,b
>     
>     
>     //查询某人负责的任务谁在执行
>     MATCH (a:User {name : '胡汉三'})-[:负责]->(m)<-[:执行]-(b:User) return m,b

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6L275bCYw5c_size_20_color_FFFFFF_t_70_g_se_x_16][]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6L275bCYw5c_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/6896fed4e4bd4de38282ca3276369138.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6L275bCYw5c=,size_20,color_FFFFFF,t_70,g_se,x_16