Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
breakoutModewide
languagesql
INSERT INTO chains (name, active) VALUES ('pihole stats to influxdb', 1);
# replace chain_id 1 with the actual result
INSERT INTO relationships (name, active, chain_id, trigger_id, action_id, transformation)
VALUES ('pihole stats to influxdb', 1, 1, 213, 9, 'transformation from below');

# insert new schedule to make this thing run 
INSERT INTO schedules (function_id, active, interval`interval`, name, payload)
VALUES (213, 1, 10, 'pihole query every 10 seconds', '{"host":"127.0.0.1", "port":80}');

...