Bug 33379

Summary: virtualshelfcontents.flags seems useless
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Architecture, internals, and plumbingAssignee: Marcel de Rooy <m.de.rooy>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: fridolin.somers, m.de.rooy, tomascohen
Version: unspecified   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
This patch set drops the column virtualshelfcontents.flag which is unused for a long time.
Version(s) released in:
23.11.00
Circulation function:
Attachments: Bug 33379: Remove virtualshelfcontents.flags
Bug 33379: DBIx changes
Bug 33379: Remove virtualshelfcontents.flags
Bug 33379: DBIx changes
Bug 33379: Remove virtualshelfcontents.flags
Bug 33379: DBIx changes
Bug 33379: (QA follow-up) Tidy dbrev

Description Jonathan Druart 2023-03-31 07:53:09 UTC
Looks like we should remove this column, it's not used.
Comment 1 Marcel de Rooy 2023-06-27 14:43:39 UTC
Created attachment 152749 [details] [review]
Bug 33379: Remove virtualshelfcontents.flags

This field is unused. A historic leftover from 2000-2010.

Test plan:
Run dbrev.
Run prove t/db_dependent/Koha/Virtualshel*

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Comment 2 Marcel de Rooy 2023-06-27 14:43:41 UTC
Created attachment 152750 [details] [review]
Bug 33379: DBIx changes

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Comment 3 Lucas Gass (lukeg) 2023-06-27 19:09:50 UTC
Created attachment 152770 [details] [review]
Bug 33379: Remove virtualshelfcontents.flags

This field is unused. A historic leftover from 2000-2010.

Test plan:
Run dbrev.
Run prove t/db_dependent/Koha/Virtualshel*

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Comment 4 Lucas Gass (lukeg) 2023-06-27 19:09:53 UTC
Created attachment 152771 [details] [review]
Bug 33379: DBIx changes

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Comment 5 Jonathan Druart 2023-07-04 10:27:15 UTC
Created attachment 153010 [details] [review]
Bug 33379: Remove virtualshelfcontents.flags

This field is unused. A historic leftover from 2000-2010.

Test plan:
Run dbrev.
Run prove t/db_dependent/Koha/Virtualshel*

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Comment 6 Jonathan Druart 2023-07-04 10:27:18 UTC
Created attachment 153011 [details] [review]
Bug 33379: DBIx changes

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Comment 7 Jonathan Druart 2023-07-04 10:28:42 UTC
We could test if the column is empty, but this leads to problem in the past. I am in favor of dropping the column.

There are release notes and backups to prevent data loss.
Comment 8 Marcel de Rooy 2023-07-14 06:27:38 UTC Comment hidden (obsolete)
Comment 9 Marcel de Rooy 2023-07-20 11:52:55 UTC
Created attachment 153718 [details] [review]
Bug 33379: (QA follow-up) Tidy dbrev

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Comment 10 Marcel de Rooy 2023-07-20 11:53:42 UTC
 OK     Koha/Schema/Result/Virtualshelfcontent.pm
   OK     critic
   OK     forbidden patterns
   OK     git manipulation
   OK     pod
   OK     pod coverage
   SKIP   spelling
   OK     tidiness
   OK     valid

 OK     installer/data/mysql/atomicupdate/bug33379.pl
   OK     critic
   OK     forbidden patterns
   OK     git manipulation
   OK     pod
   SKIP   spelling
   OK     tidiness
   OK     valid

 OK     installer/data/mysql/kohastructure.sql
   OK     boolean_vs_tinyint
   OK     charset_collate
   OK     git manipulation
   OK     tinyint_has_boolean_flag
Comment 11 Tomás Cohen Arazi (tcohen) 2023-07-20 16:03:33 UTC
Pushed to master for 23.11.

Nice work everyone, thanks!
Comment 12 Fridolin Somers 2023-08-04 01:52:02 UTC
Enhancement not pushed to 23.05.x