X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=TODO;h=7bc7cb1aa33523785d011d714e16bcb1438dbc7e;hb=6fedb92b37d460c7baef16d76cd22625c8fa3cdd;hp=eae2ee8ebb0d5c1bfc036e00e6eec727ca5a1e30;hpb=13ab1113ba7f203fc0ad5071f1163124e20ee821;p=dbsrgits%2FSQL-Translator.git

diff --git a/TODO b/TODO
index eae2ee8..7bc7cb1 100644
--- a/TODO
+++ b/TODO
@@ -1,13 +1,11 @@
-*   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.
+*   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. 
 
-*   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)
-
-*   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
@@ -15,12 +13,6 @@
 *   Add INSERT statements for xSV, Excel parsers to automatically
     create INSERTs for each row of data in the source file
 
-*   Fix Sybase parser (which means really figuring out the dump format
-    we want to parse -- Sam, can you recommend something?)
-
-*   Add more parsers (though I need some ideas -- probably at least
-    one for SQLite since we have that producer)
-
 *   Somehow merge ClassDBI producer with CGI::FormBuilder or Template
     Toolkit and some sort of automated CGI builder to create
     view/create/edit/delete forms for objects based on schema defs
@@ -29,12 +21,19 @@
     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/), add parsers
-    and producers
+    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 -- can anyone help me nail down a
-    URL that describes in detail that spec?
+    when writing other new parsers.
+
+*   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.
+
+*   More code generation producers, such as Java, PHP, and Python.
 
-*   Expand sql_translator.cgi to be a frontend for all producer
-    formats, not just the graphical ones;  also improve the interface
+*   Integrate Module::Pluggable as a replacement for the _list method.