Method getStats

server/src/db/slack-db.ts:286–317

* Get mapping statistics

()

   * Get mapping statistics
   */
  async getStats(): Promise<SlackMappingStats> {
    const result = await query<{
      total: string;
      mapped: string;
      unmapped: string;
      pending_verification: string;
      bots: string;
      deleted: string;
      opted_out: string;
    }>(
      `SELECT
        COUNT(*)::text AS total,
        COUNT(*) FILTER (WHERE mapping_status = 'mapped')::text AS mapped,
        COUNT(*) FILTER (WHERE mapping_status = 'unmapped' AND slack_is_bot = false AND slack_is_deleted = false)::text AS unmapped,
        COUNT(*) FILTER (WHERE mapping_status = 'pending_verification')::text AS pending_verification,
        COUNT(*) FILTER (WHERE slack_is_bot = true)::text AS bots,
        COUNT(*) FILTER (WHERE slack_is_deleted = true)::text AS deleted,
        COUNT(*) FILTER (WHERE nudge_opt_out = true)::text AS opted_out
       FROM slack_user_mappings`
    );

    const row = result.rows[0];
    return {
      total: parseInt(row.total, 10),
      mapped: parseInt(row.mapped, 10),
      unmapped: parseInt(row.unmapped, 10),
      pending_verification: parseInt(row.pending_verification, 10),
      bots: parseInt(row.bots, 10),
      deleted: parseInt(row.deleted, 10),
      opted_out: parseInt(row.opted_out, 10),
    };
  }

  // ============== Nudge Tracking ==============