Method append_analytics_event

src/global_db.rs:2188–2226

(
        &self,
        event: &AnalyticsEventInsert,
    )

    }

    pub async fn append_analytics_event(
        &self,
        event: &AnalyticsEventInsert,
    ) -> Result<i64, String> {
        let mut rows = self
            .conn
            .query(
                "INSERT INTO analytics_events
                 (provider, project_id, session_id, timestamp, event_kind, hook_name,
                  tool_name, tool_category, skill_name, hint_category, hint_id, outcome,
                  metadata_json)
                 VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13)
                 RETURNING id",
                params![
                    event.provider.as_str(),
                    event.project_id.as_str(),
                    opt_text(event.session_id.as_deref()),
                    event.timestamp,
                    event.event_kind.as_str(),
                    opt_text(event.hook_name.as_deref()),
                    opt_text(event.tool_name.as_deref()),
                    opt_text(event.tool_category.as_deref()),
                    opt_text(event.skill_name.as_deref()),
                    opt_text(event.hint_category.as_deref()),
                    opt_text(event.hint_id.as_deref()),
                    opt_text(event.outcome.as_deref()),
                    opt_text(event.metadata_json.as_deref()),
                ],
            )
            .await
            .map_err(|e| format!("failed to append analytics event: {e}"))?;
        let row = rows
            .next()
            .await
            .map_err(|e| format!("failed to read appended analytics event id: {e}"))?
            .ok_or_else(|| "append analytics event returned no id".to_string())?;
        row.get::<i64>(0)
            .map_err(|e| format!("failed to decode appended analytics event id: {e}"))
    }

    pub async fn append_analytics_events(
        &self,