[QT4][SQLITE] Database and query

[agent007se]

Hello !

I'm trying to have a very little db. My knowledges in db are poor but I just want to know how can I set a minimal db i.e. :

MAIN_TREE
entry1
...(1->L)
entryL
    SUB_TREE1
        entry1
        ...(1->I)
        entryI
    SUB_TREE...(1->N)
        entry1
        ...(1->J)
        entryJ
    SUB_TREEN
        entry1
        ...(1->K)
        entryK

MAIN_TREE
entry1
...(1->L)
entryL
    SUB_TREE1
        entry1
        ...(1->I)
        entryI
    SUB_TREE...(1->N)
        entry1
        ...(1->J)
        entryJ
    SUB_TREEN
        entry1
        ...(1->K)
        entryK

To copy to clipboard, switch view to plain text mode 

The entries will just be a list of files (and their path).

I'm really noob because my very little code doesn't work :

.h file:

QSqlQuery *query;

QSqlQuery *query;

To copy to clipboard, switch view to plain text mode 

.cpp file:

[post edit :] query = new QSqlQuery(db);
bool tst = query->exec("CREATE TABLE person");

[post edit :] query = new QSqlQuery(db);
bool tst = query->exec("CREATE TABLE person");

To copy to clipboard, switch view to plain text mode 

=> lol. I have a segfault... edit : The segfault is gone but... there isn't any table in the file which is correctly created. The result of the query is "false". But I wonder why... it seems to be a basic query...

[dexjam]

May be you have a look at

http://doc.trolltech.com/4.1/examples.html#sql-examples
and
http://doc.trolltech.com/qq/qq15-models.html

there is some basic code, which shows you how to use sqlite

[agent007se]

This doesn't really help because I already read that (and more).

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(databaseFile->filePath());

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(databaseFile->filePath());

To copy to clipboard, switch view to plain text mode 

QSqlQuery query = new QSqlQuery(db);
QString createQuery = "CREATE TABLE test";
bool tst = query->exec(createQuery);
if(tst)
{
    // some code
}
else
{
    QMessageBox::critical(NULL, "", "Query \"" + createQuery + "\" not executed."); // IT ALWAYS COMES
}

QSqlQuery query = new QSqlQuery(db);
QString createQuery = "CREATE TABLE test";
bool tst = query->exec(createQuery);
if(tst)
{
    // some code
}
else
{
    QMessageBox::critical(NULL, "", "Query \"" + createQuery + "\" not executed."); // IT ALWAYS COMES
}

To copy to clipboard, switch view to plain text mode 

I'm trying hard but I'm doing something wrong...

[munna]

Is this code not giving you any error during compilation?

Try this

QSqlQuery query;
bool tst = query.exec("CREATE TABLE test(id INTEGER PRIMARY KEY,"
		"name TEXT");
if(tst)  {
          // some code
}  else  {
       QMessageBox::critical(NULL, "", "Query \"" + createQuery + "\" not executed."); 
}

QSqlQuery query;
bool tst = query.exec("CREATE TABLE test(id INTEGER PRIMARY KEY,"
		"name TEXT");
if(tst)  {
          // some code
}  else  {
       QMessageBox::critical(NULL, "", "Query \"" + createQuery + "\" not executed."); 
}

To copy to clipboard, switch view to plain text mode 

[agent007se]

I copy and paste your code and "tst" is still false (and the QMessageBox pops up).

There isn't any error or warning during compilation !

I begin to think that there is a problem with QSqlite but I think that it's an integrated db with Qt, isn't it ?

Do I have to install some specific programs ?

[munna]

I begin to think that there is a problem with QSqlite but I think that it's an integrated db with Qt, isn't it ?

Yes it is.

Do I have to install some specific programs ?

No you don't have to.

what is databaseFile->filePath()?

QSqlQuery query = new QSqlQuery(db);//This line should give error

QSqlQuery query = new QSqlQuery(db);//This line should give error

To copy to clipboard, switch view to plain text mode 

[agent007se]

what is databaseFile->filePath()?

Isn't enough to know that the connect() function return a true value ?

Anyway here's the code you asked:

in CDatabase.h:

private:
QFileInfo *databaseFile;

private:
QFileInfo *databaseFile;

To copy to clipboard, switch view to plain text mode 

in CDatabase.cpp:

// constructor
CDatabase::CDatabase(QString dbName)
{
    databaseFile = new QFileInfo(dbName);
    CDatabase::dbName = databaseFile->fileName();
}

// constructor
CDatabase::CDatabase(QString dbName)
{
    databaseFile = new QFileInfo(dbName);
    CDatabase::dbName = databaseFile->fileName();
}

To copy to clipboard, switch view to plain text mode 

in SomeFile.cpp:

static CDatabase *CDB;
...
// instantiation of CDB where stest is the return of a QFileDialog::getExistingDirectory (and is not a null string)
CDB = new CDatabase(stest + "/" + dbNameStr + ".db");

static CDatabase *CDB;
...
// instantiation of CDB where stest is the return of a QFileDialog::getExistingDirectory (and is not a null string)
CDB = new CDatabase(stest + "/" + dbNameStr + ".db");

To copy to clipboard, switch view to plain text mode 

QSqlQuery query = new QSqlQuery(db);//This line should give error

QSqlQuery query = new QSqlQuery(db);//This line should give error

To copy to clipboard, switch view to plain text mode 

Just see in the public functions in QSqlQuery :

QSqlQuery ( QSqlDatabase db )

Like I said, the compilation is nice ;-). I don't understand why there might be an error...

I use : Qt 4.1, Windows (mingw) and Code::Blocks...

[aMan]

try to append a semicolon (" ; ") to the sqlstring:

QString createQuery = "CREATE TABLE test;";

QString createQuery = "CREATE TABLE test;";

To copy to clipboard, switch view to plain text mode 

and if that doesn't help, try to get the error:
http://doc.trolltech.com/4.1/qsqlquery.html#lastError


regards aman..

[agent007se]

with AND without a semicolon :

QSqlError QSE = query.lastError();
QString tmp = QSE.text();
QMessageBox::warning(NULL, "", tmp);

QSqlError QSE = query.lastError();
QString tmp = QSE.text();
QMessageBox::warning(NULL, "", tmp);

To copy to clipboard, switch view to plain text mode 

tmp value:

"near "test": syntax error Unable to execute statement"

text() function

[jacek]

"near "test": syntax error Unable to execute statement"

It looks like your query is wrong. Can you execute that statement from SQLite console?

I don't use SQLite, but usually "CREATE TABLE xxx" is not enough --- you must add column definitions.

http://www.sqlite.org/lang_createtable.html

[gfunk]

After you call this:

1. QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
2. db.setDatabaseName(databaseFile->filePath());

do you call this?

1. bool ok = db.open();

If it succeeds, ok should be true.
If it doesn't, then all the following exec() calls will probably fail too.