[Koha-bugs] [Bug 29921] Allow to index in Elasticsearch all records modified since a given date

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29921

Stéphane Delaune <stephane.delaune at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |stephane.delaune at biblibre.c
                   |                            |om

--- Comment #3 from Stéphane Delaune <stephane.delaune at biblibre.com> ---
I just tested (see test plan below): it works, thank you

test plan :
koha at test-koha:~$ mysql
MariaDB [koha]> select max(timestamp) from items;
+---------------------+
| max(timestamp)      |
+---------------------+
| 2022-02-02 10:02:20 |
+---------------------+
1 row in set (0.001 sec)

MariaDB [koha]> select max(timestamp) from biblio_metadata;
+---------------------+
| max(timestamp)      |
+---------------------+
| 2022-02-02 10:40:16 |
+---------------------+
1 row in set (0.000 sec)

MariaDB [koha]> select max(modification_time) from auth_header;
+------------------------+
| max(modification_time) |
+------------------------+
| 2022-01-31 16:22:58    |
+------------------------+

MariaDB [koha]> select biblionumber from items where itemnumber=842565;
+--------------+
| biblionumber |
+--------------+
|       509975 |
+--------------+
1 row in set (0.001 sec)

MariaDB [koha]> update items set timestamp='2022-02-14 10:02:20' where
itemnumber=842565;
Query OK, 0 rows affected (0.001 sec)
Rows matched: 1  Changed: 0  Warnings: 0

MariaDB [koha]> update biblio_metadata set timestamp='2022-02-14 10:02:20'
where biblionumber=509974;
Query OK, 0 rows affected (0.001 sec)
Rows matched: 1  Changed: 0  Warnings: 0

MariaDB [koha]> update auth_header set modification_time='2022-02-14 10:02:20'
where authid=426547;
Query OK, 0 rows affected (0.001 sec)
Rows matched: 1  Changed: 0  Warnings: 0
MariaDB [koha]> exit;
Bye
koha at test-koha:~$ ~/src/misc/search_tools/rebuild_elasticsearch.pl -b -v
--modified-since '2022-02-14 10:02:19'
[16518] Checking state of biblios index
[16518] Indexing biblios
[16518] Committing final records...
[16518] Total 2 records indexed
koha at test-koha:~$ ~/src/misc/search_tools/rebuild_elasticsearch.pl -a -v
--modified-since '2022-02-14 10:02:19'
[16529] Checking state of authorities index
[16529] Indexing authorities
[16529] Committing final records...
[16529] Total 1 records indexed

-- 
You are receiving this mail because:
You are watching all bug changes.