https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39322
Nick Clemens (kidclamp) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |39301 --- Comment #3 from Nick Clemens (kidclamp) <[email protected]> --- (In reply to David Nind from comment #2) > I had a go at testing, but I'm not sure about a couple of items in the test > plan: > > 1. Step 1 - .."none kept for pseudonymization": How do you do this? Or is > this only shown for the attribute once pseudonymization is enabled (the > "Keep for pseudonymization" field)? Correct, it only shows when pseudonymization is available > 2. Step 7: How do I tell this? The output from running the command is listed > at the end. > > For statistics, I checked out a couple of items and checked them back in. Is > this sufficient? > > > Testing notes (using KTD): > 1. Generate a password in KTD from the shell: htpasswd -bnBC 10 "" password > | tr -d ':\n' | sed 's/$2y/$2a/' > 2. Edit /etc/koha/sites/kohadev/koha-conf.xml > 3. Add an entry before the </config>: > <bcrypt_settings>whateverstep1generated</bcrypt_settings> > 4. Restart everything: restart_all > > Output from step 6 > ------------------ > > perl misc/maintenance/pseudonymize_statistics.pl -v -c --before 2026-01-01 > Searching for statistics before 2026-01-01 > SELECT COUNT( * ) FROM `statistics` `me` WHERE ( `datetime` <= ? ): > '2026-01-01' > 4 statistics found > SELECT COUNT( * ) FROM `pseudonymized_transactions` `me` WHERE ( `datetime` > <= ? ): '2026-01-01' > SELECT COUNT( * ) FROM `statistics` `me` WHERE ( `datetime` <= ? ): > '2026-01-01' > SELECT `me`.`datetime`, `me`.`branch`, `me`.`value`, `me`.`type`, > `me`.`other`, `me`.`itemnumber`, `me`.`itemtype`, `me`.`location`, > `me`.`borrowernumber`, `me`.`ccode`, `me`.`categorycode`, `me`.`interface` > FROM `statistics` `me` WHERE ( `datetime` <= ? ): '2026-01-01' > INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, > `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) > VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, > '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": > null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", > "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, > "register_name":null,"id":null}', > '{"statistic":{"itemtype":"BK","interface":"intranet","type":"issue", > "borrowernumber":5,"value":0,"location":"GEN","branch":"CPL","itemnumber": > 578,"datetime":"2025-03-16 > 20:58:50","categorycode":"PT","ccode":"REF","other":""}}', NULL, > '2025-03-16T21:05:29', 'default', '1', NULL, 'new', 'pseudonymize_statistic' > INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, > `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) > VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, > '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": > null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", > "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, > "register_name":null,"id":null}', > '{"statistic":{"type":"return","itemtype":"BK","interface":"intranet", > "value":0,"location":"GEN","branch":"CPL","borrowernumber":5,"datetime": > "2025-03-16 > 20:58:55","categorycode":"PT","itemnumber":578,"ccode":"REF","other":""}}', > NULL, '2025-03-16T21:05:29', 'default', '1', NULL, 'new', > 'pseudonymize_statistic' > INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, > `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) > VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, > '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": > null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", > "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, > "register_name":null,"id":null}', > '{"statistic":{"ccode":"REF","other":"","categorycode":"PT","datetime":"2025- > 03-16 > 20:59:07","itemnumber":296,"value":0,"location":"GEN","branch":"CPL", > "borrowernumber":23,"type":"issue","itemtype":"BK","interface":"intranet"}}', > NULL, '2025-03-16T21:05:29', 'default', '1', NULL, 'new', > 'pseudonymize_statistic' > INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, > `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) > VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, > '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": > null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", > "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, > "register_name":null,"id":null}', > '{"statistic":{"categorycode":"PT","datetime":"2025-03-16 > 20:59:15","itemnumber":296,"ccode":"REF","other":"","type":"return", > "interface":"intranet","itemtype":"BK","branch":"CPL","value":0,"location": > "GEN","borrowernumber":23}}', NULL, '2025-03-16T21:05:29', 'default', '1', > NULL, 'new', 'pseudonymize_statistic' > SELECT COUNT( * ) FROM `statistics` `me` WHERE ( `datetime` <= ? ): > '2026-01-01' > 4 statistics pseudonymized Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39301 [Bug 39301] pseudonymize_statistics.pl script generates too many background jobs -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
