[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Test results schema question re method of acquiring t
Re: [Gnumed-devel] Test results schema question re method of acquiring the result
Fri, 24 Sep 2004 08:23:14 +0200
> > > Among the auditing fields is modified_by which is NOT NULL DEFAULT
> >> 'current_user' but what value is written in here when the row is
> >> created as part of an import?
> >Well, the "current_user". The database does neither know nor
> >care whether that's a human or a script.
> Ah - so perhaps instead of having to create an "organization", the
> original source could be preserved, and this value for "current_user"
> would identify either the individual (if it happened to be a person
> making a manual entry) or a script because are scripts are ???
> credentialed in order to have a status as a user, in order to be able
> to have permission to import rows?
Well, *any*thing/one needs to get a credentialled connection
to the database no matter whether it's a script or a user. The
account part of those credentials gets written to the
modified_by field of the auditing structure - note that we
even enforce this by means of a trigger...
You'd still have to create an organization to record where the
results where generated - not who *entered*/changed the
results in your database. However, if you don't care you can
get away with a generic "a lab" organization to which you just
link *any* data.
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346