[Debian-med-packaging] Bug#687702: gnumed-client: t-p-o candidate on 1.1 maintenance branch available

ncq karsten.hilbert at gmx.net
Sat Sep 15 10:27:02 UTC 2012

Package: gnumed-client
Version: 1.1.17-1
Severity: normal


currently, Debian Wheezy includes the Medical Record GNUmed
client 1.1.17 frozen for inclusion into Stable. The 1.1
branch of GNUmed is firmly in maintenance/bug fix only mode.
In the meantime, 1.1.18 and 1.1.19 have been released, fixing
one bug each.

I would like to ask for inclusion of the 1.1.19 release into
Wheezy via testing-proposed-updates.


- two bugs were fixed
- both bug fixes amount to a one-line code change each

One bug can amount to a patient safety issue:

 Assume a doctor is writing a note to himself using the
 GNUmed client: "Must check on Mrs Smith cancer screening
 next visit." Then notices that the note should have been
 about Mrs Smithers rather than Mrs Smith.

 Due to the bug the doctor cannot edit the note to refer to
 the correct patient.

 The workaround is, of course, to delete the faulty note and
 enter a new one with the correct patient data. However,
 crucial medical details (think blood test results) may have
 carefully been included with the first message. Writing a
 new message carries the risk of making mistakes with those
 details once more. It would increase patient safety if the
 original message could be modified.

This is what the bug fix:

	FIX: faulty handling of inbox message context PK arrays


The second bug prevents users from entering regions (states,
counties, provinces, ...) of their home country in order to
record patient addresses. This will render GNUmed useless
for those countries for which GNUmed does not by default
provide all the demographic region information that they
need. We have discovered this flaw through a field report by
users from Chile where the GNUmed EMR is used to improve
healthcare in underdeveloped regions.

The work around for them is to add the necessary regions at
the raw SQL level into the PostgreSQL database.


Appended is the full patch set between 1.1.17 and 1.1.19:

diff --git a/gnumed/CHANGELOG b/gnumed/CHANGELOG
index c9ae0be..9a8ae9b 100644
--- a/gnumed/CHANGELOG
+++ b/gnumed/CHANGELOG
@@ -6,6 +6,14 @@
 # rel-1-1-patches
+	1.1.19
+FIX: faulty handling of inbox message context PK arrays
+	1.1.18
+FIX: exception on adding region [thanks U.Koch Kronberg]
 FIX: FreeDiams XML file API access
diff --git a/gnumed/gnumed/client/business/gmProviderInbox.py b/gnumed/gnumed/client/business/gmProviderInbox.py
index 6295de4..b43bdc0 100644
--- a/gnumed/gnumed/client/business/gmProviderInbox.py
+++ b/gnumed/gnumed/client/business/gmProviderInbox.py
@@ -35,7 +35,7 @@ class cInboxMessage(gmBusinessDBObject.cBusinessDBObject):
 				data = gm.nullify_empty_string(%(data)s),
 				importance = %(importance)s,
 				fk_patient = %(pk_patient)s,
-				ufk_context = %(pk_context)s
+				ufk_context = NULLIF(%(pk_context)s::integer[], ARRAY[NULL::integer])
 				pk = %(pk_inbox_message)s
@@ -52,7 +52,7 @@ class cInboxMessage(gmBusinessDBObject.cBusinessDBObject):
-		u'ufk_context'
+		u'pk_context'
 def get_inbox_messages(pk_staff=None, pk_patient=None, include_without_provider=False, order_by=None):
diff --git a/gnumed/gnumed/client/gnumed.py b/gnumed/gnumed/client/gnumed.py
index 5ad6ac2..b87150c 100644
--- a/gnumed/gnumed/client/gnumed.py
+++ b/gnumed/gnumed/client/gnumed.py
@@ -85,7 +85,7 @@ against. Please run GNUmed as a non-root user.
-current_client_version = u'1.1.17'
+current_client_version = u'1.1.19'
 current_client_branch = u'1.1'
 _log = None
