Files
Gov_Travel_App/scripts/checkMealPlan.js
mblanke ae1f13d69e feat: add scripts for database inspection and migration
- Implemented multiple scripts to check and inspect meal plans, scraped data, and accommodations for Munich and Riga.
- Added a migration script to convert scraped data into the application's database format.
- Introduced new database service methods for querying and updating travel rates.
- Enhanced server configuration for serving static files in production.
- Updated PostCSS configuration for consistency.
2026-01-13 11:32:49 -05:00

13 lines
305 B
JavaScript

const Database = require("better-sqlite3");
const path = require("path");
const db = new Database(
path.join(__dirname, "..", "database", "travel_rates.db")
);
console.log(
db
.prepare(
"select city_name, meal_plan_type from travel_rates where lower(city_name)='munich'"
)
.get()
);