SOLVED Qt 5.1 ios How to Bundle and use SQLite database in application

jraichouni

Here is an example:
@

sqlite_on_ios.pro

TEMPLATE = app
QT += qml quick
QTPLUGIN += qsqlite
QMAKE_INFO_PLIST += Info.plist
SOURCES += main.cpp
RESOURCES += main.qrc
cache()
@
@

<RCC><qresource prefix="/"> <file>main.qml</file> </qresource></RCC>
@
@
// main.qml
import QtQuick 2.0
Rectangle { id: page; width: 640; height: 1136; color: "red" }
@
@
// main.cpp
#include <QGuiApplication>
#include <QQuickView>
#include <QString>
#if defined(Q_OS_IOS)
#include <QtPlugin>
Q_IMPORT_PLUGIN(qsqlite)
#include <QSqlDatabase>
#endif
int main(int argc, char *argv[]) {
QGuiApplication *app = new QGuiApplication(argc, argv);
// QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", "xa_db");
QQuickView *view = new QQuickView;
view->setSource(QUrl("qrc:///main.qml"));
view->setResizeMode(QQuickView::SizeRootObjectToView);
view->show();
return app->exec();
}
@
@

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>CFBundleName</key>
<string>sqlite_on_ios</string>
<key>CFBundleExecutable</key>
<string>sqlite_on_ios</string>
<key>CFBundleIconFile</key>
<string>sqlite_on_ios</string>
<key>CFBundlePackageType</key>
<string>APPL</string>
<key>CFBundleShortVersionString</key>
<string>1.0.0</string>
<key>CFBundleVersion</key>
<string>1.0.0</string>
<key>CFBundleIdentifier</key>
<string>www.sqlite_on_ios.com</string>
</dict>
</plist>
@

Xcode build results in the following error:
@
main.cpp:8:14: fatal error: 'QSqlDatabase' file not found
#include <QSqlDatabase>
^
1 error generated.
@

The minitool builds/ runs in iOS Simulator if I comment lines 5-9 of main.cpp.

What is needed in addition to use sqlite on iOS?

Would be really great to get a hint! :-)

Viele Grüße aktuell aus Berlin ;-)
jraichouni

SGaist

You are missing

@QT += sql@

in your pro file

jraichouni

Alright, missed that and now the same error appears as I got it in my original project yesterday.

Xcode says:
@
Undefined symbols for architecture i386:
"qt_static_plugin_qsqlite()", referenced from:
StaticqsqlitePluginInstance::StaticqsqlitePluginInstance() in main.o
ld: symbol(s) not found for architecture i386
clang: error: linker command failed with exit code 1 (use -v to see invocation)
@
Does anything from my Qt (iOS) Installation (e.g. from plugin sqldrivers) need to be copied/ deployed into the build for iOS Simulator?

Or do I need to specify the -spec argument within the call of qmake because of that architecture error above?

syfy323

@ QStringList paths = QStandardPaths::standardLocations(QStandardPaths::DataLocation);
QString dbFile = paths.first().append("/datastore.db");

QSqlDatabase *database = new QSqlDatabase(QSqlDatabase::addDatabase("QSQLITE"));
database->setDatabaseName( dbFile );@

Add this to your .pro:
QT += sql
QTPLUGIN += qsqlite

As explained here (inclusing your cross post):
http://qt-project.org/forums/viewthread/36600/#156960
... (by SGaist) using a pointer is not necessary.

jraichouni

Tried it, and Xcode fails with below error. Did you try to build it for iOS Simulator?
@
Undefined symbols for architecture i386:
"qt_static_plugin_qsqlite()", referenced from:
StaticqsqlitePluginInstance::StaticqsqlitePluginInstance() in main.o
ld: symbol(s) not found for architecture i386
clang: error: linker command failed with exit code 1 (use -v to see invocation)
@
Used as you proposed:
@

sqlite_on_ios.pro

TEMPLATE = app
QT += qml quick sql
QTPLUGIN += qsqlite
QMAKE_INFO_PLIST += Info.plist
SOURCES += main.cpp
RESOURCES += main.qrc
cache()
@

My main.cpp:
@
// main.cpp
#include <QGuiApplication>
#include <QQuickView>
#include <QString>
#include <QtPlugin>

Q_IMPORT_PLUGIN(qsqlite)
#include <QSqlDatabase>

int main(int argc, char *argv[]) {
QGuiApplication *app = new QGuiApplication(argc, argv);
// QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", "xa_db");
QQuickView *view = new QQuickView;
view->setSource(QUrl("qrc:///main.qml"));
view->setResizeMode(QQuickView::SizeRootObjectToView);
view->show();
return app->exec();
}
@

syfy323

I am using a recent version of Qt 5.2.0-dev snapshot (in the title you are writing you are using 5.1).
For iOS development you should stick to 5.2.0 instead of < 5.2.0.

