Re: [Tutor] sqlite3: turning on foreign key support thru python

2011-12-18 Thread Wayne Werner
On Fri, Dec 16, 2011 at 1:43 PM, Modulok wrote: > >> How do I tell if it succeeded (short of trying an operation that should > be > >> blocked by foreign keys)? How do I use that cursor object returned by > the > >> pragma query to tell if its a '1' (on) or a '0' (off) and verify the > state? >

Re: [Tutor] sqlite3: turning on foreign key support thru python

2011-12-16 Thread Monte Milanuk
That helped immensely... I was trying some different things trying to get at the results, but it never occurred to me to try iterating over it. The bit about some objects being iterable and some not is good to know! Thanks, Monte On Fri, Dec 16, 2011 at 11:43 AM, Modulok wrote: > >> How do I

Re: [Tutor] sqlite3: turning on foreign key support thru python

2011-12-16 Thread Modulok
>> How do I tell if it succeeded (short of trying an operation that should be >> blocked by foreign keys)? How do I use that cursor object returned by the >> pragma query to tell if its a '1' (on) or a '0' (off) and verify the state? The cursor object contains the result set. It's a python gener