Changeset 89b3a65

Timestamp:

Mar 6, 2013, 8:08:17 PM (13 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage

Children:

9358747

Parents:

21f7242

git-author:

Alex Dehnert <adehnert@…> (03/06/13 20:08:17)

git-committer:

Alex Dehnert <adehnert@…> (03/06/13 20:08:17)

Message:

Correct Walker room access

Location:

asadb/space

Files:

• fixtures/LockTypes.xml (modified) (1 diff)
• migrations/0006_lock_types_setup.py (modified) (3 diffs)

asadb/space/fixtures/LockTypes.xml

@@ -49 +49 @@
         <field type="CharField" name="db_update">none</field>
     </object>
+    <object pk="7" model="space.locktype">
+        <field type="CharField" name="name">Group</field>
+        <field type="SlugField" name="slug">group</field>
+        <field type="TextField" name="description">Room with access administered by the group directly.</field>
+        <field type="CharField" name="info_addr">asa-exec@mit.edu</field>
+        <field type="CharField" name="info_url"></field>
+        <field type="CharField" name="db_update">none</field>
+    </object>
 </django-objects>

asadb/space/migrations/0006_lock_types_setup.py

@@ -7 +7 @@
 
 
+# W20: mostly cac-card, but some other things
+# Walker: keys and combos
+# N52: SEMO
+# See also discuss[menelaus asa-db 1320]
+
 room_lock_types = (
     ('W20-454',     'cac-key', ),
     ('W20-401D',    'cac-combo', ),
-    #('W20-415A',    'inner', ), # not in list?
+    #('W20-415A',    'inner', ), # APO's press room --- doesn't even have a door
     ('W20-449',     'inner', ),
     ('W20-451A',    'inner', ),
@@ -17 +22 @@
     ('W20-481',     'inner', ),
     ('W20-485/A',   'inner', ),
+
+    # 50-XXX offices: see https://diswww.mit.edu/menelaus/asa-db/4606
+    ('50-001',      'cac-combo', ),
+    ('50-020',      'cac-key', ),
+    ('50-023',      'cac-key', ),
+    ('50-024',      'cac-combo', ),
+    ('50-028',      'cac-combo', ),
+    ('50-030',      'group', ),
+    ('50-301',      'group', ),
+    ('50-302',      'cac-combo', ),
+    ('50-303',      'cac-key', ),
+    ('50-304/A',    'cac-combo', ),
+    ('50-306',      'cac-key', ),
+    ('50-309',      'cac-key', ),
+    ('50-316/A',    'cac-key', ),
+    ('50-318',      'cac-key', ),
+    ('50-320',      'cac-combo', ),
+    #('50-352',     'cac-key', ),      # no current occupant
+    ('50-354A',     'cac-key', ),
+    ('50-356/A',    'cac-key', ),
+    ('50-357',      'cac-key', ),
+    ('50-358',      'cac-key', ),
+    ('50-360',      'cac-key', ),
 )
-
-# Walker: keys and combos: discuss[menelaus asa-db 1320]
-# N52: SEMO
 
 class Migration(DataMigration):
@@ -29 +54 @@
         lock_types = orm['space.LockType'].objects
         spaces = orm['space.Space'].objects
-        spaces.filter(number__startswith='50-').update(lock_type=lock_types.get(slug='cac-combo'))
+        spaces.filter(number__startswith='50-').update(lock_type=lock_types.get(slug='unknown'))
         spaces.filter(number__startswith='N52-').update(lock_type=lock_types.get(slug='semo'))
         for room, lock_type in room_lock_types:
+            print "Setting room=%s's lock_type to %s" % (room, lock_type, )
             room_obj = spaces.get(number=room)
             room_obj.lock_type = lock_types.get(slug=lock_type)