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())
