Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Make default quota(s) adjustable? #858

Open
philbudne opened this issue Nov 19, 2024 · 1 comment
Open

Make default quota(s) adjustable? #858

philbudne opened this issue Nov 19, 2024 · 1 comment

Comments

@philbudne
Copy link
Contributor

We recently decided 4000 is a reasonable default value for the onlinenews-mediacloud quota, but there's no easy way to adjust it;
I've just done an SQL UPDATE each day since then.

It would be lovely if the default quota was stored as a "property" (in a default-quotas section) named by the provider, and if the user-quota has some distinctive value (0?? -1??? NUL????), the default value is used instead...

I guess the quota_XXX columns in the users_profile table could be viewed as "denormalized", and it could be represented as a users_quota table keyed by user_id and provider, and the table could only contain the exceptions (any non-staff user without a table entry gets the default).... But not sure it's worth the effort to do a migration!

@philbudne
Copy link
Contributor Author

The SQL command, and today's output:

mcweb_db=# update users_profile set quota_mediacloud = 4000 where quota_mediacloud = 100000;
UPDATE 15

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant