instancemethod

[Bruno Desthuilliers]

Gert Cuykens a écrit :
> 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)

isn't cursor.rowcount already an int ?

>    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

The finally clause is useless here.

>    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.

class Obj(object):
   pass

toto = tutu = tata = titi = Obj()

What's an "instance name" ?