# encoding: utf-8 import datetime from south.db import db from south.v2 import DataMigration from django.db import models class Migration(DataMigration): classes = [ ('Sponsored', 'sponsored', True, "Sponsored groups receive support (such as funding or space) from a departmental or similar entity.", ), ('MIT-funded', 'mit-funded', True, "MIT-funded groups are eligible for funding from the UA or GSC funding boards.", ), ('Unfunded', 'unfunded', True, "Unfunded groups are ineligible for funding from the UA and GSC funding boards and office space.", ), ('Club Sport', 'club-sport', True, "Club Sports are recognized and funded through the Club Sports Council.", ), ('Dorm/FSILG', 'dfsilg', False, "Dorm/FSILGs provide housing for MIT students, with varying degrees of Institute recognition/support.", ), ] statuses = [ ('Active', 'active', True, "Active groups are fully recognized and operational groups.", ), ('Suspended', 'suspended', True, "Suspended groups have generally been temporarily semi-derecognized and will be fully derecognized if no further action is taken.", ), ('Derecognized','derecognized', False, "Derecognized groups are no longer extant.", ), ] funding = [ ('undergraduate', 'undergrad', 'finboard@mit.edu', 'finboard-groups-only', ), ('graduate', 'grad', 'gsc-funding@mit.edu', "gsc-fb-", ), ('sports council', 'csc', 'csc-officers@mit.edu', "", ), ] def forwards(self, orm): "Write your forwards methods here." for name, slug, gets_publicity, desc in self.classes: group_class = orm.GroupClass(name=name, slug=slug, gets_publicity=gets_publicity, description=desc) group_class.save() for name, slug, is_active, desc in self.statuses: group_status = orm.GroupStatus(name=name, slug=slug, is_active=is_active, description=desc) group_status.save() for name, slug, contact_email, funding_list in self.funding: group_funder = orm.GroupFunding(name=name, slug=slug, contact_email=contact_email, funding_list=funding_list, ) group_funder.save() for group in orm.Group.objects.all(): if group.group_class_id == -1: group.group_class = orm.GroupClass.objects.get(slug='unfunded') if group.activity_category: if group.activity_category.name == "Athletic": group.group_class = orm.GroupClass.objects.get(slug='club-sport') elif group.activity_category.name == "Dorm/FSILG": group.group_class = orm.GroupClass.objects.get(slug='dfsilg') if group.group_status_id == -1: group.group_status = orm.GroupStatus.objects.get(slug='active') group.save() def backwards(self, orm): "Write your backwards methods here." for name, slug, gets_publicity, desc in self.classes: group_class = orm.GroupClass.objects.get(slug=slug) group_class.delete() for name, slug, is_active, desc in self.statuses: group_status = orm.GroupStatus.objects.get(slug=slug) group_status.delete() for name, slug, contact_email, funding_list in self.funding: group_funder = orm.GroupClass.objects.get(slug=slug) group_funder.delete() models = { 'auth.group': { 'Meta': {'object_name': 'Group'}, 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}), 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}) }, 'auth.permission': { 'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'}, 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}), 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) }, 'auth.user': { 'Meta': {'object_name': 'User'}, 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}), 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}), 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}) }, 'contenttypes.contenttype': { 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"}, 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}) }, 'groups.activitycategory': { 'Meta': {'object_name': 'ActivityCategory'}, 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) }, 'groups.athenamoiraaccount': { 'Meta': {'object_name': 'AthenaMoiraAccount'}, 'account_class': ('django.db.models.fields.CharField', [], {'max_length': '10'}), 'add_date': ('django.db.models.fields.DateField', [], {}), 'del_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '45'}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '45'}), 'mit_id': ('django.db.models.fields.CharField', [], {'max_length': '15'}), 'mod_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), 'mutable': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'username': ('django.db.models.fields.CharField', [], {'max_length': '8'}) }, 'groups.group': { 'Meta': {'ordering': "('name',)", 'object_name': 'Group'}, 'abbreviation': ('django.db.models.fields.CharField', [], {'max_length': '10', 'blank': 'True'}), 'activity_category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['groups.ActivityCategory']", 'null': 'True', 'blank': 'True'}), 'advisor_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}), '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', [], {}), 'funding_account_id': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), 'group_class': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['groups.GroupClass']"}), 'group_email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), 'group_funding': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['groups.GroupFunding']", 'null': 'True', 'blank': 'True'}), 'group_status': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['groups.GroupStatus']"}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'main_account_id': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), 'meeting_times': ('django.db.models.fields.TextField', [], {'blank': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}), 'num_community': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), 'num_grads': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), 'num_other': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), 'num_undergrads': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), 'officer_email': ('django.db.models.fields.EmailField', [], {'max_length': '75'}), 'recognition_date': ('django.db.models.fields.DateField', [], {}), 'update_date': ('django.db.models.fields.DateTimeField', [], {}), 'updater': ('django.db.models.fields.CharField', [], {'max_length': '30'}), 'website_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}) }, 'groups.groupclass': { 'Meta': {'object_name': 'GroupClass'}, 'description': ('django.db.models.fields.TextField', [], {}), 'gets_publicity': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}), 'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '50', 'db_index': 'True'}) }, 'groups.groupfunding': { 'Meta': {'object_name': 'GroupFunding'}, 'contact_email': ('django.db.models.fields.EmailField', [], {'max_length': '75'}), 'funding_list': ('django.db.models.fields.CharField', [], {'max_length': '32', 'blank': 'True'}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}), 'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '50', 'db_index': 'True'}) }, 'groups.groupstatus': { 'Meta': {'object_name': 'GroupStatus'}, 'description': ('django.db.models.fields.TextField', [], {}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}), 'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '50', 'db_index': 'True'}) }, 'groups.officeholder': { 'Meta': {'object_name': 'OfficeHolder'}, 'end_time': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(9999, 12, 31, 23, 59, 59, 999999)'}), 'group': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['groups.Group']"}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'person': ('django.db.models.fields.CharField', [], {'max_length': '30'}), 'role': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['groups.OfficerRole']"}), 'start_time': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}) }, 'groups.officerrole': { 'Meta': {'object_name': 'OfficerRole'}, 'description': ('django.db.models.fields.TextField', [], {}), 'display_name': ('django.db.models.fields.CharField', [], {'max_length': '50'}), 'grant_user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True'}), 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'max_count': ('django.db.models.fields.IntegerField', [], {'default': '10000'}), 'require_student': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'slug': ('django.db.models.fields.SlugField', [], {'max_length': '50', 'db_index': 'True'}) } } complete_apps = ['groups']