Function getActiveLottery

lottery/lottery.ts:350–359

(chatId: string)

    ORDER BY created_at DESC LIMIT 1
  `);
  return stmt.get(chatId) as any;
}

function addParticipantToLottery(lotteryId: number, participant: any): boolean {
  if (!db) return false;
  
  try {
    // Use transaction for concurrent safety
    const transaction = db.transaction(() => {
      // Check current participant count
      const countStmt = db.prepare(`SELECT COUNT(*) as count FROM lottery_participants WHERE lottery_id = ?`);
      const countResult = countStmt.get(lotteryId) as { count: number } | undefined;
      const currentCount = countResult?.count || 0;