text: # coding: utf-8
  from __future__ import unicode_literals, print_function, division, absolute_import
  from django.core.exceptions import ValidationError
  from south.v2 import DataMigration
  from onadata.libs.utils.model_tools import queryset_iterator
  from onadata.libs.utils.common_tags import MONGO_STRFTIME, SUBMISSION_TIME, XFORM_ID_STRING
  from onadata.apps.logger.models import Instance
  
  class Migration(DataMigration):
  
      def forwards(self, orm):
          """Add parsed JSON to JSON instance column."""
          for instance in queryset_iterator(
                  orm['odk_logger.Instance'].objects.all()):
              obj = Instance.objects.get(pk=instance.pk)
              json = obj.get_dict()
              json[SUBMISSION_TIME] = instance.date_created.strftime(
                  MONGO_STRFTIME)
              json[XFORM_ID_STRING] = obj._parser.get_xform_id_string()
              instance.json = json
              instance.save()
  
      def backwards(self, orm):
          """Remove JSON content."""
          for instance in orm.Instance.objects.all():
              instance.json = ''
              instance.save()
  
      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'})
          },
          'odk_logger.attachment': {
              'Meta': {'object_name': 'Attachment'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'instance': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'attachments'", 'to': "orm['odk_logger.Instance']"}),
              'media_file': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
              'mimetype': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '50', 'blank': 'True'})
          },
          'odk_logger.instance': {
              'Meta': {'object_name': 'Instance'},
              'date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
              'deleted_at': ('django.db.models.fields.DateTimeField', [], {'default': 'None', 'null': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'is_deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'json': ('jsonfield.fields.JSONField', [], {'default': '{}'}),
              'start_time': ('django.db.models.fields.DateTimeField', [], {'null': 'True'}),
              'status': ('django.db.models.fields.CharField', [], {'default': "'submitted_via_web'", 'max_length': '20'}),
              'survey_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['odk_logger.SurveyType']"}),
              'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'surveys'", 'null': 'True', 'to': "orm['auth.User']"}),
              'uuid': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '249'}),
              'xform': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'surveys'", 'null': 'True', 'to': "orm['odk_logger.XForm']"}),
              'xml': ('django.db.models.fields.TextField', [], {})
          },
          'odk_logger.instancehistory': {
              'Meta': {'object_name': 'InstanceHistory'},
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'uuid': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '249'}),
              'xform_instance': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'submission_history'", 'to': "orm['odk_logger.Instance']"}),
              'xml': ('django.db.models.fields.TextField', [], {})
          },
          'odk_logger.note': {
              'Meta': {'object_name': 'Note'},
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'instance': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'notes'", 'to': "orm['odk_logger.Instance']"}),
              'note': ('django.db.models.fields.TextField', [], {})
          },
          'odk_logger.surveytype': {
              'Meta': {'object_name': 'SurveyType'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'slug': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'})
          },
          'odk_logger.xform': {
              'Meta': {'ordering': "('id_string',)", 'unique_together': "(('user', 'id_string'), ('user', 'sms_id_string'))", 'object_name': 'XForm'},
              'allows_sms': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'bamboo_dataset': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '60'}),
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
              'description': ('django.db.models.fields.TextField', [], {'default': "''", 'null': 'True'}),
              'downloadable': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
              'encrypted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'has_start_time': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'id_string': ('django.db.models.fields.SlugField', [], {'max_length': '100'}),
              'is_crowd_form': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'json': ('django.db.models.fields.TextField', [], {'default': "''"}),
              'last_submission_time': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
              'num_of_submissions': ('django.db.models.fields.IntegerField', [], {'default': '-1'}),
              'shared': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'shared_data': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'sms_id_string': ('django.db.models.fields.SlugField', [], {'default': "''", 'max_length': '50'}),
              'surveys_with_geopoints': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'title': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
              'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'xforms'", 'null': 'True', 'to': "orm['auth.User']"}),
              'uuid': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '32'}),
              'xls': ('django.db.models.fields.files.FileField', [], {'max_length': '100', 'null': 'True'}),
              'xml': ('django.db.models.fields.TextField', [], {})
          },
          'odk_logger.ziggyinstance': {
              'Meta': {'object_name': 'ZiggyInstance'},
              'client_version': ('django.db.models.fields.BigIntegerField', [], {'default': 'None', 'null': 'True'}),
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'date_deleted': ('django.db.models.fields.DateTimeField', [], {'default': 'None', 'null': 'True'}),
              'date_modified': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
              'entity_id': ('django.db.models.fields.CharField', [], {'max_length': '249'}),
              'form_instance': ('django.db.models.fields.TextField', [], {}),
              'form_version': ('django.db.models.fields.CharField', [], {'default': "'1.0'", 'max_length': '10'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'instance_id': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '249'}),
              'reporter': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ziggys'", 'to': "orm['auth.User']"}),
              'server_version': ('django.db.models.fields.BigIntegerField', [], {}),
              'xform': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ziggy_submissions'", 'null': 'True', 'to': "orm['odk_logger.XForm']"})
          },
          'taggit.tag': {
              'Meta': {'object_name': 'Tag'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100'}),
              'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '100'})
          },
          'taggit.taggeditem': {
              'Meta': {'object_name': 'TaggedItem'},
              'content_type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'taggit_taggeditem_tagged_items'", 'to': "orm['contenttypes.ContentType']"}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'object_id': ('django.db.models.fields.IntegerField', [], {'db_index': 'True'}),
              'tag': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'taggit_taggeditem_items'", 'to': "orm['taggit.Tag']"})
          }
      }
  
      complete_apps = ['logger']
      symmetrical = True
  