Method _init_auth_db

auth_manager.py:78–110

Create the auth database schema if it doesn't exist.

(self)

    # =========================================================================

    def _init_auth_db(self):
        """Create the auth database schema if it doesn't exist."""
        with self._get_auth_conn() as conn:
            cursor = conn.cursor()
            cursor.execute("""
                CREATE TABLE IF NOT EXISTS auth (
                    id INTEGER PRIMARY KEY,
                    username TEXT NOT NULL,
                    password_hash TEXT NOT NULL,
                    password_salt TEXT NOT NULL,
                    hardware_fingerprint TEXT NOT NULL,
                    encrypted_fernet_key TEXT NOT NULL,
                    created_at TEXT DEFAULT CURRENT_TIMESTAMP,
                    updated_at TEXT DEFAULT CURRENT_TIMESTAMP
                )
            """)
            cursor.execute("""
                CREATE TABLE IF NOT EXISTS recovery_codes (
                    id INTEGER PRIMARY KEY,
                    code_hash TEXT NOT NULL,
                    code_salt TEXT NOT NULL,
                    encrypted_fernet_key TEXT NOT NULL,
                    used INTEGER DEFAULT 0,
                    used_at TEXT DEFAULT NULL
                )
            """)
            cursor.execute("""
                CREATE TABLE IF NOT EXISTS app_secrets (
                    key TEXT PRIMARY KEY,
                    value TEXT NOT NULL
                )
            """)
            conn.commit()

    @contextmanager
    def _get_auth_conn(self):