How to create a SQLite database in Qt

Question

I am trying to create a SQLite database in Qt. Here is my code:

QDir databasePath;
QString path = databasePath.currentPath()+"myDb.db";
QSqlDatabase dbConnection = QSqlDatabase:addDatabase("QSQLITE");
db.setDatabaseName(path);
db.open();

There are no errors when running the code, but I can't find the database I created in the path I defined. Does this actually create the database or does it just do some initialization?

If it does not create the database then how do I create the database within the application itself? (I am not talking about insertion.)

Hard code the path instead of creating a variable, and test again. That is one way to ensure it isn't a code or bad string issue as opposed to some other issue. — PaulMcKenzie
– PaulMcKenzie, Commented Jan 8, 2015 at 16:28
@PaulMcKenzie: this is actually solved the problem of the location thank you very much — user3009135
– user3009135, Commented Jan 8, 2015 at 16:39

Jablonski · Accepted Answer · 2015-01-08 16:37:28Z

32

You should also create query which will create not empty database and use correct name of variable(in your code you use dbConnection firstly and after that - db. For example:

QString path = "path";
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");//not dbConnection
db.setDatabaseName(path);
db.open();
QSqlQuery query;
query.exec("create table person "
          "(id integer primary key, "
          "firstname varchar(20), "
          "lastname varchar(30), "
          "age integer)");

edited Jan 8, 2015 at 16:37

answered Jan 8, 2015 at 16:28

Jablonski

18.6k2 gold badges52 silver badges49 bronze badges

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

3 Comments

Alison Over a year ago

Oh I see, I didnot notice he is using different names, sorry. Hoever, I am having a problem using the same code, after hard-coded the path like this: QString path="c://Users//me//Document//workapce//myproject//databse.db" my app crashes. when debugging it just exit with crash .. what might be the problem

NedStarkOfWinterfell Over a year ago

Is it possible to connect to a db file with a username and password?

Jablonski Over a year ago

@AttitudeMonger Try this open() method doc.qt.io/qt-5/qsqldatabase.html#open-1

in.yssh · Accepted Answer · 2022-05-23 12:47:01Z

2

His mistake was,

QDir databasePath;
QString path = databasePath.currentPath()+"/myDb.db"; // Not "myDb.db"
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(path);
db.open();
QSqlQuery query; // And he should insert some data, as the answer above mentioned
query.exec("create table person "
          "(id integer primary key, "
          "firstname varchar(20), "
          "lastname varchar(30), "
          "age integer)");

And the database file myDb.db is created in build directory not in his source code directory.

answered May 23, 2022 at 12:47

in.yssh

336 bronze badges

Collectives™ on Stack Overflow

How to create a SQLite database in Qt

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related