Method _initialize_database

rightnow_cli/cache.py:32–63

Initialize SQLite database for metadata storage.

(self)

        self.kernels_dir.mkdir(parents=True, exist_ok=True)
    
    def _initialize_database(self):
        """Initialize SQLite database for metadata storage."""
        with sqlite3.connect(self.db_path) as conn:
            cursor = conn.cursor()
            cursor.execute("""
                CREATE TABLE IF NOT EXISTS kernel_metadata (
                    id TEXT PRIMARY KEY,
                    model_name TEXT NOT NULL,
                    operation TEXT NOT NULL,
                    created_at TIMESTAMP NOT NULL,
                    last_used TIMESTAMP NOT NULL,
                    performance_metrics TEXT,
                    constraints TEXT,
                    file_path TEXT NOT NULL,
                    checksum TEXT NOT NULL
                )
            """)
            
            cursor.execute("""
                CREATE TABLE IF NOT EXISTS optimization_history (
                    id INTEGER PRIMARY KEY AUTOINCREMENT,
                    model_name TEXT NOT NULL,
                    operation TEXT NOT NULL,
                    timestamp TIMESTAMP NOT NULL,
                    baseline_time_ms REAL,
                    optimized_time_ms REAL,
                    speedup REAL,
                    memory_usage_mb REAL,
                    notes TEXT
                )
            """)
            conn.commit()
    
    def get_config_path(self) -> Path:
        """Get the config file path."""