09-25-2010, 07:28 PM | #1 |
Junior Member
Posts: 9
Karma: 10
Join Date: Sep 2010
Device: ipad
|
uuid isnull
What is the purpose of uuid? It seems to be null in the books table on importing books. Is it supposed to be null in the first place?
I'm using mekk calibre guess isbn code and is facing problems as the uuid isnull. I would need to modify the sqlitedb manually to put in a random uuid. |
09-25-2010, 07:29 PM | #2 |
creator of calibre
Posts: 43,912
Karma: 22669818
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
A uuid is an the name implies a Universally Unique Identifier. calibre uses uuids of type 4 to identify books unambiguously across multiple libraries.
|
Advert | |
|
09-25-2010, 08:25 PM | #3 |
Junior Member
Posts: 9
Karma: 10
Join Date: Sep 2010
Device: ipad
|
Any reason why that might be null on import? Or what might cause them to be null?
|
09-25-2010, 08:32 PM | #4 |
creator of calibre
Posts: 43,912
Karma: 22669818
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
not that i know of
|
09-26-2010, 04:17 AM | #5 | |
Grand Sorcerer
Posts: 11,755
Karma: 7029857
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
When a book entry is created, a trigger is run that does stuff. One thing it does is call a python-supplied function to set the UUID. That function will not be there, so the trigger is presumably removed. Fix the script to run in python using calibre's debug facility, 'calibre-debug -e'. Otherwise you are likely to never get things right. And sorry, but I am not interested in helping get this right. I don't care in the least about ISBNs. |
|
Advert | |
|
09-26-2010, 09:02 AM | #6 |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
I've only successfully done it once, and that was before more changes and triggers were added. I'd go farther than Charles and say that even experts should not try this. Reading the database is OK, but changing it isn't. You have to have a detailed knowledge of how Calibre works to safely make direct SQL changes. By the time an expert knows enough to do it safely, they'll see it's easier to do it inside Calibre, with Calibre's existing tools, than to do it in SQL.
|
09-26-2010, 12:12 PM | #7 |
Junior Member
Posts: 9
Karma: 10
Join Date: Sep 2010
Device: ipad
|
i think it was due to my sql "import" of another database that has caused it too go all bonkers. There were Drop and Create tables in there, thus destroying the triggers.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
urn:uuid in Adept epubs? | NookyBook | ePub | 2 | 05-18-2010 01:05 PM |