Column propagation to other rows?

jindroush · 11-17-2014, 05:22 PM

Hi,

I have customn column read:yes/no, where I manually track if I read some book.

I'd like to create virtual library which would consist only of authors with books I haven't read yet, but I read at least one of their books.

I thought I could do that by some kind of custom column which would be set to true if there is any book by the same author marked as read:yes.

Is this possible?

Thanks,
J.

eschwartz · 11-17-2014, 06:18 PM

No, the calibre search function is limited to the book record it tries to match.

Similar concepts have been achieved, however, using custom python scripts that search the database, iterate over the authors of all books matching a search, iterating over all books matching the authors, and editing a custom column for all those books.

jindroush · 11-17-2014, 06:24 PM

So you basically mean a script, run periodically (or on demand) which would set yes/no column readThisCauseYourReadThat and then creating the Virtual Library?

If so, could you point me to some examples? I don't speak python but I think I can hack something existing...

eschwartz · 11-17-2014, 06:26 PM

I am not sure where they are, I know @chaley has posted some.

You would run them via calibre-debug /path/to/scrupt.py

eschwartz · 11-17-2014, 06:33 PM

Here is one: https://www.mobileread.com/forums/showthread.php?p=2916772

11-17-2014, 05:22 PM	#1
jindroush Connoisseur Posts: 94 Karma: 104 Join Date: Nov 2014 Device: Kindle	Column propagation to other rows? Hi, I have customn column read:yes/no, where I manually track if I read some book. I'd like to create virtual library which would consist only of authors with books I haven't read yet, but I read at least one of their books. I thought I could do that by some kind of custom column which would be set to true if there is any book by the same author marked as read:yes. Is this possible? Thanks, J.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre library rows too big	savagekevin	Calibre	3	10-18-2014 06:59 AM
Selecting multiple rows in Calibre	amyk0202	Calibre	5	09-11-2014 10:50 AM
Multiple table rows for book in custom_column_x	Man Eating Duck	Development	4	03-14-2014 07:46 AM
iBooks: Avoid page breaks within table rows/cells	ckirchho	ePub	7	06-12-2012 03:11 PM
Feature Request: highlight rows affected by news downloads or jobs	spkmn	Calibre	0	01-02-2011 06:09 AM

11-17-2014, 06:18 PM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	No, the calibre search function is limited to the book record it tries to match. Similar concepts have been achieved, however, using custom python scripts that search the database, iterate over the authors of all books matching a search, iterating over all books matching the authors, and editing a custom column for all those books.

11-17-2014, 06:24 PM	#3
jindroush Connoisseur Posts: 94 Karma: 104 Join Date: Nov 2014 Device: Kindle	So you basically mean a script, run periodically (or on demand) which would set yes/no column readThisCauseYourReadThat and then creating the Virtual Library? If so, could you point me to some examples? I don't speak python but I think I can hack something existing...

11-17-2014, 06:26 PM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	I am not sure where they are, I know @chaley has posted some. You would run them via calibre-debug /path/to/scrupt.py

11-17-2014, 06:33 PM	#5
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Here is one: https://www.mobileread.com/forums/showthread.php?p=2916772

Advert

Advert