Changeset a7d30ef

Timestamp:

Apr 10, 2012, 4:00:41 PM (14 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage

Children:

1898cc8

Parents:

04a46ed

git-author:

Alex Dehnert <adehnert@…> (04/10/12 16:00:41)

git-committer:

Alex Dehnert <adehnert@…> (04/10/12 16:00:41)

Message:

Script to dump groups with space (ASA Trac #95)

Add support to groups/format_groups.py to dump email addresses of groups with
various kinds of assigned space (W20 office, W20 locker, etc.)

File:

• asadb/groups/format_groups.py (modified) (4 diffs)

asadb/groups/format_groups.py

@@ -11 +11 @@
     os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
 
+from django.db import connection
 from django.db.models import Q
 from django.utils import html
 
 import groups.models
+import space.models
 
+def space_Q(merged_acl=None, building=None, ):
+    Qspace = Q()
+    if merged_acl is not None: Qspace = Q(space__merged_acl=merged_acl)
+    if building: Qspace = Qspace & Q(space__number__startswith=building+'-')
+    return Q(spaceassignment__in=space.models.SpaceAssignment.current.filter(Qspace))
 
 Qsa = Q(group_status__slug__in=('active', 'suspended', ))
+
 functions = {
     'finboard' : {
@@ -43 +51 @@
         'predicate' : Q(group_status__slug__in=['active', 'suspended', 'applying', 'nge'], group_class__gets_publicity=True, ),
     },
+    'w20-locker' : {
+        'format' : '%(officer_email)s;%(name)s',
+        'predicate' : Qsa & space_Q(merged_acl=True, building='W20'),
+    },
+    'w20-office' : {
+        'format' : '%(officer_email)s;%(name)s',
+        'predicate' : Qsa & space_Q(merged_acl=False, building='W20'),
+    },
+    'all-office' : {
+        'format' : '%(officer_email)s;%(name)s',
+        'predicate' : Qsa & space_Q(merged_acl=False),
+    },
+    'all-space' : {
+        'format' : '%(officer_email)s;%(name)s',
+        'predicate' : Qsa & space_Q(),
+    },
 }
 
@@ -49 +73 @@
     format = spec['format']
     predicate = spec['predicate']
-    gs = groups.models.Group.objects.filter(predicate)
+    gs = groups.models.Group.objects.filter(predicate).distinct()
     static_args = {'script': 'groups/format_groups.py', 'mode':mode, }
     if 'prefix' in spec:
@@ -61 +85 @@
     if 'suffix' in spec:
         print spec['suffix'] % static_args
+    #for q in connection.queries: print q
 
 if __name__ == "__main__":