on 7/15/2000 8:11 AM, "Regis Koenig" <[EMAIL PROTECTED]> wrote:
> Hi,
> what is the status of XMLDatabaseMapBuilder ?
it died. I found that creating a .sql file and then converting it to a .xml
file was a waste of time. (you needed the .sql file to create the database
and the .xml file to define the MapBuilders, that was too many steps).
> It is marked as
> experimental but there is still good code and ideas there ...
thanks! :-) if anything it is a good introduction to working with SAX. :-)
> I would like to go on working on this stuff, in order to make it work
> with NewGenerateMapBuilderTask. Indeed, we will have this kind of flow:
>
> database_schema.xml -> "NewGenerateMapBuilderTask" => generated .java
> => generated .sql
> scripts for building the database.
if that is the flow you want to go with, that is fine. since i'm using
something that autogenerates .sql files, then my flow is more like this:
.sql -> MySQLDatabaseMapBuilder -> generated .java
As you can see, this is much fewer steps, which is much easier and cleaner
to me since you don't have to waste your time trying to make a square peg
(xml) fit into a round hole (.sql).
Even if you don't autogenerate your .sql files at the first step, you are
still going to have to generate that file to begin with...either with
software reading a .xml file or meta information from the database...that is
just a pain in the ass to me...
lets try to keep things as simple and fewest steps as possible.
> I think that will not need too much work, and will improve the database
> abstraction. However, I do not want to duplicate one's work (jdbc
> metadata ...). And this stuff maybe outside the scope of Turbine.
>
> I want to do that for 2 reasons:
> * getting more familiar with the peer model
> * I am using postgreSQL and not MySQL, and I am lazy ;-)
All you really need to do is write a PostGressql -> Mysql .sql file
converter. I wrote one for Oracle -> MySQL. It is really quite easy and I
even wrote it as an Ant task using the org.apache.regexp package. :-)
<http://scarab.tigris.org/source/browse/scarab/src/java/org/tigris/scarab/ut
il/ConvertOracleToMySQL.java?rev=1.3&content-type=text/x-cvsweb-markup>
-jon
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
