36 lines
1.1 KiB
JavaScript
36 lines
1.1 KiB
JavaScript
/**
|
|
* Count auto bets placed for loadtest users after enabling auto.
|
|
* Run inside API container:
|
|
* node /tmp/loadtest-count-auto.js [minutesBack]
|
|
*/
|
|
const db = require('/app/dist/db/connection');
|
|
const minutesBack = Number(process.argv[2] || 10);
|
|
|
|
(async () => {
|
|
const rows = await db.query(
|
|
`SELECT COUNT(*)::int AS cnt
|
|
FROM candle_predict_bets b
|
|
JOIN users u ON u.id = b.user_id
|
|
WHERE u.first_name LIKE 'loadtest_%'
|
|
AND b.is_auto = TRUE
|
|
AND b.created_at > NOW() - ($1 || ' minutes')::interval`,
|
|
[String(minutesBack)]
|
|
);
|
|
const byStatus = await db.query(
|
|
`SELECT b.status, COUNT(*)::int AS cnt
|
|
FROM candle_predict_bets b
|
|
JOIN users u ON u.id = b.user_id
|
|
WHERE u.first_name LIKE 'loadtest_%'
|
|
AND b.is_auto = TRUE
|
|
AND b.created_at > NOW() - ($1 || ' minutes')::interval
|
|
GROUP BY b.status
|
|
ORDER BY b.status`,
|
|
[String(minutesBack)]
|
|
);
|
|
console.log(JSON.stringify({ minutesBack, count: rows[0]?.cnt || 0, byStatus }, null, 2));
|
|
process.exit(0);
|
|
})().catch((e) => {
|
|
console.error(e);
|
|
process.exit(1);
|
|
});
|