self.dbname = 'user' self.table = 'user_corp_file' def on_get(self,req,resp,action): params = req.params kw = {} kw['table'] = self.table kw['dbname']= self.dbname kw['fields']= params.get('fields','') if action == 'getcachebyuserid': """根据会员ID获取公司档案缓存信息""" user_id = params.get('user_id','') if not user_id : raise falcon.HTTPBadRequest('illegal_argument','user_id must provided') kw['where'] = "user_id=%s" % user_id kw['order'] ='id desc' result = dbhandle.getlist(kw) else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/query/userinfo/{action}'% __Version,userinfo()) app.add_route('/%s/query/usercorpfile/{action}'% __Version,usercorpfile())
kw['page'] = int(params.get('page',1)) kw['pageSize'] = int(params.get('pagesize',sconf.PAGE_SIZE)) kw['index'] = index kw['orderBy'] = params.get('order') kw['groupBy'] = params.get('group') kw['fields'] = params.get('fields','') result = sphandle.search(kw) if result[0] == -1: raise falcon.HTTPError(falcon.HTTP_400,'searchd error',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) def on_post(self,req,resp,index): if index not in self.indexs: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant',"invalid index name %s" % index) params = req.context params['index'] = index result = sphandle.search(kw) if result[0] == -1: raise falcon.HTTPError('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/search/{index}'% __Version,search())
elif action == 'gettagsbynames': """根据标签名称列表获取产品标签ID """ name = params.get('name','') if not name : raise falcon.HTTPBadRequest('illegal_argument','name must provided') if type(name) in (tuple,list): name = ','.join(['"%s"'%k for k in name]) kw['where'] = 'name in (%s)' % name else: kw['where'] = "name='%s'" % name result = dbhandle.query(kw) else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/query/zsinfo/{action}'% __Version,zsinfo()) app.add_route('/%s/query/zstag/{action}'% __Version,zstag())
raise falcon.HTTPBadRequest('illegal_argument','title must provided') kw['where'] = "title='%s'" % title if com_id: kw['where'] = "com_id=%s and %s" % (com_id,kw['where']) res, desc = dbhandle.getlist(kw) if res ==0: rs = {'status':1,'data':[]} if desc : rs['status'] = 2 rs['data'] = desc result = 0,rs else: result = res, desc else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/query/buyinfo/{action}'% __Version,buyinfo())
raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant',"invalid databases name %s" % dbname) if '.' in table: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant',"invalid table name %s" % table) kw = req.params kw['table'] = table kw['dbname']= dbname if action == 'getbyid': if 'ids' not in kw: raise falcon.HTTPBadRequest('illegal_argument','ids must provided') result = dbhandle.getbyid(kw) elif action == 'getcount': result = dbhandle.getcount(kw) elif action == 'getlist': result = dbhandle.getlist(kw) else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/dbo/{dbname}/{table}'% __Version,rest_mysql()) app.add_route('/%s/dbo/{dbname}/{table}/{action}'% __Version,rest_mysql_query())
raise falcon.HTTPBadRequest('illegal_argument','letters must provided') kw['where'] = "letters='%s'" % letters print(kw) result = dbhandle.query(kw) elif action == 'getbyname': """根据关键字查找相关关键字(产品、公司、网址、求购) """ keyw = params.get('keyw','') if not keyw : raise falcon.HTTPBadRequest('illegal_argument','keyw must provided') kw['where'] = "keyw='%s'" % keyw result = dbhandle.query(kw) else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/query/prodinfo/{action}'% __Version,prodinfo()) app.add_route('/%s/query/prodtag/{action}'% __Version,prodtag()) app.add_route('/%s/query/keywrelate/{action}'% __Version,keywrelate())
raise falcon.HTTPBadRequest('illegal_argument','letters must provided') kw['where'] = "letters='%s'" % letters print(kw) result = dbhandle.query(kw) elif action == 'getbyname': """根据关键字查找相关关键字(资讯、公司、网址、求购) """ keyw = params.get('keyw','') if not keyw : raise falcon.HTTPBadRequest('illegal_argument','keyw must provided') kw['where'] = "keyw='%s'" % keyw result = dbhandle.query(kw) else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/query/newsinfo/{action}'% __Version,newsinfo()) app.add_route('/%s/query/newstag/{action}'% __Version,newstag()) app.add_route('/%s/query/keywrelate/{action}'% __Version,keywrelate())
elif action == 'gettagbycomid': """根据公司id获取一条公司标签关联值""" kw['table'] = 'com_tag_relate' com_id = params.get('com_id','') if not com_id : raise falcon.HTTPBadRequest('illegal_argument','com_id must provided') kw['where'] = "com_id=%s" % com_id kw['limit'] = "1" result = dbhandle.getlist(kw) elif action == 'getkeywbycomid': """根据公司id获取公司展厅关键字""" kw['table'] = 'com_keyword' com_id = params.get('com_id','') if not com_id : raise falcon.HTTPBadRequest('illegal_argument','com_id must provided') kw['where'] = "com_id=%s" % com_id kw['limit'] = "1" result = dbhandle.getlist(kw) else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/query/comcorp/{action}'% __Version,comcorp())
kw['fields'] = ','.join(kw['fields']) tag_id = int(params.get('tag_id',0)) if not tag_id : raise falcon.HTTPBadRequest('illegal_argument','tag_id must provided') kw['where'] = "tag_id=%s or (tag_id>%s and tag_id <%s) or (tag_id>%s and tag_id <%s)" % (tag_id,(tag_id*100),((tag_id+1)*1000),(tag_id*1000000),((tag_id+1)*1000000)) res, desc = dbhandle.query(kw) if res ==0: rs = {} for row in desc: rs[row['tag_id']] = row result = 0,rs else: result = res, desc else: raise falcon.HTTPError(falcon.HTTP_404,'invalid_grant','invalid action %s' % action) if result[0] == -1: raise falcon.HTTPBadRequest('invalid_sql_syntax',str(result[1])) result={'result':result[1]} resp.body = JSONEncoder().encode(result) #-------- #注册模块路由 #-------- app.add_route('/%s/query/common/{action}'% __Version,common())