[Digikam-devel] branches/digikam/0.8-experimental/digikam (fwd)

[Gilles Caulier]

Le Lundi 06 Juin 2005 09:37 AM, Renchi Raju a écrit :
> forgot to CC the list
>
> ---------- Forwarded message ----------
> Date: Mon, 06 Jun 2005 07:25:11 +0000
> From: Renchi Raju <renchi at pooh.tam.uiuc.edu>
> Reply-To: kde-commits at kde.org
> To: kde-commits at kde.org
> Subject: branches/digikam/0.8-experimental/digikam
>
> SVN commit 422695 by pahlibar:
>
> upgrade to sqlite3:
>   * upgrade old digikam.db (sqlite2) to digikam3.db (sqlite3.db)
>   * port kioslaves/albumdb to use sqlite3
>   * update to new schema (see discussion on digikam-devel)
>   * each image item has a unique long ID. make use of it to
>     access/modify captions/tags and other metadata faster
>     (this also mean you can have only 9223372036854775808
>      photos listed in the db :) )
>
>
>   _M            branches/digikam/0.8-experimental/digikam (directory)
>   M  +11 -0     configure.in.bot
>   M  +20 -2     configure.in.in
>   M  +4 -3      digikam/Makefile.am
>   M  +16 -17    digikam/album.cpp
>   M  +349 -237  digikam/albumdb.cpp
>   M  +67 -40    digikam/albumdb.h
>   A             digikam/albumdb_sqlite2.cpp   [License: GPL]
>   A             digikam/albumdb_sqlite2.h   [License: GPL]
>   M  +4 -3      digikam/albuminfo.h
>   M  +19 -17    digikam/albumlister.cpp
>   M  +13 -4     digikam/albummanager.cpp
>   M  +17 -13    digikam/imageinfo.cpp
>   M  +9 -2      digikam/imageinfo.h
>   M  +6 -44     digikam/main.cpp
>   M  +13 -14    digikam/scanlib.cpp
>   M  +5 -11     digikam/tagspopupmenu.cpp
>   A             digikam/upgradedb_sqlite2tosqlite3.cpp   [License: GPL]
>   A             digikam/upgradedb_sqlite2tosqlite3.h   [License: GPL]
>   M  +10 -10    kioslave/Makefile.am
>   M  +185 -298  kioslave/digikamalbums.cpp
>   M  +4 -10     kioslave/digikamalbums.h
>   M  +79 -174   kioslave/digikamdates.cpp
>   M  +4 -9      kioslave/digikamdates.h
>   M  +32 -136   kioslave/digikamsearch.cpp
>   M  +7 -12     kioslave/digikamsearch.h
>   M  +41 -191   kioslave/digikamtags.cpp
>   M  +8 -15     kioslave/digikamtags.h
>   A             kioslave/sqlitedb.cpp   [License: GPL]
>   A             kioslave/sqlitedb.h   [License: GPL]
>
>

albumdb.cpp:38:21: sqlite3.h: No such file or directory
albumdb.cpp: In destructor `AlbumDB::~AlbumDB()':
albumdb.cpp:59: error: `sqlite3_close' undeclared (first use this function)
albumdb.cpp:59: error: (Each undeclared identifier is reported only once for 
each function it appears in.)
albumdb.cpp: In member function `void AlbumDB::setDBPath(const QString&)':
albumdb.cpp:66: error: `sqlite3_close' undeclared (first use this function)
albumdb.cpp:72: error: `sqlite3_open' undeclared (first use this function)
albumdb.cpp:76: error: `sqlite3_errmsg' undeclared (first use this function)
albumdb.cpp: In member function `int AlbumDB::addAlbum(const QString&, const 
QString&, const QDate&, const QString&)':
albumdb.cpp:362: error: `sqlite3_last_insert_rowid' undeclared (first use this 
function)
albumdb.cpp: In member function `int AlbumDB::addTag(int, const QString&, long 
int)':
albumdb.cpp:414: error: `sqlite3_last_insert_rowid' undeclared (first use this 
function)
albumdb.cpp: In member function `bool AlbumDB::execSql(const QString&, 
QStringList*, bool)':
albumdb.cpp:478: error: `sqlite3_prepare' undeclared (first use this function)
albumdb.cpp:479: error: `SQLITE_OK' undeclared (first use this function)
albumdb.cpp:483: error: `sqlite3_errmsg' undeclared (first use this function)
albumdb.cpp:489: error: `sqlite3_column_count' undeclared (first use this 
function)
albumdb.cpp:493: error: `sqlite3_step' undeclared (first use this function)
albumdb.cpp:495: error: `SQLITE_DONE' undeclared (first use this function)
albumdb.cpp:495: error: `SQLITE_ERROR' undeclared (first use this function)
albumdb.cpp:501: error: `sqlite3_column_text' undeclared (first use this 
function)
albumdb.cpp:505: error: `sqlite3_finalize' undeclared (first use this 
function)
albumdb.cpp: In member function `int AlbumDB::getOrCreateAlbumId(const 
QString&)':
albumdb.cpp:766: error: `sqlite3_last_insert_rowid' undeclared (first use this 
function)
albumdb.cpp: In member function `long int AlbumDB::addItem(int, const 
QString&, const QDateTime&, const QString&)':
albumdb.cpp:786: error: `sqlite3_last_insert_rowid' undeclared (first use this 
function)
make[1]: *** [albumdb.lo] Erreur 1
make[1]: Leaving directory 
`/home/dcamir/Documents/Devel/SVN/branches/0.8-experimental/digikam/digikam'
make: *** [all-recursive] Erreur 1
[dcamir at cea-tir8 digikam]$                                         

We need to install external sqlite3 lib and headers now ? (:=)))...

Gilles