Annotation service: add hierarchy support to categories

[khyurri]

Back-end

• [ ] When new job is creating, user can select categories for this job. If user selects category with parents, all parents must be assigned to this job (annotation service). It means, that if user selects sub-category, all parents are also selected

• [x] Add /annotation/categories/search endpoint with hierarchy support scheme

• [x] Add /annotation/jobs/{job_id}/categories/search endpoint with hierarchy support scheme

Hierarchy support scheme contains:

• is_leaf boolean, to show is current node has children
• parents list of parent categories, ordered from root to current node without current node

Example:

  "data": [
    {
      "name": "Child2",
      "parent": "Child1",
      "type": "box",
      "id": "Child2",
      "is_leaf": true,
      "parents": [
        {
          "name": "Root",
          "type": "box",
          "id": "Root",
          "is_leaf": false
        },
        {
          "name": "Child1",
          "parent": "root",
          "type": "box",
          "id": "Child1",
          "is_leaf": false
        }
      ]
    }
  ]

Front-end

• [ ]

Filterlib LTREE support

• [x] Add filter_lib support LTREE for filtering data

Supported operations: children - returns children of value, to get only root nodes set value as root children_recursive - returns all children down the tree parent - returns parent parents_recursive - returns all parents

Others

• [x] Add annotation service PUT | POST, migrate Category table to LTREE structure
• [x] Add endpoint /annotation/jobs/job_id/categoiries/search (search by jobs categories)
• [x] Add Front-end support: get hierarchy by job_id and search in categories
• [x] Add Front-end add categories, update and delete?
• [x] Setup dev internal environment

[khyurri]

Known bugs:

• [x] Unable to create new category from /categories page with Internal server error Example request: {"id":"t-root","name":"t-root","metadata":{"color":"#876565"},"type":"box","parent":null}

[MagicTearsAsunder]

Known bugs:

• [ ] Unable to create new category from /categories page with Internal server error Example request: {"id":"t-root","name":"t-root","metadata":{"color":"#876565"},"type":"box","parent":null}

Special symbols are not allowed in Ltree path. Allowed: letters [a-z, A-Z], digits [0-9] and underscore ("_"). Solution - add validation on CategoryResponseSchema.

[khyurri]

@MagicTearsAsunder

• [x] children must contain only current level children