NickPerkins wrote:
Thanks, I tried it...but could not get the desired result ( enforced
FKs using SQLite ).
Here is my test code:
#!/usr/bin/env python
import sqlalchemy
from sqlalchemy.interfaces import PoolListener
class MyListener(PoolListener):
def connect(self, dbapi_con,
I have confirmed that it works from the sqlite3 interactive session:
sqlite insert into child values(33);
Error: foreign key mismatch
I will try it with pysqlite...see what happens...
On Apr 13, 9:59 am, Michael Bayer mike...@zzzcomputing.com wrote:
NickPerkins wrote:
Thanks, I tried
It seems that I have more than one version of SQLite installed!
When I run from Python, it picks up an older version than the new one
I put in the project directory.
I just have to figure out which SQLite it's finding, and how to make
it use the new one
( thanks for the help! )
On Apr 13,
Solved...by replacing the sqlite3.dll in my c:\Python25\DLLS\ with a
new one.
On Apr 13, 6:33 pm, NickPerkins nickperkinslon...@gmail.com wrote:
It seems that I have more than one version of SQLite installed!
When I run from Python, it picks up an older version than the new one
I put in the
Thanks, I tried it...but could not get the desired result ( enforced
FKs using SQLite ).
Here is my test code:
#!/usr/bin/env python
import sqlalchemy
from sqlalchemy.interfaces import PoolListener
class MyListener(PoolListener):
def connect(self, dbapi_con, con_record):