MyDatatables.cpp

Go to the documentation of this file.

#include "MyDatatables.h"
 
 
MyDatatables::MyDatatables(MyLanguageModel *thisLanguageModel, MyConstants *thisConstant, QObject *parent) : QObject(parent), myLanguageModel(thisLanguageModel), myConstants(thisConstant)
{
    mySqlModel = new MySqlDbtModel(thisLanguageModel, thisConstant, this);
    // Create Variable Trackers and Set to Empty
    myProject = new MyProjectClass("", "", "", "", "", "", "", "", "");
}
 
MyDatatables::~MyDatatables()
{
 
}
 
void MyDatatables::setDebugMessage(bool thisState)
{
    isDebugMessage = thisState;
    setMessage("setDebugMessage");
}
 
bool MyDatatables::getDebugMessage()
{
    setMessage("getDebugMessage");
    return isDebugMessage;
}
 
void MyDatatables::setProjectFolder(const QString &thisProjectFolder)
{
    setMessage("setProjectFolder");
    myProjectFolder = thisProjectFolder;
}
 
QString MyDatatables::getProjectFolder()
{
    setMessage("getProjectFolder");
    return myProjectFolder;
}
 
void MyDatatables::setProjectName(const QString &thisProjectName)
{
    setMessage("setProjectName");
    myProjectName = thisProjectName;
}
 
QString MyDatatables::getProjectName()
{
    setMessage("getProjectName");
    return myProjectName;
}
 
void MyDatatables::setProjectID(const QString &thisProjectID)
{
    setMessage("setProjectID");
    myProjectID = thisProjectID;
}
 
QString MyDatatables::getProjectID()
{
    setMessage("getProjectID");
    return myProjectID;
}
 
void MyDatatables::setComboBoxSqlValue(const QString &thisComboBoxSqlValue)
{
    setMessage("setComboBoxSqlValue");
    myComboBoxSqlValue = thisComboBoxSqlValue;
}
 
QString MyDatatables::getComboBoxSqlValue()
{
    setMessage("getComboBoxSqlValue");
    return myComboBoxSqlValue;
}
 
bool MyDatatables::checkDatabase()
{
    setMessage("checkDatabase");
    #ifdef USE_SQL_FLAG
    // Database
    mySqlModel->setSqlDriver(myComboBoxSqlValue);
    if (!mySqlModel->createDataBaseConnection()) { return false; }
    //
    // Configuration
    //
    if (!mySqlModel->isDbTable("Projects"))
    {
        /*
         * Table Projects holds the name of the Qt Project
         * id integer PRIMARY KEY autoincrement,
         * id, QtProjectName, QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, SourceLanguage, LanguageIDs, Make
        */
        if (mySqlModel->runQuery(QLatin1String(R"(CREATE TABLE Projects(id integer PRIMARY KEY autoincrement, QtProjectName, QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, SourceLanguage, LanguageIDs, Make))")))
        {
            QString theQtProjectName    = myConstants->MY_QT_PROJECT_NAME;
            QString theQtProjectFolder  = myConstants->MY_QT_PROJECT_FOLDER;
            QString theSource           = myConstants->MY_SOURCE_FOLDER;
            QString theDoxyfile         = myConstants->MY_DOXYFILE_FOLDER;
            QString theHelpFolder       = myConstants->MY_HELP_FOLDER;
            QString theSourceLanguage   = myConstants->MY_SOURCE_LANGUAGE;
            QString theMake             = myConstants->MY_MAKE;
            QString theLanguageIDs      = myConstants->MY_LANGUAGE_IDs;
            setProject(theQtProjectName, theQtProjectFolder, theSource, theDoxyfile, theHelpFolder, theSourceLanguage, theLanguageIDs, theMake);
            if (insertQtProjects())
            {
                myProjectID = mySqlModel->getRecordID();
                myLanguageModel->mySetting->writeSettings(myConstants->MY_SQL_PROJECT_ID, myProjectID);
            }
            else
            {
                qCritical() << mySqlModel->getSqlDriver() <<  "  INSERT TABLE Projects error:";
            }
        }
        //
    } // end if (!isDbTable("Projects"))
    //
    #endif
    return true;
}
 
bool MyDatatables::insertQtProjects()
{
    setMessage("insertProjects");
    // QtProjectName, QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, LanguageIDs, Make
    QString theQuery = QLatin1String(R"(INSERT INTO Projects (QtProjectName, QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, SourceLanguage, LanguageIDs, Make) values('%1', '%2', '%3', '%4', '%5', '%6', '%7', '%8'))").arg(myProject->getQtProjectName(), myProject->getQtProjectFolder(), myProject->getSourceFolder(), myProject->getDoxyfileFolder(), myProject->getHelpFolder(), myProject->getSourceLanguage(), myProject->getLanguageIDs(), myProject->getMake());
    setMessage("insertProjects: " + theQuery);
    //
    if (!mySqlModel->runQuery(theQuery))
    {
        qCritical() << "INSERT Projects error: " << theQuery;
        return false;
    }
    setProjectID(mySqlModel->getRecordID());
    return true;
}
 
