Method delete_code_projects

src/global_db.rs:1599–1617

Removes registered code-project rows by exact project id. Dependent registry rows in `project_aliases`, `store_instances`, `graph_scopes`, and `store_artifacts` cascade through foreign keys. This only removes registry metadata; it never deletes project files or profile-sharded store files on disk.

(&self, project_ids: &[String])

    /// This only removes registry metadata; it never deletes project files or
    /// profile-sharded store files on disk.
    pub async fn delete_code_projects(&self, project_ids: &[String]) -> usize {
        const CHUNK: usize = 256;
        let mut total: usize = 0;
        for chunk in project_ids.chunks(CHUNK) {
            let placeholders = vec!["?"; chunk.len()];
            let sql = format!(
                "DELETE FROM code_projects WHERE project_id IN ({})",
                placeholders.join(",")
            );
            let values: Vec<libsql::Value> = chunk
                .iter()
                .map(|project_id| libsql::Value::Text(project_id.clone()))
                .collect();
            if let Ok(n) = self.conn.execute(&sql, values).await {
                total = total.saturating_add(n as usize);
            }
        }
        total
    }

    pub async fn search_code_projects(&self, query: &str, limit: usize) -> Vec<CodeProjectRecord> {
        let limit = i64::try_from(limit).unwrap_or(i64::MAX);