[Digikam-devel] db upgrade verification

[Laurent Rathle]

Le Mardi 7 Juin 2005 00:54, Renchi Raju a écrit :
> the test has been updated to bail out if there is no digikam.db in the
> library path and correctly handle the extra / at the end if present.
>
> please download and check again.

After renaming digikam-testing.db to digikam.db and upgraded dbupgrade_check :

dbupgrade_check]$ ./dbupgrade_check /home/lolo/Documents/AlbumsPhotos/
Creating temporary database in memory
Checking upgrading database to sqlite3
sqlite_compile error: near "andouille": syntax error on query: SELECT id FROM 
Images WHERE dirid=2 AND name='ariane fait encore l'andouille.JPG'
sqlite_compile error: near "andouille": syntax error on query: SELECT id FROM 
Images WHERE dirid=2 AND name='ariane fait l'andouille.JPG'
sqlite_compile error: near "obéit": syntax error on query: SELECT id FROM 
Images WHERE dirid=2 AND name='ariane m'obéit.JPG'
sqlite_compile error: near "exposant": syntax error on query: SELECT id FROM 
Images WHERE dirid=37 AND name='une maman d'exposant, ch'ais plus qui.jpg'
Successfully upgraded database to sqlite3
Checking database consistency
Checking Albums..................(57 Albums) OK
Checking Tags....................(4 Tags) OK
Checking Images..................(2375 Images) OK
Checking ImageTags...............(5 ImageTags) OK
Checking Album icons ...............(57 Album Icons) OK
Checking Tag icons ...............(4 Tag Icons) OK

All Tests: A-OK