experiments/DBAdd/uDB.py - main - VolcanoByte/vbBooks

experiments/DBAdd/uDB.py

37 строк1008 B

Eugene Gavrilyuk

test: Эксперименты

06 авг 2025, 16:33

06 авг 2025, 16:33c5e5274

import sqlite3
from xmlrpc.client import DateTime

from uBook import Book

class DB:
    def __init__(self):
        self.conn = sqlite3.connect('vbBooks.db')
        self.cursor = self.conn.cursor()

    def findBookFilename(self, filename) -> int | None:
        """Возвращает индекс книги по имени файла или None"""
        pass

    def isPathComplete(self, path: str, datatime: DateTime) -> bool:
        pass

    def addBook(self, book: Book):
        pass

    def addPath(self, path: str) -> int:
        self.cursor.execute('SELECT fldPathId FROM tblPaths WHERE fldPathText = ?',
                            (path,))
        pathId = self.cursor.fetchone()
        if pathId is None:
            self.cursor.execute('INSERT INTO tblPaths (fldPathText) '
                                'VALUES (?)', (path,))
            pathId = self.cursor.lastrowid

        return pathId

    def close(self):
        self.conn.commit()
        self.conn.close()


db = DB()