import aiosqlite
from app.core.config import settings
from custom_logger import logger_config as logger

async def init_db():
    logger.info(f"Initializing database at {settings.DATABASE_FILE}")
    async with aiosqlite.connect(settings.DATABASE_FILE) as db:
        await db.execute('''CREATE TABLE IF NOT EXISTS tasks
                     (id TEXT PRIMARY KEY,
                      filename TEXT,
                      text TEXT NOT NULL,
                      voice TEXT,
                      speed REAL,
                      status TEXT NOT NULL,
                      output_file TEXT,
                      created_at TEXT NOT NULL,
                      processed_at TEXT,
                      error TEXT,
                      progress INTEGER DEFAULT 0,
                      progress_text TEXT,
                      hide_from_ui INTEGER DEFAULT 0)'''
        )
        await db.commit()
    logger.info("Database initialized successfully.")