Method __init__

src/view/nas/nas_db.py:14–62

(self)

class NasDb(object):
    def __init__(self):
        self.db = QSqlDatabase.addDatabase("QSQLITE", "nas")
        path = os.path.join(Setting.GetConfigPath(), "nas.db")
        self.db.setDatabaseName(path)
        if not self.db.open():
            Log.Warn(self.db.lastError().text())

        query = QSqlQuery(self.db)
        sql = """\
            create table if not exists nas_info(\
            nas_id int primary key,\
            title varchar ,\
            address varchar,\
            port int, \
            type int ,\
            user varchar ,\
            passwd varchar ,\
            compress_index int,\
            save_index int,\
            dir_index int,\
            is_waifu2x int,\
            path varchar ,\
            tick int \
            )\
            """
        suc = query.exec_(sql)
        if not suc:
            a = query.lastError().text()
            Log.Warn(a)

        query = QSqlQuery(self.db)
        sql = """\
            create table if not exists nas_upload(\
            book_id varchar ,\
            title varchar,\
            nas_id int,\
            eps_ids varchar, \
            curPreUpIndex int,\
            tick int, \
            status int ,\
            status_msg int ,\
            primary key (book_id,nas_id)\
            )\
            """
        suc = query.exec_(sql)
        if not suc:
            a = query.lastError().text()
            Log.Warn(a)
        # self.LoadDownload()

    def DelUploadDB(self, nas_id, book_id):
        query = QSqlQuery(self.db)