[Middlegen-user] Mixing Middlegen and Druid.

[ROSSEL Olivier]

Middlegen is very good at showing interactively a database structure.
And at generating code/conf.

Druid is another open-source piece of software, that is more dedicated to
database
modelling.

Both tools are quite neat.
Mixing them would be a really nice thing.

At the moment, I want to do that, and am looking for any info
about the Java internal data model that is maintained by Middlegen:

I suppose Middlegen uses JDBC meta datas to create an internal
model that is used both for display and for code generation.

Druid has almost that behaviour, and in my scope, I want to provide a
static class to pass from one data model to the other, so both apps
can be merged.

Any help/idea is welcome.


---cut here---


This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

[Aslak Hellesøy]

-----Original Message-----
Olivier
Sent: 11. mars 2003 14:58
Subject: [Middlegen-user] Mixing Middlegen and Druid.
Middlegen is very good at showing interactively a database structure.
And at generating code/conf.
Druid is another open-source piece of software, that is more dedicated to
database
modelling.
Both tools are quite neat.
Mixing them would be a really nice thing.
At the moment, I want to do that, and am looking for any info

I started on a refactoring of Middlegen's data model about a month ago. The
next generation of Middlegen will take advantage of XDoclet 2's (also under
development) flexible architecture. These refactorings will move the
internal data model of XDoclet closer to that of Commons SQL, and combined
with XDoclet 2 it will be even easier to write plugins for Middlegen.

I have been talking with James Strachan (who maintains Jakarta Commons SQL)
to merge Middlegen's core and Commons SQL. That's my main priority right
now. I suggest you wait and see what comes out of this refactoring, and then
we can discuss whether Druid fits into the picture.

I suppose Middlegen uses JDBC meta datas to create an internal
model that is used both for display and for code generation.

Correct.

Druid has almost that behaviour, and in my scope, I want to provide a
static class to pass from one data model to the other, so both apps
can be merged.

I think the best would be to move Middlegen's logic for reading and building
the data model into Commons SQL. Then Middlegen and Druid would just use
Commons SQL as a core library. If a merger with Commons SQL is not possible,
you should still be able to use the core part of Middlegen in Druid.

Any help/idea is welcome.

Let's hear what James has to say.

Cheers,
Aslak

---cut here---
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.
-------------------------------------------------------
This SF.net email is sponsored by:Crypto Challenge is now open!
Get cracking and register here for some mind boggling fun and
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

[James Strachan]

Post by Aslak Hellesøy

-----Original Message-----
Olivier
Druid has almost that behaviour, and in my scope, I want to provide a
static class to pass from one data model to the other, so both apps
can be merged.

I think the best would be to move Middlegen's logic for reading and building
the data model into Commons SQL. Then Middlegen and Druid would just use
Commons SQL as a core library. If a merger with Commons SQL is not possible,
you should still be able to use the core part of Middlegen in Druid.

Hopefully reuse of Commons SQL should be really easy - either just using the
same XML format for describing a relational data model or using the Commons
SQL beans to describe the same model. Then if you want to import or export a
relational model you just have a simple XML or bean model to work with.

Then once that integration is done you can reuse the tools in Commons SQL
such as to auto-generate the DDL for various different databases, or a
siimple DynaBean API to work with the database or tools for performing
schema migration (e.g. generation of alter table scripts etc).

So really all Commons SQL is trying to do is just be a common reusable SQL
related tools that are quite independent of where the model comes from, what
persistence mechanism is used or the API the code uses to work with data.
Its explicitly designed to be technology agnositc and real easy to just
reuse as Ant tasks or via Jelly.

James
-------
http://radio.weblogs.com/0112098/

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

[ROSSEL Olivier]

Post by Aslak Hellesøy
I think the best would be to move Middlegen's logic for
reading and building
the data model into Commons SQL. Then Middlegen and Druid
would just use
Commons SQL as a core library. If a merger with Commons SQL
is not possible,
you should still be able to use the core part of Middlegen in Druid.

Post by ROSSEL Olivier
Any help/idea is welcome.

Let's hear what James has to say.

Sticking to a common SQL data model would be a HUGE improvement.
But then what?
A common XML file to describe the data model?
Then what?
Some kind of common API for OR mappers?
Then what?
A kind of pluggable OR mapper?
(rm ./hibernate.jar && cp torque.jar .).

Hummm, that sounds like total world domination :-))

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.