[SailfishDevel] Deploy QSQLite database

Andrey Kozhevnikov coderusinbox at gmail.com
Wed Jun 18 05:50:08 UTC 2014


you should build and deploy as RPM package ;)

18.06.2014 03:42, Lukas Vogel ?????:
> Hi there,
>
> I try to create an app in which I want to have an existing database 
> bind in the binary.
>
> My approach was the following:
> in pro file:
> QT+=sql
> database.files  =  stations.db
> database.path  =  /home/nemo/.local/share/harbour-qtimetable/harbour-qtimetable
>
> INSTALLS += database
> To open the database:
> db = QSqlDatabase::addDatabase("QSQLITE");
> db.setDatabaseName(DB_NAME);
> db.setUserName(USER_NAME);
> db.setPassword(PASSWORD);
> db.setConnectOptions("QSQLITE_OPEN_READONLY=1");
> if(db.open()) {...}
> for DB_NAME I use QStandardPaths::writableLocation(QStandardPaths::DataLocation) with stations.db appended.
> However when I deploy this will fail as the path on emulator has
>
> home/deploy/installroot/ prefix, and when deploying on device there is /opt/sdk/..
> prefix.
> This makes testing quite annoying, is there a genuine way to get the database to open both in the emulator and the device?
> Side question is there a "standard path::datalocation" variable for the .pro file?
> Thanks for any help,
> Lukas
>
>
> _______________________________________________
> SailfishOS.org Devel mailing list
> To unsubscribe, please send a mail to devel-unsubscribe at lists.sailfishos.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.sailfishos.org/pipermail/devel/attachments/20140618/1ce8fb38/attachment-0001.html>


More information about the Devel mailing list