cli:franke:fip_3274_monitoraggio_impianto_fotovoltaico

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
cli:franke:fip_3274_monitoraggio_impianto_fotovoltaico [2025/08/07 10:10]
r.fioretti [SFTP] 		cli:franke:fip_3274_monitoraggio_impianto_fotovoltaico [2025/08/08 15:47] (current)
r.fioretti [Tabelle]
Line 5: Line 5:
 {{ :cli:franke:sqltabelle.txt |}} {{ :cli:franke:sqltabelle.txt |}}
  
 +<code sql>
 +--GRUPPI
 +INSERT INTO public.sensorsgrp VALUES (1, 'roof_building_n_3');
 +INSERT INTO public.sensorsgrp VALUES (2, 'parking_area');
 +
 +--SENSORI
 +INSERT INTO public.sensorsdev VALUES (276085, 'Inverter 15', 2);
 +INSERT INTO public.sensorsdev VALUES (276083, 'Inverter 14', 2);
 +INSERT INTO public.sensorsdev VALUES (276082, 'Inverter 13', 2);
 +INSERT INTO public.sensorsdev VALUES (276081, 'Inverter 12', 2);
 +INSERT INTO public.sensorsdev VALUES (276080, 'Inverter 11', 2);
 +INSERT INTO public.sensorsdev VALUES (276079, 'Inverter 10', 2);
 +INSERT INTO public.sensorsdev VALUES (276078, 'Inverter 9', 2);
 +INSERT INTO public.sensorsdev VALUES (276077, 'Inverter 8', 2);
 +INSERT INTO public.sensorsdev VALUES (276076, 'Inverter 7', 2);
 +INSERT INTO public.sensorsdev VALUES (276075, 'Inverter 6', 2);
 +INSERT INTO public.sensorsdev VALUES (276074, 'Inverter 5', 2);
 +INSERT INTO public.sensorsdev VALUES (276073, 'Inverter 4', 2);
 +INSERT INTO public.sensorsdev VALUES (276072, 'Inverter 3', 1);
 +INSERT INTO public.sensorsdev VALUES (276071, 'Inverter 2', 1);
 +INSERT INTO public.sensorsdev VALUES (276070, 'Inverter 1', 1);
 +</code>
 ===== SFTP ===== ===== SFTP =====
  
  • cli/franke/fip_3274_monitoraggio_impianto_fotovoltaico.1754554204.txt.gz
  • Last modified: 2025/08/07 10:10
  • by r.fioretti