kallithea Files · rhodecode/lib/dbmigrate/versions/007_version_1_4

Files @ 9dd726706178

Branch filter:

Location: kallithea/rhodecode/lib/dbmigrate/versions/007_version_1_4_0.py

9dd726706178 1.7 KiB text/x-python Show Annotation Show as Raw Download as Raw

Bradley M. Kuhn

Complete copyright notices for web interface; change footer to link to them.

The original copyright notice found in the footer was not accurate as it
included only one of the many copyright holders in this project. This change
creates an "about" page, which currently contains just the copyright and
license information. It links to repository for additional potential copyright
holders not listed on the about page.

Unlisted contributors are mentioned in template comments.

Html links for Kallithea is fixed and we link to Conservancy.

Display of version information in the footer is improved.

import logging
import datetime

from sqlalchemy import *
from sqlalchemy.exc import DatabaseError
from sqlalchemy.orm import relation, backref, class_mapper
from sqlalchemy.orm.session import Session
from sqlalchemy.ext.declarative import declarative_base

from rhodecode.lib.dbmigrate.migrate import *
from rhodecode.lib.dbmigrate.migrate.changeset import *

from rhodecode.model.meta import Base
from rhodecode.model import meta

log = logging.getLogger(__name__)


def upgrade(migrate_engine):
    """
    Upgrade operations go here.
    Don't create your own engine; bind migrate_engine to your metadata
    """

    #==========================================================================
    # CHANGESET_COMMENTS
    #==========================================================================
    from rhodecode.lib.dbmigrate.schema.db_1_4_0 import ChangesetComment
    tbl_name = ChangesetComment.__tablename__
    tbl = Table(tbl_name,
                MetaData(bind=migrate_engine), autoload=True,
                autoload_with=migrate_engine)
    col = tbl.columns.revision

    # remove nullability from revision field
    col.alter(nullable=True)

    #==========================================================================
    # REPOSITORY
    #==========================================================================
    from rhodecode.lib.dbmigrate.schema.db_1_4_0 import Repository
    tbl = Repository.__table__
    updated_on = Column('updated_on', DateTime(timezone=False),
                        nullable=True, unique=None)
    # create created on column for future lightweight main page
    updated_on.create(table=tbl)


def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine