Function consumePrize

lottery/lottery.ts:267–277

(prizeId: number)

    WHERE id = ? AND stock_count > 0
  `);
  const result = stmt.run(prizeId);
  return result.changes > 0;
}

function clearWarehouse(warehouseName: string): number {
  if (!db) return 0;
  
  const stmt = db.prepare(`
    DELETE FROM prize_warehouse 
    WHERE warehouse_name = ?
  `);
  const result = stmt.run(warehouseName);
  return result.changes;
}