import MySQLdb
class Db(object):
def __enter__(self):
pass
def __init__(self,server,user,password,database):
self._db=MySQLdb.connect(server , user , password , database)
self._db.autocommit(True)
self.cursor=self._db.cursor()
def execute(self,cmd):
self.cursor.execute(cmd)
self.rowcount=int(self.cursor.rowcount)
def close(self):
self.cursor.close()
self._db.close()
def __getattr__(self, name):
attr = getattr(self._cursor, name,getattr(self._db, name, None))
if attr is None:
raise AttributeError("object %s has no attribute %s"
%(self.__class__.__name__, name))
return attr
def __del__(self):
try:
self.close()
finally:
pass
except:
pass
def __exit__(self):
pass
if __name__ == '__main__':
gert = Db('localhost','root','*****','gert')
gert.execute('select * from person')
for row in gert.cursor:
print row
with Db('localhost','root','*****','gert') as gert:
gert.excecute('select * from person')
for row in gert.cursor:
print row
Desktop/svn/db/Py/db.py:45: Warning: 'with' will become a reserved
keyword in Python 2.6
File "Desktop/svn/db/Py/db.py", line 45
with Db('localhost','root','*****','gert') as gert:
^
SyntaxError: invalid syntax
I was thinking if it would be possible to create a object that uses
it's own instance name as a atribute.
For example instead of
gert = Db('localhost','root','*****','gert')
you would do this
gert = Db('localhost','root','*****')
and the name of the object itself 'gert' get's assigned to database somehow ?
--
http://mail.python.org/mailman/listinfo/python-list
