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 : db18.py

# -*- coding: utf-8 -*-
#
# Copyright (C) 2006-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/.

from trac.db import Table, Column, Index, DatabaseManager

def do_upgrade(env, ver, cursor):
    cursor.execute("CREATE TEMPORARY TABLE session_old AS SELECT * FROM session")
    cursor.execute("DROP TABLE session")
    cursor.execute("CREATE TEMPORARY TABLE ticket_change_old AS SELECT * FROM ticket_change")
    cursor.execute("DROP TABLE ticket_change")

# A more normalized session schema where the attributes are stored in
    # a separate table
    tables = [Table('session', key=('sid', 'authenticated'))[
                Column('sid'),
                Column('authenticated', type='int'),
                Column('last_visit', type='int'),
                Index(['last_visit']),
                Index(['authenticated'])],
              Table('session_attribute', key=('sid', 'authenticated', 'name'))[
                Column('sid'),
                Column('authenticated', type='int'),
                Column('name'),
                Column('value')],
              Table('ticket_change', key=('ticket', 'time', 'field'))[
                Column('ticket', type='int'),
                Column('time', type='int'),
                Column('author'),
                Column('field'),
                Column('oldvalue'),
                Column('newvalue'),
                Index(['ticket']),
                Index(['time'])]]

db_connector, _ = DatabaseManager(env).get_connector()
    for table in tables:
        for stmt in db_connector.to_sql(table):
            cursor.execute(stmt)

# Add an index to the temporary table to speed up the conversion
    cursor.execute("CREATE INDEX session_old_sid_idx ON session_old(sid)")
    # Insert the sessions into the new table
    with env.db_query as db:
        cursor.execute("""
            INSERT INTO session (sid, last_visit, authenticated)
            SELECT distinct s.sid,COALESCE(%s,0),s.authenticated
            FROM session_old AS s LEFT JOIN session_old AS s2
            ON (s.sid=s2.sid AND s2.var_name='last_visit')
            WHERE s.sid IS NOT NULL
            """ % db.cast('s2.var_value', 'int'))
    cursor.execute("""
        INSERT INTO session_attribute (sid, authenticated, name, value)
        SELECT s.sid, s.authenticated, s.var_name, s.var_value
        FROM session_old s
        WHERE s.var_name <> 'last_visit' AND s.sid IS NOT NULL
        """)

# Insert ticket change data into the new table
    cursor.execute("""
        INSERT INTO ticket_change (ticket, time, author, field, oldvalue,
                                   newvalue)
        SELECT ticket, time, author, field, oldvalue, newvalue
        FROM ticket_change_old
        """)

cursor.execute("DROP TABLE session_old")
    cursor.execute("DROP TABLE ticket_change_old")

${this.title}

Code Editor : db18.py