Determining DHIS2 version in use from database instance

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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


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@gmail.com 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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

+1 vote for this. I remember it was proposed at the August academy, but I don’t see any JIRA issue on it.

Olav

···

On 11 January 2017 at 17:01, Calle Hedberg calle.hedberg@gmail.com 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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

+1 vote for this too!

···

On Thu, Jan 12, 2017 at 12:29 AM, Olav Poppe olav.poppe@me.com wrote:

Olav

+1 vote for this. I remember it was proposed at the August academy, but I don’t see any JIRA issue on it.

  1. jan. 2017 kl. 20.05 skrev Bob Jolliffe bobjolliffe@gmail.com:

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.


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 11 January 2017 at 17:01, Calle Hedberg calle.hedberg@gmail.com 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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

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@2paths.com wrote:

+1 vote for this too!


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Thu, Jan 12, 2017 at 12:29 AM, Olav Poppe olav.poppe@me.com wrote:

Olav

+1 vote for this. I remember it was proposed at the August academy, but I don’t see any JIRA issue on it.

  1. jan. 2017 kl. 20.05 skrev Bob Jolliffe bobjolliffe@gmail.com:

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.


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On 11 January 2017 at 17:01, Calle Hedberg calle.hedberg@gmail.com 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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : 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@gmail.com

Skype: calle_hedberg


Hi Calle,

At 2.23, our programrulevariable table got some minor change.

That may help you differentiate between 2.23 and previous.

See 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
···

https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-223.sql

photo

                        Ime Asangansi MD, PhD (Informatics)

                                                  Chief Excellence Officer, ehealth4everyone

                        Abuja, Nigeria


+2348180790150


ime@ehealth4everyone.com


Skype: asangansiime


www.ehealth4everyone.com

  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@2paths.com>
      wrote:

+1 vote for this too!

                On Thu, Jan 12, 2017 at 12:29 AM, Olav Poppe <olav.poppe@me.com>
                wrote:

Olav

                    +1 vote for this. I remember it was proposed at the August academy, but I don�t see any JIRA issue on it.
                                  11. jan. 2017 kl. 20.05 skrev Bob Jolliffe <bobjolliffe@gmail.com>:
                                    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@gmail.com>
                                      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
                                                      Cell: +27-82-853-5352
                                                      Iridium SatPhone: +8816-315-19119
                                                      Email: calle.hedberg@gmail.com
                                                      Skype: calle_hedberg


                                        Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

                                        Post to� � �: dhis2-devs@lists.launchpad.net

                                        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@lists.launchpad.net

                                  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@lists.launchpad.net

                  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@2paths.com

                                                              skype: lorill2paths
                              (604) 689-4123 x 15

        _______________________________________________

        Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

        Post to� � �: dhis2-devs@lists.launchpad.net

        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@gmail.com

Skype: calle_hedberg


_______________________________________________ Mailing list: Post to : Unsubscribe : More help :

https://launchpad.net/~dhis2-devsdhis2-devs@lists.launchpad.nethttps://launchpad.net/~dhis2-devshttps://help.launchpad.net/ListHelp