#include "dbthread.h"

DBThread::DBThread(QObject *parent) : QThread(parent)
{
    db = QSqlDatabase::addDatabase("QSQLITE","landwell_db");
    db.setDatabaseName("landwell.db");


}



void DBThread::initdb()
{
    Path = "D:/Program Files (x86)/巡检管理系统专业版 B1.0/GuardTour_DB.mdb";
    PassWd = "LW";

    if(db.open()){
        bool found = false;
        QStringList tables = db.tables();
        for(int i=0;i<tables.length();i++){
            if(QString::compare(tables.at(i),"usky_landwell_config")==0){
                found = true;
                break;
            }
        }
        if(!found){
            if(db.transaction()){
                db.exec("create table usky_landwell_config (PATH text,PASSWD text);");
                db.exec(QString("insert into usky_landwell_config (PATH, PASSWD) values ('%1', '%2');").arg(Path).arg(PassWd));
                db.commit();
            }
        }else{
            QSqlQuery qry = db.exec("select PATH, PASSWD from usky_landwell_config;");
            while (qry.next()) {
                Path = qry.value(0).toString();
                PassWd = qry.value(1).toString();
                }
            qry.clear();
         }
    }
    db.close();

    emit getParam(Path, PassWd);
}