QSqlDatabase::open() always returns true Qt 5.3.2

Question

Independently of the parameter that I set to the setDatabaseName function, the open function always returns true. Is that normal?

For example:

If I ran the following code:

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");

db.setDatabaseName("");

if( db.open() )
{
    qDebug() << "open";
}

The open function returns true.

What I expect is that the open function only returns true if it was successfully connected to the database.

I already find some topics but none solved my problem:

Qt 5.5 QSqlDatabase::open() always returns true?

QSqlDatabase::open() always returns true

QSqlDatabase open always returns true after update

I am using SQLite and Qt 5.3.2.

For sqlite it creates a database if the file does not exist. Although I am not sure what it is supposed to do if you give it a blank file name. — drescherjm
– drescherjm, Commented Dec 12, 2016 at 20:32
@drescherjm, thanks. I didn't know that. So, if I need to check if the database file exists, do I need to do it "manually"? — KelvinS
– KelvinS, Commented Dec 12, 2016 at 20:35
Thanks, @drescherjm. I did it using: QFile::exists( dbPath ). — KelvinS
– KelvinS, Commented Dec 12, 2016 at 20:42

Kuba hasn't forgotten Monica · Accepted Answer · 2016-12-12 21:23:08Z

2

It is normal, because the connection succeeds for you.

Specifically, if a database doesn't exist, sqlite will create it. The connection will fail only if the database cannot be created with a given filepath.

If you want to check if a file exists, use QFile::exists().

answered Dec 12, 2016 at 21:23

Kuba hasn't forgotten Monica

99.1k17 gold badges168 silver badges333 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

QSqlDatabase::open() always returns true Qt 5.3.2

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related