Hey, I have created an issue in google code it is issue 353. Here is the link http://code.google.com/p/web2py/issues/detail?id=353 -Eric
On Jul 29, 5:18 am, Massimo Di Pierro <[email protected]> wrote: > I have limited connectivity today. please one an issue in google code > and I will test it asap. > > On Jul 28, 11:02 am, "[email protected]" <[email protected]> wrote: > > > > > > > > > Hey > > I have a db table that has a self referencing field. I need to create > > an audit table that inherits this table. In this table I also set > > primarykey so that web2py does not create it's default id. Attempting > > to do this with the current dal.py results in a splitting error on > > line 523: > > > rtablename,rfieldname = referenced.split('.') > > > To stop this issue I catch when the reference contains do . and isn't > > referring to the tablename. > > > if (referenced.split('.')[0] == referenced) and not(referenced == > > tablename) and hasattr(table,'_primarykey'): > > ftype = self.types['integer'] > > > This if gets added after line 520 and the lines 521 - 511 are > > contained in the else of this if. Another thing I thought would be > > nice is if you have a self referencing field in addition to 'reference > > tablename' you could do 'reference'. This would help in inheritance > > that way the table that inherits this will also have a self > > referencing field. To do this I modify line 520 to: > > > referenced = field.type[10:].strip() or tablename > > > Let me know what you guys think of these changes I would love to get > > them into the trunk. > > > -Eric

