My Datatables. More...

#include <MyDatatables.h>

Inheritance diagram for MyDatatables:

Public Member Functions
	MyDatatables (MyLanguageModel thisLanguageModel=nullptr, MyConstants thisConstant=nullptr, QObject *parent=nullptr)
	My Datatables Constructor. MyDatatables. More...

	~MyDatatables ()
	My Datatables Deconstructor. MyDatatables. More...

bool	checkDatabase ()
	check Database More...

bool	insertQtProjects ()
	insert Qt Project More...

bool	addQtProject ()
	add Qt Project More...

void	deleteQtProject (const QString &thisID)
	delete Qt Project More...

void	saveQtProject ()
	save Qt Project More...

void	setProject (const QString &thisQtProjectName, const QString &thisQtProject, const QString &thisSecret, const QString &thisEnvironment, const QString &thisHelpFolder, const QString &thisSourceLanguage, const QString &thisLanguageIDs, const QString &thisMake)
	set Project Sets all Variables used in the Configuarion Database in one Place: QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, SourceLanguage, LanguageIDs, Make. setProject More...

QString	getQtProjectNameSelectQueryID (const QString &thisWhereID)
	get Qt Projects Name Select Query ID More...

QString	getQtProjectNameSelectQuery ()
	get Qt Projects Name Select Query More...

QString	getQtProjectFullSelectQueryID (const QString &thisWhereID)
	get Qt Projects Full Select Query ID More...

QString	getQtProjectNameByNameQuery (const QString &thisProject)
	get Qt Projects Name By Name Query More...

bool	isQtProjectNameQuery (const QString &thisProjectName)
	is Qt Project Name Query More...

void	setProjectName (const QString &thisProjectName)
	set Project Name More...

QString	getProjectName ()
	get Project Name More...

void	setProjectID (const QString &thisProjectID)
	set Project ID More...

QString	getProjectID ()
	get Project ID More...

void	setProjectFolder (const QString &thisProjectFolder)
	set Project Folder More...

QString	getProjectFolder ()
	get Project Folder More...

void	setComboBoxSqlValue (const QString &thisComboBoxSqlValue)
	set ComboBox SqlValue More...

QString	getComboBoxSqlValue ()
	get ComboBox SqlValue More...

void	setDebugMessage (bool thisState)
	set Debug Message More...

bool	getDebugMessage ()
	get Debug Message More...

void	setMessage (const QString &thisMessage)
	set Message More...

Public Attributes
MyProjectClass *	myProject
	`myProject` More...

MySqlDbtModel *	mySqlModel
	`mySqlModel` More...

MyLanguageModel *	myLanguageModel
	`myLanguageModel` More...

MyConstants *	myConstants
	`myConstants` More...

Detailed Description

My Datatables.

Author: Jeffrey Scott Flesher

Definition at line 49 of file MyDatatables.h.

Constructor & Destructor Documentation

◆ MyDatatables()

MyDatatables::MyDatatables	(	MyLanguageModel *	thisLanguageModel = `nullptr`,
		MyConstants *	thisConstant = `nullptr`,
		QObject *	parent = `nullptr`
	)

explicit

My Datatables Constructor. MyDatatables.

Definition at line 7 of file MyDatatables.cpp.

                                                                                                         : QObject(parent), myLanguageModel(thisLanguageModel), myConstants(thisConstant)
{
    mySqlModel = new MySqlDbtModel(thisLanguageModel, thisConstant, this);
    // Create Variable Trackers and Set to Empty
    myProject = new MyProjectClass("", "", "", "", "", "", "", "", "");
}

◆ ~MyDatatables()

MyDatatables::~MyDatatables ( )

My Datatables Deconstructor. MyDatatables.

Definition at line 17 of file MyDatatables.cpp.

{
 
}

Member Function Documentation

◆ addQtProject()

bool MyDatatables::addQtProject ( )

add Qt Project

addQtProject Assumes you have ran setProject: QtProjectName, QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, LanguageIDs. addQtProject

Definition at line 182 of file MyDatatables.cpp.

