ComicBookLover Technical stuff

[BigBamBoo]

My curent purpose is relative to files management into big CBL databases.

I've recently installed a new RAID set with new harddrives, and I had to move all my CBL library.
I was limited by implementation of the source file path into field ZUUID of table ZBINARYBLOB : when the comic file is moved, the ZBINARYBLOB needs to be changed.

But how to change it in an automatic way?

This would need to understand the ZUUID implementation...


Comic Book Lover Database Model (database can be browsed with sqlite3)

Table : ZCOMICBOOK
01 ZLANGUAGE 06 ZSERIES 11 ZSTATUS 16 ZVOLUME 21 ZDATEPUBLISHED 26 ZISSUELABEL
02 Z_PK 07 ZPRIMARYWRITER 12 ZRATING 17 ZARCHIVETYPE 22 ZDATEADDED
03 Z_OPT 08 ZGENRE 13 ZISSUEOF 18 ZDOCINFO 23 ZLASTREADINGDATE
04 ZCOVERTHUMBNAIL 09 Z_ENT 14 ZVOLUMEOF 19 ZPRIMARYARTIST 24 ZCOMMENTS
05 ZPUBLISHER 10 ZARCHIVESZE 15 ZREADINGCOUNT 20 ZCOUNTRY 25 ZTITLE
Sample :
01 |02 | |04 ||||08| |10 | | ||| || |18 |19 |20 ||22 |||25 |26
2437|290|3|289||||15|3|2022620|0|0|||0||3|289|384|2499||240614636.471967|||Parfum de jouissance|


Table : ZBINARYBLOB
01 Z_ENT 03 Z_OPT 05 ZUUID
02 Z_PK 04 ZOWNER
Sample :
|02 | |04 |05
1|290|1|289|13EC93CD-6960-4A25-A0DE-F0D817EDD1F8


Table : ZCOMICDOCINFO
01 ZOWNER ZPAGEMODE ZCIBRIGHTNESS ZROTATIONANGLE ZBDALIASDATA
Z_PK ZOPENTHUMBNAILSDRAWERZCISHARPNESS ZWINDOWFRAME ZBACKGROUNDCOLOR
Z_OPT Z_ENT ZSCALEFACTOR ZCIWHITEPOINTCOLOR ZSCALEMODE
ZLASTPAGEPOSITION ZCICONTRAST ZCISATURATION ZCIBLACKPOINTCOLOR
Sample :
01 |02 | | | | | | |09 |10 |11 |12 |13 |14 ||||16
289|290|1|1|2|0|1|4|1.0|0.0|0.0|1.0|1.0|0.0||||