kobotoolbox / kpi / 13681003235 / 1

79%

master: 76%

push

github

feat(massEmail): query for users reaching their maximum storage limit TASK-1454 (#5562)

### 📣 Summary
Create the query for retrieving users who are >90% and >100% of their
storage limits.


### 📖 Description
The query returns a list of user uids. It will be used as part of a
MassEmailConfig. Emails that use that query will be sent to the list of
users generated by it. The usage calculated is the same as what is shown
on the Usage page.

### 💭 Notes

Part of this PR is taking the logic we use to determine the limits for
one organization and expanding it to be able to calculate the limits for
multiple organizations. This means moving some of the python logic to
the ORM query, but the results should be exactly the same. In
particular, the selection of price metadata over product metadata is
done with a Coalesce call rather than fetching both and then choosing
which one to use in the python processing code. All unit tests still
passed. Also added a few new ones.

Note: This will affect how we get all usage limits, not just storage
bytes, but again it should be a pure refactor so nothing user-facing
will change. This should make it easier in the future to write the
queries for those approaching their NLP and submission limits.

Similarly, this PR extends the usage calculator query for submission
bytes to get the usage for multiple users at once.

The actual user queries get all user limits, then all user storage, then
compare the two to see who is within the specified range.


### 👀 Preview steps

* Note: after every "purchase," make sure to resync the subscriber

1. Enable stripe on your local setup
2. Have at least 2 organizations/accounts. 
3. Set up org2 with the Professional Plan. Keep org1 on the community
plan.
4. Create a project in org2 with an audio question and add a few
submissions with attachments.
5. In admin, go to Djstripe -> Product -> Up to 5 GB of file storage
6. Edit the product metadata with ` "storage_bytes_limit": "111000"` and
save... (continued)

5994 of 9527 branches covered (62.92%)

22869 of 28291 relevant lines covered (80.83%)

0.81 hits per line