SQLITE with QT Application...

[dcbasso]

1. How to add SQLITE suporte to my application?
2. I will need to compile the SQLITE driver?
3. Have any step-by-step example?

Thanks everyone.

[dmcr]

http://doc.qt.nokia.com/4.7-snapshot/sql-driver.html#qmysql

[Skyrim]

Hi
do not have to compile the SQLite driver.

simple example:

in *.pro file add line
@
QT += sql
@
and
@
#include <QtSql/QtSql>
QSqlDatabase db;
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("fileName.db3");
db.open();
// db.close(); // for close connection
@

more, depending on the task.

[dcbasso]

Thanks!

Skyrim, where you find this example?

[dcbasso]

Another question...
I'm trying to open my generated database with some tables on SQLITEMAN and the SQLITEMAN does not show any table on the file...
I have used sqlite on android apps and I could open the SQLITE FILES on SQLITEMAN withtout any problems....

It's a problem, it could not be done... anyone with the same "problem"?
thanks

[franku]

• different sqlite versions?
• did you at least generate any table in the database (qsqlquery, qsqltablemodel, ...)?

;-) .. frank

[dcbasso]

Could be the version, I read something that says Sqliteman just open sqlite3 files...

I make this code, case study code?

@
#include "banco.h"
#include "QtSql/QtSql"
#include "QDebug"

Banco::Banco(QObject *parent) :
QObject(parent)
{
QSqlDatabase db;
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName( QDir::homePath() + QDir::separator() + "inoveDB.db3");
if (db.open()) {
QSqlQuery query(db);
if (query.exec("CREATE TABLE usuario ( INTEGER oid PRIMARY KEY);")) {
qDebug() << "criado tabela com sucesso.";
} else {
qDebug() << "erro ao criar tabela." << query.lastError();
}
} else {
qDebug() << "DB Nao aberto.";
}
db.close();
@

• brazillian portuguese debug messages.

If I run this code twice, I got error saying that already exists the table "usuario".

[franku]

Hmm, code looks quite good. Have you tried the Firefox Plugin "SQLite Manager"? Sqlite3 is Qt-default as far as I know.

[dcbasso]

I read the documentation, and the Qt uses Sqlite2 only if you include the sqlite2, by default really appers to be sqlite3.
I will try try Sqlite Manager.

[dcbasso]

With Firefox Plugin show my "usuario" table! So my code works!
Another detail: Sqliteman uses QT!

[pemoamsi]

Can someone give me and example or complete code of an app with sqlite please?

[SGaist]

Hi and welcome to devnet,

Please don't revive old thread with new questions, open your own.

As for your question, have a look at the "Sql Example in Qt's documentation":http://qt-project.org/doc/qt-4.8/examples-sql.html

[drsasa]

Its working. Just SQL part you using will generate error second time becouse table already exists. You could replace with CREATE TABLE IF NOT EXISTS ....

[quote author="dcbasso" date="1341519956"]Could be the version, I read something that says Sqliteman just open sqlite3 files...

I make this code, case study code?

@
#include "banco.h"
#include "QtSql/QtSql"
#include "QDebug"

Banco::Banco(QObject *parent) :
QObject(parent)
{
QSqlDatabase db;
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName( QDir::homePath() + QDir::separator() + "inoveDB.db3");
if (db.open()) {
QSqlQuery query(db);
if (query.exec("CREATE TABLE usuario ( INTEGER oid PRIMARY KEY);")) {
qDebug() << "criado tabela com sucesso.";
} else {
qDebug() << "erro ao criar tabela." << query.lastError();
}
} else {
qDebug() << "DB Nao aberto.";
}
db.close();
@

• brazillian portuguese debug messages.

If I run this code twice, I got error saying that already exists the table "usuario".[/quote]