Hi Daniel,
On Sun, 27 Jul 2008, Daniel Zingaro wrote: > Hi, > > Thanks, Jon. I've kept the part of your code that does the regular > expression stuff (I think) -- why exactly is this necessary? > > Also, Re: Darren's message, using .schema instead of .dump from within > sqlite3.exe seems to work. However, the SQLite parser doesn't seem to > accept primary/foreign key stuff, such as a file containing just: > CREATE TABLE test (first, last primary key); I'm fairly sure that's new for SQLite v3, v2 only supported "ID INTEGER PRIMARY KEY" and not just "primary key". And as the parser was written to work with v2, that's what it supports. Quite happy for you to bung us a patch to support basic "primary key" when an "sqlite_version" parameter says "3" (see the mysql parser/producer for how this works there). > This is accepted by the SQLite parser of sqlite3.exe. Did I miss > something? I thought I would be able to add primary keys and foreign > keys so that my ER diagrams show links between tables. Just that SQL::Translator doesn't keep up with new versions of SQLite as fast as it might. ;) > Thanks, > Dan Jess ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
