X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=TODO;h=2aa70a652ebe625a2cdc66e95e3616763b42e554;hb=6d3f63791e99da2ea2444c4d2068f84c6c4ec732;hp=11c7317802e730de09e9c032f3c9cfeb7edaf010;hpb=35bab74243827d6e141cd8b3986b1e9bb1f37f07;p=dbsrgits%2FSQL-Translator.git

diff --git a/TODO b/TODO
index 11c7317..2aa70a6 100644
--- a/TODO
+++ b/TODO
@@ -1,8 +1,36 @@
-Define structure of the data returned by parsers:
-  o Producers need to know what to expect
-  o For testing purposes, we need to know if parsers are returning
-    something reasonable
-
-cvs rm t/data/mysql/Apache-Session-MySQL.sql
-cvs add TODO
-cvs add t/01load.t
+*   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.
+
+*   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.
+
+*   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
+
+*   At least allow more pass-through of INSERT, DELETE, and UPDATE
+    statements
+
+*   Add INSERT statements for xSV, Excel parsers to automatically
+    create INSERTs for each row of data in the source file
+
+*   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
+
+*   Embetter the Diagram producer to use some real graphing algorithms
+    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/)
+
+*   Possibly write a basic ANSI-92 SQL parser which could be extended
+    when writing other new parsers
+
+*   More parsers, more producers!