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)
def http_parse_query(meg):
http=LHBMap();
regex = re.compile("(GET|POST)\s+(.+?)\s+(.+?)\r\n", re.IGNORECASE)
out=regex.findall(meg)
if len(out)>0:
http.setvalue("HTTP_METHOD", out[0][0])
http.setvalue("HTTP_QUERY_STRING", out[0][1])
http.setvalue("HTTP_PROTOCOL", out[0][2])
else:
http.setvalue("HTTP_METHOD", "")
http.setvalue("HTTP_QUERY_STRING", "")
http.setvalue("HTTP_PROTOCOL", "")
http_parse_query_item(meg,"Accept:\s+(.+?)\r\n",http,"HTTP_ACCEPT")
http_parse_query_item(meg,"Accept-Language:\s+(.+?)\r\n",http,"HTTP_ACCEPT_LANGUAGE")
http_parse_query_item(meg,"User-Agent:\s+(.+?)\r\n",http,"HTTP_USER_AGENT")
http_parse_query_item(meg,"Content-Type:\s+(.+?)\r\n",http,"HTTP_CONTENT_TYPE")
http_parse_query_item(meg,"Accept-Encoding:\s+(.+?)\r\n",http,"HTTP_ACCEPT_ENCODING")
http_parse_query_item(meg,"Host:\s+(.+?)\r\n",http,"HTTP_HOST")
http_parse_query_item(meg,"Connection:\s+(.+?)\r\n",http,"HTTP_CONNECTION")
http_parse_query_item(meg,"Content-Length:\s+(.+?)\r\n",http,"HTTP_CONNECTION_LENGTH")
http_parse_query_item(meg,"Cache-Control:\s+(.+?)\r\n",http,"HTTP_CACHE_CONTROL")
regex = re.compile("\r\n\r\n(.+)", re.IGNORECASE)
out=regex.findall(meg)
if len(out)>0:
http.setvalue("HTTP_POST_VARS", out[0])
else:
http.setvalue("HTTP_POST_VARS", "")
return http
