CQL随记

• 如果不存在则创建

MERGE (trg0:DataSource {name:'gdm.gdm_cus_tag_di', date:'20200628', type:'TABLE'})

• 批量创建

MERGE (trg0:DataSource {name:'a', date:'20200628', type:'TABLE'})
MERGE (trg1:DataSource {name:'b', date:'20200628', type:'TABLE'})
MERGE (trg2:DataSource {name:'c', date:'20200628', type:'TABLE'})
......

重复写即可

• 创建时如果存在则... 不存在则...

merge (trg0:DataSource {name:'a', type:'table'})
on create set trg0.create_ts=15885454354 --如果不存在
on match set trg0.update_ts=15885498999 --如果存在
......

批量创建重复写即可

• 批量创建Relation

MATCH (src0:DataSource{name:'fdm.fdm_cms_subgame_public_da', date:'20200628'})
MATCH (src1:DataSource{name:'gdm.gdm_cus_signup_di', date:'20200628'})
MATCH (trg6:DataSource{name:'gdm.gdm_cus_tag_di', date:'20200628'}) 
WITH src0,src1,trg6
MERGE (src1)-[r0:DATA_GOTO{type:'PROJECTION'}]->(trg6)
MERGE (src0)-[r1:DATA_GOTO{type:'PROJECTION'}]->(trg6)

• 删除节点以及与之相关的所有关系

MATCH (n:BC_Person)-[r]-() DELETE n,r