bool MyDatatables::addQtProject()
{
    setMessage("addQtProject");
    #ifdef USE_SQL_FLAG
    // SELECT id, QtProjectName FROM Projects WHERE QtProject =
    if (isQtProjectNameQuery(myProject->getQtProjectName()))
    {
        myLanguageModel->mySetting->showMessageBox(QObject::tr("Record found!").toLocal8Bit(), QString("%1: %2").arg(tr("Not adding: Record found in database"), myProject->getQtProjectName()).toLocal8Bit(), myLanguageModel->mySetting->Warning);
        return false;
    }
    return insertQtProjects();
    #else
    return true;
    #endif
}
 
void MyDatatables::deleteQtProject(const QString &thisID)
{
    setMessage("deleteQtProject");
    #ifdef USE_SQL_FLAG
    QSqlQuery query; 
    QString theQuery = QString("DELETE FROM Projects WHERE id = ").append(thisID);
    setMessage("thisQuery: " + theQuery);
    if (!query.exec(theQuery))
    {
        qCritical() << "SqLite error:" << query.lastError().text() << ", SqLite error code:" << query.lastError();
    }
    #endif
}
 
QString MyDatatables::getQtProjectNameSelectQuery()
{
    setMessage("getQtProjectNameSelectQuery");
    return QString("SELECT id, QtProjectName FROM Projects");
}
 
QString MyDatatables::getQtProjectNameByNameQuery(const QString &thisProject)
{
    setMessage("getQtProjectNameByNameQuery");
    return QString("SELECT id, QtProjectName FROM Projects WHERE QtProjectName = '%1'").arg(thisProject);
}
 
bool MyDatatables::isQtProjectNameQuery(const QString &thisProjectName)
{
    setMessage("isQtProjectNameQuery");
    #ifdef USE_SQL_FLAG
    QSqlQuery theQuery; 
    QString theQueryCommand = getQtProjectNameByNameQuery(thisProjectName);
    if (theQuery.exec(theQueryCommand))
    {
        if (theQuery.first()) { return true;  }
        else                  { return false; }
    }
    else
    {
        qCritical() << "SqLite error isProjectQuery:" << theQuery.lastError().text() << ", SqLite error code:" << theQuery.lastError();
    }
    #endif
    return false;
}
 
QString MyDatatables::getQtProjectFullSelectQueryID(const QString &thisWhereID)
{
    setMessage("getProjectFolderFullSelectQueryID");
    return QString("SELECT * FROM Projects WHERE id = ").append(thisWhereID);
}
 
QString MyDatatables::getQtProjectNameSelectQueryID(const QString &thisWhereID)
{
    setMessage("getQtProjectNameSelectQueryID");
    return QString("SELECT id, QtProjectName FROM Projects WHERE id = ").append(thisWhereID);
}
 
void MyDatatables::saveQtProject()
{
    setMessage("saveProject");
    #ifdef USE_SQL_FLAG
    QSqlQuery theQuery; 
    QString theQueryString = QString("UPDATE Projects set QtProjectName = '%1', QtProjectFolder = '%2', SourceFolder = '%3', DoxyfileFolder = '%4', HelpFolder = '%5', SourceLanguage = '%6', LanguageIDs = '%7', Make = '%8' WHERE id = %9").arg(myProject->getQtProjectName(), myProject->getQtProjectFolder(), myProject->getSourceFolder(), myProject->getDoxyfileFolder(), myProject->getHelpFolder(), myProject->getSourceLanguage(), myProject->getLanguageIDs(), myProject->getMake(), myProject->getID());
    setMessage("thisQuery: |" + theQueryString + "|  getQtProjectName = " + myProject->getQtProjectName() + "|  getQtProjectFolder = " + myProject->getQtProjectFolder() + "| getSourceFolder=" + myProject->getSourceFolder() + "| getDoxyfileFolder=" + myProject->getDoxyfileFolder() + "| getHelpFolder=" + myProject->getHelpFolder() + "| getSourceLanguage=" + myProject->getSourceLanguage() + "| getLanguageIDs=" + myProject->getLanguageIDs() + "| getMake=" + myProject->getMake() + "| ID=" + myProject->getID() + "|");
    if (!theQuery.exec(theQueryString))
    {
        qCritical() << "SqLite error saveProject:" << theQuery.lastError().text() << ", SqLite error code:" << theQuery.lastError();
    }
    isSaveSettings = false;
    #endif
}
 
void MyDatatables::setProject(const QString &thisQtProjectName, const QString &thisQtProjectFolder, const QString &thisSourceFolder, const QString &thisDoxyfileFolder,  const QString &thisHelpFolder, const QString &thisSourceLanguage, const QString &thisLanguageIDs, const QString &thisMake)
{
    setMessage("setProject");
    myProject->setQtProjectName(thisQtProjectName);
    myProject->setQtProjectFolder(thisQtProjectFolder);
    myProject->setSourceFolder(thisSourceFolder);
    myProject->setDoxyfileFolder(thisDoxyfileFolder);
    myProject->setHelpFolder(thisHelpFolder);
    myProject->setSourceLanguage(thisSourceLanguage);
    myProject->setLanguageIDs(thisLanguageIDs);
    myProject->setMake(thisMake);
}
 
void MyDatatables::setMessage(const QString &thisMessage)
{
    if (isDebugMessage)
    {
        qDebug() << thisMessage;
        //std::cout << thisMessage.toStdString() << std::endl;
    }
}