kobotoolbox / kpi / 13770767138

81%

master: 76%

push

github

feat(massEmail): query for identifying inactive users based on login, form activity, and submissions TASK-1581 (#5569)

### 📣 Summary
Detect and return a list of users who have been inactive for a specified
period based on login activity, project updates, and submissions.


### 📖 Description
This update introduces a method to identify inactive users who have not:

- Logged into their account.
- Modified their projects or had modifications made by others.
- Received submissions to their projects.

By default, the inactivity period is set to 365 days but can be
configured dynamically.


### 👀 Preview steps

1. Run `get_inactive_users(days=1)` in the shell, users inactive for 1+
days should be listed.
2. Modify `inactivity_threshold = now() - timedelta(minutes=2)`
3. Log in & log out, run `get_inactive_users()`, user should NOT be
listed. Wait 2 mins, run again, user should be listed now.
4. Log in, create a project, run `get_inactive_users()`, user should NOT
be listed. Wait 2 mins, run again, user should be listed now.
5. Change the name of the project, run `get_inactive_users()`, user
should NOT be listed. Wait 2 mins, run again, user should be listed now.
6. Add a submission, run `get_inactive_users()`, user should NOT be
listed. Wait 2 mins, run again, user should be listed.

5997 of 9529 branches covered (62.93%)

13 of 13 new or added lines in 1 file covered. (100.0%)

22886 of 28305 relevant lines covered (80.85%)

0.81 hits per line