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.