X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=TODO;h=1bd0713eb291830b3e7ecd4bf53c60796a75192a;hb=7d8f0a61b9fbd54e85625c0f9857fc000ae11bfd;hp=2cd448660de690050323e17607d6ffc019b287d3;hpb=d3b1f33ad13ddd77674007451f455f541f69f23c;p=dbsrgits%2FSQL-Translator.git diff --git a/TODO b/TODO index 2cd4486..1bd0713 100644 --- a/TODO +++ b/TODO @@ -1,16 +1,14 @@ +* Parse FOREIGN KEY / REFERENCES with SQLite as the latest version + supports them. + +* Add Parser/Producer for ActiveRecord::Migration + [http://api.rubyonrails.com/classes/ActiveRecord/Migration.html]. + * 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. -* 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. I've - started a script called "sqlt-diff" to diff two schemas, but it's - not included with the 0.03 release. Submit ideas on how this - should work and what it should create (e.g., text reports and ALTER - statements) to the list. - * Add more DBI parsers! These have the potential to be very thorough and far faster than parsing text files with Parse::RecDescent. @@ -30,8 +28,19 @@ * Integrate more with some standard XML schema representations, maybe like Torque DB (http://db.apache.org/torque/). We've - started messing around with XMI, too, but that wasn't quite usable - for the 0.03 release. + 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. + +* 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.