View Single Post
Old 01-14-2019, 10:25 AM   #37
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Miscellaneous

compurandom:

Quote:
Rather than hunting through my library for extra long authors or tags, can you put a limit on the width of the pulldown or something?
Since you wrote a plugin, I assume you can use SQLite to do this type of thing for any textual column you wish to shorten if it is too long:

Code:
[Not Tested due to Trigger] UPDATE books SET title = (REPLACE(title,(SUBSTR(title,115)),''))
WHERE LENGTH(title) > 115;
Afterwards, run a TRIM on the same column to remove any trailing spaces.

Since the SQLite tool that you would be using has no active user-defined function called 'title_sort' that Calibre creates whenever it runs, you will have to temporarily copy the Triggers for the table (books in the example above) to a text file, drop the Triggers, run your queries, then add the Triggers back to what they were using the copy you made. I did not want to go to the effort to do that just to be able to test the example query shown above.


Quote:
Can I have a plugin that converts .ui files (with tooltips) into an epub? :->
Requests for new plugins go in the "Plugin Ideas....add yours here" thread so that all interested persons can see them. Note that .ui files are only created by Qt 'Creator', which I have never used. I hand-code my Qt.



DaltonST
DaltonST is offline   Reply With Quote