Method getActiveSessions

server/src/db/si-db.ts:246–259

(hostIdentifier?: string)

  }

  async getActiveSessions(hostIdentifier?: string): Promise<SiSession[]> {
    let sql = "SELECT * FROM si_sessions WHERE status = 'active'";
    const params: string[] = [];

    if (hostIdentifier) {
      sql += " AND host_identifier = $1";
      params.push(hostIdentifier);
    }

    sql += " ORDER BY last_activity_at DESC";

    const result = await query(sql, params);
    return result.rows.map((row) => this.deserializeSession(row));
  }

  async getSessionsByUser(
    userIdentifier: string,