How do I deploy an existing sqlite database with my qt application on Symbian device?

[hungchuviet]

I have one SQLite database, I want to deploy it with my App on symbina device.
But I don't know how to do?
Help me!

[alexander]

Try this in the .pro file:
@sqfiles.sources = file with sqlite
DEPLOYMENT += sqfiles@

[kalle]

An SQLite database is just one single file that needs to be installed on the device. If you are using QMake, use the DEPLOYMENT variable to do that.

[kalle]

Alexander beat me there while I was typing :-)

[alexander]

kalle :)

[remy_david]

Hello,

This solution works as long as you deploy to C:\ drive on Symbian.
But when deploying on E:\ (aka mass storage), this won't work :

.pro
@sqldeployment.sources = db.sqlite
sqldeployment.path = .
DEPLOYMENT += sqldeployment@

.cpp
@QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("db.sqlite");@

The file db.sqlite exists in E:\Private\appID\ folder but do not get loaded by QSqlDatabase
With C:\Private\appID\ it works fine.

Any clue ?

[remy_david]

Ok I found a solution :

@
QString apppath = QApplication::applicationDirPath();
QString dbpath(apppath);
dbpath.append(QDir::separator()).append("db.sqlite");
dbpath = QDir::toNativeSeparators(dbpath);
db.setDatabaseName(dbpath);
@

This way it works both with C:\ and E:\ deployment.
I can't see why the other way did not work however.

[francomartins]

@
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(qApp->applicationDirPath()+"/"db.sqlite");
@

for windows users use on main.cpp for define a librarypath :
@
#ifdef Q_OS_WIN32
QString env = getenv("SYSTEMROOT");
QCoreApplication::addLibraryPath(env+"\system32");
#endif
@