# -*- coding: utf-8 -*-

from core.utils import show_progress

from django.db import transaction, reset_queries

from south.v2 import SchemaMigration

class Migration(SchemaMigration):

    def forwards(self, orm):

        total = orm['core.term'].objects.count()

        transaction.enter_transaction_management(True)

        transaction.managed()

        writer = None

        for i, obj in enumerate(orm['core.term'].objects.values("id").iterator()):

            term_id = obj['id']

            writer = show_progress(i+1, total, "Processing term %d" % term_id, 50, writer)

            nb_illustrated_notice = orm['core.notice'].objects.filter(noticeterm__term__id=term_id,image=True).count()

            orm['core.term'].objects.filter(id=term_id).update(nb_illustrated_notice=nb_illustrated_notice)

            if not ((i+1) % 5000):

                transaction.commit()

                reset_queries() 

        transaction.commit()

        reset_queries()

    def backwards(self, orm):

        orm['core.term'].objects.update(nb_illustrated_notice=0)

    models = {

        u'auth.group': {

            'Meta': {'object_name': 'Group'},

            u'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': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})

        },

        u'auth.permission': {

            'Meta': {'ordering': "(u'content_type__app_label', u'content_type__model', u'codename')", 'unique_together': "((u'content_type', u'codename'),)", 'object_name': 'Permission'},

            'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),

            'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contenttypes.ContentType']"}),

            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),

            'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})

        },

        u'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'}),

            u'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'})

        },

        'core.autrnoticeterm': {

            'Meta': {'object_name': 'AutrNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.domnnoticeterm': {

            'Meta': {'object_name': 'DomnNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.ecolnoticeterm': {

            'Meta': {'object_name': 'EcolNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.epoqnoticeterm': {

            'Meta': {'object_name': 'EpoqNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.lieuxnoticeterm': {

            'Meta': {'object_name': 'LieuxNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.notice': {

            'Meta': {'object_name': 'Notice'},

            'adpt': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'appl': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'aptn': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'attr': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'autr': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'autr_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'autr+'", 'symmetrical': 'False', 'through': "orm['core.AutrNoticeTerm']", 'to': "orm['core.Term']"}),

            'bibl': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'comm': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'contact': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'coor': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'copy': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'dacq': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'data': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'dation': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'ddpt': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'decv': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'deno': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'depo': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'desc': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'desy': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'dims': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'dmaj': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),

            'dmis': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),

            'domn': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'domn_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'domn+'", 'symmetrical': 'False', 'through': "orm['core.DomnNoticeTerm']", 'to': "orm['core.Term']"}),

            'drep': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'ecol': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'ecol_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'ecol+'", 'symmetrical': 'False', 'through': "orm['core.EcolNoticeTerm']", 'to': "orm['core.Term']"}),

            'epoq': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'epoq_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'epoq+'", 'symmetrical': 'False', 'through': "orm['core.EpoqNoticeTerm']", 'to': "orm['core.Term']"}),

            'etat': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'expo': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'gene': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'geohi': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'hist': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),

            'image': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),

            'insc': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'inv': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'label': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'labo': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'lieux': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'lieux_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'lieux+'", 'symmetrical': 'False', 'through': "orm['core.LieuxNoticeTerm']", 'to': "orm['core.Term']"}),

            'loca': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'loca2': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'mill': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'milu': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'mosa': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'msgcom': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'museo': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'nsda': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'onom': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'paut': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'pdat': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'pdec': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'peoc': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'peri': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'}),

            'peri_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'peri+'", 'symmetrical': 'False', 'through': "orm['core.PeriNoticeTerm']", 'to': "orm['core.Term']"}),

            'peru': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'phot': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'pins': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'plieux': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'prep': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'puti': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'reda': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'ref': ('django.db.models.fields.CharField', [], {'max_length': '20', 'unique': 'True', 'null': 'True', 'blank': 'True'}),

            'refim': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'repr': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'repr_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'repr+'", 'symmetrical': 'False', 'through': "orm['core.ReprNoticeTerm']", 'to': "orm['core.Term']"}),

            'srep': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'srep_terms': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'srep+'", 'symmetrical': 'False', 'through': "orm['core.SrepNoticeTerm']", 'to': "orm['core.Term']"}),

            'stat': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'tech': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'tico': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'titr': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            'util': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'video': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'www': ('django.db.models.fields.CharField', [], {'max_length': '512', 'null': 'True', 'blank': 'True'})

        },

        'core.noticeimage': {

            'Meta': {'unique_together': "(('relative_url', 'notice'),)", 'object_name': 'NoticeImage'},

            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),

            'notice': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'images'", 'to': "orm['core.Notice']"}),

            'relative_url': ('django.db.models.fields.URLField', [], {'max_length': "'1024'"})

        },

        'core.noticeterm': {

            'Meta': {'object_name': 'NoticeTerm'},

            'graph': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),

            'notice': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Notice']"}),

            'term': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Term']"})

        },

        'core.perinoticeterm': {

            'Meta': {'object_name': 'PeriNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.reprnoticeterm': {

            'Meta': {'object_name': 'ReprNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.srepnoticeterm': {

            'Meta': {'object_name': 'SrepNoticeTerm', '_ormbases': ['core.NoticeTerm']},

            u'noticeterm_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.NoticeTerm']", 'unique': 'True', 'primary_key': 'True'})

        },

        'core.term': {

            'Meta': {'object_name': 'Term'},

            'alternative_wikipedia_pageid': ('django.db.models.fields.BigIntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),

            'alternative_wikipedia_url': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),

            'dbpedia_uri': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),

            'label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),

            'lang': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '128', 'null': 'True', 'blank': 'True'}),

            u'level': ('django.db.models.fields.PositiveIntegerField', [], {'db_index': 'True'}),

            u'lft': ('django.db.models.fields.PositiveIntegerField', [], {'db_index': 'True'}),

            'link_semantic_level': ('django.db.models.fields.IntegerField', [], {'default': 'None', 'null': 'True', 'db_index': 'True', 'blank': 'True'}),

            'nb_illustrated_notice': ('django.db.models.fields.IntegerField', [], {'default': '0', 'db_index': 'True'}),

            'nb_notice': ('django.db.models.fields.IntegerField', [], {'default': '0', 'db_index': 'True'}),

            'normalized_label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),

            'notices': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'terms+'", 'symmetrical': 'False', 'through': "orm['core.NoticeTerm']", 'to': "orm['core.Notice']"}),

            'parent': ('mptt.fields.TreeForeignKey', [], {'blank': 'True', 'related_name': "'children'", 'null': 'True', 'to': "orm['core.Term']"}),

            u'rght': ('django.db.models.fields.PositiveIntegerField', [], {'db_index': 'True'}),

            'thesaurus': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Thesaurus']"}),

            u'tree_id': ('django.db.models.fields.PositiveIntegerField', [], {'db_index': 'True'}),

            'uri': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'url_status': ('django.db.models.fields.IntegerField', [], {'default': 'None', 'null': 'True', 'db_index': 'True', 'blank': 'True'}),

            'validated': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),

            'validation_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),

            'validator': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.User']", 'null': 'True', 'blank': 'True'}),

            'wikipedia_edition': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),

            'wikipedia_pageid': ('django.db.models.fields.BigIntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),

            'wikipedia_revision_id': ('django.db.models.fields.BigIntegerField', [], {'null': 'True', 'blank': 'True'}),

            'wikipedia_url': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}),

            'wp_alternative_label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '1024', 'null': 'True', 'blank': 'True'}),

            'wp_label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '1024', 'null': 'True', 'blank': 'True'})

        },

        'core.termlabel': {

            'Meta': {'object_name': 'TermLabel'},

            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),

            'label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),

            'lang': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '128', 'null': 'True', 'blank': 'True'}),

            'term': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'alternative_labels'", 'to': "orm['core.Term']"})

        },

        'core.thesaurus': {

            'Meta': {'ordering': "['label']", 'object_name': 'Thesaurus'},

            'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),

            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),

            'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128', 'db_index': 'True'}),

            'title': ('django.db.models.fields.CharField', [], {'max_length': '1024'}),

            'uri': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'})

        },

        'core.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': u"orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),

            u'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'}),

            'language': ('django.db.models.fields.CharField', [], {'default': "'en'", 'max_length': '2'}),

            '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': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),

            'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})

        }

    }

    complete_apps = ['core']