def http_queryobject(httpMap):
querystring="";
regex = re.compile(".+\?(.+)", re.IGNORECASE)
out=regex.findall(httpMap.getvalue("HTTP_QUERY_STRING"))
if len(out)>0:
querystring="&"+out[0]
if httpMap.getvalue("HTTP_POST_VARS")!="":
querystring="&"+httpMap.getvalue("HTTP_POST_VARS")
regex = re.compile("&(\w+)=([^&]+)", re.IGNORECASE)
out=regex.findall(querystring)
queryobject=LHBMap()
queryobject.clear()
for i in range(len(out)):
queryobject.put(out[i][0], out[i][1])
return queryobject
import cx_Oracle
from awspy.database import DbModel, Db
class DbOracle(Db):
'''
classdocs
'''
def __init__(self,connstr=None,host=None,user=None,passwd=None,db=None):
Db.__init__(self,connstr,host,user,passwd,db)
def getCursor(self):
self.conn=cx_Oracle.connect(self.connstr)
self.cursor = self.conn.cursor()
if __name__=="__main__":
db=DbOracle("jjoa/[email protected]:1521/ORCL1")
model= DbModel(db,"t_count")
f=LHBMap();
f.put("countname as tt","newid1")
f.put("countcontent.string","2")
# print model.getInsertResult(f)
# print model.getUpdateResult(f, "countname='newid1'")
rs=model.getSelectResult(f)
print rs.getitem()
#
# print model.getDeleteResult("countname='newid1'")
# print model.getSelectResult(f)
