feat: Add new projects field to database

Kinukeo commented 3 years ago

Description

Added a new projects field to the database in order to use this for the business insights dashboard.

Migrations (if applicable)

Have any database migrations been committed as part of this pull request? Yes

Checklist:

[x] My code follows the style guidelines of this project
[x] I have performed a self-review of my own code
[x] I have commented my code, particularly in hard-to-understand areas
[ ] I have made corresponding changes to the documentation
[x] My changes generate no new warnings
[x] New migrations have been committed
[ ] I have added tests that prove my fix is effective or that my feature works
[x] New and existing unit tests pass locally with my changes
[ ] If appropriate, I have bumped any version numbers

cooper667 commented 3 years ago

Can this not just be inferred by counting a users collections?

ChasNelson1990 commented 3 years ago

It will indeed be based on counting their collections. The next PR will be a scheduled task, like Silvia's, to update this field every 24 hours. We need the data to be in the BI replicant of the DB for the dashboard?

cooper667 commented 3 years ago

Why not just use SQL to select that value rather than store it ourselves?

ChasNelson1990 commented 3 years ago

Why not just use SQL to select that value rather than store it ourselves?

So just count the rows in Django Etebase Collection for each Owner ID? I presume Etebase's Owner ID matches our Team Owner ID?

ChasNelson1990 commented 3 years ago

Closed as discussed at #techteam

gliff-ai / store