Am Donnerstag, 8. September 2016, 14:40:16 CEST schrieb Chris Walker: > Can anybody point me in the direction of some C++ code to connect to > two SQL databases please?
Does it have to be pure C++ code? If not and if it can be the Qt way, read on.
:)
> I want to have one set as read-only and the other as read-write.
>
> Whatever I'm doing is wrong as I always end up with a default
> connection.
Have a look at QSqlDatabase and it's addDatabase() method. [1]
Example for two SQLite databases:
You have to set a connection name for each database.
> QSqlDatabase rodb = QSqlDatabase::addDatabase(QStringLiteral("QSQLITE"),
QStringLiteral("rodb"));
> rodb.setConnectOptions(QStringLiteral("QSQLITE_OPEN_READONLY");
> rodb.setDatabaseName(QStringLiteral("/full/path/to/ro_database.sqlite"));
>
> if (rodb.open()) {
> QSqlQuery qro(rodb);
> .....
> }
>
> QSqlDatabase rwdb = QSqlDatabase::addDatabase(QStringLiteral("QSQLITE"),
QStringLiteral("rwdb"));
> rwdb.setDatabaseName(QStringLiteral("/full/path/to/rw_database.sqlite"));
> if (rwdb.open()) {
> QSqlQuery qrw(rwdb);
> .....
> }
Later on you can refer everywhere in your application to the databases by
using the connection names (rodb and rwdb):
> QSqlDatabase rodb = QSqlDatabase::database(QStringLiteral("rodb"));
> QSqlQuery q(rodb);
> ....
Best greetings
Matthias
[1] http://doc.qt.io/qt-5/qsqldatabase.html#addDatabase
--
Das Gesetz hat zum Schneckengang verdorben, was Adlerflug geworden wäre.
(Friedrich Schiller - Die Räuber)
Und der Buschfunk spielt gerade "Pikse Palve" von "In Extremo".
www.buschmann23.de
GPG-Key: 3A70A936614C3258
GPG Fingerprint: D786 DDF8 4CA9 00BC CDE0 9A5F CCC5 125D 6E87 D4FC
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ SailfishOS.org Devel mailing list To unsubscribe, please send a mail to devel-unsubscr...@lists.sailfishos.org
