コード例 #1
0
    def getFieldByCondition(self,aParam):
        '''
        根据条件查询内容
        '''
        resultRow = 1
        if(aParam!=None):

            sSql = " SELECT %s FROM %s WHERE 1=1  AND %s "
            if( aParam.has_key(Config.HAS_JOIN) and  aParam[Config.HAS_JOIN]!=""):
                sSql = " SELECT %s FROM %s " + aParam[Config.HAS_JOIN] +" WHERE 1=1 AND %s"
            condition = " AND 1=1 "
            SearchFields = " * "
            if( aParam.has_key(Config.S_SEARCHFIELDS) and  aParam[Config.S_SEARCHFIELDS]!=""):
                SearchFields=aParam[Config.S_SEARCHFIELDS]
            if(aParam.has_key(Config.S_SEARCHCONDITION) and aParam[Config.S_SEARCHCONDITION]!=""):
                condition=aParam[Config.S_SEARCHCONDITION]
            if(aParam.has_key(Config.S_RESULTROW) and aParam[Config.S_RESULTROW]>1):
                resultRow=aParam[Config.S_RESULTROW]

            sSql = sSql % (SearchFields,aParam[Config.S_TABLE],condition)
#            Func.debugInfo(sSql)
            if(aParam.has_key(Config.S_ORDERBY) and aParam[Config.S_ORDERBY]!=""):
                sOrderBy = aParam[Config.S_ORDERBY]
                sSql = sSql+(" ORDER BY %s" % sOrderBy )
            if(aParam.has_key(Config.S_LIMIT) and aParam[Config.S_LIMIT]!=""):
                sLimit = aParam[Config.S_LIMIT]
            else:
                sLimit = " 1 ";
            if(aParam.has_key(Config.S_FETCH_ALL) and aParam[Config.S_FETCH_ALL]==False):
                    sSql = sSql + (" LIMIT %s"%sLimit)
            Func.debugInfo(sSql)
            if(resultRow>1):
                return self.findAll(sSql)
            else:
                return self.getOne(sSql)
        else:
            return None
コード例 #2
0
 def __init__(self):
     self.__pool = PooledDB(mysql.connector,mincached=0, maxcached=10, maxshared=10, maxusage=10000, **Func.getConfig("DbConnectString"))