Quote:
Originally Posted by kovidgoyal
Not unless you're willing to a write python code
|
Nah. The very idea makes the hairs on my neck stand on end
I already have to cope with C++, Java, and Perl on a daily basis.
I was wondering whether the metadata.db could be edited offline without breaking the program? But I'm afraid I could not make sense of your database schema...
I note that the `authors' table has a `sort' text column, but it doesn't seem to have anything in it -- at least in my setup. But the `books' table has an `author_sort' column, which does appear to be populated, and with the same text as appears in the GUI.
So I had rather hoped to be able to set all the author_sort fields to the author name by doing something like:
> update books set author_sort=(select authors.name from authors,books_authors_link where books_authors_link.book=books.id and books_authors_link.author=authors.id);
But it seems that this invokes triggers which use functions which are implemented somewhere other than in the database (in Python? C?) Anyway, it doesn't work.
It would have been nice to manipulate the database directly, but if it isn't possible, then it isn't possible :/