edit: yes, I did - works for Mac, iOS Sim and on my iPhone.

jraichouni

I am using "Qt 5.2.0 (official release)":http://download.qt-project.org/official_releases/qt/5.2/5.2.0/qt-mac-opensource-5.2.0-ios-x86_64-offline.dmg

I did not create the thread.

A very short but complete mini project .pro file & main.cpp would help.

I mean an example, which runs at your computer. I would launch qmake only to get the .xcodeproject directory to test that.

syfy323

[quote author="jraichouni" date="1389032658"]I am using "Qt 5.2.0 (official release)":http://download.qt-project.org/official_releases/qt/5.2/5.2.0/qt-mac-opensource-5.2.0-ios-x86_64-offline.dmg

I did not create the thread.[/quote]

Oh, sorry.

drop this from your file:
Q_IMPORT_PLUGIN(qsqlite)

edit for your edit:

[quote author="jraichouni" date="1389032658"]
A very short but complete mini project .pro file & main.cpp would help.

I mean an example, which runs at your computer. I would launch qmake only to get the .xcodeproject directory to test that.[/quote]

I already did - the code above works as your main() content.

jraichouni

It runs!
I am a bit confused, as the "Plug & paint example":http://qt-project.org/doc/qt-4.8/tools-plugandpaint.html uses that macro.

But many thanks for your reply and help!!

Really interesting would be to be able to use the SQLite Function "load_extension" which is omitted in Standard Qt build.

syfy323

[quote author="jraichouni" date="1389033119"]It runs!
I am a bit confused, as the "Plug & paint example":http://qt-project.org/doc/qt-4.8/tools-plugandpaint.html uses that macro.

But many thanks for your reply and help!![/quote]

You're welcome.

mac131

"A very short but complete mini project .pro file & main.cpp would help.
I mean an example, which runs at your computer. I would launch qmake only to get the .xcodeproject directory to test that."

I just start to use QT 5.2 (with iOS even more) a mini exemple project with all files would be great

jraichouni

Hi!

Take the example in the current thread.

The important things to consider are:

.pro file:
@
QT += sql
ios:QTPLUGIN += qsqlite

deploy the database file via something like:

databases.files = ../../src/data/xp-apt.sqlite
ios: databases.path = Documents
macx: databases.path = Contents/Resources
QMAKE_BUNDLE_DATA += databases

note, that the path databases.files is relative to the cwd, in which

the process qmake runs

@

The class implementing the initialisation/ access to the db needs to do the following for instance:
@
#include <QtSql>
(...)

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", "some_name");
QSqlDatabase db = QSqlDatabase::database("some_name", false);
QString dbFilePath = "(...)";
db.setDatabaseName(dbFilePath);
db.open();
QSqlQuery *q = new QSqlQuery(db);
(...)
@

Hope that helps!

elliott0124

Hi!

I'm follow this example.
But It doesn't work for me.

In Desktop, iOS simulator mode is fine.
But it doesn't work with my iPad.

Thanks you if you can help me.

jraichouni

I currently work on my work environment and do also have no iPad (iPhone only) but it shall work as described in above posts.

elliott0124

Hi, Jamil

Thanks for your feedback.

Then I tried with my iPhone5s. And It just work, but my iPadRetina don't.
Post QT creator error log above:

This plugin does not support propagateSizeHints()
&
Failed to make complete framebuffer object 8cdd

Thanks again for your help.

elliott0124

[Solved]
Update to QT5.2.1, iPad just work fine.

Thanks you.

vtong

Hi,
Please help. I build my app for iPad, and using database Sqlite.
Can you explain the QString dbFilePath = "(...)"; why it is "(...)"
Thanks and regards

[quote author="Jamil Raichouni" date="1389206294"]Hi!

Take the example in the current thread.

The important things to consider are:

.pro file:
@
QT += sql
ios:QTPLUGIN += qsqlite

deploy the database file via something like:

databases.files = ../../src/data/xp-apt.sqlite
ios: databases.path = Documents
macx: databases.path = Contents/Resources
QMAKE_BUNDLE_DATA += databases

note, that the path databases.files is relative to the cwd, in which

the process qmake runs

@

The class implementing the initialisation/ access to the db needs to do the following for instance:
@
#include <QtSql>
(...)

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", "some_name");
QSqlDatabase db = QSqlDatabase::database("some_name", false);
QString dbFilePath = "(...)";
db.setDatabaseName(dbFilePath);
db.open();
QSqlQuery *q = new QSqlQuery(db);
(...)
@

Hope that helps![/quote]

SGaist

It's a placeholder text that you must replace with the path to your database file

vtong

Thanks SGaist,
It works now.

SherifOmran

hi every body,

i ve the same issue, should this mean that we don't need to use Q_IMPORT_PLUGIN(qsqlite);
any more for static compiling?