[Bug 18606] New: Move rotating collections code to Koha::Object
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Bug ID: 18606 Summary: Move rotating collections code to Koha::Object Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: josef.moravec@gmail.com QA Contact: testopia@bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|gmcharlt@gmail.com |josef.moravec@gmail.com Blocks| |15449 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15449 [Bug 15449] Move stuffs to the Koha namespace -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=17202 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #1 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63508 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63508&action=edit Bug 18606: Add Koha::RotatingCollection[s] object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #2 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63509 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63509&action=edit Bug 18606: Get rid of DeleteCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #3 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63510 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63510&action=edit Bug 18606: Get rid of GetCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #4 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63511 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63511&action=edit Bug 18606: Get rid off GetCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #5 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63512 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63512&action=edit Bug 18606: Get rid of CreateCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #6 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63513 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63513&action=edit Bug 18606: Get rid of UpdateCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #7 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63514 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63514&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #8 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63515 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63515&action=edit Bug 18606: Schema changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #9 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63516 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63516&action=edit Bug 18606: Get rid of GetItemsInCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #10 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63517 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63517&action=edit Bug 18606: Get rid of GetCollectionItemBranches -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #11 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63518 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63518&action=edit Bug 18606: Add RotatingCollectionTracking objects -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #12 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63519 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63519&action=edit Bug 18606: Get rid of AddItemToCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #13 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63520 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63520&action=edit Bug 18606: Get rid of RemoveItemFromCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #14 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63521 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63521&action=edit Bug 18606: Get rid of TransferCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #15 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63522 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63522&action=edit Bug 18606: Get rid of isItemInThisCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #16 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63523 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63523&action=edit Bug 18606: Get rid of isItemInAnyCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #17 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63524 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63524&action=edit Bug 18606: Remove lefover of C4::RotatingCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #18 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63525 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63525&action=edit Bug 18606: Rework tests for rotating collections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #19 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63526 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63526&action=edit Bug 18606: Fix issues to pass tests -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #20 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63527 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63527&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #21 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 63528 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63528&action=edit Bug 18606: Unify handling of success/error messages -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff --- Comment #22 from Josef Moravec <josef.moravec@gmail.com> --- Not 100% ready, but I need some feedback. Note that the transfers subtesto to RotatingCollections.t is not passsing. I don't know how to implement item transfering in Koha::RotatingCollection module yet. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |17202 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17202 [Bug 17202] Deleting a rotating collection with items should either be prohibited or items should be removed -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #63508|0 |1 is obsolete| | Attachment #63509|0 |1 is obsolete| | Attachment #63510|0 |1 is obsolete| | Attachment #63511|0 |1 is obsolete| | Attachment #63512|0 |1 is obsolete| | Attachment #63513|0 |1 is obsolete| | Attachment #63514|0 |1 is obsolete| | Attachment #63515|0 |1 is obsolete| | Attachment #63516|0 |1 is obsolete| | Attachment #63517|0 |1 is obsolete| | Attachment #63518|0 |1 is obsolete| | Attachment #63519|0 |1 is obsolete| | Attachment #63520|0 |1 is obsolete| | Attachment #63521|0 |1 is obsolete| | Attachment #63522|0 |1 is obsolete| | Attachment #63523|0 |1 is obsolete| | Attachment #63524|0 |1 is obsolete| | Attachment #63525|0 |1 is obsolete| | Attachment #63526|0 |1 is obsolete| | Attachment #63527|0 |1 is obsolete| | Attachment #63528|0 |1 is obsolete| | --- Comment #23 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66227 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66227&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #24 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66228 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66228&action=edit Bug 18606: Easy ones - CRUD -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #25 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66229 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66229&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #26 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66230 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66230&action=edit Bug 18606: Schema changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #27 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66231 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66231&action=edit Bug 18606: Get rid of GetItemsInCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #28 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66232 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66232&action=edit Bug 18606: Get rid of GetCollectionItemBranches -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #29 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66233 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66233&action=edit Bug 18606: Get rid of AddItemToCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #30 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66234 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66234&action=edit Bug 18606: Get rid of RemoveItemFromCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #31 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66235 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66235&action=edit Bug 18606: Get rid of TransferCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #32 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66236 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66236&action=edit Bug 18606: Get rid of isItemInThisCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #33 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66237 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66237&action=edit Bug 18606: Get rid of isItemInAnyCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #34 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66238 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66238&action=edit Bug 18606: Remove lefover of C4::RotatingCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #35 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66239 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66239&action=edit Bug 18606: Rework tests for rotating collections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #36 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66240 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66240&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #37 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66241 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66241&action=edit Bug 18606: Unify handling of success/error messages -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #66227|0 |1 is obsolete| | Attachment #66228|0 |1 is obsolete| | Attachment #66229|0 |1 is obsolete| | Attachment #66230|0 |1 is obsolete| | Attachment #66231|0 |1 is obsolete| | Attachment #66232|0 |1 is obsolete| | Attachment #66233|0 |1 is obsolete| | Attachment #66234|0 |1 is obsolete| | Attachment #66235|0 |1 is obsolete| | Attachment #66236|0 |1 is obsolete| | Attachment #66237|0 |1 is obsolete| | Attachment #66238|0 |1 is obsolete| | Attachment #66239|0 |1 is obsolete| | Attachment #66240|0 |1 is obsolete| | Attachment #66241|0 |1 is obsolete| | --- Comment #38 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66286 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66286&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #39 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66287 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66287&action=edit Bug 18606: Easy ones - CRUD -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #40 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66288 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66288&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #41 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66289 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66289&action=edit Bug 18606: Schema changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #42 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66290 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66290&action=edit Bug 18606: Get rid of GetItemsInCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #43 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66291 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66291&action=edit Bug 18606: Get rid of GetCollectionItemBranches -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #44 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66292 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66292&action=edit Bug 18606: Get rid of AddItemToCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #45 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66293 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66293&action=edit Bug 18606: Get rid of RemoveItemFromCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #46 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66294 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66294&action=edit Bug 18606: Get rid of TransferCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #47 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66295 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66295&action=edit Bug 18606: Get rid of isItemInThisCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #48 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66296 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66296&action=edit Bug 18606: Get rid of isItemInAnyCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #49 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66297 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66297&action=edit Bug 18606: Remove lefover of C4::RotatingCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #50 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66298 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66298&action=edit Bug 18606: Rework tests for rotating collections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #51 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66299 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66299&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #52 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 66300 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66300&action=edit Bug 18606: Unify handling of success/error messages -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #53 from Josef Moravec <josef.moravec@gmail.com> --- I've rebased this on top of master, squashed few commits, fix issues, now it should be working and ready to test. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Aleisha Amohia <aleisha@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |aleisha@catalyst.net.nz Status|Needs Signoff |Failed QA --- Comment #54 from Aleisha Amohia <aleisha@catalyst.net.nz> --- Hi Josef I have one test failing in t/db_dependent/Circulation.t. I've pasted the output here: http://paste.koha-community.org/621 All other tests pass. Some notes from following the rest of your test plan: When deleting a collection, two different confirmation boxes pop up. (i know this is the behaviour before your patches) Deleting a collection with items was no different from deleting a collection without items (no error message to say the collection had items). No difference when returning an item in an untransferred collection and returning an item in a transferred collection I know the first point is the original behaviour before your patches. Unfortunately I can't test whether the second and third points are the expected behaviour because rotating collections appears to be broken for me without your patches! :) If the behaviour I've described is expected, then everything looks good. Setting to Failed QA for the failed test. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #66286|0 |1 is obsolete| | Attachment #66287|0 |1 is obsolete| | Attachment #66288|0 |1 is obsolete| | Attachment #66289|0 |1 is obsolete| | Attachment #66290|0 |1 is obsolete| | Attachment #66291|0 |1 is obsolete| | Attachment #66292|0 |1 is obsolete| | Attachment #66293|0 |1 is obsolete| | Attachment #66294|0 |1 is obsolete| | Attachment #66295|0 |1 is obsolete| | Attachment #66296|0 |1 is obsolete| | Attachment #66297|0 |1 is obsolete| | Attachment #66298|0 |1 is obsolete| | Attachment #66299|0 |1 is obsolete| | Attachment #66300|0 |1 is obsolete| | --- Comment #55 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67734 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67734&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #56 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67735 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67735&action=edit Bug 18606: Easy ones - CRUD -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #57 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67736 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67736&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #58 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67737 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67737&action=edit Bug 18606: Schema changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #59 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67738 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67738&action=edit Bug 18606: Get rid of GetItemsInCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #60 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67739 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67739&action=edit Bug 18606: Get rid of GetCollectionItemBranches -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #61 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67740 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67740&action=edit Bug 18606: Get rid of AddItemToCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #62 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67741 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67741&action=edit Bug 18606: Get rid of RemoveItemFromCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #63 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67742 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67742&action=edit Bug 18606: Get rid of TransferCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #64 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67743 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67743&action=edit Bug 18606: Get rid of isItemInThisCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #65 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67744 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67744&action=edit Bug 18606: Get rid of isItemInAnyCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #66 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67745 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67745&action=edit Bug 18606: Remove lefover of C4::RotatingCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #67 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67746 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67746&action=edit Bug 18606: Rework tests for rotating collections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #68 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67747 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67747&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #69 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67748 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67748&action=edit Bug 18606: Unify handling of success/error messages -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #70 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 67749 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67749&action=edit Bug 18606: (followup) Fix double delete confirmation -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #71 from Josef Moravec <josef.moravec@gmail.com> --- (In reply to Aleisha Amohia from comment #54)
Hi Josef
I have one test failing in t/db_dependent/Circulation.t. I've pasted the output here: http://paste.koha-community.org/621
All other tests pass.
Some notes from following the rest of your test plan: When deleting a collection, two different confirmation boxes pop up. (i know this is the behaviour before your patches) Deleting a collection with items was no different from deleting a collection without items (no error message to say the collection had items). No difference when returning an item in an untransferred collection and returning an item in a transferred collection
I know the first point is the original behaviour before your patches. Unfortunately I can't test whether the second and third points are the expected behaviour because rotating collections appears to be broken for me without your patches! :) If the behaviour I've described is expected, then everything looks good.
Setting to Failed QA for the failed test.
Thanks for testing! I did another rebase today. Test t/db_dependent/Circulation.t is passing form me. The double confirmation dialog was easy to fix, I am doing it in followup Ability to delete a collection with items is current behavior in master, I will fix it on another report Returning from transferred and untransferred collection is not diferrentiate in in current master too. Setting back to needs signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #72 from Josef Moravec <josef.moravec@gmail.com> ---
Ability to delete a collection with items is current behavior in master, I will fix it on another report
It is Bug 17202 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |19470 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19470 [Bug 19470] Add information about item being in rotating collection on detail page -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |19519 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19519 [Bug 19519] Ability to bind the rotating collection with branch during creating -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #67734|0 |1 is obsolete| | Attachment #67735|0 |1 is obsolete| | Attachment #67736|0 |1 is obsolete| | Attachment #67737|0 |1 is obsolete| | Attachment #67738|0 |1 is obsolete| | Attachment #67739|0 |1 is obsolete| | Attachment #67740|0 |1 is obsolete| | Attachment #67741|0 |1 is obsolete| | Attachment #67742|0 |1 is obsolete| | Attachment #67743|0 |1 is obsolete| | Attachment #67744|0 |1 is obsolete| | Attachment #67745|0 |1 is obsolete| | Attachment #67746|0 |1 is obsolete| | Attachment #67747|0 |1 is obsolete| | Attachment #67748|0 |1 is obsolete| | Attachment #67749|0 |1 is obsolete| | --- Comment #73 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68428 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68428&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #74 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68429 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68429&action=edit Bug 18606: Easy ones - CRUD -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #75 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68430 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68430&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #76 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68431 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68431&action=edit Bug 18606: Schema changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #77 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68432 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68432&action=edit Bug 18606: Get rid of GetItemsInCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #78 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68433 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68433&action=edit Bug 18606: Get rid of GetCollectionItemBranches -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #79 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68434 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68434&action=edit Bug 18606: Get rid of AddItemToCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #80 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68435 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68435&action=edit Bug 18606: Get rid of RemoveItemFromCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #81 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68436 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68436&action=edit Bug 18606: Get rid of TransferCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #82 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68437 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68437&action=edit Bug 18606: Get rid of isItemInThisCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #83 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68438 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68438&action=edit Bug 18606: Get rid of isItemInAnyCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #84 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68439 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68439&action=edit Bug 18606: Remove lefover of C4::RotatingCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #85 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68440 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68440&action=edit Bug 18606: Rework tests for rotating collections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #86 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68441 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68441&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #87 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68442 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68442&action=edit Bug 18606: Unify handling of success/error messages -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #88 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 68443 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68443&action=edit Bug 18606: (followup) Fix double delete confirmation -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #89 from Josef Moravec <josef.moravec@gmail.com> --- Just rebased on master (conflict in C4/Circulation.pm because of bug 14826) -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #68428|0 |1 is obsolete| | Attachment #68429|0 |1 is obsolete| | Attachment #68430|0 |1 is obsolete| | Attachment #68431|0 |1 is obsolete| | Attachment #68432|0 |1 is obsolete| | Attachment #68433|0 |1 is obsolete| | Attachment #68434|0 |1 is obsolete| | Attachment #68435|0 |1 is obsolete| | Attachment #68436|0 |1 is obsolete| | Attachment #68437|0 |1 is obsolete| | Attachment #68438|0 |1 is obsolete| | Attachment #68439|0 |1 is obsolete| | Attachment #68440|0 |1 is obsolete| | Attachment #68441|0 |1 is obsolete| | Attachment #68442|0 |1 is obsolete| | Attachment #68443|0 |1 is obsolete| | --- Comment #90 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69709 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69709&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #91 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69710 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69710&action=edit Bug 18606: Easy ones - CRUD -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #92 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69711 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69711&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #93 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69712 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69712&action=edit Bug 18606: Schema changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #94 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69713 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69713&action=edit Bug 18606: Get rid of GetItemsInCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #95 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69714 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69714&action=edit Bug 18606: Get rid of GetCollectionItemBranches -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #96 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69715 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69715&action=edit Bug 18606: Get rid of AddItemToCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #97 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69716 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69716&action=edit Bug 18606: Get rid of RemoveItemFromCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #98 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69717 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69717&action=edit Bug 18606: Get rid of TransferCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #99 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69718 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69718&action=edit Bug 18606: Get rid of isItemInThisCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #100 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69719 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69719&action=edit Bug 18606: Get rid of isItemInAnyCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #101 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69720 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69720&action=edit Bug 18606: Remove lefover of C4::RotatingCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #102 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69721 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69721&action=edit Bug 18606: Rework tests for rotating collections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #103 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69722 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69722&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #104 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69723 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69723&action=edit Bug 18606: Unify handling of success/error messages -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA --- Comment #105 from Owen Leonard <oleonard@myacpl.org> --- Testing functionality goes without any problem, but running "prove t/db_dependent/Koha/Items.t t/db_dependent/Circu lation.t" gave this result: t/db_dependent/Circulation.t (Wstat: 65280 Tests: 42 Failed: 1) Failed test: 41 Non-zero exit status: 255 Parse errors: Bad plan. You planned 112 tests but ran 42. Also, running the QA tool highlighted some issues. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #106 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 69759 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69759&action=edit Bug 18606: (followup) Make QA tools happy -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff --- Comment #107 from Josef Moravec <josef.moravec@gmail.com> --- (In reply to Owen Leonard from comment #105)
Testing functionality goes without any problem, but running "prove t/db_dependent/Koha/Items.t t/db_dependent/Circu lation.t" gave this result:
t/db_dependent/Circulation.t (Wstat: 65280 Tests: 42 Failed: 1) Failed test: 41 Non-zero exit status: 255 Parse errors: Bad plan. You planned 112 tests but ran 42.
Also, running the QA tool highlighted some issues.
Thanks for testing! I added a followup, test are passing now and QA tools return just one "warning" about pod coverage on Koha/RotatingCollection/Tracking.pm, but that is new file with no added methods, so there is nothing more to add to pod IMO. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #69709|0 |1 is obsolete| | Attachment #69710|0 |1 is obsolete| | Attachment #69711|0 |1 is obsolete| | Attachment #69712|0 |1 is obsolete| | Attachment #69713|0 |1 is obsolete| | Attachment #69714|0 |1 is obsolete| | Attachment #69715|0 |1 is obsolete| | Attachment #69716|0 |1 is obsolete| | Attachment #69717|0 |1 is obsolete| | Attachment #69718|0 |1 is obsolete| | Attachment #69719|0 |1 is obsolete| | Attachment #69720|0 |1 is obsolete| | Attachment #69721|0 |1 is obsolete| | Attachment #69722|0 |1 is obsolete| | Attachment #69723|0 |1 is obsolete| | Attachment #69759|0 |1 is obsolete| | --- Comment #108 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72416 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72416&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #109 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72417 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72417&action=edit Bug 18606: Easy ones - CRUD -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #110 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72418 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72418&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #111 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72419 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72419&action=edit Bug 18606: Schema changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #112 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72420 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72420&action=edit Bug 18606: Get rid of GetItemsInCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #113 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72421 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72421&action=edit Bug 18606: Get rid of GetCollectionItemBranches -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #114 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72422 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72422&action=edit Bug 18606: Get rid of AddItemToCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #115 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72423 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72423&action=edit Bug 18606: Get rid of RemoveItemFromCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #116 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72424 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72424&action=edit Bug 18606: Get rid of TransferCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #117 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72425 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72425&action=edit Bug 18606: Get rid of isItemInThisCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #118 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72426 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72426&action=edit Bug 18606: Get rid of isItemInAnyCollection -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #119 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72427 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72427&action=edit Bug 18606: Remove lefover of C4::RotatingCollections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #120 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72428 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72428&action=edit Bug 18606: Rework tests for rotating collections -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #121 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72429 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72429&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #122 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72430 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72430&action=edit Bug 18606: Unify handling of success/error messages -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #123 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72431 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72431&action=edit Bug 18606: (Follow-up) Make QA tools happy -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #72416|0 |1 is obsolete| | Attachment #72417|0 |1 is obsolete| | Attachment #72418|0 |1 is obsolete| | Attachment #72419|0 |1 is obsolete| | Attachment #72420|0 |1 is obsolete| | Attachment #72421|0 |1 is obsolete| | Attachment #72422|0 |1 is obsolete| | Attachment #72423|0 |1 is obsolete| | Attachment #72424|0 |1 is obsolete| | Attachment #72425|0 |1 is obsolete| | Attachment #72426|0 |1 is obsolete| | Attachment #72427|0 |1 is obsolete| | Attachment #72428|0 |1 is obsolete| | Attachment #72429|0 |1 is obsolete| | Attachment #72430|0 |1 is obsolete| | Attachment #72431|0 |1 is obsolete| | --- Comment #124 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72572 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72572&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #125 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72573 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72573&action=edit Bug 18606: Easy ones - CRUD Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #126 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72574 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72574&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #127 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72575 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72575&action=edit Bug 18606: Schema changes Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #128 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72576 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72576&action=edit Bug 18606: Get rid of GetItemsInCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #129 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72577 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72577&action=edit Bug 18606: Get rid of GetCollectionItemBranches Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #130 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72578 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72578&action=edit Bug 18606: Get rid of AddItemToCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #131 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72579 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72579&action=edit Bug 18606: Get rid of RemoveItemFromCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #132 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72580 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72580&action=edit Bug 18606: Get rid of TransferCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #133 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72581 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72581&action=edit Bug 18606: Get rid of isItemInThisCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #134 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72582 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72582&action=edit Bug 18606: Get rid of isItemInAnyCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #135 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72583 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72583&action=edit Bug 18606: Remove lefover of C4::RotatingCollections Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #136 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72584 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72584&action=edit Bug 18606: Rework tests for rotating collections Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #137 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72585 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72585&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #138 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72586 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72586&action=edit Bug 18606: Unify handling of success/error messages Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #139 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 72587 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72587&action=edit Bug 18606: (Follow-up) Make QA tools happy Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kyle@bywatersolutions.com --- Comment #140 from Kyle M Hall <kyle@bywatersolutions.com> --- QA question, should you not delete 'orphaned' collections_tracking rows before adding the foreign key constraints? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #141 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 72816 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72816&action=edit Bug 18606: (Follow-up) Remove lines from collections_tracking referencing non existant objects -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #142 from Josef Moravec <josef.moravec@gmail.com> --- (In reply to Kyle M Hall from comment #140)
QA question, should you not delete 'orphaned' collections_tracking rows before adding the foreign key constraints?
Thank for testing Kyle! I added a follow-up for this -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact|testopia@bugs.koha-communit |alex.arnaud@biblibre.com |y.org | CC| |alex.arnaud@biblibre.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #143 from Alex Arnaud <alex.arnaud@biblibre.com> --- Comment on attachment 72574 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72574 Bug 18606: Database changes - Add foreign keys to collections_tracking Review of attachment 72574: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=18606&attachment=72574) ----------------------------------------------------------------- ::: installer/data/mysql/kohastructure.sql @@ +969,5 @@
+ PRIMARY KEY (collections_tracking_id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +ALTER TABLE `collections_tracking` + ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE;
Why did add constraints separatly from the table creation? It seems to me that it is less readable for people wanting to quickly get the structure of the table. @@ +973,5 @@
+ ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE; + +ALTER TABLE `collections_tracking` + ADD CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE; +
idem -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #144 from Alex Arnaud <alex.arnaud@biblibre.com> --- Also, we lost the "reason" in error messages when adding/removing items. - Failed to add item with barcode <barcode>: Item is already in this collection => Failed to add item with barcode <barcode> - Failed to add item with barcode unknown_barcode: No item with matching barcode found => Failed to add item with barcode unknown_barcode - Failed to remove item with barcode unknown_barcode: No item with matching barcode found => Failed to remove item with barcode unknown_barcode -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #72572|0 |1 is obsolete| | Attachment #72573|0 |1 is obsolete| | Attachment #72574|0 |1 is obsolete| | Attachment #72575|0 |1 is obsolete| | Attachment #72576|0 |1 is obsolete| | Attachment #72577|0 |1 is obsolete| | Attachment #72578|0 |1 is obsolete| | Attachment #72579|0 |1 is obsolete| | Attachment #72580|0 |1 is obsolete| | Attachment #72581|0 |1 is obsolete| | Attachment #72582|0 |1 is obsolete| | Attachment #72583|0 |1 is obsolete| | Attachment #72584|0 |1 is obsolete| | Attachment #72585|0 |1 is obsolete| | Attachment #72586|0 |1 is obsolete| | Attachment #72587|0 |1 is obsolete| | Attachment #72816|0 |1 is obsolete| | --- Comment #145 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79141 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79141&action=edit Bug 18606: Add RotationCollections object classes Test plan: 1) Apply the patch 2) Update database 3) Go to tools -> Rotating collections and play with trying to break it: 3a) Add some collections 3b) Edit them 3c) Add some items to collections 3d) Remove some items 3e) Transfer some collections 3f) Try to remove collection without items 3g) Try to remove collection with items 4) Go to returns and: 4a) Try to return item from untransferred collection 4b) Try to return item from transferred collection 5) prove t/db_dependent/Koha/RotatingCollections.t t/db_dependent/Koha/Items.t t/db_dependent/Circulation.t t/db_dependent/Circulation/Returns.t Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #146 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79142 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79142&action=edit Bug 18606: Easy ones - CRUD Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #147 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79143 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79143&action=edit Bug 18606: Database changes - Add foreign keys to collections_tracking Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #148 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79144 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79144&action=edit Bug 18606: Schema changes Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #149 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79145 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79145&action=edit Bug 18606: Get rid of GetItemsInCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #150 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79146 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79146&action=edit Bug 18606: Get rid of GetCollectionItemBranches Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #151 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79147 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79147&action=edit Bug 18606: Get rid of AddItemToCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #152 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79148 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79148&action=edit Bug 18606: Get rid of RemoveItemFromCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #153 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79149 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79149&action=edit Bug 18606: Get rid of TransferCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #154 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79150 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79150&action=edit Bug 18606: Get rid of isItemInThisCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #155 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79151 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79151&action=edit Bug 18606: Get rid of isItemInAnyCollection Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #156 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79152 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79152&action=edit Bug 18606: Remove lefover of C4::RotatingCollections Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #157 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79153 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79153&action=edit Bug 18606: Rework tests for rotating collections Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #158 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79154 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79154&action=edit Bug 18606: Add test to t/db_dependent/Koha/Items.t Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #159 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79155 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79155&action=edit Bug 18606: Unify handling of success/error messages Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #160 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79156 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79156&action=edit Bug 18606: (follow-up) Make QA tools happy Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #161 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79157 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79157&action=edit Bug 18606: (follow-up) Remove lines from collections_tracking referencing non existant objects -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #162 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79158 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79158&action=edit Bug 18606: (follow-up) Do not add contraints in kohastructure.sql separately -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #163 from Josef Moravec <josef.moravec@gmail.com> --- (In reply to Alex Arnaud from comment #143)
Comment on attachment 72574 [details] [review] Bug 18606: Database changes - Add foreign keys to collections_tracking
Review of attachment 72574 [details] [review]: -----------------------------------------------------------------
::: installer/data/mysql/kohastructure.sql @@ +969,5 @@
+ PRIMARY KEY (collections_tracking_id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +ALTER TABLE `collections_tracking` + ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE;
Why did add constraints separatly from the table creation? It seems to me that it is less readable for people wanting to quickly get the structure of the table.
No strong reason from me, fixed in follow-up. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #164 from Josef Moravec <josef.moravec@gmail.com> --- (In reply to Alex Arnaud from comment #144)
Also, we lost the "reason" in error messages when adding/removing items. - Failed to add item with barcode <barcode>: Item is already in this collection => Failed to add item with barcode <barcode> - Failed to add item with barcode unknown_barcode: No item with matching barcode found => Failed to add item with barcode unknown_barcode - Failed to remove item with barcode unknown_barcode: No item with matching barcode found => Failed to remove item with barcode unknown_barcode
I rebased the patches on master and now I am working on the error messages, follow-up will come soon - hopefully -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 --- Comment #165 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 79161 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79161&action=edit Bug 18606: Fix TT filters -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #166 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Josef, looking through some older bugs - should this still be FQA? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Marjorie Barry-Vila <marjorie.barry-vila@collecto.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |marjorie.barry-vila@collect | |o.ca -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com --- Comment #167 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Still hoping to move this one forward Josef? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|17202 | Depends on| |17202 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17202 [Bug 17202] Deleting a rotating collection with items should either be prohibited or items should be removed -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |29842 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29842 [Bug 29842] Item should be removed from rotating collection when item is deleted -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Patrick Robitaille <patrick.robitaille@collecto.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |patrick.robitaille@collecto | |.ca -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org