def save(param):
try:
# 创建新User对象:
new_asset =Asset( sn=param['wxsn'], purchase_date= '0000-00-00', idc_id =param['idc_id'], is_virtual =1)
session.add(new_asset)
session.flush()
session.commit()
param['asset_id'] = new_asset.id
new_ip =IP( outer_ip=param['outer_ip'],idc_id =param['idc_id'],is_balancer = 1)
session.add(new_ip)
session.flush()
session.commit()
param['ip_id'] = new_ip.id
new_idc_op_ship =idc_op_ship( asset_id=param['asset_id'],cabinet_id= 0 , game_id=0 , cluster_id = 0, idc_id =param['idc_id'], ip_id = param['ip_id'])
session.add(new_idc_op_ship)
new_sys_op_ship=sys_op_ship( asset_id=param['asset_id'], game_id=0 , cluster_id = 0, services_id =0, ip_id = param['ip_id'])
session.add(new_sys_op_ship)
session.flush()
session.commit()
except:
session.rollback()
def main():
if not engine.dialect.has_table(engine, 'wine_attributes'):
Base.metadata.create_all(engine)
try:
file_name = "wine_attributes.csv"
data = load_data(file_name)
for i in data:
record = WineAttribute(
**{
'japanese_title': i[1],
'english_title': i[2],
'step': float(i[3]),
'max_value': float(i[4]),
'min_value': float(i[5])
})
session.add(record)
session.commit()
except Exception as e:
print(e)
session.rollback()
finally:
session.close()
def save(param):
try:
# 创建新User对象:
new_user =IDC( name=param['name'],prefix=param['prefix'])
session.add(new_user)
session.commit()
except:
session.rollback()
def save(param):
try:
new_sys_op_ship=sys_op_ship( asset_id=param['asset_id'], game_id=0 , cluster_id = 0, services_id =0, ip_id = param['ip_id'])
session.add(new_sys_op_ship)
session.flush()
session.commit()
return new_sys_op_ship.id
except:
session.rollback()
def save(param):
try:
# 创建新User对象:
new_ip =IP( outer_ip=param['outer_ip'],inner_ip=param['inner_ip'],idc_id =param['idc_id'])
session.add(new_ip)
session.flush()
session.commit()
return new_ip.id
except:
session.rollback()
def save(param):
try:
# 创建新User对象:
new_asset =Asset( sn=param['wxsn'], purchase_date=param['purchase_date'], idc_id =param['idc_id'], is_virtual =1)
session.add(new_asset)
session.flush()
session.commit()
return new_asset.id
except:
session.rollback()
def save(param):
try:
# 创建新User对象:
new_idc_op_ship =idc_op_ship( asset_id=param['asset_id'],cabinet_id= 0 , game_id=0 , cluster_id = 0, idc_id =param['idc_id'], ip_id = param['ip_id'])
session.add(new_idc_op_ship)
session.flush()
session.commit()
return new_idc_op_ship.id
except:
session.rollback()
