Method list_code_projects

src/global_db.rs:1532–1555

(&self, limit: usize)

    }

    pub async fn list_code_projects(&self, limit: usize) -> Vec<CodeProjectRecord> {
        let limit = i64::try_from(limit).unwrap_or(i64::MAX);
        let Ok(mut rows) = self
            .conn
            .query(
                "SELECT project_id, canonical_root, display_root, git_common_dir,
                        git_remote_url, default_branch, created_at, last_seen_at
                 FROM code_projects
                 ORDER BY last_seen_at DESC, project_id
                 LIMIT ?1",
                params![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
    }

    /// Returns registered code projects whose `last_seen_at` is within the last
    /// `since_secs` seconds, most-recently-seen first, capped at `limit`.