E:/sqlmaster/src/connection.h

Go to the documentation of this file.

#ifndef CONNECTION_H
#define CONNECTION_H

#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QtGui>
#include <QString>

static bool createConnection()
{
    {
        QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
        db.setDatabaseName(qApp->tr("%1/db.db").arg(qApp->applicationDirPath()));
        if (!db.open()) {
            QMessageBox::critical(0, qApp->tr("Cannot open database"),
                                  qApp->tr("Unable to establish a database connection.\n"
                                           "This application needs SQLite support."
                                           "\n\n"
                                           "Click Cancel to exit."), QMessageBox::Cancel);
            return false;
        }
    }
    {
        QSqlQuery query;
        query.exec("create table if not exists connections (id integer primary key autoincrement, "
                   "connectionName varchar(50), serverName varchar(20), "
                   "userName varchar(50), password varchar(50))");
    }
    return true;
}

static void test() {
    if (createConnection()) {
        test();
    }
}

#endif