def downgrade(upd, with_testing, exception, *args, **kwargs):
# 00090_update.py
upd.print_log('Downgrade system_settings scheme...')
redis = ConnectionPool.get_connection()
SystemSettings.query.delete()
db.session.add_all([
SystemSettings(name='billing_apps_link',
label='Link to billing system script',
description='Link to predefined application request processing script',
placeholder='http://whmcs.com/script.php',
value=redis.get('old_billing_apps_link')),
SystemSettings(name='persitent_disk_max_size',
value=redis.get('old_persitent_disk_max_size'),
label='Persistent disk maximum size',
description='maximum capacity of a user container persistent disk in GB',
placeholder='Enter value to limit PD size')
])
db.session.commit()
helpers.downgrade_db(revision='27ac98113841')
# 00094_update.py
try:
from kubedock.nodes.models import NodeMissedAction
except ImportError:
upd.print_log('Cannot find NodeMissedAction model')
else:
upd.print_log('Create table for NodeMissedAction model if not exists')
NodeMissedAction.__table__.create(bind=db.engine, checkfirst=True)
db.session.commit()
# 00099_update.py
helpers.downgrade_db(revision='46bba639e6fb') # first of rc4
def downgrade(upd, with_testing, exception, *args, **kwargs):
# 00103_update.py
upd.print_log('Disabling restart for ntpd.service on master')
local('rm -f ' + OVERRIDE_FILE)
local('systemctl daemon-reload')
# 00105_update.py
upd.print_log('Remove MenuRoles...')
PAUserRole = Role.query.filter(Role.rolename == 'LimitedUser').first()
if PAUserRole is not None:
for menu_role in PAUserRole.menus_assocs:
db.session.delete(menu_role)
upd.print_log('Delete roles {} with its permissions...'.format(ROLES))
fixtures.delete_roles([name for name, internal in ROLES])
upd.print_log(
'Delete resources {} with its permissions...'.format(RESOURCES))
fixtures.delete_resources(RESOURCES)
db.session.commit()
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='2df8c40ab250') # first of rc5
upd.print_log('Restoring uwsgi configuration ...')
local('test -f "{0}" && mv "{0}" "{1}"'.format(SAVE_KUBERDOCK_INI,
UWSGI_KUBERDOCK_INI_DEST))
def downgrade(upd, with_testing, exception, *args, **kwargs):
# 00119
upd.print_log('Allow null in User.package_id field...')
helpers.downgrade_db(revision='2c64986d76b9')
# 00118
upd.print_log('Reverting package count_type column...')
helpers.downgrade_db(revision='42b36be03945')
# 00117
upd.print_log('Downgrade permissions...')
Permission.query.delete()
Resource.query.delete()
add_permissions()
db.session.commit()
# 00116
upd.print_log('Remove system settings for CPU and Memory multipliers')
for name in ('cpu_multiplier', 'memory_multiplier'):
entry = SystemSettings.query.filter_by(name=name).first()
if entry is not None:
db.session.delete(entry)
upd.print_log('Drop table "node_actions" if exists')
table = Table('node_actions', db.metadata)
table.drop(bind=db.engine, checkfirst=True)
db.session.commit()
helpers.close_all_sessions()
def downgrade(upd, with_testing, exception, *args, **kwargs):
# 00080_update.py
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='37ccf7811576')
# 00081_update.py
upd.print_log('Return old urls')
for item in MenuItem.query.all():
if item.path:
item.path = '{0}/'.format(item.path.replace('#', '/', 1))
db.session.commit()
def downgrade(upd, with_testing, exception, *args, **kwargs):
_downgrade_k8s_master(upd, with_testing)
service, res = helpers.restart_master_kubernetes()
if res != 0:
raise helpers.UpgradeError('Failed to restart {0}. {1}'
.format(service, res))
_downgrade_etcd(upd)
# Restart KD to make sure new libs are running
res = helpers.restart_service(settings.KUBERDOCK_SERVICE)
if res != 0:
raise helpers.UpgradeError('Failed to restart KuberDock')
helpers.downgrade_db(revision='3c832810a33c')
def downgrade(upd, *args, **kwars):
# === 00137_update.py ===
# upd.print_log('Downgrading db...')
# downgrade_db(revision='220dacf65cba')
# === 00135_update.py ===
upd.print_log('Downgrading db...')
downgrade_db(revision='45e4b1e232ad')
# === 00124_update.py ===
try:
stop_service(u124_service_name)
if os.path.isfile(u124_new) and not os.path.isfile(u124_old):
shutil.move(u124_new, u124_old)
finally:
start_service(u124_service_name)
def downgrade(upd, with_testing, exception, *args, **kwargs):
#00109_update.py
upd.print_log('Downgrade system_settings scheme...')
redis = ConnectionPool.get_connection()
old_settings = redis.get('old_system_settings')
if old_settings:
# restore old settings
SystemSettings.query.delete()
for param in json.loads(old_settings):
db.session.add(
SystemSettings(name=param.get('name'),
label=param.get('label'),
description=param.get('description'),
placeholder=param.get('placeholder'),
options=json.dumps(param.get('options')),
value=param.get('value')))
db.session.commit()
#00113_update.py
upd.print_log('Removing "count_type" column from packages...')
helpers.downgrade_db(revision='27c8f4c5f242')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='1139a080f512')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db()
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='28b23145af40')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='56f9182bf415')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='241a7b04a9ff')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='3d2db4a87f86')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='46b5b819ba35')
def downgrade(upd, with_testing, exception, *args, **kwargs):
helpers.downgrade_db(revision='3a8320be841c')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='33ae2dd8e49b')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='3505518f6f4f')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='3a8320be841c')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='589e137e4b7c')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Remove PersistentDisk model.')
helpers.downgrade_db(revision='1ee2cbff529c')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Delete permissions to system settings ...')
drop_permissions()
helpers.downgrade_db()
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='5049471549ba')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='4912523d89cb')
def downgrade(upd, with_testing, exception, *args, **kwargs):
upd.print_log('Downgrading db...')
helpers.downgrade_db(revision='312700b6c892')
