Method getSessionsByUser

server/src/db/si-db.ts:261–284

(
    userIdentifier: string,
    identifierType: "slack_id" | "email" | "anonymous"
  )

  }

  async getSessionsByUser(
    userIdentifier: string,
    identifierType: "slack_id" | "email" | "anonymous"
  ): Promise<SiSession[]> {
    let column: string;
    switch (identifierType) {
      case "slack_id":
        column = "user_slack_id";
        break;
      case "email":
        column = "user_email";
        break;
      case "anonymous":
        column = "user_anonymous_id";
        break;
    }

    const result = await query(
      `SELECT * FROM si_sessions WHERE ${column} = $1 ORDER BY created_at DESC`,
      [userIdentifier]
    );

    return result.rows.map((row) => this.deserializeSession(row));
  }

  // --------------------------------------------------------------------------
  // Messages