Method upsert_code_project

src/global_db.rs:1232–1274

(
        &self,
        project_id: &str,
        project_root: &Path,
        git_common_dir: Option<&Path>,
        git_remote_url: Option<&str>,
        default_branch: Option<&str>,
    )

    }

    pub async fn upsert_code_project(
        &self,
        project_id: &str,
        project_root: &Path,
        git_common_dir: Option<&Path>,
        git_remote_url: Option<&str>,
        default_branch: Option<&str>,
    ) -> Option<CodeProjectRecord> {
        let now = crate::tracedecay::current_timestamp();
        let canonical_root = Self::canonical_project_key(project_root);
        let display_root = project_root.to_string_lossy().to_string();
        let git_common_dir_text = git_common_dir.map(|path| path.to_string_lossy().to_string());
        self.conn
            .execute(
                "INSERT INTO code_projects
                 (project_id, canonical_root, display_root, git_common_dir, git_remote_url,
                  default_branch, created_at, last_seen_at)
                 VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?7)
                 ON CONFLICT(project_id) DO UPDATE SET
                    canonical_root = excluded.canonical_root,
                    display_root = excluded.display_root,
                    git_common_dir = excluded.git_common_dir,
                    git_remote_url = excluded.git_remote_url,
                    default_branch = excluded.default_branch,
                    last_seen_at = excluded.last_seen_at",
                params![
                    project_id,
                    canonical_root,
                    display_root,
                    opt_text(git_common_dir_text.as_deref()),
                    opt_text(git_remote_url),
                    opt_text(default_branch),
                    now,
                ],
            )
            .await
            .ok()?;
        self.upsert_project_alias(project_root, project_id).await?;
        for alias in repo_identity_aliases(git_common_dir) {
            self.upsert_project_alias_key(&alias, project_id).await?;
        }
        self.get_code_project(project_id).await
    }

    pub async fn upsert_project_alias(
        &self,