1
import { kv } from '@vercel/kv';

1
// Get sport_id by sport key
2
export async function getSportID(sport_key: string): Promise<number> {
3
  try {
4
    const startTime = Date.now();
5
    const cacheKey = `sport_${sport_key}`;
6
    console.log("cacheKey", cacheKey);
7
    if (await kv.exists(cacheKey)) {
8
      const cachedSport = await kv.get(cacheKey);
9
      console.log("cachedSport", cachedSport);
10
      if (cachedSport) {
11
        console.log("Returned from cache");
12
        return cachedSport as unknown as number;
13
      }
14
    }
15
    console.log("Returned from db");
16
    const pool = await initializePool();
17
    const sport = await pool.any(
18
      sql.unsafe`
19
        SELECT
20
          sport_id
21
        FROM
22
          sport
23
        WHERE
24
          key = ${sport_key}
25
        `
26
    );
27
    const sport_id = sport?.[0]?.sport_id;
28
    console.log("sport_id", sport_id);
29
    const setSportResult = await kv.set(cacheKey,sport_id);
30
    console.log("setSportResult", setSportResult);
31
    const endTime = Date.now();
32
    console.log("Time taken to get sport_id", endTime - startTime);
33
    return sport_id;
34
  } catch (error) {
35
    console.error('Failed to fetch sport:', error);
36
    throw new Error('Unable to retrieve sport');
37
  }
38
}