| Time |
Nick |
Message |
| 00:53 |
|
sandbergja joined #evergreen |
| 05:00 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 05:29 |
|
stephengwills joined #evergreen |
| 07:12 |
|
rjackson_isl joined #evergreen |
| 07:14 |
|
agoben joined #evergreen |
| 07:27 |
|
JBoyer joined #evergreen |
| 08:36 |
|
bos20k joined #evergreen |
| 08:42 |
|
mmorgan joined #evergreen |
| 08:54 |
|
Dyrcona joined #evergreen |
| 09:16 |
|
yboston joined #evergreen |
| 09:38 |
pastebot |
"gmcharlt" at 64.57.241.14 pasted "about to be end of an era for somebody" (3 lines) at http://paste.evergreen-ils.org/10835 |
| 09:50 |
rhamby |
"it's the end of the world as we know it and I feel fine" |
| 09:50 |
Dyrcona |
:) |
| 09:51 |
JBoyer |
gmcharlt++ |
| 09:54 |
|
sandbergja joined #evergreen |
| 09:58 |
|
nfBurton joined #evergreen |
| 11:20 |
|
sandbergja joined #evergreen |
| 11:34 |
|
khuckins joined #evergreen |
| 11:48 |
|
sandbergja_ joined #evergreen |
| 11:49 |
|
Christineb joined #evergreen |
| 11:53 |
|
yboston joined #evergreen |
| 11:57 |
|
sandbergja_ joined #evergreen |
| 12:14 |
|
jihpringle joined #evergreen |
| 12:31 |
|
sandbergja_ joined #evergreen |
| 13:12 |
|
yboston joined #evergreen |
| 13:27 |
bos20k |
In the auditor.actor_usr_history table, the audit_action column. Are values in there linked to another table or are they just any text. I am looking at rows that have 'U' for audit_action and have no idea what that means (if it means anything at all). |
| 13:27 |
jeff |
"update" |
| 13:27 |
Dyrcona |
bos20k: It m..... |
| 13:27 |
Dyrcona |
What jeff said. :) |
| 13:28 |
bos20k |
Duh, that makes sense. Seems this user was deleted or something since it is now PURGED but it only shows these U actions in the auditor table. I guess that makes sense, deletion is a form of updating. :) |
| 13:29 |
jeff |
the value in that column comes from auditor.audit_actor_usr_func, and is SUBSTR(TG_OP,1,1) -- TG_OP is going to be either UPDATE or DELETE: |
| 13:29 |
jeff |
audit_actor_usr_update_trigger AFTER DELETE OR UPDATE ON actor.usr FOR EACH ROW EXECUTE PROCEDURE auditor.audit_actor_usr_func() |
| 13:30 |
jeff |
but in reality you'll probably never see a D for Delete because of the rule: |
| 13:30 |
jeff |
ON DELETE TO actor.usr DO INSTEAD UPDATE actor.usr SET deleted = true |
| 13:30 |
bos20k |
Hmmm, wondering how it got PURGED then since there are only these Us in the action column in auditor. |
| 13:31 |
Dyrcona |
Well, as jeff explained, usrs are never really deleted from a database perspective. |
| 13:31 |
Dyrcona |
If the user was purged, then the last entry in the auditor should be what they looked like before the purge, and the audit_user would be the one who did it. |
| 13:32 |
bos20k |
I wonder if it is a merge gone wrong (or right but the staff just don't know what they merged it to). |
| 13:34 |
bos20k |
Is the only way for staff to make a usr marked PURGED is for them to merge it with another usr, or am I not thinking of something? |
| 13:37 |
Dyrcona |
If you delete a patron from the staff client, they get purged. |
| 13:40 |
bos20k |
They do? Hmmm, I thought they just were marked as deleted. |
| 13:46 |
jeffdavis |
Well, I think the action for deleting individual accounts is called "Completely Purge Account" or something like that in the web client. |
| 13:47 |
jeffdavis |
I don't recall if batch deletions purge or flag as deleted, or what terminology they use. It ought to use "purge" if that's what happens. |
| 14:24 |
Dyrcona |
bos20k: You may have a local customization not to purge patrons via the staff client. CW MARS had that because of performance issues, but we're using the stock functions, now. |
| 14:34 |
* mmorgan |
can confirm that batch deletions from a user bucket mark the record deleted rather than purge |
| 14:36 |
mmorgan |
also, prior to 3.1.8, 3.2.2, patron records deleted from a merge operation were only flagged deleted, not purged. |
| 14:37 |
bos20k |
Thanks for all your thoughts on this. I think I was confusing deletion with merging. I don't mess with this stuff often enough to remember all the different behaviors. |
| 14:39 |
Dyrcona |
Merging also purges the patron that is going away. |
| 14:41 |
|
stephengwills joined #evergreen |
| 15:15 |
|
sandbergja_ joined #evergreen |
| 15:17 |
|
khuckins joined #evergreen |
| 17:00 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 17:03 |
|
mmorgan left #evergreen |
| 17:06 |
|
seymour joined #evergreen |
| 17:44 |
|
gsams joined #evergreen |
| 21:25 |
|
sandbergja joined #evergreen |
| 22:23 |
|
sandbergja joined #evergreen |
