[dbsrgits/SQL-Translator.git] / TODO

*   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!
Commit	Line	Data
12d68885	1	* The Sybase parser still doesn't work. It is not included with the
4a1ee60f	2	distribution but can be found in CVS. There has been some
12d68885	3	discussion about reviving this, but no one has had that particular
	4	itch to scratch, so it's languished.
	5
13ab1113	6	* Some way to deeply check to schema objects, e.g., for testing I
b4d75dc1	7	parse a MySQL schema, translate to Oracle, then parse the created
b4d75dc1	8	Oracle schema and want to check the two schema objects.
9398955f	9
13ab1113	10	* Explore some way to pass an open database handle instead of a
	11	schema and then query through DBI methods to get the schema
	12	definition, somewhat a la SQL::Schema (which only works with
	13	Oracle right now)
	14
	15	* Add "CREATE VIEW" support to existing parsers
	16
	17	* At least allow more pass-through of INSERT, DELETE, and UPDATE
	18	statements
	19
	20	* Add INSERT statements for xSV, Excel parsers to automatically
	21	create INSERTs for each row of data in the source file
	22
13ab1113	23	* Somehow merge ClassDBI producer with CGI::FormBuilder or Template
	24	Toolkit and some sort of automated CGI builder to create
	25	view/create/edit/delete forms for objects based on schema defs
	26
	27	* Embetter the Diagram producer to use some real graphing algorithms
	28	to distribute the tables so that the lines don't overlap so badly
	29
	30	* Integrate more with some standard XML schema representations,
12d68885	31	maybe like Torque DB (http://db.apache.org/torque/)
e99e9593	32
13ab1113	33	* Possibly write a basic ANSI-92 SQL parser which could be extended
12d68885	34	when writing other new parsers
e99e9593	35
12d68885	36	* More parsers, more producers!