コード例 #1
0
def do_upgrade():
    op.drop_table(u'wtgTAG_usergroup')

    op.add_column('wtgTAG', db.Column(
        'group_access_rights', mysql.INTEGER(display_width=2), nullable=False))

    op.add_column(
        'wtgTAG', db.Column('id_usergroup', mysql.INTEGER(display_width=15),
                            server_default='0', nullable=True))
    op.add_column('wtgTAG_bibrec', db.Column(
        'annotation', db.Text(convert_unicode=True), nullable=True))
コード例 #2
0
def do_upgrade():
    """Migrate format references."""
    op.add_column('collection_format',
                  db.Column('format', db.String(length=10), nullable=False))
    run_sql('UPDATE collection_format cf JOIN format f ON f.id = cf.id_format '
            'SET cf.format = f.code')
    op.drop_constraint(None, 'collection_format', type_='primary')
    op.create_primary_key(None, 'collection_format',
                          ['id_collection', 'format'])
    op.drop_column('collection_format', 'id_format')
    op.drop_table('formatname')
    op.drop_table('format')
def do_upgrade():
    """Migrate format references."""
    op.add_column('collection_format',
                  db.Column('format', db.String(length=10), nullable=False))
    run_sql('UPDATE collection_format cf JOIN format f ON f.id = cf.id_format '
            'SET cf.format = f.code')
    op.drop_constraint(None, 'collection_format', type_='primary')
    op.create_primary_key(None, 'collection_format',
                          ['id_collection', 'format'])
    op.drop_column('collection_format', 'id_format')
    op.drop_table('formatname')
    op.drop_table('format')
コード例 #4
0
def do_upgrade():
    op.drop_table(u'wtgTAG_usergroup')

    op.add_column(
        'wtgTAG',
        db.Column('group_access_rights',
                  mysql.INTEGER(display_width=2),
                  nullable=False))

    op.add_column(
        'wtgTAG',
        db.Column('id_usergroup',
                  mysql.INTEGER(display_width=15),
                  server_default='0',
                  nullable=True))
    op.add_column(
        'wtgTAG_bibrec',
        db.Column('annotation', db.Text(convert_unicode=True), nullable=True))
コード例 #5
0
def do_upgrade():
    op.drop_table(u'depDRAFT')
    op.drop_table(u'depWORKFLOW')
    op.drop_table(u'bibdoc_bibdoc_backup_newdatamodel')
    op.drop_table(u'bibdoc_backup_newdatamodel')
コード例 #6
0
def do_upgrade():
    op.drop_table(u'depDRAFT')
    op.drop_table(u'depWORKFLOW')
    op.drop_table(u'bibdoc_bibdoc_backup_newdatamodel')
    op.drop_table(u'bibdoc_backup_newdatamodel')