instancemethod

[Gert Cuykens]

import MySQLdb

class Db:

_db=-1
_cursor=-1

@classmethod
def __init__(self,s erver,user,pass word,database):
self._db=MySQLd b.connect(serve r , user , password , database)
self._cursor=se lf._db.cursor()

@classmethod
def excecute(self,c md):
self._cursor.ex ecute(cmd)
self._db.commit ()

@classmethod
def rowcount(self):
return int(self._curso r.rowcount)

@classmethod
def fetchone(self):
return self._cursor.fe tchone()

@classmethod
def close(self):
self._cursor.cl ose()
self._db.close( )

if __name__ == '__main__':
gert=Db('localh ost','root','** ****','gert')
gert.excecute(' select * from person')
for x in range(0,gert.ro wcount):
print gert.fetchone()
gert.close()

gert@gert:~$ python ./Desktop/svn/db/Py/db.py
Traceback (most recent call last):
File "./Desktop/svn/db/Py/db.py", line 35, in <module>
for x in range(0,gert.ro wcount):
TypeError: range() integer end argument expected, got instancemethod.
gert@gert:~$

Can anybody explain what i must do in order to get integer instead of
a instance ?

[Nanjundi]

>

if __name__ == '__main__':
gert=Db('localh ost','root','** ****','gert')
gert.excecute(' select * from person')
for x in range(0,gert.ro wcount):
print gert.fetchone()
gert.close()

gert@gert:~$ python ./Desktop/svn/db/Py/db.py
Traceback (most recent call last):
File "./Desktop/svn/db/Py/db.py", line 35, in <module>
for x in range(0,gert.ro wcount):
TypeError: range() integer end argument expected, got instancemethod.
gert@gert:~$

Can anybody explain what i must do in order to get integer instead of
a instance ?

Gert,

for x in range(0,gert.ro wcount):

gert.rowcount is the method (and not a data attribute).
gert.rowcount() is the method call, which get the return value from
method.

So try this.
for x in range( 0,gert.rowcount () ):

-N

[Gert Cuykens]

On 21 Jan 2007 14:35:19 -0800, Nanjundi <na******@gmail .comwrote:

if __name__ == '__main__':
gert=Db('localh ost','root','** ****','gert')
gert.excecute(' select * from person')
for x in range(0,gert.ro wcount):
print gert.fetchone()
gert.close()

gert@gert:~$ python ./Desktop/svn/db/Py/db.py
Traceback (most recent call last):
File "./Desktop/svn/db/Py/db.py", line 35, in <module>
for x in range(0,gert.ro wcount):
TypeError: range() integer end argument expected, got instancemethod.
gert@gert:~$

Can anybody explain what i must do in order to get integer instead of
a instance ?

Gert,

for x in range(0,gert.ro wcount):

gert.rowcount is the method (and not a data attribute).
gert.rowcount() is the method call, which get the return value from
method.

So try this.
for x in range( 0,gert.rowcount () ):

Doh! :)

thx

[Bruno Desthuilliers]

Gert Cuykens a écrit :

import MySQLdb

class Db:

(snip)

def excecute(self,c md):
self._cursor.ex ecute(cmd)
self._db.commit ()

What about autocommit and automagic delegation ?

import MySQLdb

class Db(object):
def __init__(self,s erver, user, password, database):
self._db = MySQLdb.connect (server , user , password , database)
self._db.autoco mmit(True)
self._cursor = self._db.cursor ()

def close(self):
self._cursor.cl ose()
self._db.close( )

def __del__(self):
try:
self.close()
except:
pass

def __getattr__(sel f, name):
attr = getattr(
self._cursor, name,
getattr(self._d b, name, None)
)
if attr is None:
raise AttributeError(
"object %s has no attribute %s" \
% (self.__class__ .__name__, name)
)
return attr

(NB :not tested...)

[Gert Cuykens]

Reading all of the above this is the most simple i can come too.

import MySQLdb

class Db:

def __init__(self,s erver,user,pass word,database):
self._db=MySQLd b.connect(serve r , user , password , database)
self._db.autoco mmit(True)
self.cursor=sel f._db.cursor()

