dhis2-devs team mailing list archive

[Ime Asangansi <imeasangansi@xxxxxxxxx>]

Hi Calle,

At 2.23, our programrulevariable table got some minor change.
That may help you differentiate between 2.23 and previous.
See 
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-223.sql

For devs, I've seen some other projects use the liquibase library 
(liquibase.org) to track their db schema - not sure if its appropriate, 
but just thought to mention.

Hope it helps

Ime
Abuja

photo 		
<http://twitter.com/imeasangansi> 
<http://ng.linkedin.com/company/ehealth4everyone> 
<http://twitter.com/ehealth4every1>
Ime Asangansi MD, PhD (Informatics)
Chief Excellence Officer, ehealth4everyone
Abuja, Nigeria

+2348180790150 <tel:+2348180790150>
ime@xxxxxxxxxxxxxxxxxxxx <mailto:ime@xxxxxxxxxxxxxxxxxxxx>
Skype: asangansiime <#>
www.ehealth4everyone.com <http://www.ehealth4everyone.com>

<https://twitter.com/ehealth4every1><https://ng.linkedin.com/in/asangansi>



On 1/13/2017 7:19 AM, Calle Hedberg wrote:
> Hi
>
> sigh - so there isn't any obvious way to do this currently.
>
> I've written a JIRA issue for it - DHIS2-506
>
> Best regards
> Calle
>
> On 12 January 2017 at 18:44, Lorill Crees <lcrees@xxxxxxxxxx 
> <mailto:lcrees@xxxxxxxxxx>> wrote:
>
>     +1 vote for this too!
>
>     On Thu, Jan 12, 2017 at 12:29 AM, Olav Poppe <olav.poppe@xxxxxx
>     <mailto:olav.poppe@xxxxxx>> wrote:
>
>         +1 vote for this. I remember it was proposed at the August
>         academy, but I don’t see any JIRA issue on it.
>
>         Olav
>
>
> >         11. jan. 2017 kl. 20.05 skrev Bob Jolliffe
> >         <bobjolliffe@xxxxxxxxx <mailto:bobjolliffe@xxxxxxxxx>>:
> >
> >         No I think its a good question.  I've often thought that it
> >         would be useful for the database to get "marked" in some way
> >         once it has been run against a particular build of war file. 
> >         This can be useful for example when dealing with archived
> >         backups.
> >
> >         But no I don't think we do this currently.
> >
> >         On 11 January 2017 at 17:01, Calle Hedberg
> >         <calle.hedberg@xxxxxxxxx <mailto:calle.hedberg@xxxxxxxxx>> wrote:
> >
> >             Hi,
> >
> >             maybe this is a bit dumb question, but:
> >
> >             Is there an easy method of determining which version a
> >             specific database is using (e.g. differentiating between
> >             2.25 and earlier versions are easy due to the new
> >             softdelete field in the datavalue table, but it is not so
> >             easy to differentiate between 2.21, 2.22, 2.23, and 2.24...)
> >
> >             Regards
> >             Calle
> >
> >             *******************************************
> >
> >             Calle Hedberg
> >
> >             46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> >
> >             Tel/fax (home): +27-21-685-6472 <tel:+27%2021%20685%206472>
> >
> >             Cell: +27-82-853-5352 <tel:+27%2082%20853%205352>
> >
> >             Iridium SatPhone: +8816-315-19119
> >             <tel:+881%206%20315%2019119>
> >
> >             Email: calle.hedberg@xxxxxxxxx
> >             <mailto:calle.hedberg@xxxxxxxxx>
> >
> >             Skype: calle_hedberg
> >
> >             *******************************************
> >
> >
> >
> >             _______________________________________________
> >             Mailing list: https://launchpad.net/~dhis2-devs
> >             <https://launchpad.net/%7Edhis2-devs>
> >             Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >             <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> >             Unsubscribe : https://launchpad.net/~dhis2-devs
> >             <https://launchpad.net/%7Edhis2-devs>
> >             More help   : https://help.launchpad.net/ListHelp
> >             <https://help.launchpad.net/ListHelp>
> >
> >
> >         _______________________________________________
> >         Mailing list: https://launchpad.net/~dhis2-devs
> >         <https://launchpad.net/%7Edhis2-devs>
> >         Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >         <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> >         Unsubscribe : https://launchpad.net/~dhis2-devs
> >         <https://launchpad.net/%7Edhis2-devs>
> >         More help   : https://help.launchpad.net/ListHelp
> >         <https://help.launchpad.net/ListHelp>
>
>
>         _______________________________________________
>         Mailing list: https://launchpad.net/~dhis2-devs
>         <https://launchpad.net/%7Edhis2-devs>
>         Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>         <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>         Unsubscribe : https://launchpad.net/~dhis2-devs
>         <https://launchpad.net/%7Edhis2-devs>
>         More help   : https://help.launchpad.net/ListHelp
>         <https://help.launchpad.net/ListHelp>
>
>
>
>
>     -- 
>     Lorill Crees
>     Project Leader / Senior Developer
>     2Paths Solutions Ltd. <http://www.2paths.com>
>
>     lcrees@xxxxxxxxxx <mailto:lcrees@xxxxxxxxxx>
>     skype: lorill2paths
>     (604) 689-4123 x 15 <tel:%28604%29%20689-4123>
>
>     _______________________________________________
>     Mailing list: https://launchpad.net/~dhis2-devs
>     <https://launchpad.net/%7Edhis2-devs>
>     Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>     <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~dhis2-devs
>     <https://launchpad.net/%7Edhis2-devs>
>     More help   : https://help.launchpad.net/ListHelp
>     <https://help.launchpad.net/ListHelp>
>
>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx <mailto:calle.hedberg@xxxxxxxxx>
>
> Skype: calle_hedberg
>
> *******************************************
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp