2. description
3. env vars
4. endpoints
5. diagrams

Yet another microservice for resume project

cool features: recursive cte for categories:

SELECT id,
       name,
       parent_id,
       0          AS level,
       ARRAY [id] AS path
FROM category
WHERE parent_id IS NULL

recursive part: In first place we're getting the root elements. Starting from the root elements, we recurse down to the leaves of the tree. At the same time, a path is formed — an array containing the path from the root to the current element.

SELECT c.id,
       c.name,
       c.parent_id,
       ct.level + 1,
       ct.path || c.id
FROM category c
         JOIN "CategoryTree" ct ON c.parent_id = ct.id

We store the result of this query in redis until the data changes. When deleting, changing, or adding, the cache is cleared with @delete_cache decorator. You can check out db listeners in server/alembic/versions/7b7f20cf8099_.py migration.

Some makefilecommands. You can use any with simple make command. Just type make run or smth

• GET /health - check is server all right;
• GET / - category tree;
• GET /category/{category_id} - category page or link or nothing actually;
• POST /add - add new category;
• POST /category/{category_id}/update - update category name;
• POST /category/{category_id}/delete - delete category, cascade all children;

architecture /diagrams/architecture.png
er /diagrams/er.png