[Mapbender-dev] Build script / SQL

[Christoph Baudson]

We still don't have an automated routine to generate the SQL dumps for a 
new release. The problems are the schema SQLs, as the data SQL is pretty 
much exchangeable for MySQL and PostgreSQL.

I was thinking about this: Maybe create the ER model in Dia [1], and 
then use tedia2sql [2] to export the model to MySQL, PostgreSQL etc. The 
export is basically a Perl script which parses the XML saved by Dia. You 
have to misuse the UML syntax to get results though. A class corresponds 
to a table, an attribute corresponds to a column etc.

We would have
a) a tool to maintain the database structure
b) an up-to-date image to teach the db structure to new Mapbender devs
c) various output formats like MySQL, PostgreSQL, Oracle etc.

There is even a tool to import PostgreSQL databases into dia, 
postgresql_autodoc [3], but it is far from perfect, but could be at 
least helpful.

I have made a prototypical Dia file [4], covering only three tables. But 
it seems to work for both MySQL and PostgreSQL.

Please share your valued opinion. Maybe you know a better way to solve 
this problem.

[1] http://live.gnome.org/Dia
[2] http://tedia2sql.tigris.org/
[3] http://www.rbt.ca/autodoc/
[4] 
https://svn.osgeo.org/mapbender/branches/testbaudson_dev/documents/mpbn25_.dia

-- 
_______________________________________

W h e r e G r o u p GmbH & Co. KG

Siemensstraße 8
53121 Bonn
Germany

Christoph Baudson
Anwendungsentwickler

Fon: +49 (0)228 / 90 90 38 - 15
Fax: +49 (0)228 / 90 90 38 - 11
christoph.baudson at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________

Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
_______________________________________