MyDatatables.h

Go to the documentation of this file.

#ifndef MYDATATABLES_H
#define MYDATATABLES_H
 
#include <QObject>
#include <QtDebug>
#include "MyConstants.h"
#include "MySqlDbtModel.h"
#include "MyLanguageModel.h"
 
class MyProjectClass
{
    public:
        MyProjectClass(const QString &thisID, const QString &thisQtProjectName, const QString &thisQtProjectFolder, const QString &thisSourceFolder, const QString &thisDestinationFolder,  const QString &thisHelpFolder, const QString &thisSourceLanguage, const QString &thisLanguageIDs, const QString &thisMake)
            : myID{thisID}, myQtProjectName{thisQtProjectName}, myQtProjectFolder{thisQtProjectFolder}, mySourceFolder{thisSourceFolder}, myDoxyfileFolder{thisDestinationFolder}, myHelpFolder{thisHelpFolder}, mySourceLanguage{thisSourceLanguage}, myLanguageIDs{thisLanguageIDs}, myMake{thisMake} {}
        // Getters
        QString getID()                const { return myID;                } 
        QString getQtProjectName()     const { return myQtProjectName;     } 
        QString getQtProjectFolder()   const { return myQtProjectFolder;   } 
        QString getSourceFolder()      const { return mySourceFolder;      } 
        QString getDoxyfileFolder()    const { return myDoxyfileFolder;    } 
        QString getHelpFolder()        const { return myHelpFolder;        } 
        QString getSourceLanguage()    const { return mySourceLanguage;    } 
        QString getLanguageIDs()       const { return myLanguageIDs;       } 
        QString getMake()              const { return myMake;              } 
        // Setters
        void setID(const QString &s)                { myID                = s; }
        void setQtProjectName(const QString &s)     { myQtProjectName     = s; }
        void setQtProjectFolder(const QString &s)   { myQtProjectFolder   = s; }
        void setSourceFolder(const QString &s)      { mySourceFolder      = s; }
        void setDoxyfileFolder(const QString &s)    { myDoxyfileFolder    = s; }
        void setHelpFolder(const QString &s)        { myHelpFolder        = s; }
        void setSourceLanguage(const QString &s)    { mySourceLanguage    = s; }
        void setLanguageIDs(const QString &s)       { myLanguageIDs       = s; }
        void setMake(const QString &s)              { myMake              = s; }
 
    private:
        QString myID, myQtProjectName, myQtProjectFolder, mySourceFolder, myDoxyfileFolder, myHelpFolder;
        QString mySourceLanguage, myLanguageIDs, myMake;
};
 
class MyDatatables : public QObject
{
        Q_OBJECT
    public:
        explicit MyDatatables(MyLanguageModel *thisLanguageModel = nullptr, MyConstants *thisConstant = nullptr, QObject *parent = nullptr);
        ~MyDatatables();
        //
        MyProjectClass  *myProject;                  
        MySqlDbtModel   *mySqlModel;                 
        MyLanguageModel *myLanguageModel;            
        MyConstants     *myConstants;                
        //
        bool checkDatabase();                        
        bool insertQtProjects();                     
        bool addQtProject();                         
        void deleteQtProject(const QString &thisID); 
        void saveQtProject();                        
        //
        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);
        // Query
        QString getQtProjectNameSelectQueryID(const QString &thisWhereID);  
        QString getQtProjectNameSelectQuery();                              
        QString getQtProjectFullSelectQueryID(const QString &thisWhereID);  
        QString getQtProjectNameByNameQuery(const QString &thisProject);    
        bool isQtProjectNameQuery(const QString &thisProjectName);          
        // Project Name
        void setProjectName(const QString &thisProjectName);                
        QString getProjectName();                                           
        // Project ID
        void setProjectID(const QString &thisProjectID);                    
        QString getProjectID();                                             
        // Project Folder
        void setProjectFolder(const QString &thisProjectFolder);            
        QString getProjectFolder();                                         
        // ComboBox SQL Value
        void setComboBoxSqlValue(const QString &thisComboBoxSqlValue);      
        QString getComboBoxSqlValue();                                      
        // Is Debug Message
        void setDebugMessage(bool thisState);                               
        bool getDebugMessage();                                             
        void setMessage(const QString &thisMessage);                        
 
    private:
        QString          myProjectID        = "-1";          
        QString          myComboBoxSqlValue = "-1";          
        QString          myProjectFolder    = "QtLingo";     
        QString          myProjectName      = "QtLingo";     
        bool             isDebugMessage     = true;          
        bool             isSaveSettings     = false;         
 
};
#endif // MYDATATABLES_H