Changeset ff3a614 for database/drizzle/util/reports.ts

Timestamp:

03/05/26 11:31:19 (4 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Parents:

41825d5

Message:

Fix SQL functions for reporting and update queries in reports

File:

• database/drizzle/util/reports.ts (modified) (1 diff)

database/drizzle/util/reports.ts

@@ -11 +11 @@
         console.table(r1.rows);
 
-        const r2 = await db.execute(sql`SELECT * FROM get_report_user_leaderboard()`);
+        const r2 = await db.execute(sql`SELECT * FROM get_report_user_reputation_leaderboard()`);
         console.log('--- User Reputation Leaderboard ---');
         console.table(r2.rows);
 
-        const r3 = await db.execute(sql`SELECT * FROM get_report_price_performance()`);
+        const r3 = await db.execute(sql`SELECT * FROM get_report_price_to_performance()`);
         console.log('--- Price-to-Performance Analysis ---');
         console.table(r3.rows);
 
-        const r4 = await db.execute(sql`SELECT * FROM get_report_budget_tier()`);
+        const r4 = await db.execute(sql`SELECT * FROM get_report_budget_tier_popularity()`);
         console.log('--- Budget Tier Popularity ---');
         console.table(r4.rows);