sqlalchemy_mptt
sqlalchemy_mptt copied to clipboard
uralbash
SQLAlchemy nested sets mixin (MPTT)
I am using this library for category table in my fastapi application. When I try to create a category, I get null value in column \"lft\" violates not-null constraint error....
There appears to be an issue when adding a parent ID to an existing node that doesn’t already have a parent ID, in the same tree. The use case is...
Hi, I need to apply soft-delete when doing a node deletion. I will use an extra field named: **deleted** with its value 1 char `Y` for the row is soft-deleted...
When i'm trying to move node to leftmost position using node.move_before nothing happens with tree. i think it's because there's no left_sibling here: https://github.com/uralbash/sqlalchemy_mptt/blob/master/sqlalchemy_mptt/events.py#L362 Here's test code: ``` class MoveLeft(self):...
move_after moves element one position further than expected. I think it's because after we called `mptt_before_delete` [here](https://github.com/uralbash/sqlalchemy_mptt/blob/ce7c8ceea915f4bc2716aafdc7cafe075d862942/sqlalchemy_mptt/events.py#L394), lft and rgt of left sibling has changed, but variable `left_sibling` still has...
Drilldowntree return a list but not a query, returning a query can make the query easier
Mptt is a great project, It helps a lot of junior programmers to realize the connection between tree structure and database. Maybe we can build another project about linear structure....
The `tree_id` column is currently an Integer thats managed in application code. New trees are created by querying for the max value in the table and incrementing it by one,...
Hi! In order to initialize an empty tree. I used the following code based on the example in the doc: ```python # if the table is empty if not current_session.query(TreeDelcaretiveClass).all():...
