Re: [Gnumed-devel] Inadvertent deletion of Procedure when Deleting episode

[Busser, Jim]

On 2013-08-01, at 10:46 AM, Karsten Hilbert <address@hidden> wrote:

>> 2) I had already been unable to locate the existence of a
>> clin.clin_root_item referencing the procedure which I had
>> caused to disappear into the audit table.
> 
> I am still hard pressed to believe that.
> 
> Please retry with the attached which will give use more information.

Retry attached, which informs about the test that I just created and deleted.

I only point out that a script to

        identify -- among *existing* clin_root_item rows -- those with dangling 
keys

will not itself

        account for missing *clin_root_item* rows

-- JIm

==============================
Please enter the required login parameters:
host ('' = non-TCP/IP) (CTRL-C aborts) []: 
database (CTRL-C aborts) [gnumed_v18]: gnumed_v18
user name (CTRL-C aborts) []: gm-dbo
password for "gm-dbo" (not shown): 
port (CTRL-C aborts) [5432]: 5432


Looking for dangling clin.clin_root_item rows ...

1) rows with dangling .fk_episode:
=> dangling row: [1662626, 0, datetime.datetime(2013, 8, 1, 9, 9, 45, 788782, 
tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=-420, name=None)), u'jabu', 1071, 
datetime.datetime(2013, 8, 1, 9, 9, 45, 788782, 
tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=-420, name=None)), 1156, 398, 
u'fixation left tibial fracture', u'p', 'clin.procedure']
   verifying corresponding child table row in [clin.procedure] ...
=> [clin.procedure] row: [1662626, 0, datetime.datetime(2013, 8, 1, 9, 9, 45, 
788782, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=-420, name=None)), 
u'jabu', 1071, datetime.datetime(2013, 8, 1, 9, 9, 45, 788782, 
tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=-420, name=None)), 1156, 398, 
u'fixation left tibial fracture', u'p', 5, u'Enterprise Healthcare Unit', None, 
None, False]
   looking for most recent row about episode 398 in audit table ...
=> audited row: [1662625, 1, datetime.datetime(2013, 8, 1, 9, 9, 17, 647967, 
tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=-420, name=None)), u'jabu', 
17788, u'DELETE', datetime.datetime(2013, 8, 1, 9, 59, 37, 227794, 
tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=-420, name=None)), u'gm-dbo', 1, 
datetime.datetime(2013, 8, 1, 9, 9, 17, 647967, 
tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=-420, name=None)), u'jabu', 398, 
95, u'mva', True, 1156, None, None]

2) rows with dangling .fk_encounter:
MacBook-2:testing djb$ 
==============================