X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=TODO;h=2aa70a652ebe625a2cdc66e95e3616763b42e554;hb=0a1ec87af6bf62f801f03d9ad58d41a4b3a2a4ac;hp=38482dc366f99ace24d5d7cf28536fbd431230c3;hpb=b4d75dc1e818d336a5bceda6e31858ceccaa2bc2;p=dbsrgits%2FSQL-Translator.git diff --git a/TODO b/TODO index 38482dc..2aa70a6 100644 --- a/TODO +++ b/TODO @@ -1,9 +1,36 @@ -- Diagram producer could benefit from some real graphing algorithms to - better distribute the boxes. +* 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 +* 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 parsers and producers for Torque XML/DB schema - (http://db.apache.org/torque/) +* 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!