X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=TODO;h=1bd0713eb291830b3e7ecd4bf53c60796a75192a;hb=1c56cdb02ec03c0cdea50e5dbcec8f19412f265a;hp=2aa70a652ebe625a2cdc66e95e3616763b42e554;hpb=4a1ee60f6bab44636cff11fcc03260539f9cadaf;p=dbsrgits%2FSQL-Translator.git

diff --git a/TODO b/TODO
index 2aa70a6..1bd0713 100644
--- a/TODO
+++ b/TODO
@@ -1,18 +1,17 @@
-*   The Sybase parser still doesn't work.  It is not included with the
-    distribution but can be found in CVS.  There has been some
-    discussion about reviving this, but no one has had that particular
-    itch to scratch, so it's languished.
+*   Parse FOREIGN KEY / REFERENCES with SQLite as the latest version
+     supports them.
 
-*   Some way to deeply check to schema objects, e.g., for testing I
-    parse a MySQL schema, translate to Oracle, then parse the created
-    Oracle schema and want to check the two schema objects.
+*   Add Parser/Producer for ActiveRecord::Migration 
+    [http://api.rubyonrails.com/classes/ActiveRecord/Migration.html].
 
-*   Explore some way to pass an open database handle instead of a
-    schema and then query through DBI methods to get the schema
-    definition, somewhat a la SQL::Schema (which only works with
-    Oracle right now)
+*   The regular Sybase parser is only just functional.  If you are
+    interested in using Sybase, I would suggest serializing the schema
+    (via YAML or Storable) using the DBI-Sybase parser and then
+    manipulating that as you see fit. 
 
-*   Add "CREATE VIEW" support to existing parsers
+*   Add more DBI parsers!  These have the potential to be very
+    thorough and far faster than parsing text files with
+    Parse::RecDescent.
 
 *   At least allow more pass-through of INSERT, DELETE, and UPDATE
     statements
@@ -28,9 +27,20 @@
     to distribute the tables so that the lines don't overlap so badly
 
 *   Integrate more with some standard XML schema representations,
-    maybe like Torque DB (http://db.apache.org/torque/)
+    maybe like Torque DB (http://db.apache.org/torque/).  We've
+    started messing around with XMI, too, but it isn't quite usable.
 
 *   Possibly write a basic ANSI-92 SQL parser which could be extended
-    when writing other new parsers
+    when writing other new parsers.
 
-*   More parsers, more producers!
+*   Make as many "required" modules as possible optional.  This will
+    require support in the Makefile, the tests, and the modules
+    themselves (they'll need to die gracefully if prerequisites are
+    not installed).
+
+*   Support for precompiled Parse::RecDescent grammars.
+- This is easy and I've done it locally with the DB2 parser - Jess
+
+*   More code generation producers, such as Java, PHP, and Python.
+
+*   Integrate Module::Pluggable as a replacement for the _list method.