Cypher 文件作为 py2neo python 中的参数

Question

我正在尝试在py2neo中将文件作为参数传递，以使查询中的变量作为其他参数。而不是：cypherfrom py2neo import Graphgraph = Graph(password = "*****")def test(some_things):    result = graph.run(                "MATCH (movie:movies)"                "where movie.name =~ $name "                "RETURN movie",{"name":"(?i).*" + some_things+ ".*"})    return result我想知道是否有这样的东西：from py2neo import Graphgraph = Graph(password = "*****")def test(some_things):    result = graph.run("some_cypher.cypher", some_things)    return result其中可能是：some_cypher.cypherMATCH (movie:movies) where movie.name =~ $name RETURN movie, ,{"name":"(?i).*" + ?+ ".*"}在 python 文件中是要替换为 的参数。?some_things

Answer 1

虽然在py2neo中没有直接从文件中读取的内置选项，但有一种机制可以根据需要获取参数序列。因此，剩下的只是使用一个函数从文件中读取查询并使用参数。这应该看起来像这样：

from py2neo import Graph

graph = Graph(password = "*****")

def run_query_from_file(cypher_file_path,  parameters=None, **kwparameters):

    with open(cypher_file_path, 'r') as cypher_file:

          cypher_query = cypher_file.read().strip()

    graph.run(cypher_query, parameters)

def test1(dict_of_parameters):

    result = run_query_from_file("some_cypher.cypher", dict_of_parameters)

    return result

def test2(**kwparameters):

    result = run_query_from_file("some_cypher.cypher", **kwparameters)

    return result

# Both should work

test1({'username': 'abc', 'password': '123'})

test2('username'='abc', 'password'='123')

其中包含：some_cypher.cypher

MERGE （user：User {username：$username}） with user， user.password as user_password SET user.password = $password RETURN user_password

Answer 2

py2neo中没有内置这样的功能。如果你想这样做，你必须滚动自己的函数。