Gecko [ fernandoquevedodop.com ]

Name	Size	Permission
__pycache__	[ DIR ]	drwxr-xr-x
__init__.py	536 B	-rw-r--r--
db10.py	1.17 KB	-rw-r--r--
db11.py	1.59 KB	-rw-r--r--
db12.py	1.36 KB	-rw-r--r--
db13.py	3.28 KB	-rw-r--r--
db14.py	1.72 KB	-rw-r--r--
db15.py	1.26 KB	-rw-r--r--
db16.py	1.59 KB	-rw-r--r--
db17.py	1.45 KB	-rw-r--r--
db18.py	3.16 KB	-rw-r--r--
db19.py	1.29 KB	-rw-r--r--
db20.py	1.48 KB	-rw-r--r--
db21.py	2.33 KB	-rw-r--r--
db22.py	851 B	-rw-r--r--
db23.py	2.67 KB	-rw-r--r--
db24.py	3.31 KB	-rw-r--r--
db25.py	1.8 KB	-rw-r--r--
db26.py	2.3 KB	-rw-r--r--
db27.py	994 B	-rw-r--r--
db28.py	3.45 KB	-rw-r--r--
db29.py	1.51 KB	-rw-r--r--
db3.py	962 B	-rw-r--r--
db30.py	1.75 KB	-rw-r--r--
db31.py	1.41 KB	-rw-r--r--
db32.py	2.92 KB	-rw-r--r--
db33.py	1.81 KB	-rw-r--r--
db34.py	1.22 KB	-rw-r--r--
db35.py	1.05 KB	-rw-r--r--
db36.py	1.01 KB	-rw-r--r--
db37.py	1.66 KB	-rw-r--r--
db38.py	1.78 KB	-rw-r--r--
db39.py	1.16 KB	-rw-r--r--
db4.py	828 B	-rw-r--r--
db40.py	1.89 KB	-rw-r--r--
db41.py	1.2 KB	-rw-r--r--
db42.py	714 B	-rw-r--r--
db43.py	2.62 KB	-rw-r--r--
db44.py	2.23 KB	-rw-r--r--
db45.py	1.46 KB	-rw-r--r--
db5.py	1.02 KB	-rw-r--r--
db6.py	724 B	-rw-r--r--
db7.py	1.13 KB	-rw-r--r--
db8.py	1.22 KB	-rw-r--r--
db9.py	1.21 KB	-rw-r--r--

Code Editor : db44.py

# -*- coding: utf-8 -*-
#
# Copyright (C) 2016-2021 Edgewall Software
# All rights reserved.
#
# This software is licensed as described in the file COPYING, which
# you should have received as part of this distribution. The terms
# are also available at https://trac.edgewall.org/wiki/TracLicense.
#
# This software consists of voluntary contributions made by many
# individuals. For the exact contribution history, see the revision
# history and logs, available at https://trac.edgewall.org/.

import re

from trac.db.api import DatabaseManager
from trac.db.schema import Column, Table
from trac.resource import ResourceNotFound
from trac.ticket.model import Report
from trac.util.text import printout
from trac.util.translation import _

url = 'https://trac.edgewall.org/wiki/1.3/TracUpgrade#enum-description-field'

def do_upgrade(env, version, cursor):
    """Add `description` column to `enum` table."""
    new_schema = [
        Table('enum', key=('type', 'name'))[
            Column('type'),
            Column('name'),
            Column('value'),
            Column('description'),
        ]
    ]

with env.db_transaction:
        DatabaseManager(env).upgrade_tables(new_schema)
        failures = []
        for id_ in [1, 2, 3, 4, 5, 7, 8]:
            try:
                r = Report(env, id_)
            except ResourceNotFound:
                pass
            else:
                query = replace_sql_fragment(r.query)
                if query:
                    r.query = query
                    r.update()
                else:
                    failures.append(str(id_))

if failures:
        failures = ', '.join(failures)
        # TRANSLATOR: Wrap message to 80 columns
        printout(_("""\
Report(s) %(ids)s could not be upgraded and may need to be manually
edited to avoid an "ambiguous column name" error. See %(url)s for more
information.
""", ids=failures, url=url))

pattern = r'(?<!\.)(description AS _description)((?=_)|\b)'
def replace_sql_fragment(query):
    """Replace SQL fragment, but try to confirm that the default reports
    haven't been modified. The default reports have at most one
    'description AS ...' fragment.
    """
    if len(re.findall(pattern, query)) == 1:
        return re.sub(pattern, r't.\1', query)

${this.title}

Code Editor : db44.py