[Scons-users] database builder

[Philipp Kraus]

Nice, here the link http://www.liquibase.org/
Yes I think something like this, but I don't want to install a lot of tools for developing and Liquidbase is a Java-based solution so I need also a Java installation.
One build & update tool should be nice, so a Scons / Python solution is IMHO a little bit better, but I will take a look into Liquidbase for some concept ideas

Thx

Phil


Am 13.04.2013 um 14:54 schrieb Bruce Adams:


> I would take a look at something like liquibase for managing database updates and drive it from scons if you think you need to. You may need some boiler plate to create a new db.

> 

> Sent from Yahoo! Mail on Android

> 

> 

> From: Philipp Kraus <philipp.kraus at flashpixx.de>; 

> To: SCons list users mailing <scons-users at scons.org>; 

> Subject: [Scons-users] database builder 

> Sent: Sat, Apr 13, 2013 9:34:26 AM 

> 

> Hi,

> 

> I'm searching for database support in Scons something like databse installation and updating. I'm often work with database and do the installation with SQL scripts,

> but the client is compiled and installed with Scons, so can be this an idea for Scons? Do you think this is a good & meningful feature?

> At the moment I run env.Command with the database command-line client, but the updating process can not work / can only work with deleting & creating the database.

> 

> I think a feature like this

> env.CreateDatabase("localhost:5432", databse="testdb", user"=myself", password="1234", type="postgresql", source="database.sql.scons")

> 

> should be nice, also an env.UpdateDatabase which updates the database without deleting tables, it creates only alter statements and run these statements for the update process.

> Scons can handle this calls in an transaction for atomic calls and uses Pythons database packages. The database script should be more than a plain text file, so Scons can

> check the database and create individual statements during the update process.

> 

> My idea is, that the Scons database.sql.scons file is a XML files which descriptes tables, indicies, references datatypes (validation via XSD)....

> On the createdatabase Scons transform this data with XSLT into SQL or walk through the XML tree and creates on-fly the statements and send it over Python Database API

> The update is more difficult, because I must create a diff between installed tables and new table definition. I think a post- / preprocessing should be also in it, so the user

> can run some codes before / after the update for modifying datasets.

> 

> Hope for some comments :-)

> Have a nice weekend

> 

> Phil

> _______________________________________________

> Scons-users mailing list

> Scons-users at scons.org

> http://four.pairlist.net/mailman/listinfo/scons-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://four.pairlist.net/pipermail/scons-users/attachments/20130413/aeedd4b8/attachment-0001.html>