Commit | Line | Data |
13ab1113 |
1 | * Some way to deeply check to schema objects, e.g., for testing I |
b4d75dc1 |
2 | parse a MySQL schema, translate to Oracle, then parse the created |
3 | Oracle schema and want to check the two schema objects. |
9398955f |
4 | |
13ab1113 |
5 | * Explore some way to pass an open database handle instead of a |
6 | schema and then query through DBI methods to get the schema |
7 | definition, somewhat a la SQL::Schema (which only works with |
8 | Oracle right now) |
9 | |
10 | * Add "CREATE VIEW" support to existing parsers |
11 | |
12 | * At least allow more pass-through of INSERT, DELETE, and UPDATE |
13 | statements |
14 | |
15 | * Add INSERT statements for xSV, Excel parsers to automatically |
16 | create INSERTs for each row of data in the source file |
17 | |
18 | * Fix Sybase parser (which means really figuring out the dump format |
19 | we want to parse -- Sam, can you recommend something?) |
20 | |
21 | * Add more parsers (though I need some ideas -- probably at least |
22 | one for SQLite since we have that producer) |
23 | |
24 | * Somehow merge ClassDBI producer with CGI::FormBuilder or Template |
25 | Toolkit and some sort of automated CGI builder to create |
26 | view/create/edit/delete forms for objects based on schema defs |
27 | |
28 | * Embetter the Diagram producer to use some real graphing algorithms |
29 | to distribute the tables so that the lines don't overlap so badly |
30 | |
31 | * Integrate more with some standard XML schema representations, |
32 | maybe like Torque DB (http://db.apache.org/torque/), add parsers |
33 | and producers |
e99e9593 |
34 | |
13ab1113 |
35 | * Possibly write a basic ANSI-92 SQL parser which could be extended |
36 | when writing other new parsers -- can anyone help me nail down a |
37 | URL that describes in detail that spec? |
e99e9593 |
38 | |
13ab1113 |
39 | * Expand sql_translator.cgi to be a frontend for all producer |
40 | formats, not just the graphical ones; also improve the interface |