diff options
author | Yingtong Li <runassudo@yingtongli.me> | 2020-03-10 16:49:27 +1100 |
---|---|---|
committer | Yingtong Li <runassudo@yingtongli.me> | 2020-03-10 16:49:27 +1100 |
commit | 187f3a9b7c71e1105da2283c442b7809d3fc8f4a (patch) | |
tree | 6474aaf902ffe734494e871e877d7de36977a48c | |
parent | 1cd09562a92bdfd13af1fe3c5c42f4c105dac96f (diff) |
Add management commands to find duplicate users/members
-rw-r--r-- | ssmain/management/commands/find_duplicate_users.py | 29 | ||||
-rw-r--r-- | ssmembership/management/commands/find_duplicate_members.py | 29 |
2 files changed, 58 insertions, 0 deletions
diff --git a/ssmain/management/commands/find_duplicate_users.py b/ssmain/management/commands/find_duplicate_users.py new file mode 100644 index 0000000..cc63777 --- /dev/null +++ b/ssmain/management/commands/find_duplicate_users.py @@ -0,0 +1,29 @@ +# Society Self-Service +# Copyright © 2018-2020 Yingtong Li (RunasSudo) +# +# This program is free software: you can redistribute it and/or modify +# it under the terms of the GNU Affero General Public License as published by +# the Free Software Foundation, either version 3 of the License, or +# (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU Affero General Public License for more details. +# +# You should have received a copy of the GNU Affero General Public License +# along with this program. If not, see <https://www.gnu.org/licenses/>. + +from django.core.management.base import BaseCommand, CommandError + +from django.contrib.auth.models import User +from django.db.models import Count + +class Command(BaseCommand): + help = 'Finds Users with duplicate emails' + + def handle(self, *args, **options): + duplicates = User.objects.values('email').annotate(email_count=Count('email')).filter(email_count__gt=1) + + for d in duplicates: + print(d.email) diff --git a/ssmembership/management/commands/find_duplicate_members.py b/ssmembership/management/commands/find_duplicate_members.py new file mode 100644 index 0000000..c65d4ab --- /dev/null +++ b/ssmembership/management/commands/find_duplicate_members.py @@ -0,0 +1,29 @@ +# Society Self-Service +# Copyright © 2018-2020 Yingtong Li (RunasSudo) +# +# This program is free software: you can redistribute it and/or modify +# it under the terms of the GNU Affero General Public License as published by +# the Free Software Foundation, either version 3 of the License, or +# (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU Affero General Public License for more details. +# +# You should have received a copy of the GNU Affero General Public License +# along with this program. If not, see <https://www.gnu.org/licenses/>. + +from django.core.management.base import BaseCommand, CommandError + +from ssmembership.models import Member +from django.db.models import Count + +class Command(BaseCommand): + help = 'Finds members with duplicate emails' + + def handle(self, *args, **options): + duplicates = Member.objects.values('email').annotate(email_count=Count('email')).filter(email_count__gt=1) + + for d in duplicates: + print(d.email) |