def create(**kwargs):
# 1 获取参数
# print kwargs
# 2 检查参数
# for field in kwargs.keys():
# # 2.1 验证参数是否在idc表中
# if not hasattr(Idc, field):
# # logging
# current_app.logger.warning(
# "参数错误，{} 不在Idc这张表中".format(field)
# )
# raise Exception("params error: {}".format(field))
# # 2.2 不能为空
# if not kwargs.get(field, None):
# # logging
# current_app.logger.warning(
# "参数错误，{} 不能为空".format(field)
# )
# raise Exception("{} 不能为空".format(field))
check_field_exists(Idc, kwargs)
# 3 插入到数据库
idc = Idc(**kwargs)
db.session.add(idc)
try:
db.session.commit()
except Exception, e:
# logging
current_app.logger.warning("commit error: {}".format(e.message))
raise Exception("commit error")
def create(**kwargs):
check_field_exists(Idc,kwargs)
obj = Idc(**kwargs)
db.session.add(obj)
try:
db.session.commit()
except Exception,e:
raise Exception(e.message.split(")")[1])
def create(**kwargs):
#1.获取参数信息
check_field_exists(Idc, kwargs)
#2.传参个数验证
obj = Idc(**kwargs)
db.session.add(obj)
db.session.commit()
return obj.id
def idc_add():
form = AddIdcForm(data=request.get_json())
if form.validate_on_submit():
idc = Idc(name=form.name.data,
zone=form.zone.data,
region=form.region.data,
description=form.description.data)
db.session.add(idc)
db.session.commit()
flash('%s is add.' % form.name.data, 'success')
else:
flash_errors(form)
return redirect(url_for('.idc'))
def create(**params):
# 1. 获取参数信息
check_field_exists(Idc, params)
print inspect.getmembers(Idc, predicate=inspect.ismethod(id))
# 传参的个数需要验证
obj = Idc(**params)
# 插入到数据库
db.session.add(obj)
db.session.commit()
return obj.id
def create(**kwargs):
# 1. 获取参数
# 2. 验证参数是否合法
check_field_exists(Idc, kwargs)
idc = Idc(**kwargs)
db.session.add(idc)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning("插入错误: {} ".format(e.message))
raise Exception("commit error")
# 3. 插入到数据库
# 4. 返回插入的状态
return idc.id
def idc_insert_data():
idcs = {
u'周浦': '',
u'北京南路': '',
u'欧阳路': '',
u'万国数据中心': '',
u'Ucloud': '',
u'aliyun': '',
u'北京酒仙桥': '',
u'金华双线': '',
u'宁波三线': '',
u'无锡线路': '',
u'南京联通': '',
u'青岛联通': '',
}
for s in idcs:
idc = Idc.query.filter_by(name=s).first()
if idc is None:
idc = Idc(name=s)
idc.description = idcs[s]
db.session.add(idc)
db.session.commit()
print "Insert idc test data."
def create(**kwargs):
# 1 获取用户传入参数
print kwargs
# 2 验证参数的合法性
check_field_exists(Idc, kwargs)
# 3 插入到数据库
idc = Idc(**kwargs)
db.session.add(idc)
try:
db.session.commit()
except Exception, e:
current_app.logger.warning("commit error: {}".format(e.message))
raise Exception("commit error")
def create(**kwargs):
#1获取参数
check_field_exists(Idc, kwargs)
#2处理数据
#print inspect.getmembers(Idc, predicate=inspect.is)
#return 1
print kwargs
#3实例化idc
idc = Idc(**kwargs)
#4插入到数据库
db.session.add(idc)
try:
db.session.commit()
except Exception, e:
raise Exception(e.message.split(") ")[1])
def create(**params):
# 1. 获取参数信息
check_field_exists(Idc, params)
print inspect.getmembers(Idc,predicate=inspect.ismethod(id))
# 传参的个数需要验证
obj = Idc(**params)
# 插入到数据库
db.session.add(obj)
try:
db.session.commit()
except Exception,e:
print e.message.split()[1]
raise Exception(e.message.split(") ")[1])
def create(**kwargs):
"""
"""
# 1.获取参数
print kwargs
# 2.检查参数
for field in kwargs.keys():
if not hasattr(Idc, field):
current_app.logger.warning("参数错误，{}不在idc这张表里".format(field))
raise Exception("params error:{}".format(field))
if not kwargs.get(field, None):
current_app.logger.warning("参数错误，{}不能为空".format(field))
raise Exception("{}不能为空".format(field))
# 3.插入到数据库
idc = Idc(**kwargs)
db.session.add(idc)
try:
db.session.commit()
current_app.logger.debug("新增参数为 {}的数据成功".format(kwargs))
except Exception, e:
current_app.logger.warning("commit error:{}".format(e.message))
raise Exception("commit error")
def idc_list():
page = request.args.get('page', 1, type=int)
per_page = request.args.get('per_page', 10, type=int)
data = Idc.to_collection_dict(Idc.query, page, per_page, 'cmdb.idc_list')
return jsonify(data)
