%(msg)s
""" % {'title': _('Pootle: Update'), 'msg': _('Database tables are currently at build version %d. Pootle will now update the database.', db_buildversion)} return text def syncdb(): text = u"""%s
""" % _('Creating missing database tables...') logging.info("Creating missing database tables") call_command('syncdb', interactive=False) return text def update_permissions_20030(): text = """%s
""" % _('Fixing permission table...') logging.info("Fixing permission table") from django.contrib.auth.models import Permission from django.contrib.contenttypes.models import ContentType contenttype, created = ContentType.objects.get_or_create(app_label="pootle_app", model="directory") for permission in Permission.objects.filter(content_type__name='pootle').iterator(): permission.content_type = contenttype permission.save() contenttype.name = 'pootle' contenttype.save() return text def update_tables_21000(): text = u"""%s
""" % _('Updating existing database tables...') logging.info("Updating existing database tables") from south.db import db #raise ImportError table_name = Store._meta.db_table field = Store._meta.get_field('state') db.add_column(table_name, field.name, field) db.create_index(table_name, (field.name,)) field = Store._meta.get_field('translation_project') field.null = True db.add_column(table_name, field.name, field) db.create_index(table_name, (field.name + '_id',)) table_name = Project._meta.db_table field = Project._meta.get_field('directory') field.null = True db.add_column(table_name, field.name, field) field = Project._meta.get_field('source_language') try: en = Language.objects.get(code='en') except Language.DoesNotExist: # we can't allow translation project detection to kick in yet so let's create en manually en = Language(code='en', fullname='English', nplurals=2, pluralequation="(n != 1)") en.directory = Directory.objects.root.get_or_make_subdir(en.code) en.save_base(raw=True) field.default = en.id db.add_column(table_name, field.name, field) db.create_index(table_name, (field.name + '_id',)) return text def update_qualitychecks_21040(): text = """%s
""" % _('Removing quality checks, will be recalculated on demand...') logging.info("Fixing quality checks") flush_quality_checks() return text def update_stats_21060(): text = """%s
""" %_('Removing potentially incorrect cached stats, will be recalculated...') logging.info('flushing cached stats') for tp in TranslationProject.objects.filter(stores__unit__state=OBSOLETE).distinct().iterator(): deletefromcache(tp, ["getquickstats", "getcompletestats", "get_mtime", "has_suggestions"]) return text def update_ts_tt_12008(): text = """%s
""" %_('Reparsing Qt ts files...') logging.info('reparsing qt ts') for store in Store.objects.filter(state__gt=PARSED, translation_project__project__localfiletype='ts', file__iendswith='.ts').iterator(): store.sync(update_translation=True) store.update(update_structure=True, update_translation=True, conservative=False) return text def parse_start(): text = u"""%s
%s
""" % _('All translations are now imported.') return text def footer(): text = """%(endmsg)s
""" % {'endmsg': _('Pootle initialized the database. You will be redirected to the front page in 10 seconds.')} return text def staggered_update(db_buildversion, tt_buildversion): """Update pootle database, while displaying progress report for each step""" # django's syncdb command prints progress reports to stdout, but # mod_wsgi doesn't like stdout, so we reroute to stderr stdout = sys.stdout sys.stdout = sys.stderr yield header(db_buildversion) ############## version specific updates ############ if db_buildversion < 20030: yield update_permissions_20030() if db_buildversion < 21000: try: yield update_tables_21000() except Exception, e: logging.warning(u"something broke while upgrading database tables:\n%s", e) logging.info("creating project directories") Directory.objects.root.get_or_make_subdir('projects') for project in Project.objects.iterator(): # saving should force project to update it's directory property try: project.save() except Exception, e: logging.warning(u"something broke while upgrading %s:\n%s", project, e) logging.info("associating stores with translation projects") for store in Store.objects.iterator(): try: store.translation_project = store.parent.get_translationproject() store.save() except Exception, e: logging.warning(u"something broke while upgrading %s:\n%s", store.pootle_path, e) # build missing tables try: yield syncdb() except Exception, e: logging.warning(u"something broke while creating new database tables:\n%s", e) if db_buildversion < 21000: yield parse_start() for store in Store.objects.iterator(): try: yield parse_store(store) yield import_suggestions(store) except Exception, e: logging.warning(u"something broke while parsing %s:\n%s", store, e) yield parse_end() if db_buildversion < 21040: yield update_qualitychecks_21040() if db_buildversion < 21060: yield update_stats_21060() if tt_buildversion < 12008: yield update_ts_tt_12008() # first time to visit the front page all stats for projects and # languages will be calculated which can take forever, since users # don't like webpages that take forever let's precalculate the # stats here (copied from dbinit) yield stats_start() for language in Language.objects.iterator(): yield stats_language(language) for project in Project.objects.iterator(): yield stats_project(project) yield stats_end() yield footer() # bring back stdout sys.stdout = stdout return