def excecute(self,c md):
self.cursor.exe cute(cmd)
self.rowcount=i nt(self.cursor. rowcount)

def close(self):
self.cursor.clo se()
self._db.close( )

def __del__(self):
try:
self.close()
except:
pass

if __name__ == '__main__':
gert=Db('localh ost','root','** ****','gert')
gert.excecute(' select * from person')
for row in gert.cursor:
print row

This must be the most simple it can get right ?

PS i didn't understand the __getattr__ quit well but i thought it was
just to overload the privies class

[Bruno Desthuilliers]

Gert Cuykens a écrit :

Reading all of the above this is the most simple i can come too.

import MySQLdb

class Db:

def __init__(self,s erver,user,pass word,database):
self._db=MySQLd b.connect(serve r , user , password , database)
self._db.autoco mmit(True)
self.cursor=sel f._db.cursor()

def excecute(self,c md):

Just out of curiousity: is there any reason you spell it "excecute"
instead of "execute" ?

self.cursor.exe cute(cmd)
self.rowcount=i nt(self.cursor. rowcount)

def close(self):
self.cursor.clo se()
self._db.close( )

def __del__(self):
try:
self.close()
except:
pass

if __name__ == '__main__':
gert=Db('localh ost','root','** ****','gert')
gert.excecute(' select * from person')
for row in gert.cursor:
print row

This must be the most simple it can get right ?

Using __getattr__ is still simpler.

PS i didn't understand the __getattr__ quit well but i thought it was
just to overload the privies class

The __getattr__ method is called when an attribute lookup fails (and
remember that in Python, methods are -callable- attributes). It's
commonly used for delegation.

[Gert Cuykens]

import MySQLdb

class Db(object):

def __enter__(self) :
pass

def __init__(self,s erver,user,pass word,database):
self._db=MySQLd b.connect(serve r , user , password , database)
self._db.autoco mmit(True)
self.cursor=sel f._db.cursor()

def execute(self,cm d):
self.cursor.exe cute(cmd)
self.rowcount=i nt(self.cursor. rowcount)

def close(self):
self.cursor.clo se()
self._db.close( )

def __getattr__(sel f, name):
attr = getattr(self._c ursor, name,getattr(se lf._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('s elect * 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 ?

[Bruno Desthuilliers]

Gert Cuykens a écrit :

import MySQLdb

class Db(object):

def __enter__(self) :
pass

def __init__(self,s erver,user,pass word,database):
self._db=MySQLd b.connect(serve r , user , password , database)
self._db.autoco mmit(True)
self.cursor=sel f._db.cursor()

def execute(self,cm d):
self.cursor.exe cute(cmd)
self.rowcount=i nt(self.cursor. rowcount)

isn't cursor.rowcount already an int ?

def close(self):
self.cursor.clo se()
self._db.close( )

def __getattr__(sel f, name):
attr = getattr(self._c ursor, name,getattr(se lf._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('s elect * 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" ?

[Gert Cuykens]

class Obj(object):

pass

toto = tutu = tata = titi = Obj()

What's an "instance name" ?

--
http://mail.python.org/mailman/listinfo/python-list

i would say __object__.__na me__[3] == toto

And if your obj is a argument like

something(Obj() )

i would say __object__.__na me__[0] == 0x2b7bd17e9910

[Steven D'Aprano]

On Fri, 26 Jan 2007 17:25:37 +0100, Bruno Desthuilliers wrote:

> def __del__(self):
try:
self.close()
finally:
pass
except:
pass

The finally clause is useless here.

In principle, closing a file could raise an exception. I've never seen it
happen, but it could. From the Linux man pages:

"Not checking the return value of close() is a common but nevertheless
serious programming error. It is quite possible that errors on a previous
write(2) operation are first reported at the final close(). Not checking
the return value when closing the file may lead to silent loss of data.
This can especially be observed with NFS and with disk quota."

http://www.die.net/doc/linux/man/man2/close.2.html

I assume that the same will apply in Python.

It has to be said, however, that the error recovery shown ("pass") is
fairly pointless :-)
--
Steven