apoc.import.file.enabled=true
apoc.import.file.use_neo4j_config=false

# A comma separated list of procedures and user defined functions that are allowed
# full access to the database through unsupported/insecure internal APIs.
dbms.security.procedures.unrestricted=my.extensions.example,my.procedures.*,jwt.security.*,apoc.*,tabby.*

# A comma separated list of procedures to be loaded by default.
# Leaving this unconfigured will load all procedures found.
dbms.security.procedures.allowlist=apoc.*,tabby.*

CREATE CONSTRAINT c1 IF NOT EXISTS FOR (c:Class) REQUIRE c.ID IS UNIQUE;
CREATE CONSTRAINT c2 IF NOT EXISTS FOR (c:Class) REQUIRE c.NAME IS UNIQUE;
CREATE CONSTRAINT c3 IF NOT EXISTS FOR (m:Method) REQUIRE m.ID IS UNIQUE;
CREATE CONSTRAINT c4 IF NOT EXISTS FOR (m:Method) REQUIRE m.SIGNATURE IS UNIQUE;
CREATE INDEX index1 IF NOT EXISTS FOR (m:Method) ON (m.NAME);
CREATE INDEX index2 IF NOT EXISTS FOR (m:Method) ON (m.CLASSNAME);
CREATE INDEX index3 IF NOT EXISTS FOR (m:Method) ON (m.NAME, m.CLASSNAME);
CREATE INDEX index4 IF NOT EXISTS FOR (m:Method) ON (m.NAME, m.NAME0);
CREATE INDEX index5 IF NOT EXISTS FOR (m:Method) ON (m.SIGNATURE);
CREATE INDEX index6 IF NOT EXISTS FOR (m:Method) ON (m.NAME0);
CREATE INDEX index7 IF NOT EXISTS FOR (m:Method) ON (m.NAME0, m.CLASSNAME);
:schema //查看表库
:sysinfo //查看数据库信息

CALL apoc.help('all')
CALL tabby.help('tabby')

match (movie:Movie) where movie.rating > 7 return movie.title

// 节点用圆括号表示
(n)           // 一个节点，变量名为n
(person)      // 一个节点，变量名为person
(:Person)     // 一个带标签Person的节点，没有变量名
(p:Person)    // 一个带标签Person的节点，变量名为p

// 关系用方括号表示，在两个节点之间
-[r]->        // 有向关系，变量名为r
-[:KNOWS]->   // 有向关系，类型为KNOWS
-[k:KNOWS]->  // 有向关系，类型为KNOWS，变量名为k
-[]-          // 无向关系

// 基本匹配
MATCH (n:Person)                    // 找所有Person标签的节点
MATCH (p:Person {name: "Alice"})    // 找name属性为Alice的Person节点
MATCH (p:Person)-[:KNOWS]->(f)      // 找Person认识的所有人

//where 条件过滤
MATCH (p:Person)
WHERE p.age > 30                    // 年龄大于30
WHERE p.name =~ "A.*"               // 名字以A开头（正则表达式）
WHERE p.age IN [25, 30, 35]         // 年龄在指定列表中

//with传递结果过
MATCH (p:Person)
WITH p, p.age * 2 AS doubleAge      // 计算后传递给下一部分
WHERE doubleAge > 60
RETURN p.name

//collect聚合收集
MATCH (p:Person)-[:KNOWS]->(f)
WITH p, collect(f) AS friends       // 将所有朋友收集到数组中
RETURN p.name, friends

//call调用过程
CALL db.labels() YIELD label        // 调用系统过程
RETURN label

// 调用自定义过程
CALL my.procedure(param1, param2) YIELD result
RETURN result

//正则表达式
WHERE p.name =~ ".*Smith"           // 以Smith结尾
WHERE p.email =~ ".*@gmail\\.com"   // Gmail邮箱
WHERE p.code =~ "org\\.apache\\..*" // 以org.apache.开头

match (source:Method {NAME:"toString"})
where source.CLASSNAME=~"org.apache.commons.collections.*"

match (sink:Method {NAME:"get", CLASSNAME:"java.util.Map"})
where sink.PARAMETER_SIZE=1

call tabby.algo.findJavaGadget(source, ">"，sink, 5, false) yield path

// 黑名单
//where none(n in nodes(path) where
 // n.CLASSNAME in [
  //  "java.io.ObjectInputStream",
 //   "java.util.concurrent.ConcurrentHashMap"
 // ])

return path