Changeset e2ceffa for asadb/space

Timestamp:

Jan 29, 2013, 7:50:01 PM (13 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage

Children:

f6982d4

Parents:

67dd640

git-author:

Alex Dehnert <adehnert@…> (01/29/13 19:50:01)

git-committer:

Alex Dehnert <adehnert@…> (01/29/13 19:50:01)

Message:

Add list of lock types and assign them to rooms

Location:

asadb/space

Files:

• fixtures/LockTypes.xml (added)
• migrations/0005_add_lock_type.py (modified) (5 diffs)
• migrations/0006_lock_types_setup.py (modified) (2 diffs)
• models.py (modified) (2 diffs)

asadb/space/migrations/0005_add_lock_type.py

@@ -16 +16 @@
             ('description', self.gf('django.db.models.fields.TextField')()),
             ('info_addr', self.gf('django.db.models.fields.EmailField')(default='asa-exec@mit.edu', max_length=75)),
-            ('db_update', self.gf('django.db.models.fields.CharField')(default=None, max_length=20, null=True)),
+            ('db_update', self.gf('django.db.models.fields.CharField')(default='none', max_length=20)),
         ))
         db.send_create_signal('space', ['LockType'])
@@ -46 +46 @@
             'athena_locker': ('django.db.models.fields.CharField', [], {'max_length': '20', 'blank': 'True'}),
             'constitution_url': ('django.db.models.fields.CharField', [], {'max_length': '200', 'blank': 'True'}),
-            'description': ('django.db.models.fields.TextField', [], {}),
+            'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
             'funding_account_id': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
             'group_class': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['groups.GroupClass']"}),
@@ -64 +64 @@
             'update_date': ('django.db.models.fields.DateTimeField', [], {}),
             'updater': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
-            'website_url': ('django.db.models.fields.URLField', [], {'max_length': '200'})
+            'website_url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'blank': 'True'})
         },
         'groups.groupclass': {
@@ -92 +92 @@
         'space.locktype': {
             'Meta': {'object_name': 'LockType'},
-            'db_update': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '20', 'null': 'True'}),
+            'db_update': ('django.db.models.fields.CharField', [], {'default': "'none'", 'max_length': '20'}),
             'description': ('django.db.models.fields.TextField', [], {}),
             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
@@ -116 +116 @@
             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
             'space': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['space.Space']"}),
-            'start': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2012, 6, 24, 3, 49, 23, 229326)', 'db_index': 'True'})
+            'start': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2013, 1, 27, 17, 53, 25, 630881)', 'db_index': 'True'})
         },
         'space.spaceassignment': {

asadb/space/migrations/0006_lock_types_setup.py

@@ -3 +3 @@
 from south.db import db
 from south.v2 import DataMigration
+from django.core.management import call_command
 from django.db import models
 
-lock_types = (
-    ('Inner', 'inner', 'Offices accessed through another office owned by the same group, which therefore does not having a separate lock.', 'asa-exec@mit.edu', None, ),
-    ('CAC Card Access', 'cac-card', 'Offices with the standard CAC-maintained card access system', ),
+
+room_lock_types = (
+    ('W20-454',     'cac-key', ),
+    ('W20-401D',    'cac-combo', ),
+    #('W20-415A',    'inner', ), # not in list?
+    ('W20-449',     'inner', ),
+    ('W20-451A',    'inner', ),
+    ('W20-459',     'inner', ),
+    ('W20-463',     'inner', ),
+    ('W20-481',     'inner', ),
+    ('W20-485/A',   'inner', ),
 )
+
+# Walker: keys and combos: discuss[menelaus asa-db 1320]
+# N52: SEMO
 
 class Migration(DataMigration):
@@ -14 +26 @@
     def forwards(self, orm):
         "Write your forwards methods here."
+        call_command("loaddata", "LockTypes.xml")
+        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='N52-').update(lock_type=lock_types.get(slug='semo'))
+        for room, lock_type in room_lock_types:
+            room_obj = spaces.get(number=room)
+            room_obj.lock_type = lock_types.get(slug=lock_type)
+            room_obj.save()
 
 

asadb/space/models.py

@@ -11 +11 @@
 EXPIRE_OFFSET   = datetime.timedelta(seconds=1)
 
-LOCK_DB_UPDATE_NONE = None
+LOCK_DB_UPDATE_NONE = 'none'
 LOCK_DB_UPDATE_CAC_CARD = 'cac-card'
 lock_db_update_choices = (
@@ -23 +23 @@
     description = models.TextField()
     info_addr = models.EmailField(default='asa-exec@mit.edu', help_text='Address groups should email to get more information about managing access through this lock type.')
-    db_update = models.CharField(null=True, max_length=20, default=None, choices=lock_db_update_choices)
+    db_update = models.CharField(max_length=20, default='none', choices=lock_db_update_choices)
+
+    def __unicode__(self, ):
+        return self.name
+
 
 class Space(models.Model):