Implement pre-CTE filtering

OmenApps / django-postgresql-dag

Directed Acyclic Graphs with a variety of methods for both Nodes and Edges, and multiple exports (NetworkX, Pandas, etc). This project is the foundation for a commercial product, so expect regular improvements. PR's and other contributions are welcomed.

Apache License 2.0

41 stars 6 forks source link

Implement pre-CTE filtering #2

Open JackAtOmenApps opened 3 years ago

JackAtOmenApps commented 3 years ago

Add the ability to filter down prior to running CTE.

For instance, in a graph of a municipal district, it may be more efficient to limit the search to a particular region, category of nodes/edges, or other characteristics.

This would involve modifying the raw Postgresql statement to include the additional filtering.

JackAtOmenApps commented 3 years ago

Options to pre-filter on the following:

[X] A queryset of node instances to ignore
[ ] A queryset of node instances to require
[ ] A queryset of edge instances to ignore
[ ] A queryset of edge instances to require
[ ] A ForeignKey on the node model
[X] A ForeignKey on the edge model

Maybe in the future:

[ ] A ManyToManyField on the node model
[ ] A ManyToManyField on the edge model