Tracker: Feature Requests

5 Need an object repr of the base schema instead of gui - ID: 2949120
Last Update: Comment added ( sf-robot )

Hi,

Your soft looks like a good piece of code .
Unfortunately, I don't need a gui output, but I need to retrieve an object representation of the database schema in order to do, for example, dynamic formulary generation according to the schema.

Today, the analyze() method only returns an int.
Is it possible to have a modified analyze() that returns such an object representation (table desc, column desc, keys, table relationships, etc.) ?

Thanks for your help.

Best Regards,
Dominique De Vito


ddv ( ddv36a78 ) - 2010-02-10 06:43:27 PST

5

Closed

None

John Currier

Output Improvements

None

Public


Comments ( 7 )

Date: 2010-09-29 12:25:05 PDT
Sender: sf-robotSourceForge.net Site Admin

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).


Date: 2010-08-17 14:11:52 PDT
Sender: johncurrierProject AdminAccepting Donations

Implemented in Release 5.0.0.


Date: 2010-02-22 05:29:18 PST
Sender: ddv36a78

ok, it works just fine.
Thanks again.


Date: 2010-02-17 11:42:59 PST
Sender: johncurrierProject AdminAccepting Donations

The latest version in Subversion no longer reports problems with dot if
HTML generation is disabled.


Date: 2010-02-14 11:01:38 PST
Sender: ddv36a78

Hi,

I have gone further with SchemaSpy.

While SchemaSpy looks like running ok so far, I have got the following
error:
===============
Failed to query Graphviz version information
with: dot -V
java.io.IOException: Cannot run program "dot": CreateProcess error=2, the
given file is not found
Using database properties:

[D:\workspace-dnk2\SchemaSpyTrial\bin]/net/sourceforge/schemaspy/dbTypes/mysql.properties
...........
================

Well, I have used the option "-nohtml" for not having the display
generation.

But, IMHO, it should be some "if" is missing somewhere, and that the "dot"
GraphViz is still called (for version identification ?).

This being said, even with this error reported, SchemaSpy looks like
running as said above.

I am gonna try to go further tomorrow.

Regards,
Dominique


Date: 2010-02-10 13:38:12 PST
Sender: ddv36a78

Thanks for your quick modification.

Yes, indeed, I need to determine insertion/deletion order of tables.

While MDA is associated with code generation, this generation is static, so
I am happy to have found your project to analyze dynamically a database in
order to propose dynamically forms (mapped on the database).


Date: 2010-02-10 08:52:04 PST
Sender: johncurrierProject AdminAccepting Donations

SchemaAnalyzer.analyze() now returns an instance of Database that, in
theory, contains all of the metadata about a specific schema.

Note, however, that additional work needs to be done to really support this
concept because part of the analysis of a schema involves determining
insertion/deletion order of tables. The algorithm used consumes the data
model as it goes, resulting in a relatively empty model upon completion.


Attached File

No Files Currently Attached

Changes ( 4 )

Field Old Value Date By
status_id Pending 2010-09-29 12:25:05 PDT sf-robot
close_date 2010-08-17 14:11 2010-09-29 12:25:05 PDT sf-robot
status_id Open 2010-08-17 14:11:52 PDT johncurrier
close_date - 2010-08-17 14:11:52 PDT johncurrier