{
    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
}

◆ checkDatabase()

bool MyDatatables::checkDatabase ( )

check Database

check Database. checkDatabase

Definition at line 115 of file MyDatatables.cpp.

{
    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;
}

◆ deleteQtProject()

void MyDatatables::deleteQtProject ( const QString & thisID )

delete Qt Project

delete Project. deleteProject

Definition at line 201 of file MyDatatables.cpp.

{
    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
}

◆ getComboBoxSqlValue()

QString MyDatatables::getComboBoxSqlValue ( )

get ComboBox SqlValue

get ComboBox Sql Value. getComboBoxSqlValue

Definition at line 106 of file MyDatatables.cpp.

{
    setMessage("getComboBoxSqlValue");
    return myComboBoxSqlValue;
}

◆ getDebugMessage()

bool MyDatatables::getDebugMessage ( )

get Debug Message

get Debug Message. getDebugMessage

Definition at line 34 of file MyDatatables.cpp.

{
    setMessage("getDebugMessage");
    return isDebugMessage;
}

◆ getProjectFolder()

QString MyDatatables::getProjectFolder ( )

get Project Folder

get Project Folder. getProjectFolder

Definition at line 52 of file MyDatatables.cpp.

{
    setMessage("getProjectFolder");
    return myProjectFolder;
}

◆ getProjectID()

QString MyDatatables::getProjectID ( )

get Project ID

get Project ID. getProjectID

Definition at line 88 of file MyDatatables.cpp.

{
    setMessage("getProjectID");
    return myProjectID;
}

◆ getProjectName()

QString MyDatatables::getProjectName ( )

get Project Name

get Project Name. getProjectName

Definition at line 70 of file MyDatatables.cpp.

{
    setMessage("getProjectName");
    return myProjectName;
}

◆ getQtProjectFullSelectQueryID()

QString MyDatatables::getQtProjectFullSelectQueryID ( const QString & thisWhereID )

get Qt Projects Full Select Query ID

get Qt Project Full Select Query ID SELECT * FROM Projects WHERE id =. getQtProjectFullSelectQueryID

Definition at line 258 of file MyDatatables.cpp.

{
    setMessage("getProjectFolderFullSelectQueryID");
    return QString("SELECT * FROM Projects WHERE id = ").append(thisWhereID);
}

◆ getQtProjectNameByNameQuery()

QString MyDatatables::getQtProjectNameByNameQuery ( const QString & thisProject )

get Qt Projects Name By Name Query

get Qt Project Name By Name Query SELECT id, QtProjectName FROM Projects WHERE QtProjectFolder =. getQtProjectNameByNameQuery

Definition at line 227 of file MyDatatables.cpp.

{
    setMessage("getQtProjectNameByNameQuery");
    return QString("SELECT id, QtProjectName FROM Projects WHERE QtProjectName = '%1'").arg(thisProject);
}

◆ getQtProjectNameSelectQuery()

QString MyDatatables::getQtProjectNameSelectQuery ( )

get Qt Projects Name Select Query

get Qt Project Name Select Query SELECT id, QtProjectName FROM Projects. getQtProjectNameSelectQuery

Definition at line 218 of file MyDatatables.cpp.

{
    setMessage("getQtProjectNameSelectQuery");
    return QString("SELECT id, QtProjectName FROM Projects");
}

◆ getQtProjectNameSelectQueryID()

QString MyDatatables::getQtProjectNameSelectQueryID ( const QString & thisWhereID )

get Qt Projects Name Select Query ID

get Qt Project Name Select Query ID SELECT id, QtProjectName FROM Projects WHERE id. getQtProjectNameSelectQueryID

Definition at line 267 of file MyDatatables.cpp.

{
    setMessage("getQtProjectNameSelectQueryID");
    return QString("SELECT id, QtProjectName FROM Projects WHERE id = ").append(thisWhereID);
}

◆ insertQtProjects()

bool MyDatatables::insertQtProjects ( )

insert Qt Project

insert Qt Projects into SQL Database. insertQtProjects

