Enabling foreign key constraints

[kalafut]

Hi,

This is a useful project! It has been working well for me but I've recently bumped into a couple data issues because constraints I expected weren't enforced (e.g., creating a reference to a nonexistent user and deletes not cascading). I think the foreign_keys pragma is OFF (at least it looks like that based on an ad-hoc query of the value), and based on #76 (comment) I don't think there is a way to change that.

Any chance of a new CLI option to turn on FK constraints?

Thanks.

[coleifer]

Yeah, I have it enabled by default on my system sqlite (via compilation flag) but most system installs do not have this, so I've added a new CLI option -- use -f or --foreign-keys to enable.

[kalafut]

Excellent! Thank you for the super-quick update!