src/database/database.cpp

Sat, 12 Feb 2022 21:24:43 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 12 Feb 2022 21:24:43 +0100
changeset 6
f8474f2c5db9
parent 4
fe106c497b75
child 85
34ca34ed81df
permissions
-rw-r--r--

We can fetch a list of suppliers and show it in the wrong window. Still a lot to learn about Qt5

/**
 * database.cpp is part of bmsapp.
 *
 * bmsapp is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * bmsapp is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
#include "database.h"


DataBase::DataBase(QObject *parent) : QObject(parent)
{
     
}


DataBase::~DataBase()
{

}


bool DataBase::openDataBase(bool develop)
{
    QSettings settings(QSettings::IniFormat, QSettings::UserScope, "mbse", "bmsapp");

    if (develop)
    	settings.beginGroup("dbdev");
    else
	settings.beginGroup("dbprod");

    qDebug() << settings.value("host").toString() << settings.value("port").toString() << settings.value("name").toString() << settings.value("user").toString() << settings.value("pass").toString();
    db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName(settings.value("host").toString());
    db.setPort(settings.value("port").toInt());
    db.setDatabaseName(settings.value("name").toString());
    db.setUserName(settings.value("user").toString());
    db.setPassword(settings.value("pass").toString());
    settings.endGroup();

    if (db.open()) {
	qDebug() << "Database open success";
	return true;
    } else {
	qDebug() << "Database open failed";
	return false;
    }
}
     
void DataBase::closeDataBase()
{
    qDebug() << "Database close called";
    db.close();
}

mercurial