[Mapbender-dev] Discussion on Update Script Interface

[Christoph Baudson]

Hi Siddharth,

so the two scripts you described are these

(1) determine database changes to prior version (build process)
(2) determine database changes to user's prior version and apply 
necessary changes (update process)

Is this what you meant?

If yes, please let me elaborate:

about (1):
how are the SQL files generated? We need to know the status of "old" 
Mapbender and "new" Mapbender, and create the SQL files by comparing 
"old" and "new". How do we manage to do it? Do we have to have template 
databases, or SQL dumps? Or are the changes entered manually?

about (2):
probably the version of the user has been altered. We definitely have to 
find a way how to deal with conflicts. Regarding the db structure, this 
may be seldom the case, but with data, we need to be more sophisticated.

How do you want to proceed? You told me you already started coding, 
maybe let us know what you plan to do next.

Christoph



Siddharth Prakash Singh schrieb:
> Hello Devs,
>
> As, all of you are aware that I am working on Automated Update routine 
> for mapbender.
> I am currently working on automating the Database structure changes. I 
> worked out the mediawiki's update routine. Their update routine does a 
> simple task of going through the database structure sequentially, and 
> committing the required changes. All the changes to be done are stored 
> in many sql files and all those sql files are called one by one 
> iteratively by a php function.
> So, now I identify that actually there should be two scripts, as 
> described below :
>
> 1> The *back-end script for administrator*s of the mapbender 
> project.This script will -- produce the user update script and the 
> required sql files for the user update script.
>             Let me explain in detail. With every new release of 
> mapbender there might be changes in the database structure. So after 
> every release there has to be a user update script which will update 
> the mapbender installation of any user. Now the administrator of the 
> mapbender project will have to write the sql files for every release. 
> So what can be done is that - we may have web based GUI which will ask 
> for the changes done in the current release and will then produce 
> dynamically the *user update script* and the sql files required for 
> the *user update script*.
>
> 2> The *user update script *for the users of mapbender. This will be a 
> php script which may be run on the terminal or from a browser to 
> update the installation.
>
> Hopefully, I am clear to all of you.
> Comments, suggestions and queries awaited.
> Anticipating a huge response.
> cheers,
> A committed mapbender developer.
>
> --
> __________________________________
> Siddharth Prakash Singh
> Sophomore
> Computer Science & Engineering
> Indian Institute Of Technology Guwahati
> Guwahati - 781039
> India.
> -----------------------------------------------------------
> http://www.spsneo.com
> -----------------------------------------------------------
> -----------------------------------------------------------
> email : s.siddharth at iitg.ac.in <mailto:s.siddharth at iitg.ac.in>
> send a CC to: spsneo at gmail.com <mailto:spsneo at gmail.com>
> -----------------------------------------------------------
> # 215, Manas,
> IIT Guwahati
> Guwahati, India-781039
> -----------------------------------------------------------
> Cell No. : +91 9864435377
> -----------------------------------------------------------
> *****|| I was walking then
> I realized I should Run ||*****
> __________________________________
> ------------------------------------------------------------------------
>
> _______________________________________________
> Mapbender_dev mailing list
> Mapbender_dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_dev
>   


-- 
_______________________________________

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
_______________________________________