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)