{"id":1134603,"date":"2025-01-08T21:17:05","date_gmt":"2025-01-08T13:17:05","guid":{"rendered":"https:\/\/docs.pingcode.com\/ask\/ask-ask\/1134603.html"},"modified":"2025-01-08T21:17:05","modified_gmt":"2025-01-08T13:17:05","slug":"%e5%a6%82%e4%bd%95%e7%94%a8python%e4%bd%bf%e7%94%a8neo4j%e7%9a%84cql","status":"publish","type":"post","link":"https:\/\/docs.pingcode.com\/ask\/ask-ask\/1134603.html","title":{"rendered":"\u5982\u4f55\u7528python\u4f7f\u7528neo4j\u7684cql"},"content":{"rendered":"

\"\u5982\u4f55\u7528python\u4f7f\u7528neo4j\u7684cql\"<\/p>\n

\u5982\u4f55\u7528Python\u4f7f\u7528Neo4j\u7684CQL<\/strong><\/p>\n<\/p>\n

\u5728Python\u4e2d\u4f7f\u7528Neo4j\u7684CQL\uff08Cypher Query Language\uff09\u8fdb\u884c\u56fe\u6570\u636e\u5e93\u64cd\u4f5c\u65f6\uff0c\u5173\u952e\u6b65\u9aa4\u5305\u62ec\u5b89\u88c5Neo4j\u9a71\u52a8\u3001\u8fde\u63a5\u5230Neo4j\u6570\u636e\u5e93\u3001\u6267\u884cCQL\u67e5\u8be2\u3001\u5904\u7406\u67e5\u8be2\u7ed3\u679c<\/strong>\u3002\u672c\u7bc7\u6587\u7ae0\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u8fd9\u4e9b\u6b65\u9aa4\uff0c\u5e76\u63d0\u4f9b\u793a\u4f8b\u4ee3\u7801\u4ee5\u5e2e\u52a9\u4f60\u66f4\u597d\u5730\u7406\u89e3\u548c\u5e94\u7528\u3002<\/p>\n<\/p>\n

\u4e00\u3001\u5b89\u88c5Neo4j\u9a71\u52a8<\/h3>\n<\/p>\n

\u8981\u5728Python\u4e2d\u64cd\u4f5cNeo4j\u6570\u636e\u5e93\uff0c\u9996\u5148\u9700\u8981\u5b89\u88c5Neo4j\u7684Python\u9a71\u52a8\u7a0b\u5e8fneo4j<\/code>. \u4f60\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u901a\u8fc7pip\u8fdb\u884c\u5b89\u88c5\uff1a<\/p>\n<\/p>\n

pip install neo4j<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u4e8c\u3001\u8fde\u63a5\u5230Neo4j\u6570\u636e\u5e93<\/h3>\n<\/p>\n
\u5b89\u88c5\u9a71\u52a8\u540e\uff0c\u4e0b\u4e00\u6b65\u662f\u8fde\u63a5\u5230Neo4j\u6570\u636e\u5e93\u3002\u4f60\u9700\u8981\u6570\u636e\u5e93\u7684URI\u3001\u7528\u6237\u540d\u548c\u5bc6\u7801\u6765\u5efa\u7acb\u8fde\u63a5\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u793a\u4f8b\u4ee3\u7801\uff1a<\/p>\n<\/p>\n
from neo4j import GraphDatabase<\/p>\n
uri = "bolt:\/\/localhost:7687"  # Neo4j\u9ed8\u8ba4URI<\/p>\n
username = "neo4j"  # \u9ed8\u8ba4\u7528\u6237\u540d<\/p>\n
password = "password"  # \u6570\u636e\u5e93\u5bc6\u7801<\/p>\n
driver = GraphDatabase.driver(uri, auth=(username, password))<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u4e09\u3001\u6267\u884cCQL\u67e5\u8be2<\/h3>\n<\/p>\n
\u8fde\u63a5\u5efa\u7acb\u540e\uff0c\u53ef\u4ee5\u4f7f\u7528session<\/code>\u5bf9\u8c61\u6267\u884cCQL\u67e5\u8be2\u3002\u4ee5\u4e0b\u793a\u4f8b\u5c55\u793a\u4e86\u5982\u4f55\u521b\u5efa\u8282\u70b9\u548c\u5173\u7cfb\uff1a<\/p>\n<\/p>\n
def create_node(tx, label, properties):<\/p>\n
    cypher_query = f"CREATE (n:{label} {{ {', '.join(f'{k}: ${k}' for k in properties.keys())} }})"<\/p>\n
    tx.run(cypher_query, properties)<\/p>\n
def create_relationship(tx, label1, label2, relationship_type, id1, id2):<\/p>\n
    cypher_query = f"""<\/p>\n
    MATCH (a:{label1}), (b:{label2})<\/p>\n
    WHERE ID(a) = $id1 AND ID(b) = $id2<\/p>\n
    CREATE (a)-[r:{relationship_type}]->(b)<\/p>\n
    """<\/p>\n
    tx.run(cypher_query, id1=id1, id2=id2)<\/p>\n
with driver.session() as session:<\/p>\n
    session.write_transaction(create_node, "Person", {"name": "Alice", "age": 30})<\/p>\n
    session.write_transaction(create_node, "Person", {"name": "Bob", "age": 35})<\/p>\n
    session.write_transaction(create_relationship, "Person", "Person", "FRIENDS_WITH", 0, 1)<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u56db\u3001\u5904\u7406\u67e5\u8be2\u7ed3\u679c<\/h3>\n<\/p>\n
\u67e5\u8be2\u6267\u884c\u540e\uff0c\u4f60\u9700\u8981\u5904\u7406\u8fd4\u56de\u7684\u7ed3\u679c\u3002\u4ee5\u4e0b\u793a\u4f8b\u5c55\u793a\u4e86\u5982\u4f55\u67e5\u8be2\u8282\u70b9\u5e76\u5904\u7406\u7ed3\u679c\uff1a<\/p>\n<\/p>\n
def get_nodes(tx, label):<\/p>\n
    cypher_query = f"MATCH (n:{label}) RETURN n"<\/p>\n
    result = tx.run(cypher_query)<\/p>\n
    return [record["n"] for record in result]<\/p>\n
with driver.session() as session:<\/p>\n
    nodes = session.read_transaction(get_nodes, "Person")<\/p>\n
    for node in nodes:<\/p>\n
        print(node)<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u4e94\u3001\u793a\u4f8b\u9879\u76ee\uff1a\u6784\u5efa\u793e\u4ea4\u7f51\u7edc\u56fe<\/h3>\n<\/p>\n
\u4e0b\u9762\u662f\u4e00\u4e2a\u5b8c\u6574\u7684\u793a\u4f8b\u9879\u76ee\uff0c\u5c55\u793a\u4e86\u5982\u4f55\u4f7f\u7528Python\u548cNeo4j\u6784\u5efa\u4e00\u4e2a\u7b80\u5355\u7684\u793e\u4ea4\u7f51\u7edc\u56fe\uff1a<\/p>\n<\/p>\n
1\u3001\u9879\u76ee\u7ed3\u6784<\/h4>\n<\/p>\n
social_network\/<\/p>\n
|-- mAI<\/a>n.py<\/p>\n
|-- requirements.txt<\/p>\n
<\/code><\/pre>\n<\/p>\n
2\u3001requirements.txt<\/h4>\n<\/p>\n
neo4j<\/p>\n
<\/code><\/pre>\n<\/p>\n
3\u3001main.py<\/h4>\n<\/p>\n
from neo4j import GraphDatabase<\/p>\n
class SocialNetwork:<\/p>\n
    def __init__(self, uri, user, password):<\/p>\n
        self.driver = GraphDatabase.driver(uri, auth=(user, password))<\/p>\n
    def close(self):<\/p>\n
        self.driver.close()<\/p>\n
    def create_person(self, name, age):<\/p>\n
        with self.driver.session() as session:<\/p>\n
            session.write_transaction(self._create_and_return_person, name, age)<\/p>\n
    @staticmethod<\/p>\n
    def _create_and_return_person(tx, name, age):<\/p>\n
        query = (<\/p>\n
            "CREATE (p:Person {name: $name, age: $age}) "<\/p>\n
            "RETURN p"<\/p>\n
        )<\/p>\n
        result = tx.run(query, name=name, age=age)<\/p>\n
        return result.single()[0]<\/p>\n
    def create_friendship(self, name1, name2):<\/p>\n
        with self.driver.session() as session:<\/p>\n
            session.write_transaction(self._create_and_return_friendship, name1, name2)<\/p>\n
    @staticmethod<\/p>\n
    def _create_and_return_friendship(tx, name1, name2):<\/p>\n
        query = (<\/p>\n
            "MATCH (a:Person {name: $name1}) "<\/p>\n
            "MATCH (b:Person {name: $name2}) "<\/p>\n
            "CREATE (a)-[:FRIENDS_WITH]->(b)"<\/p>\n
        )<\/p>\n
        tx.run(query, name1=name1, name2=name2)<\/p>\n
    def find_person(self, name):<\/p>\n
        with self.driver.session() as session:<\/p>\n
            result = session.read_transaction(self._find_and_return_person, name)<\/p>\n
            return [record["p"] for record in result]<\/p>\n
    @staticmethod<\/p>\n
    def _find_and_return_person(tx, name):<\/p>\n
        query = (<\/p>\n
            "MATCH (p:Person) "<\/p>\n
            "WHERE p.name = $name "<\/p>\n
            "RETURN p"<\/p>\n
        )<\/p>\n
        result = tx.run(query, name=name)<\/p>\n
        return result<\/p>\n
if __name__ == "__main__":<\/p>\n
    uri = "bolt:\/\/localhost:7687"<\/p>\n
    user = "neo4j"<\/p>\n
    password = "password"<\/p>\n
    app = SocialNetwork(uri, user, password)<\/p>\n
    app.create_person("Alice", 30)<\/p>\n
    app.create_person("Bob", 35)<\/p>\n
    app.create_friendship("Alice", "Bob")<\/p>\n
    persons = app.find_person("Alice")<\/p>\n
    for person in persons:<\/p>\n
        print(person)<\/p>\n
    app.close()<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u516d\u3001\u6df1\u5165\u7406\u89e3\u4e0e\u4f18\u5316<\/h3>\n<\/p>\n
1\u3001\u4e8b\u52a1\u7ba1\u7406<\/h4>\n<\/p>\n
\u5728Neo4j\u4e2d\uff0c\u6240\u6709\u7684\u64cd\u4f5c\u90fd\u5e94\u5f53\u5728\u4e8b\u52a1\u4e2d\u6267\u884c\uff0c\u4ee5\u786e\u4fdd\u6570\u636e\u7684\u4e00\u81f4\u6027\u548c\u5b8c\u6574\u6027\u3002\u4f7f\u7528session.write_transaction<\/code>\u548csession.read_transaction<\/code>\u53ef\u4ee5\u65b9\u4fbf\u5730\u7ba1\u7406\u4e8b\u52a1\u3002<\/p>\n<\/p>\n
2\u3001\u53c2\u6570\u5316\u67e5\u8be2<\/h4>\n<\/p>\n
\u4e3a\u4e86\u9632\u6b62CQL\u6ce8\u5165\u653b\u51fb\uff0c\u5e94\u8be5\u4f7f\u7528\u53c2\u6570\u5316\u67e5\u8be2\u800c\u4e0d\u662f\u76f4\u63a5\u62fc\u63a5\u5b57\u7b26\u4e32\u3002\u4e0a\u6587\u793a\u4f8b\u4ee3\u7801\u4e2d\u5df2\u7ecf\u5c55\u793a\u4e86\u5982\u4f55\u4f7f\u7528\u53c2\u6570\u5316\u67e5\u8be2\u3002<\/p>\n<\/p>\n
3\u3001\u6279\u91cf\u64cd\u4f5c<\/h4>\n<\/p>\n
\u5bf9\u4e8e\u5927\u89c4\u6a21\u6570\u636e\u5904\u7406\uff0c\u53ef\u4ee5\u4f7f\u7528\u6279\u91cf\u64cd\u4f5c\u6765\u63d0\u9ad8\u6027\u80fd\u3002\u4f8b\u5982\uff0c\u53ef\u4ee5\u5728\u4e00\u4e2a\u4e8b\u52a1\u4e2d\u521b\u5efa\u591a\u4e2a\u8282\u70b9\u548c\u5173\u7cfb\uff0c\u800c\u4e0d\u662f\u4e3a\u6bcf\u4e2a\u64cd\u4f5c\u542f\u52a8\u4e00\u4e2a\u65b0\u7684\u4e8b\u52a1\u3002<\/p>\n<\/p>\n
def create_multiple_nodes(tx, nodes):<\/p>\n
    query = "UNWIND $nodes AS node CREATE (n:Person {name: node.name, age: node.age})"<\/p>\n
    tx.run(query, nodes=nodes)<\/p>\n
nodes = [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 35}, {"name": "Charlie", "age": 25}]<\/p>\n
with driver.session() as session:<\/p>\n
    session.write_transaction(create_multiple_nodes, nodes)<\/p>\n
<\/code><\/pre>\n<\/p>\n
\u4e03\u3001\u5e38\u89c1\u95ee\u9898\u4e0e\u89e3\u51b3\u65b9\u6848<\/h3>\n<\/p>\n
1\u3001\u8fde\u63a5\u5931\u8d25<\/h4>\n<\/p>\n
\u786e\u4fddNeo4j\u6570\u636e\u5e93\u6b63\u5728\u8fd0\u884c\uff0c\u5e76\u4e14\u53ef\u4ee5\u901a\u8fc7\u63d0\u4f9b\u7684URI\u3001\u7528\u6237\u540d\u548c\u5bc6\u7801\u8fdb\u884c\u8bbf\u95ee\u3002\u68c0\u67e5\u9632\u706b\u5899\u8bbe\u7f6e\u548c\u7f51\u7edc\u8fde\u63a5\u3002<\/p>\n<\/p>\n
2\u3001\u6027\u80fd\u95ee\u9898<\/h4>\n<\/p>\n
\u5bf9\u4e8e\u5927\u89c4\u6a21\u6570\u636e\u5904\u7406\uff0c\u8003\u8651\u4f7f\u7528\u6279\u91cf\u64cd\u4f5c\u548c\u7d22\u5f15\u6765\u63d0\u9ad8\u67e5\u8be2\u6027\u80fd\u3002\u5b9a\u671f\u8fdb\u884c\u6570\u636e\u5e93\u4f18\u5316\u548c\u7ef4\u62a4\uff0c\u5982\u91cd\u5efa\u7d22\u5f15\u548c\u6e05\u7406\u5b64\u7acb\u8282\u70b9\u3002<\/p>\n<\/p>\n
3\u3001\u6570\u636e\u4e00\u81f4\u6027<\/h4>\n<\/p>\n
\u5728\u591a\u7528\u6237\u73af\u5883\u4e2d\uff0c\u4e8b\u52a1\u7ba1\u7406\u81f3\u5173\u91cd\u8981\u3002\u786e\u4fdd\u6240\u6709\u64cd\u4f5c\u5728\u4e8b\u52a1\u4e2d\u6267\u884c\uff0c\u5e76\u5408\u7406\u5904\u7406\u5e76\u53d1\u51b2\u7a81\u3002<\/p>\n<\/p>\n
\u516b\u3001\u603b\u7ed3<\/h3>\n<\/p>\n
\u672c\u6587\u8be6\u7ec6\u4ecb\u7ecd\u4e86\u5982\u4f55\u7528Python\u4f7f\u7528Neo4j\u7684CQL\u8fdb\u884c\u56fe\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u5305\u62ec\u5b89\u88c5\u9a71\u52a8\u3001\u8fde\u63a5\u6570\u636e\u5e93\u3001\u6267\u884cCQL\u67e5\u8be2\u548c\u5904\u7406\u67e5\u8be2\u7ed3\u679c\u3002\u901a\u8fc7\u4e00\u4e2a\u5b8c\u6574\u7684\u793a\u4f8b\u9879\u76ee\uff0c\u5c55\u793a\u4e86\u5982\u4f55\u6784\u5efa\u548c\u64cd\u4f5c\u4e00\u4e2a\u7b80\u5355\u7684\u793e\u4ea4\u7f51\u7edc\u56fe\u3002\u6700\u540e\uff0c\u63d0\u4f9b\u4e86\u4e00\u4e9b\u4f18\u5316\u5efa\u8bae\u548c\u5e38\u89c1\u95ee\u9898\u7684\u89e3\u51b3\u65b9\u6848\uff0c\u5e0c\u671b\u80fd\u5e2e\u52a9\u4f60\u66f4\u597d\u5730\u4f7f\u7528Python\u4e0eNeo4j\u8fdb\u884c\u56fe\u6570\u636e\u5e93\u5f00\u53d1\u3002<\/p>\n<\/p>\n
\u76f8\u5173\u95ee\u7b54FAQs\uff1a<\/strong><\/h2>\n
 \u5982\u4f55\u5728Python\u4e2d\u8fde\u63a5\u5230Neo4j\u6570\u636e\u5e93\uff1f<\/strong>
\u8981\u5728Python\u4e2d\u8fde\u63a5\u5230Neo4j\u6570\u636e\u5e93\uff0c\u60a8\u9700\u8981\u4f7f\u7528Neo4j\u7684\u5b98\u65b9Python\u9a71\u52a8\u7a0b\u5e8f\u3002\u9996\u5148\uff0c\u786e\u4fdd\u5b89\u88c5\u4e86neo4j<\/code>\u5e93\uff0c\u53ef\u4ee5\u901a\u8fc7pip install neo4j<\/code>\u547d\u4ee4\u8fdb\u884c\u5b89\u88c5\u3002\u8fde\u63a5\u65f6\uff0c\u9700\u8981\u63d0\u4f9b\u6570\u636e\u5e93\u7684URI\u3001\u7528\u6237\u540d\u548c\u5bc6\u7801\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u7b80\u5355\u7684\u793a\u4f8b\u4ee3\u7801\uff1a<\/p>\n
from neo4j import GraphDatabase\n\nuri = "bolt:\/\/localhost:7687"\ndriver = GraphDatabase.driver(uri, auth=("username", "password"))\n\nwith driver.session() as session:\n    result = session.run("MATCH (n) RETURN n LIMIT 5")\n    for record in result:\n        print(record)\n<\/code><\/pre>\n
CQL\u67e5\u8be2\u8bed\u53e5\u5982\u4f55\u5728Python\u4e2d\u6267\u884c\uff1f<\/strong>
\u5728Python\u4e2d\uff0c\u60a8\u53ef\u4ee5\u901a\u8fc7Neo4j\u7684\u4f1a\u8bdd\u5bf9\u8c61\u8fd0\u884cCQL\u67e5\u8be2\u3002\u4f7f\u7528session.run()<\/code>\u65b9\u6cd5\u53ef\u4ee5\u4f20\u9012CQL\u8bed\u53e5\u548c\u53c2\u6570\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u793a\u4f8b\uff0c\u5c55\u793a\u5982\u4f55\u521b\u5efa\u8282\u70b9\u5e76\u67e5\u8be2\uff1a<\/p>\n
with driver.session() as session:\n    session.run("CREATE (a:Person {name: $name})", name="Alice")\n    result = session.run("MATCH (a:Person) RETURN a.name AS name")\n    for record in result:\n        print(record["name"])\n<\/code><\/pre>\n
\u5982\u4f55\u5904\u7406Neo4j\u4e2d\u7684\u4e8b\u52a1\uff1f<\/strong>
\u5728\u4f7f\u7528Neo4j\u65f6\uff0c\u5904\u7406\u4e8b\u52a1\u975e\u5e38\u91cd\u8981\uff0c\u4ee5\u786e\u4fdd\u6570\u636e\u7684\u4e00\u81f4\u6027\u548c\u5b8c\u6574\u6027\u3002\u5728Python\u4e2d\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528session.begin_transaction()<\/code>\u65b9\u6cd5\u6765\u521b\u5efa\u4e00\u4e2a\u4e8b\u52a1\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u793a\u4f8b\uff1a<\/p>\n
with driver.session() as session:\n    with session.begin_transaction() as tx:\n        tx.run("CREATE (b:Person {name: $name})", name="Bob")\n        tx.run("CREATE (c:Person {name: $name})", name="Charlie")\n        # \u63d0\u4ea4\u4e8b\u52a1\n<\/code><\/pre>\n
\u901a\u8fc7\u8fd9\u79cd\u65b9\u5f0f\uff0c\u60a8\u53ef\u4ee5\u5728\u4e8b\u52a1\u8303\u56f4\u5185\u6267\u884c\u591a\u4e2aCQL\u8bed\u53e5\uff0c\u786e\u4fdd\u5b83\u4eec\u8981\u4e48\u5168\u90e8\u6210\u529f\uff0c\u8981\u4e48\u5168\u90e8\u5931\u8d25\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u5982\u4f55\u7528Python\u4f7f\u7528Neo4j\u7684CQL \u5728Python\u4e2d\u4f7f\u7528Neo4j\u7684CQL\uff08Cypher Query L […]","protected":false},"author":3,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1134603"}],"collection":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/comments?post=1134603"}],"version-history":[{"count":0,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/posts\/1134603\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/media?parent=1134603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/categories?post=1134603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.pingcode.com\/wp-json\/wp\/v2\/tags?post=1134603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}