def index(request): #overview resultTitle=["enzymeId","substrateName","productName",] #fetch data import MySQLdb import util.dbOperator as dbor from properties import dbProperties dbConn = MySQLdb.connect(host=dbProperties["dbHost"],user=dbProperties["dbUser"],passwd=dbProperties["dbPw"],db="enzymetib",charset='utf8') dbCursor = dbConn.cursor() tableName="enzyme" fieldNameArray=resultTitle parameterDic={} sqlString="select distinct "+(",".join(fieldNameArray))+" from "+tableName if (parameterDic): parameterData=[] parameterTitle=[] for k,v in parameterDic.iteritems(): parameterData.append(v) parameterTitle.append(k) sqlString=sqlString+" where ("+(",".join(parameterTitle))+")=('"+("','".join(parameterData))+"')" #logger.debug(sqlString) sqlResultData,sqlResultCount=dbor.sqlSelect(sqlString,dbCursor) #logger.debug(sqlResultCount) dbConn.close() #return sqlResultData,sqlResultCount resultData,resultCount=sqlResultData,sqlResultCount #resultData,resultCount=selectData("enzyme",resultTitle,{}) return render(request, os.path.join(htmlFolderPath,'index.html').replace('\\', '/'),locals())
def selectData(tableName,fieldNameArray,parameterDic): #prepare db import util.dbOperator as dbor dbConn,dbCursor=dbor.prepareDb() #fetch data sqlString="select distinct "+(",".join(fieldNameArray))+" from "+tableName if (parameterDic): parameterData=[] parameterTitle=[] for k,v in parameterDic.iteritems(): parameterData.append(v) parameterTitle.append(k) sqlString=sqlString+" where ("+(",".join(parameterTitle))+")=('"+("','".join(parameterData))+"')" # logger.debug(sqlString) sqlResultData,sqlResultCount=dbor.sqlSelect(sqlString,dbCursor) # logger.debug(sqlResultCount) #close dbConn.close() return sqlResultData,sqlResultCount