On Apr 7, 2011, at 9:35 AM, Massi wrote:
> Hi everyone, I'm writing a script using sqlalchemy 0.66 and sqlite3.
> I'm encountering a problem trying to create and load a table from two
> different engines.
> Here is an example script showing the problem:
>
> from sqlalchemy import *
>
> engine1 = create_engine("sqlite:///test.db", echo=False)
> metadata1 = MetaData(engine1)
>
> try :
>table = Table("user", metadata1, autoload=True)
>table.drop()
> except :
>print "Not found"
>
> engine2 = create_engine("sqlite:///test.db", echo=False)
> metadata2 = MetaData(engine2)
> table = Table("user", metadata2,
>Column('id', Integer, primary_key=True),
>Column('name', String),
>Column('password', String), sqlite_autoincrement=True)
> table.create()
>
> metadata1 = MetaData(engine1)
> print Table("user", metadata2, autoload=True)
> print Table("user", metadata1, autoload=True)
>
> As you can see, I create the table 'user' from engine2 and then I try
> to load it both from engine1 and engine2. The try-except part do some
> clean up and it is aimed only to make the script repeatable.
> If you run the code you'll see that the first print statement is
> executed correctly, while the second one raises a NoSuchTableError
> exception. It seems to be connected with some flushing issue, but I
> don't know what I am doing wrong. Any suggestion?
> Thanks in advance.
its been observed that SQLite doesn't refresh the pragma information regarding
tables once a connection is made. So switch to NullPool or create the engine
after tables are created.
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
