[SailfishDevel] Deploy QSQLite database

[Saija Saarenpää]

Hi,

What comes to having datalocation path variable in the .pro file:
I was having similar thoughts when I wanted to install something in the writable storage location, but I was corrected. Nothing should be installed in the home directory with the application, but under application directory /usr/share/harbour-yourappname/. There can be also subdirs under that location. Then, at runtime, you can create the writable storage location if it does not exist, and copy or create stuff there. Preferably the app would not pre-install any data, but everything would be downloaded / created runtime. That would be the ideal though, not always applicable.

- Saija
@setelani
matrixx #sailfishOS

Lähetetty iPadista

> "Andrey Kozhevnikov" <coderusinbox at gmail.com> kirjoitti 18.6.2014 kello 8.50:
> 
> 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
> 
> _______________________________________________
> 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/d02d7023/attachment.html>
-------------- next part --------------
_______________________________________________
SailfishOS.org Devel mailing list
To unsubscribe, please send a mail to devel-unsubscribe at lists.sailfishos.org