Foreign Keys support for SQLite

[Giorgos Logiotatidis]

Hello,
In sqlite you have to exceptionally ask for foreign key support (because it was introduced recently and not activated -due to compatibility restrictions- by default)

Currently there is no easy way of doing it since the developer has to execute a PRAGMA command to the sqlite db.

To solve the problem I patched SQLite() to include a foreign_keys uri.option. The patched is attached.

[Jamu Kakar (jkakar)]

Thanks for the patch Giorgos! Before we can accept we need to confirm
that you've signed the Canonical contributor agreement:

http://www.canonical.com/contributors

Please follow the instructions there if you haven't already signed the
agreement and confirm for us when you have.

[Giorgos Logiotatidis (seadog)]

Hello Jamu,
I just signed the agreement, please proceed with the patch.

[Giovanni Pellerano (evilaliv3)]

This is already merged in 0.20 by a patch i did.

why is this issue still open and included in milestone 0.21?

[Colin Watson (cjwatson)]

Yes, sorry, this seems to have been an oversight. I can't change the milestone to 0.20 now because that's already been released, but this was indeed fixed in r458.