Function _restore_sqlite

apps/backups/services.py:194–226

Restore SQLite database by replacing the database file.

(dump_file: Path)

def _restore_sqlite(dump_file: Path) -> None:
    """Restore SQLite database by replacing the database file."""
    logger.info("Restoring SQLite database...")
    db_path = Path(settings.DATABASES["default"]["NAME"])
    backup_current = None

    # Backup current database before overwriting
    if db_path.exists():
        backup_current = db_path.with_suffix(".db.bak")
        shutil.copy2(db_path, backup_current)
        logger.info(f"Backed up current database to {backup_current}")

    # Ensure parent directory exists
    db_path.parent.mkdir(parents=True, exist_ok=True)

    # The backup file from _dump_sqlite is a complete SQLite database file
    # We can simply copy it over the existing database
    shutil.copy2(dump_file, db_path)

    # Verify the restore worked by checking if the file is a readable SQLite database
    import sqlite3 as _sqlite3
    try:
        conn = _sqlite3.connect(str(db_path))
        conn.execute("SELECT name FROM sqlite_master WHERE type='table'").fetchall()
        conn.close()
    except _sqlite3.DatabaseError as exc:
        logger.error(f"SQLite verification failed: {exc}")
        if backup_current and backup_current.exists():
            shutil.copy2(backup_current, db_path)
            logger.info("Restored original database from backup")
        raise RuntimeError(f"SQLite restore verification failed: {exc}") from exc

    logger.info("SQLite restore completed successfully")


def create_backup() -> Path: