I have my little class for working with MySQL:
# -*- coding: utf-8 -*-
import MySQLdb
class Sql(object):
__db=None
__cur=None
__numRows=None
def __init__(self,conf):
try:
self.__db=MySQLdb.connect(host=conf["host"],user=conf["user"],\
passwd=conf["passwd"],db=conf["db"],\
use_unicode=False,charset=conf["charset"])
except:
self.__db=False
def query(self,query):
if self.__db:
self.__cur=self.__db.cursor(MySQLdb.cursors.DictCursor)
try:
self.__numRows=self.__cur.execute(query)
return True
except:
self.__cur=False
return False
else:
self.__cur=False
return False
def escapeStr(self,s):
if self.__db:
#Decoding and encoding for little pylons utf bug :)
return
self.__db.escape_string(s.encode('utf-8','replace')).decode
("utf-8")
else:
return False
def begin(self):
if self.__db:
self.__db.begin()
else:
return False
def commit(self):
if self.__db:
self.__db.commit()
else:
return False
def rollback(self):
if self.__db:
self.__db.rollback()
else:
return False
def lastId(self):
if self.__cur and self.__db:
return self.__db.insert_id()
else:
return False
def getNumRows(self):
if self.__cur and self.__db:
return self.__numRows
else:
return False
def getResult(self):
if self.__cur and self.__db:
return self.__cur.fetchall()
else:
return False
def __str__(self):
return "db: %s,cursor: %s, numRows %s" %
(self.__db,self.__cur,self.__numRows)
How can i use in Pylons?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
