test.py 856 B

123456789101112131415161718192021222324252627
  1. from py2neo import Graph
  2. # 连接 Neo4j 数据库
  3. graph = Graph("bolt://localhost:7687", auth=("neo4j", "123456"))
  4. entities = ["液压2系统压力正常", "液压告警灯熄灭", "再次进行电传PBIT测试,依旧报此故障"]
  5. query = ""
  6. for i in entities:
  7. query += "MATCH (a)-[:故障现象]->(:故障现象{name:'" + i + "'}) "
  8. query += "MATCH (a)-[:排故流程]->(b:故障流程) RETURN b.name"
  9. print(query)
  10. # 构建 Cypher 查询语句
  11. #query = "MATCH (a:故障名称)-[:故障原因]->(:故障原因{name:'2号电传计算机故障'}), (a)-[:故障现象]->(:故障现象{name:'液压告警灯熄灭'}) MATCH (a)-[:排故流程]->(b:故障流程) RETURN a,b"
  12. # 执行查询
  13. result = graph.run(query)
  14. # Process the query result
  15. for record in result:
  16. fault_process = record['b.name']
  17. print(f"排故流程: {fault_process}")