Query Results¶

with db.session() as session:
    result = session.execute("""
        MATCH (p:Person)
        RETURN p.name, p.age
    """)

    # Iterate over rows
    for row in result:
        print(f"{row['p.name']}: {row['p.age']}")

with db.session() as session:
    result = session.execute("""
        MATCH (p:Person {name: 'Alice'})
        RETURN p.name, p.age, p.active
    """)

    row = next(iter(result))

    # By column name
    name = row['p.name']

    # By index
    name = row[0]

with db.session() as session:
    result = session.execute("MATCH (p:Person) RETURN p.name")

    # Convert to list of dicts
    rows = result.to_list()

    # Or use list comprehension
    names = [row['p.name'] for row in result]

with db.session() as session:
    # Get a single scalar value
    count = session.execute("""
        MATCH (p:Person)
        RETURN count(p) AS count
    """).scalar()

    print(f"Total people: {count}")

with db.session() as session:
    result = session.execute("""
        MATCH (p:Person)
        RETURN p.name AS name, p.age AS age
    """)

    # Get column names
    print(result.columns)  # ['name', 'age']

with db.session() as session:
    result = session.execute("""
        MATCH (p:Person {name: 'NonExistent'})
        RETURN p
    """)

    # Check if empty
    rows = result.to_list()
    if not rows:
        print("No results found")

with db.session() as session:
    result = session.execute("""
        MATCH (p:Person)
        RETURN p.name
    """)

    # Stream results (memory efficient)
    for row in result:
        process(row)
        # Each row is fetched as needed