[Gnumed-devel] dem.staff.fk_role column removed

[Jerzy Luszawski]

Hello everybody!

After few years of break in using Gnumed, I am trying to get back to it.

I checked out git repository, bootstrapped database v18, and found
couple of problems ;)

The most important is inability to enlist a person as staff, which
seems to be related to change in v18 database
(v18-dem-staff-static.sql) which was not reflected in code (gmStaff.py).
I am not up-to-date with current concepts, so I don't want to fix it myself.


----- relevant part of the log -----------
2013-03-18 01:00:14  ERROR     gm.db 
(/home/jll2/prg/gm-git/gnumed/gnumed/gnumed/Gnumed/pycommon/gmPG2.py::run_rw_queries()
 #1201): PG error message: ERROR:  column "fk_role" of relation "staff" does 
not exist
LINE 3:     (fk_identity, fk_role, db_user, short_alias)
                          ^
2013-03-18 01:00:14  DEBUG     gm.gui 
(/home/jll2/prg/gm-git/gnumed/gnumed/gnumed/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
 #196): unhandled exception caught:
Traceback (most recent call last):
  File 
"/home/jll2/prg/gm-git/gnumed/gnumed/gnumed/Gnumed/wxpython/gmStaffWidgets.py", 
line 268, in _on_enlist_button_pressed
    short_alias = self._TXT_short_alias.GetValue().strip()
  File "/home/jll2/prg/gm-git/gnumed/gnumed/gnumed/Gnumed/business/gmStaff.py", 
line 182, in create_staff
    rows, idx = gmPG2.run_rw_queries(link_obj = conn, queries = queries, end_tx 
= True)
  File "/home/jll2/prg/gm-git/gnumed/gnumed/gnumed/Gnumed/pycommon/gmPG2.py", 
line 1194, in run_rw_queries
    curs.execute(query['cmd'], args)
  File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 123, in 
execute
    return _cursor.execute(self, query, vars)
ProgrammingError: column "fk_role" of relation "staff" does not exist
LINE 3:     (fk_identity, fk_role, db_user, short_alias)
------------ log end ----


Best regards,
Jerzy
 
PS. There is no tag in git repository for 1.3 release :(