diff --git a/gnumed/gnumed/client/wxpython/gmAddressWidgets.py b/gnumed/gnumed/client/wxpython/gmAddressWidgets.py
index 7b8c681..4059f5f 100644
--- a/gnumed/gnumed/client/wxpython/gmAddressWidgets.py
+++ b/gnumed/gnumed/client/wxpython/gmAddressWidgets.py
@@ -424,7 +424,8 @@ class cProvinceEAPnl(wxgProvinceEAPnl.wxgProvinceEAPnl, gmEditArea.cGenericEditA
 		self.data = {
 			'l10n_state' : self._PRW_province.GetValue().strip(),
 			'code_state' : self._TCTRL_code.GetValue().strip(),
-			'l10n_country' : self._PRW_country.GetValue().strip()
+			'l10n_country' : self._PRW_country.GetValue().strip(),
+			'code_country' : self._PRW_country.GetData().strip()
 		return True
diff --git a/gnumed/gnumed/dists/Linux/make-release_tarball.sh b/gnumed/gnumed/dists/Linux/make-release_tarball.sh
index 7476225..7efe9b6 100755
--- a/gnumed/gnumed/dists/Linux/make-release_tarball.sh
+++ b/gnumed/gnumed/dists/Linux/make-release_tarball.sh
@@ -3,10 +3,10 @@
 # license: GPL v2 or later
diff --git a/gnumed/gnumed/server/sql/v15-v16/dynamic/v16-release_notes-dynamic.sql b/gnumed/gnumed/server/sql/v15-v16/dynamic/v16-release_notes-dynamic.sql
index 8a67057..cd51104 100644
--- a/gnumed/gnumed/server/sql/v15-v16/dynamic/v16-release_notes-dynamic.sql
+++ b/gnumed/gnumed/server/sql/v15-v16/dynamic/v16-release_notes-dynamic.sql
@@ -17,12 +17,12 @@ INSERT INTO dem.message_inbox (
 	(select pk from dem.staff where db_user = 'any-doc'),
 	(select pk_type from dem.v_inbox_item_type where type = 'memo' and category = 'administrative'),
-	'Release Notes for GNUmed 1.1.17 (database v16.17)',
-	'GNUmed 1.1.17 Release Notes:
+	'Release Notes for GNUmed 1.1.19 (database v16.19)',
+	'GNUmed 1.1.19 Release Notes:
-	16.17
+	1.1.19
-FIX: insufficient waiting time formatting [thanks J.Busser]
+FIX: faulty handling of inbox message context PK arrays
 -- --------------------------------------------------------------

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'stable-updates'), (500, 'stable'), (50, 'unstable'), (10, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-3-686-pae (SMP w/2 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages gnumed-client depends on:
ii  aspell                              0.60.7~20110707-1
ii  file                                5.11-2
ii  gnumed-common                       1.2.3-1
ii  ispell                              3.3.02-5
ii  myspell-de-at [myspell-dictionary]  20120607-1
ii  myspell-de-ch [myspell-dictionary]  20120607-1
ii  myspell-en-us [myspell-dictionary]  1:3.3.0-4
ii  python                              2.7.3~rc2-1
ii  python-egenix-mxdatetime            3.2.1-1.1
ii  python-enchant                      1.6.5-2
ii  python-gnuplot                      1.8-1.1
ii  python-wxgtk2.8           
ii  texlive-latex-base                  2012.20120611-4

Versions of packages gnumed-client recommends:
ii  aeskulap                   0.2.2b1-11
ii  cups-pdf                   2.6.1-6
ii  dicomscope                 3.6.0-9
ii  extract                    1:0.6.3-5
ii  freediams                  0.7.6-1
ii  ginkgocadx       
ii  gnumed-doc                 1.2.3-1
ii  gtklp                      1.2.7-2.3
ii  iceweasel [www-browser]    10.0.7esr-2
ii  imagej                     1.46a-1
ii  konqueror [www-browser]    4:4.8.4-1
ii  libreoffice-writer         1:3.5.4+dfsg-1
ii  ntp                        1:4.2.6.p5+dfsg-2
ii  pdftk                      1.44-6
ii  python-uno                 1:3.5.4+dfsg-1
ii  texlive-latex-extra        2012.20120611-2
ii  texlive-latex-recommended  2012.20120611-4
ii  w3m [www-browser]          0.5.3-8
ii  wgerman-medical            20110608-1
ii  xdg-utils                  1.1.0~rc1+git20111210-6
ii  xmedcon                    0.10.7-1+b2
ii  xsane                      0.998-3+b1

Versions of packages gnumed-client suggests:
pn  autokey-qt | autokey-gtk  <none>
ii  edfbrowser                1.48-1
ii  gimp                      2.8.0-2+b1
ii  gnumed-server             16.17-1
ii  incron                    0.5.10-1
ii  konsolekalendar           4:
ii  korganizer                4:
ii  libchipcard-tools         5.0.3beta-2
ii  pgadmin3                  1.14.2-2
pn  shutdown-at-night         <none>

-- no debconf information

More information about the Debian-med-packaging mailing list