def getUri(request, protocol="HTTP"): if protocol == "ALL": return executeSqlGetDict( "SELECT cu.*,u.userName FROM tb_config_uri cu LEFT JOIN (SELECT * FROM tb_user_uri WHERE addBy= %s ) uu ON cu.uriKey = uu.uriKey LEFT JOIN tb_user u ON cu.addBy = u.loginName WHERE cu.state = 1 ORDER BY uu.confLevel IS NULL,uu.confLevel ASC ,cu.addTime desc", [request.session.get("loginName")]) else: return executeSqlGetDict( "SELECT cu.*,u.userName FROM tb_config_uri cu LEFT JOIN (SELECT * FROM tb_user_uri WHERE addBy= %s ) uu ON cu.uriKey = uu.uriKey LEFT JOIN tb_user u ON cu.addBy = u.loginName WHERE cu.state = 1 AND cu.protocol = %s ORDER BY uu.confLevel IS NULL,uu.confLevel ASC ,cu.addTime desc", [request.session.get("loginName"), protocol])
def getPythonThirdLib(): importStr = "" if not serviceRedis.existsKey("python_third_libs"): res = executeSqlGetDict( "select execPythonValue from tb_exec_python_attrs where execPythonAttr = 'importString' " ) if res: importStr = res[0]['execPythonValue'] serviceRedis.set_data("python_third_libs", importStr) print("INIT KEY[python_third_libs] to redis!!!") return serviceRedis.get_data("python_third_libs")
def getKeywordExecPythonTimeout(key="timeoutString"): timeout = 10 currentKey = "python_timeout_%s" % key if not serviceRedis.existsKey(currentKey): res2 = executeSqlGetDict( "select execPythonValue from tb_exec_python_attrs where execPythonAttr = '%s' " % key) if res2: timeoutStr = res2[0]['execPythonValue'] if isInt(timeoutStr): timeout = int(timeoutStr) serviceRedis.set_data(currentKey, timeout) print("INIT KEY[%s] to redis!!!" % currentKey) return int(serviceRedis.get_data(currentKey))
def getAllHttpConf(request): return executeSqlGetDict( "SELECT ch.httpConfKey,ch.alias,ch.httpConfDesc FROM tb_config_http ch LEFT JOIN " "(SELECT * FROM tb_user_httpconf WHERE addBy = %s ) uh on ch.httpConfKey = uh.httpConfKey " "WHERE ch.state = 1 ORDER BY uh.conflevel is null,uh.conflevel asc , ch.modTime desc ", request.session.get("loginName"))
def queryUIRunHttpConfSort(request): return executeSqlGetDict( "SELECT ch.httpConfKey,ch.alias FROM tb_config_http ch LEFT JOIN (SELECT * FROM tb_user_httpconf WHERE addBy = %s ) uh on ch.httpConfKey = uh.httpConfKey WHERE ch.state = 1 AND ch.uiRunState = 1 ORDER BY uh.conflevel is null,uh.conflevel asc , ch.modTime desc ", request.session.get("loginName"))
def queryServiceConfSort(request): return executeSqlGetDict( "SELECT * from tb_config_service s LEFT JOIN (select * from ( SELECT id ucid,httpConfKey uhck,confLevel from tb_user_httpconf where addBy= %s ) b LEFT JOIN (SELECT id hid,serviceConfKey hsk,httpConfKey hck from tb_config_http) a on b.uhck = a.hck) c on s.serviceConfKey = c.hsk where s.state = 1 group by s.serviceConfKey order by c.confLevel is null,c.confLevel ASC", [request.session.get("loginName")])
import apps.common.func.InitDjango from apps.common.func.CommonFunc import dbModelListToListDict, executeSqlGetDict from all_models.models import TbConfigService class ServiceConfService(object): @staticmethod def getServiceConf(): return dbModelListToListDict(TbConfigService.objects.filter(state=1)) @staticmethod def queryServiceConfSort(request): return executeSqlGetDict( "SELECT * from tb_config_service s LEFT JOIN (select * from ( SELECT id ucid,httpConfKey uhck,confLevel from tb_user_httpconf where addBy= %s ) b LEFT JOIN (SELECT id hid,serviceConfKey hsk,httpConfKey hck from tb_config_http) a on b.uhck = a.hck) c on s.serviceConfKey = c.hsk where s.state = 1 group by s.serviceConfKey order by c.confLevel is null,c.confLevel ASC", [request.session.get("loginName")]) if __name__ == "__main__": # print((businessService.=))) # print(UserService.getUserByLoginname(UserService.getUsers()[0].loginname)) # print(ServiceConfService.queryServiceConfSort()) print( executeSqlGetDict( "SELECT * from tb_config_service s LEFT JOIN (select * from ( SELECT id ucid,httpConfKey uhck,confLevel from tb_user_httpconf where addBy= %s ) b LEFT JOIN (SELECT id hid,serviceConfKey hsk,httpConfKey hck from tb_config_http) a on b.uhck = a.hck) c on s.serviceConfKey = c.hsk where s.state = 1 group by s.serviceConfKey order by c.confLevel is null,c.confLevel ASC", ["liyc"]))