def impl_loadaattrs(request): ''' 查询指定表包含的字段 ''' keys = ['appname', 'tablename'] res = {'support keys:': ','.join(keys)} if request.method == 'POST': kwargs = dict() for key, val in request.POST.items(): try: val = json.loads(val) except Exception as e: pass # traceback.print_exc() kwargs[key] = val # {key: val for key, val in request.POST.items()} if func.checkparams(kwargs, keys): if 'with_verbose_name' not in kwargs.keys(): kwargs['with_verbose_name'] = True res = func.loadtable_attributes(**kwargs) # print ('res: ', res) else: res['your keys'] = kwargs return JsonResponse(packing.JsonResponsePack(data=res).val())
def cmpl_loadfilter(request): ''' 根据给定的多表查询的条件 获取指定的字段''' # keys = settings.MY_INSTALLED_APPS# app name list keys = ['condition', 'tablelist'] res = { 'support keys': ','.join(keys), 'tips': '''condition typeof dict or json, and tablelist typeof list. eg. {'condition':{'id':2},'tablelist':['conf.ConfExaminationItem','conf.ConfExaminationPlot']} ''' } if request.method == 'POST': kwargs = dict() for key, val in request.POST.items(): try: val = json.loads(val) except Exception as e: traceback.print_exc() kwargs[key] = val if func.checkparams(kwargs, keys): ''' 只要kwargs的key, 都存在于keys下即可''' res = func.loadtable_filter_cmpl(**kwargs) else: res['your keys'] = kwargs return JsonResponse(packing.JsonResponsePack(data=res).val())
def impl_loadfilter(request): ''' 查询指定的modelname,tablename,condition的数据并返回json eg. condition: {'key1':'value1','key2':'value2'} --> json格式 ''' # 应当包含的参数 keys = ['appname', 'tablename', 'condition'] res = { 'support keys:': ','.join(keys), 'tips': 'condition typeof dict or json' } if request.method == 'POST': kwargs = dict() for key, val in request.POST.items(): try: val = json.loads(val) except Exception as e: pass # traceback.print_exc() kwargs[key] = val # {key: val for key, val in request.POST.items()} if func.checkparams(kwargs, keys): res = func.loadtable_filter(**kwargs) # print ('res: ', res) else: res['your keys'] = kwargs return JsonResponse(packing.JsonResponsePack(data=res).val())
def impl_loadone(request): ''' 查询指定modelname,tablename,id的数据并返回json''' # 应当包含的参数 keys = ['appname', 'tablename', 'itemid'] res = {'support keys:': ','.join(keys), 'tips': 'itemid typeof number'} if request.method == 'POST': kwargs = dict() for key, val in request.POST.items(): try: val = json.loads(val) except Exception as e: pass # traceback.print_exc() kwargs[key] = val # {key: val for key, val in request.POST.items()} if func.checkparams(kwargs, keys): res = func.loadtable_one(**kwargs) # print ('res: ', res) else: res['your keys'] = kwargs return JsonResponse(packing.JsonResponsePack(data=res).val())
def impl_saveobj(request): ''' 保存指定的modelname,tablename,obj的数据,并返回保存成功与否 eg. obj {'id':1,'name':'name1'} --> json格式 ''' # 应当包含的参数 keys = ['appname', 'tablename', 'obj'] res = {'support keys:': ','.join(keys), 'tips': 'obj typeof dict or json'} if request.method == 'POST': kwargs = dict() for key, val in request.POST.items(): try: val = json.loads(val) except Exception as e: pass # traceback.print_exc() kwargs[key] = val # {key: val for key, val in request.POST.items()} if func.checkparams(kwargs, keys): res = func.savetable_obj(**kwargs) # print ('res: ', res) else: res['your keys'] = kwargs return JsonResponse(packing.JsonResponsePack(data=res).val())