Method search_code_projects

src/global_db.rs:1619–1652

(&self, query: &str, limit: usize)

    }

    pub async fn search_code_projects(&self, query: &str, limit: usize) -> Vec<CodeProjectRecord> {
        let limit = i64::try_from(limit).unwrap_or(i64::MAX);
        let pattern = like_pattern(query);
        let Ok(mut rows) = self
            .conn
            .query(
                "SELECT DISTINCT cp.project_id, cp.canonical_root, cp.display_root,
                        cp.git_common_dir, cp.git_remote_url, cp.default_branch,
                        cp.created_at, cp.last_seen_at
                 FROM code_projects cp
                 LEFT JOIN project_aliases pa ON pa.project_id = cp.project_id
                 WHERE cp.project_id LIKE ?1 ESCAPE '\\'
                    OR cp.canonical_root LIKE ?1 ESCAPE '\\'
                    OR cp.display_root LIKE ?1 ESCAPE '\\'
                    OR COALESCE(cp.git_common_dir, '') LIKE ?1 ESCAPE '\\'
                    OR COALESCE(cp.git_remote_url, '') LIKE ?1 ESCAPE '\\'
                    OR COALESCE(cp.default_branch, '') LIKE ?1 ESCAPE '\\'
                    OR COALESCE(pa.alias_path, '') LIKE ?1 ESCAPE '\\'
                 ORDER BY cp.last_seen_at DESC, cp.project_id
                 LIMIT ?2",
                params![pattern, limit],
            )
            .await
        else {
            return Vec::new();
        };
        let mut projects = Vec::new();
        while let Ok(Some(row)) = rows.next().await {
            if let Some(project) = row_to_code_project(&row, 0) {
                projects.push(project);
            }
        }
        projects
    }

    pub async fn project_registry_context_by_id(
        &self,