Neo4j 之西游记取经团队人物创建和关系设置

Myth丶恋晨 2023-07-12 05:11 3阅读 0赞

以西游记小说为为例子

# 创建 #

## 创建带属性的人物节点 ##

创建取经团队的人物，包含名称和年龄属性

CREATE (xyj_tsz:X_Person{name:"唐三藏",age:39})
    CREATE (xyj_swk:X_Person{name:"孙悟空",age:520})
    CREATE (xyj_zbj:X_Person{name:"猪八戒",age:512})
    CREATE (xyj_swj:X_Person{name:"沙悟净",age:444})

## 创建人物之间的关系 ##

创建团队人物之间的关系，师傅和师兄弟

MATCH (a:X_Person),(b:X_Person)
    WHERE a.name = '唐三藏' AND (b.name = '猪八戒' or b.name ='沙悟净')
    CREATE (a)-[r:师傅] -> (b)
    RETURN r
    
    MATCH (a:X_Person),(b:X_Person)
    WHERE a.name = '孙悟空' AND (b.name = '猪八戒' or b.name ='沙悟净')
    CREATE (a)-[r:师兄] -> (b)
    RETURN r
    
    MATCH (a:X_Person),(b:X_Person)
    WHERE a.name = '猪八戒' AND (b.name ='沙悟净')
    CREATE (a)-[r:师兄] -> (b)
    RETURN r

## 创建他们的武器 ##

CREATE (xyj_wuqi:X_Wuqi{name:"金箍棒",age:10000})
    CREATE (xyj_wuqi:X_Wuqi{name:"九齿钉耙",age:2000})
    CREATE (xyj_wuqi:X_Wuqi{name:"禅杖",age:50000})

## 创建人物和武器的关系 ##

match (a: X_Person),(b:X_Wuqi)
    where a.name = '孙悟空' and b.name = '金箍棒'
    create (a) -[r: has] -> (b)
    return r;
    
    match (a: X_Person),(b:X_Wuqi)
    where a.name = '沙悟净' and b.name = '禅杖'
    create (a) -[r: has] -> (b)
    return r;
    
    match (a: X_Person),(b:X_Wuqi)
    where a.name = '猪八戒' and b.name = '九齿钉耙'
    create (a) -[r: has] -> (b)
    return r;

# 查询 #

## 查询所有人的武器 ##

match (a:X_Person) -[r:has] ->(b:X_Wuqi) return a,b

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70]

## 查询孙悟空有什么武器 ##

match (a:X_Person) -[r:has] ->(b:X_Wuqi) where a.name = '孙悟空' return a,b

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70 1]

创建道教和佛教

CREATE (xyj_DaoTong:X_DaoTong{name:"佛教",age:9999999})
    CREATE (xyj_DaoTong:X_DaoTong{name:"道教",age:9999999})

创建佛教几个角色

CREATE (xyj_Fo:X_Fo{name:"如来佛祖",age:9999999})
    CREATE (xyj_Fo:X_Fo{name:"观音菩萨",age:99999})
    CREATE (xyj_Fo:X_Fo{name:"观音菩萨",age:99999})
    CREATE (xyj_Fo:X_Fo{name:"普贤菩萨",age:99999})
    CREATE (xyj_Fo:X_Fo{name:"孔雀明王",age:99999})

创建佛教的角色属于佛教的关系

match (a: X_Fo),(b:X_DaoTong)
    where b.name ='佛教'
    create (a) -[r: belong_to] -> (b)
    return r;

同样创建道教任务和角色，建立关系

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70 2]

根据创建节点和关系，创建了下面的所有实体和关系。

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70 3]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200307102250981.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200307102036469.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2020030711013428.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200307142906499.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pocTQyNg==,size_16,color_FFFFFF,t_70