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>
[email protected] <mailto:[email protected]>
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 <[email protected] <mailto:[email protected]>> wrote:

    +1 vote for this too!

    On Thu, Jan 12, 2017 at 12:29 AM, Olav Poppe <[email protected]
    <mailto:[email protected]>> 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
        <[email protected] <mailto:[email protected]>>:

        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
        <[email protected] <mailto:[email protected]>> 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: [email protected]
            <mailto:[email protected]>

            Skype: calle_hedberg

            *******************************************



            _______________________________________________
            Mailing list: https://launchpad.net/~dhis2-devs
            <https://launchpad.net/%7Edhis2-devs>
            Post to     : [email protected]
            <mailto:[email protected]>
            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     : [email protected]
        <mailto:[email protected]>
        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     : [email protected]
        <mailto:[email protected]>
        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>

    [email protected] <mailto:[email protected]>
    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     : [email protected]
    <mailto:[email protected]>
    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: [email protected] <mailto:[email protected]>

Skype: calle_hedberg

*******************************************




_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Reply via email to