Weather Station / ECOWITT / DNT
1
2import { getDuckConn } from "./src/lib/db/duckdb";
3
4async function check() {
5 try {
6 const conn = await getDuckConn();
7
8 console.log("--- Forecasts Storage Dates ---");
9 const forecasts = await conn.runAndReadAll(`
10 SELECT DISTINCT storage_date
11 FROM forecasts
12 ORDER BY storage_date DESC
13 LIMIT 20
14 `);
15 const fRows = forecasts.getRowObjects();
16 console.table(fRows);
17
18 console.log("\n--- Analysis Dates ---");
19 const analysis = await conn.runAndReadAll(`
20 SELECT DISTINCT analysis_date
21 FROM forecast_analysis
22 ORDER BY analysis_date DESC
23 LIMIT 20
24 `);
25 const aRows = analysis.getRowObjects();
26 console.table(aRows);
27
28 } catch (e) {
29 console.error(e);
30 }
31}
32
33check();