thanks, this is patched in the trunk
On Aug 28, 2006, at 10:59 AM, Nicola Larosa wrote:
> When an autoload of a non-existing table fails:
>
>
>>>> from sqlalchemy import *
>>>> md = BoundMetaData('sqlite:///test.db')
>>>> Table('nonesuch', md, autoload=True)
> Traceback (most recent call last):
> ...
> sqlalchemy.exceptions.NoSuchTableError: nonesuch
>
>
> the table remains in the metadata dict:
>
>
>>>> md.tables
> {'nonesuch': Table('nonesuch',
> BoundMetaData(),
> schema=None)}
>
>
> that way, a subsequent definition of the same table fails:
>
>
>>>> Table('nonesuch', md,
> ... Column('id', Integer, primary_key=True))
> Traceback (most recent call last):
> ...
> sqlalchemy.exceptions.ArgumentError: Table 'None.nonesuch' is already
> defined. specify 'redefine=True' to remap columns, or
> 'useexisting=True'
> to use the existing table
>
>
> One could use the 'redefine=True' parameter to avoid this error, but
> I would prefer avoiding it, because in some cases that would actually,
> and wrongly, redefine a table.
>
> The patch attached to ticket #289 deregisters the table, but only when
> autoloading raises NoSuchTableError, and therefore makes the
> subsequent
> definition work.
>
>
> --
> Nicola Larosa - http://www.tekNico.net/
>
> Fear is the prison, its absence is the key. What we need is the under-
> standing and the will to change the reality that manifests as control
> and suppression, and this can never be done while we are imprisoned by
> fear. Freedom from fear is freedom itself. -- David Icke, March 2006
>
>
>
> ----------------------------------------------------------------------
> ---
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
