bak insert back adj

w1146869587

2021-11-10 08d963298148327571feeaea057185d6cbfb0965

 mbwatch/mbwatchdb.h

@@ -26,7 +26,7 @@
private:
    bool         execSql( QString sql,QString &errInfo );  // 执行sql
    bool         execSql(QSqlDatabase &db,QString sql,QString &errInfo );  // 执行sql
    bool         getTmpFiledSql( QString sql,QString &tmpValue,QString &errInfo );  // 获取tmp字段的值
    bool         getFiledValueSql( QString sql,QString &tmpValue,QString tmpFiled,QString &errInfo );  // 获取tmp字段的值
    bool         exsitSql( QString sql,bool &bExsit,QString &errInfo );
    bool         isTableExist(QString table);
private:
@@ -38,13 +38,41 @@
    bool         loadDB(QSqlQuery &query);
public:
    bool         queryDB(QString &errInfo);
private: // log db
    bool         exsitLogDB(QString fileName,bool &bExsit,QString &errInfo);
    bool         updateLogDB(QString fileName,QString lastMdfTime,QString &errInfo);         // 更新DB
    bool         insertLogDB(QString fileName,QString lastMdfTime,QString &errInfo);         // 插入DB
    bool         getLastMdfTimeLogDB(QString fileName,QString &lastMdfTime,QString &errInfo);
public:
    bool         setLogDB(QString &cmd,bool &bOpDB,QString fileName,QString lastMdfTime, QString &errInfo);
    bool         setLogDB(bool &bOpDB,QString fileName,QString lastMdfTime, QString &errInfo);
private: // backup db
    bool         insertBackupDirDB(QString opType,QString fileName,
                                   QString newFileName,QString svrPath,
                                   QString lastMdfTime);
    bool         insertBackupDirDB(QString fileName,
                                   QString svrFlag,QString &errInfo);
    bool         exsitFileNameBackupDirDB(QString fileName,bool &bExsit,QString &errInfo);
private:
    bool         delBackupDirDB(QString fileName,QString &errInfo);
    bool         renameBakcupDirDB(QString opType,QString fileName,
                                   QString newFileName,QString svrPath,
                                   QString lastMdfTime);
                                   QString svrFlag,QString &errInfo);
    bool         newBakcupDirDB(QString opType,QString fileName,
                                   QString newFileName,QString svrPath,
                                   QString svrFlag,QString &errInfo);
    bool         mdyBakcupDirDB(QString opType,QString fileName,
                                   QString newFileName,QString svrPath,
                                   QString svrFlag,QString &errInfo);
public:
    bool         setBackupDirDB(QString opType,QString fileName,
                                QString newFileName,QString svrPath,
                                QString lastMdfTime,QString svrFlag,QString &errInfo);
public: // 调整数据库
    bool         adjDB(QString opType,QString fileName,
                                   QString newFileName,QString svrPath,
                                   QString lastMdfTime,QString svrFlag,QString &errInfo);
    bool         adjDB(QString fileName,
                                   QString newFileName,QString svrPath,
                                   QString lastMdfTime,QString svrFlag,QString &errInfo);
};

#endif // MBWATCHDB_H