43 lines
2 KiB
JavaScript
43 lines
2 KiB
JavaScript
#!/usr/bin/env node
|
|
// Run from plant/ dir: DATABASE_URL=... node seed-app.js
|
|
import pg from 'pg'
|
|
|
|
const { Pool } = pg
|
|
const pool = new Pool({ connectionString: process.env.DATABASE_URL })
|
|
|
|
await pool.query(`
|
|
INSERT INTO apps (slug, name, description, base_path, icon, theme_color, category, internal_host, internal_port)
|
|
VALUES ('plant', 'Plant Room', 'Plant-room equipment monitoring and alerting — boilers, water softener, calorifiers and pumps via MQTT telemetry', '/plant', 'Gauge', '#0e7490', 'Hotel', '10.10.10.123', 3080)
|
|
ON CONFLICT (slug) DO UPDATE SET
|
|
name = EXCLUDED.name,
|
|
description = EXCLUDED.description,
|
|
base_path = EXCLUDED.base_path,
|
|
icon = EXCLUDED.icon,
|
|
theme_color = EXCLUDED.theme_color,
|
|
category = EXCLUDED.category,
|
|
internal_host = EXCLUDED.internal_host,
|
|
internal_port = EXCLUDED.internal_port
|
|
`)
|
|
|
|
await pool.query(`
|
|
INSERT INTO app_capabilities (app_id, slug, name, description, sort_order)
|
|
SELECT a.id, c.slug, c.name, c.description, c.sort_order
|
|
FROM apps a, (VALUES
|
|
('view', 'View', 'View the plant-room dashboard and alert list', 1),
|
|
('manage_assets', 'Manage Assets', 'Create/edit assets, alert rules and asset photos', 2),
|
|
('acknowledge_alerts', 'Acknowledge Alerts','Acknowledge and resolve triggered alerts', 3),
|
|
('settings', 'Settings', 'Configure plant app settings', 4)
|
|
) AS c(slug, name, description, sort_order)
|
|
WHERE a.slug = 'plant'
|
|
ON CONFLICT (app_id, slug) DO UPDATE SET
|
|
name = EXCLUDED.name,
|
|
description = EXCLUDED.description,
|
|
sort_order = EXCLUDED.sort_order
|
|
`)
|
|
|
|
// No default Staff grants — read-only monitoring is still plant-room-adjacent
|
|
// operational data, access is admin-assigned per role via the portal (same
|
|
// convention as hvac/wages/utilities, the other recently-added apps).
|
|
|
|
console.log('plant app seeded.')
|
|
await pool.end()
|