On 2017-01-17 02:59 PM, Tobias Ellinghaus wrote:
Am Dienstag, 17. Januar 2017, 12:20:52 CET schrieb I. Ivanov:
[...]
bojo@cheetah:~$ echo "select max(id) from images" | sqlite3
~/.config/darktable/library.db
Error: incomplete SQL: select max(id) from images
Not sure why sqlite doesn't like the query, let's try it like this (and make
sure it's all in a single line when pasting to the shell):
echo "select id from images order by id desc limit 1" | sqlite3 ~/.config/
darktable/library.db
Here it is (I had to put ; after 1)
bojo@cheetah:~$ echo "select id from images order by id desc limit 1;"
| sqlite3 ~/.config/darktable/library.db
91689
Also redid the first statement (again added ;)
bojo@cheetah:~$ echo "select max(id) from images;" | sqlite3
~/.config/darktable/library.db
91689
bojo@cheetah:~$ cd ~/.cache/darktable/mipmaps-`echo -n
$HOME/.config/darktable/library.db |
> sha1sum | cut -f1 -d ' '`.d
bojo@cheetah:~/.cache/darktable/mipmaps-c98cb315109ad10973463fc5119a5bb09089cf2b.d$
for i in *; do echo -n "$i: "; ls $i/|sort -n | tail -1; done
0: 91689.jpg
1: 91557.jpg
2: 81394.jpg
3: 91640.jpg
4: 91610.jpg
bojo@cheetah:~/.cache/darktable/mipmaps-c98cb315109ad10973463fc5119a5bb09089cf2b.d$
Tobias
[...]
Bojidar
____________________________________________________________________________
darktable user mailing list
to unsubscribe send a mail to [email protected]
