Possible to get tags from the calibre database?

GRiker · 05-04-2009, 12:08 PM

Is there a command line interface available to interrogate the calibre database for a list of the tags currently assigned to books in the database?

for example:

calibredb -getTags

might return

fiction
nonfiction
favorite

etc.

Thanks.

G

kovidgoyal · 05-04-2009, 12:43 PM

not directly but you can do

calibredb list --fields tags

and then parse the output in a script

GRiker · 05-04-2009, 01:12 PM

Excellent, thanks!!

G

itimpi · 05-04-2009, 01:32 PM

Is there any reason you need it from the command line? If not you could use a tool (eg sqliteman on Windows) that can access a sqlite database to look directly at the tags table in the calibre database.

GRiker · 05-04-2009, 02:30 PM

I'm writing a script to add books to the database, and I want to present a list of existing tags to choose from, or optionally add a new one. Using the CLI seems nimbler than using sql.

G

05-04-2009, 12:08 PM	#1
GRiker Comparer of the Ephemeris Posts: 1,496 Karma: 424697 Join Date: Mar 2009 Device: iPad	Possible to get tags from the calibre database? Is there a command line interface available to interrogate the calibre database for a list of the tags currently assigned to books in the database? for example: calibredb -getTags might return fiction nonfiction favorite etc. Thanks. G

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre and Kobo database	crowez	Calibre	1	10-15-2010 08:24 PM
Calibre Database Creation	RockstarPenguin	Calibre	0	07-08-2010 12:17 PM
Calibre 7.7 cant open database	Patricia1066	Calibre	17	07-05-2010 10:23 AM
Using SQL against Calibre database	jjansen	Calibre	3	03-29-2010 10:14 AM
Reference Database in Calibre?	nnxbtz	Calibre	5	09-27-2009 06:16 PM

05-04-2009, 12:43 PM	#2
kovidgoyal creator of calibre Posts: 45,210 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	not directly but you can do calibredb list --fields tags and then parse the output in a script

05-04-2009, 01:12 PM	#3
GRiker Comparer of the Ephemeris Posts: 1,496 Karma: 424697 Join Date: Mar 2009 Device: iPad	Excellent, thanks!! G

05-04-2009, 01:32 PM	#4
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	Is there any reason you need it from the command line? If not you could use a tool (eg sqliteman on Windows) that can access a sqlite database to look directly at the tags table in the calibre database.

05-04-2009, 02:30 PM	#5
GRiker Comparer of the Ephemeris Posts: 1,496 Karma: 424697 Join Date: Mar 2009 Device: iPad	I'm writing a script to add books to the database, and I want to present a list of existing tags to choose from, or optionally add a new one. Using the CLI seems nimbler than using sql. G

Advert

Advert