src/database/database.cpp@4b95e33ee476 (annotated)
src/database/database.cpp
Fri, 11 Feb 2022 12:02:09 +0100
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Fri, 11 Feb 2022 12:02:09 +0100
- changeset 3
- 4b95e33ee476
- child 4
- fe106c497b75
- permissions
- -rw-r--r--
We have a mainscreen!
| 3 | 1 | |
| 2 | // from: https://evileg.com/en/post/93/ | |
| 3 | ||
| 4 | #include "database.h" | |
| 5 | ||
| 6 | DataBase::DataBase(QObject *parent) : QObject(parent) | |
| 7 | { | |
| 8 | ||
| 9 | } | |
| 10 | ||
| 11 | DataBase::~DataBase() | |
| 12 | { | |
| 13 | ||
| 14 | } | |
| 15 | ||
| 16 | void DataBase::connectToDataBase() | |
| 17 | { | |
| 18 | this->openDataBase(); | |
| 19 | } | |
| 20 | ||
| 21 | bool DataBase::openDataBase() | |
| 22 | { | |
| 23 | QSettings settings(QSettings::IniFormat, QSettings::UserScope, "mbse", "bmsapp"); | |
| 24 | ||
| 25 | settings.beginGroup("dbdev"); | |
| 26 | qDebug() << settings.value("host").toString() << settings.value("port").toString() << settings.value("name").toString() << settings.value("user").toString() << settings.value("pass").toString(); | |
| 27 | db = QSqlDatabase::addDatabase("QMYSQL"); | |
| 28 | db.setHostName(settings.value("host").toString()); | |
| 29 | db.setPort(settings.value("port").toInt()); | |
| 30 | db.setDatabaseName(settings.value("name").toString()); | |
| 31 | db.setUserName(settings.value("user").toString()); | |
| 32 | db.setPassword(settings.value("pass").toString()); | |
| 33 | settings.endGroup(); | |
| 34 | ||
| 35 | if (db.open()) { | |
| 36 | qDebug() << "Database open success"; | |
| 37 | return true; | |
| 38 | } else { | |
| 39 | qDebug() << "Database open failed"; | |
| 40 | return false; | |
| 41 | } | |
| 42 | } | |
| 43 | ||
| 44 | void DataBase::closeDataBase() | |
| 45 | { | |
| 46 | qDebug() << "Database close called"; | |
| 47 | db.close(); | |
| 48 | } | |
| 49 |
