MySqlDbtModel.h

Go to the documentation of this file.

#ifndef MY_SQL_DBT_MODEL_H
#define MY_SQL_DBT_MODEL_H
 
#include <QObject>
#include <QtWidgets>
#ifdef USE_SQL_FLAG
    #include <QtSql>
#endif
#include <QtDebug>
#include <QDir>
//
#include "MyConstants.h"
//#include "MyOrgSettings.h"
#include "MyLanguageModel.h"
 
class MySqlDbtModel : public QObject
{
        Q_OBJECT
    public:
        MySqlDbtModel(MyLanguageModel *thisLanguageModel = nullptr, MyConstants *thisConstant = nullptr, QObject *parent = 0); 
        ~MySqlDbtModel();                                           
        // Public
        MyLanguageModel *myLanguageModel;                           
        MyConstants     *myConstants;                               
        // DataBase Connection
        bool createDataBaseConnection();                            
        bool isDbTable(const QString &thisTable);                   
        // Sql Driver
        void setSqlDriver(const QString &thisDriver);               
        QString getSqlDriver();                                     
        // Sql Table Name
        void setSqlTableName(const QString &thisTableName);         
        QString getSqlTableName();                                  
        // Sql Host Name
        void setSqlHostName(const QString &thisHostName);           
        QString getSqlHostName();                                   
        // Sql User Name
        void setSqlUserName(const QString &thisUserName);           
        QString getSqlUserName();                                   
        // Sql Password
        void setSqlPassword(const QString &thisPassword);           
        QString getSqlPassword();                                   
        // Sql Database Name
        void setSqlDatabaseName(const QString &thisPassword);       
        QString getSqlDatabaseName();                               
        #ifdef USE_SQL_FLAG
        // Sql Database
        void setSqlDatabase(QSqlDatabase thisDatabase);             
        QSqlDatabase getSqlDatabase();                              
        #endif
        // Connection Name
        QString getConnectionName();                                
        void setConnectionName(const QString &thisConnectionName);  
        // RecordID
        QString getRecordID();                                      
        void setRecordID(const QString &thisRecordID);              
        // run Query
        bool runQuery(const QString &thisQuery);                    
        // move Db
        bool moveDb(const QString &thisSourceFile, const QString &thisSourcePath, const QString &thisDestinationFolder); 
        QString runProcces(const QString &thisExePath, const QString &thisArgument, bool isWait, int thisWaitTimeSec);   
        // Run Return Code
        int getRunReturnCode();                      
        // Is Debug Message
        void setDebugMessage(bool thisState);        
        bool getDebugMessage();                      
        void setMessage(const QString &thisMessage); 
 
    private:
        #ifdef USE_SQL_FLAG
        QSqlDatabase myDb;                              
        #endif
        QString      myDatabaseName   = "QtLingo";      
        QString      myTableName      = "QtLingo" ;     
        QString      mySqlDriver      = "NOTSET";       
        QString      myHostName       = "localhost";    
        QString      myUserName       = "";             
        QString      myPassword       = "";             
        QString      myConnectionName = "QtLingo";      
        QString      myInsertID       = "-1";           
        bool         isDebugMessage   = true;           
        int          myRunReturnCode  = 1;              
};
#endif // MY_SQL_DBT_MODEL_H