[Koha-bugs] [Bug 20271] Merge deleted biblio, biblioitems, biblio_metadata, and items tables with their "alive" cousins
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jun 22 12:06:57 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20271
Josef Moravec <josef.moravec at gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #75977|0 |1
is obsolete| |
Attachment #75978|0 |1
is obsolete| |
Attachment #75979|0 |1
is obsolete| |
Attachment #75980|0 |1
is obsolete| |
Attachment #75981|0 |1
is obsolete| |
Attachment #75982|0 |1
is obsolete| |
Attachment #75983|0 |1
is obsolete| |
Attachment #75984|0 |1
is obsolete| |
Attachment #75985|0 |1
is obsolete| |
Attachment #75986|0 |1
is obsolete| |
Attachment #75987|0 |1
is obsolete| |
Attachment #75988|0 |1
is obsolete| |
Attachment #75989|0 |1
is obsolete| |
Attachment #75990|0 |1
is obsolete| |
Attachment #75991|0 |1
is obsolete| |
Attachment #75992|0 |1
is obsolete| |
Attachment #75993|0 |1
is obsolete| |
Attachment #76048|0 |1
is obsolete| |
Attachment #76255|0 |1
is obsolete| |
--- Comment #136 from Josef Moravec <josef.moravec at gmail.com> ---
Created attachment 76256
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=76256&action=edit
Bug 20271: merging delete biblio/items
The present bug merges the following tables:
deletedbiblio -> biblio
deletedbiblioitems -> biblioitems
deletedbiblio_metadata -> biblio_metadata
deleteditems -> items
and adds a column deleted_at to signify time of deletion, if deleted
it replaces all occurrences of the mentioned occurences and uses
of mentioned deleted* tables
upgrade is handled by moving rows from deleted* tables to the live
ones. If all rows are moved, the corresponding tables are dropped.
If there are duplicates or conflicts (duplicate barcodes e.g.) they
reminders are left for scrutiny and table renamed to _deleted*
Test plan:
1) Make sure you have a db with at least a few deleted biblios,
biblioitems and items.
2) Apply patch and run updatedatabase.pl
3) Make note of the db upgrade messages, if you get a message like:
There were x deleteditems that could not be moved, please check
_deleteditems
you should check the _deleteditems table and verify that they are
actual conflicts
4) Click around in the web interface and make sure you can delete items
and biblios
5) "Undelete" an item by NULLing the deleted_at column for an item
and verify that it returns in interface (Not neccessary really)
Signed-off-by: Brendan A Gallagher <brendan at bywatersolutions.com>
Signed-off-by: Martin Renvoize <martin.renvoize at ptfs-europe.com>
Signed-off-by: Josef Moravec <josef.moravec at gmail.com>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list