def upgrade():
session = Session(bind=op.get_bind())
op.drop_column('system_settings', 'created')
op.drop_column('system_settings', 'deleted')
op.add_column('system_settings', sa.Column('label', sa.Text, nullable=True))
op.add_column('system_settings', sa.Column('description', sa.Text, nullable=True))
op.add_column('system_settings', sa.Column('placeholder', sa.String, nullable=True))
billing_link = session.query(SystemSettings).filter_by(name='billing_apps_link').order_by(SystemSettings.id.desc()).first()
if billing_link is not None:
last = billing_link.id
session.query(SystemSettings).filter(SystemSettings.id!=last).delete()
billing_link.label = 'Link to billing system script'
billing_link.description = 'Link to predefined application request processing script'
billing_link.placeholder = 'http://whmcs.com/script.php'
else:
bl = 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')
session.add(bl)
pd = SystemSettings(name='persitent_disk_max_size',
value='10',
label='Persistent disk maximum size',
description='maximum capacity of a user container persistent disk in GB',
placeholder = 'Enter value to limit PD size')
session.add(pd)
ms = SystemSettings(name='default_smtp_server',
label='Default SMTP server',
description='Default SMTP server',
placeholder = 'Default SMTP server')
session.add(ms)
session.commit()
op.create_unique_constraint('uq_system_settings_name', 'system_settings', ['name'])
56ab56a9ac5_change_settings_schema_and_add_initial_.py 文件源码
python
阅读 23
收藏 0
点赞 0
评论 0
评论列表
文章目录