Function liveSessionWhere

freebuff/web/src/server/live-stats.ts:40–50

(now: Date)

}

function liveSessionWhere(now: Date) {
  return and(
    eq(schema.freeSession.status, 'active'),
    gt(schema.freeSession.expires_at, now),
    sql`NOT EXISTS (
      SELECT 1 FROM ${schema.user}
      WHERE ${schema.user.id} = ${schema.freeSession.user_id}
        AND ${schema.user.banned} = true
    )`,
  )
}

function sortCounts<T extends { count: number }>(rows: T[]): T[] {
  return [...rows].sort((a, b) => b.count - a.count)