Attachment 107275 Details for Bug 23696 – Bug 23696: take deleted biblios into account when building oai sets

[patch] Bug 23696: take deleted biblios into account when building oai sets

Bug-23696-take-deleted-biblios-into-account-when-b.patch (text/plain), 1.63 KB, created by Marcel de Rooy on 2020-07-24 07:22:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2020-07-24 07:22:47 UTC

Size: 1.63 KB

patch

obsolete

>From 498e2381327393f8d4d9e852afe54e534f3d3052 Mon Sep 17 00:00:00 2001
>From: Josef Moravec <josef.moravec@gmail.com>
>Date: Mon, 30 Sep 2019 09:28:40 +0000
>Subject: [PATCH] Bug 23696: take deleted biblios into account when building
> oai sets
>Content-Type: text/plain; charset=utf-8
>
>Test plan:
>0) do not apply the patch
>1) set up OAI and create at least one set
>2) run build_oai_sets.pl
>3) remember/write down number of records added
>4) delete a biblio, the is included in set
>5) run buid_oai_sets.pl again
>6) the set is 1 record smaller
>7) apply the patch
>8) run build_oai_sets.pl
>9) the number of record should be the same as in 3)
>
>Signed-off-by: Michal Denar <black23@gmail.com>
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> misc/migration_tools/build_oai_sets.pl | 7 ++++++-
> 1 file changed, 6 insertions(+), 1 deletion(-)
>
>diff --git a/misc/migration_tools/build_oai_sets.pl b/misc/migration_tools/build_oai_sets.pl
>index 64addad2ce..c7b73a2d7d 100755
>--- a/misc/migration_tools/build_oai_sets.pl
>+++ b/misc/migration_tools/build_oai_sets.pl
>@@ -75,6 +75,11 @@ my $query = qq{
>     FROM biblio_metadata
>     WHERE format='marcxml'
>     AND  `schema` = ?
>+    UNION
>+    SELECT biblionumber, metadata
>+    FROM deletedbiblio_metadata
>+    WHERE format='marcxml'
>+    AND  `schema` = ?
> };
> if($length) {
>     $query .= "LIMIT $length";
>@@ -83,7 +88,7 @@ if($length) {
>     }
> }
> my $sth = $dbh->prepare($query);
>-$sth->execute( C4::Context->preference('marcflavour') );
>+$sth->execute( C4::Context->preference('marcflavour'), C4::Context->preference('marcflavour'));
> my $results = $sth->fetchall_arrayref({});
> print "done.\n" if $verbose;
> 
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 23696: 93229 | 93334 | 107275