MobileRead Forums - View Single Post - Plugin to trasform database to upper case

JimmXinu · 10-21-2012, 04:59 PM

In addition to mi.title and mi.authors, try doing the upper steps on mi.title_sort and mi.author_sort? That might do it.

As for authors with more than one book, there's also some author metadata kept outside the books. You might something like this in addition to (or instead of) setting the authors on each book's mi object.

Code:

autid=db.get_author_id(authorname)
db.rename_author(autid, authorname.upper())

10-21-2012, 04:59 PM	#14
JimmXinu Plugin Developer Posts: 6,320 Karma: 3966249 Join Date: Dec 2011 Location: Midwest USA Device: Kindle Paperwhite(10th)	In addition to mi.title and mi.authors, try doing the upper steps on mi.title_sort and mi.author_sort? That might do it. As for authors with more than one book, there's also some author metadata kept outside the books. You might something like this in addition to (or instead of) setting the authors on each book's mi object. Code: autid=db.get_author_id(authorname) db.rename_author(autid, authorname.upper())