games_app/backend/dist-test-faq/repositories/userGameBetStatsRepository.js

16 lines
713 B
JavaScript

"use strict";
/**
* SQL fragments for cross-game user bet statistics.
* Source: `user_game_bet_stats` view (one row per user per game).
*/
Object.defineProperty(exports, "__esModule", { value: true });
exports.USER_BET_STATS_LATERAL_BODY = void 0;
/** Lateral subquery body — aggregates all games for the outer `users u` row. */
exports.USER_BET_STATS_LATERAL_BODY = `
SELECT COALESCE(SUM(bet_count), 0)::int AS prediction_count,
COALESCE(SUM(total_stake_raw), 0)::bigint AS total_stake_raw,
COALESCE(SUM(total_payout_raw), 0)::bigint AS total_payout_raw,
MAX(last_bet_at) AS last_bet_at
FROM user_game_bet_stats
WHERE user_id = u.id`;
//# sourceMappingURL=userGameBetStatsRepository.js.map