Method code_projects_seen_within

src/global_db.rs:1562–1591

Returns registered code projects whose `last_seen_at` is within the last `since_secs` seconds, most-recently-seen first, capped at `limit`. Used by the git-metadata watcher to register only projects seen recently (e.g. within 14 days), bounded by `watch_max_projects`.

(
        &self,
        since_secs: i64,
        limit: usize,
    )

    /// Used by the git-metadata watcher to register only projects seen recently
    /// (e.g. within 14 days), bounded by `watch_max_projects`.
    pub async fn code_projects_seen_within(
        &self,
        since_secs: i64,
        limit: usize,
    ) -> Vec<CodeProjectRecord> {
        let limit = i64::try_from(limit).unwrap_or(i64::MAX);
        let cutoff = crate::tracedecay::current_timestamp().saturating_sub(since_secs);
        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
                 WHERE last_seen_at >= ?1
                 ORDER BY last_seen_at DESC, project_id
                 LIMIT ?2",
                params![cutoff, 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
    }

    /// Removes registered code-project rows by exact project id.
    ///