Definition at line 163 of file MyDatatables.cpp.

{
    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;
}

◆ isQtProjectNameQuery()

bool MyDatatables::isQtProjectNameQuery ( const QString & thisProjectName )

is Qt Project Name Query

is Project Folder Query myAccessSqlDbtModel->isProjectQuery(ui->lineEditSettingsProjectBin->text());. isProjectFolderQuery

Definition at line 236 of file MyDatatables.cpp.

{
    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;
}

◆ saveQtProject()

void MyDatatables::saveQtProject ( )

save Qt Project

save Project Projects: id, QtProjectName QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, SourceLanguage, LanguageIDs, Make saveProject

Definition at line 276 of file MyDatatables.cpp.

{
    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
}

◆ setComboBoxSqlValue()

void MyDatatables::setComboBoxSqlValue ( const QString & thisComboBoxSqlValue )

set ComboBox SqlValue

set ComboBox Sql Value. setComboBoxSqlValue

Definition at line 97 of file MyDatatables.cpp.

{
    setMessage("setComboBoxSqlValue");
    myComboBoxSqlValue = thisComboBoxSqlValue;
}

◆ setDebugMessage()

void MyDatatables::setDebugMessage ( bool thisState )

set Debug Message

set Debug Message. setDebugMessage

Definition at line 25 of file MyDatatables.cpp.

{
    isDebugMessage = thisState;
    setMessage("setDebugMessage");
}

◆ setMessage()

void MyDatatables::setMessage ( const QString & thisMessage )

set Message

set Message. setMessage

Definition at line 311 of file MyDatatables.cpp.

{
    if (isDebugMessage)
    {
        qDebug() << thisMessage;
        //std::cout << thisMessage.toStdString() << std::endl;
    }
}

◆ setProject()

void MyDatatables::setProject	(	const QString &	thisQtProjectName,
		const QString &	thisQtProject,
		const QString &	thisSecret,
		const QString &	thisEnvironment,
		const QString &	thisHelpFolder,
		const QString &	thisSourceLanguage,
		const QString &	thisLanguageIDs,
		const QString &	thisMake
	)

set Project Sets all Variables used in the Configuarion Database in one Place: QtProjectFolder, SourceFolder, DoxyfileFolder, HelpFolder, SourceLanguage, LanguageIDs, Make. setProject

Definition at line 295 of file MyDatatables.cpp.

{
    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);
}

◆ setProjectFolder()

void MyDatatables::setProjectFolder ( const QString & thisProjectFolder )

set Project Folder

set Project Folder. setProjectFolder

Definition at line 43 of file MyDatatables.cpp.

{
    setMessage("setProjectFolder");
    myProjectFolder = thisProjectFolder;
}

◆ setProjectID()

void MyDatatables::setProjectID ( const QString & thisProjectID )

set Project ID

set Project ID. setProjectID

Definition at line 79 of file MyDatatables.cpp.

{
    setMessage("setProjectID");
    myProjectID = thisProjectID;
}

◆ setProjectName()

void MyDatatables::setProjectName ( const QString & thisProjectName )

set Project Name

set Project Name. setProjectName

Definition at line 61 of file MyDatatables.cpp.

{
    setMessage("setProjectName");
    myProjectName = thisProjectName;
}

Member Data Documentation

◆ myConstants

MyConstants* MyDatatables::myConstants

myConstants

All Constants in one class

Definition at line 59 of file MyDatatables.h.

◆ myLanguageModel

MyLanguageModel* MyDatatables::myLanguageModel

myLanguageModel

Localization Model.

Definition at line 58 of file MyDatatables.h.

◆ myProject

MyProjectClass* MyDatatables::myProject

myProject

My Project Variables

Definition at line 56 of file MyDatatables.h.

◆ mySqlModel

MySqlDbtModel* MyDatatables::mySqlModel

mySqlModel

Pointer to DataTable

Definition at line 57 of file MyDatatables.h.

The documentation for this class was generated from the following files:

src/MyDatatables.h
src/MyDatatables.cpp

Public Member Functions

Public Attributes