[Tutor] CSV -> sqlite tables with foreign keys

Monte Milanuk memilanuk at gmail.com
Wed Oct 17 16:32:51 CEST 2012

Thanks for the help!  Not sure why I assumed that csv.reader was returning
row as a tuple instead of a list... that makes that part easier ;)

As for the 'INSTEAD OF' trigger on a VIEW... that *does* look pretty
handy.  I was trying to remember why I hadn't heard of that before, or why
I hadn't looked into it.  I think it has to do with MySQL not supporting
triggers on views, at least not 'INSTEAD OF'.  Right now I'm using sqlite,
but at some point I may need to work with MySQL as well.  It's getting kind
of frustrating how many little things it doesn't support...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20121017/6733e0e1/attachment.html>

More information about the Tutor mailing list