memgraph / gqlalchemy

GQLAlchemy is a library developed with the purpose of assisting in writing and running queries on Memgraph. GQLAlchemy supports high-level connection to Memgraph as well as modular query builder.
https://pypi.org/project/gqlalchemy/
Apache License 2.0
226 stars 32 forks source link

Add IS NOT NULL to query builder #293

Open katarinasupe opened 11 months ago

katarinasupe commented 11 months ago

Below should work:

Python: `match().node(variable='n').to().node(variable='m').where(item='n.name', operator=Operator.IS_NOT_NULL).return_()`
Cypher: `MATCH (n)-[]->(m) WHERE n.name IS NOT NULL RETURN *;`

Currently, there is no operator IS_NOT_NULL in Operator Enum and where() necessarily requires three arguments (literal or expression as third), while in this case there would be 2 args)

cmhac commented 3 months ago

I also have a need for this - currently unable to do the query I want in the query builder without it