Skip to content

Get information from FVE Wattrouter in XML format. Parse it and put it into database.

License

Notifications You must be signed in to change notification settings

musil/Wattrouter-daily-stats-to-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Wattrouter daily stats to database

MySQL

mysql  Ver 15.1 Distrib 10.3.28-MariaDB, for Linux (x86_64) using readline 5.1

##DB sturcture it will create table "wattrouter_stat_day" with UTF8_Czech colation

CREATE TABLE `wattrouter_stat_day` (
  `id` bigint(20) NOT NULL,
  `datum` date NOT NULL,
  `cas` time NOT NULL,
  `sds1` decimal(10,2) NOT NULL,
  `sdh1` decimal(10,2) NOT NULL,
  `sdl1` decimal(10,2) NOT NULL,
  `sdp1` decimal(10,2) NOT NULL,
  `sds2` decimal(10,2) NOT NULL,
  `sdh2` decimal(10,2) NOT NULL,
  `sdl2` decimal(10,2) NOT NULL,
  `sdp2` decimal(10,2) NOT NULL,
  `sds3` decimal(10,2) NOT NULL,
  `sdh3` decimal(10,2) NOT NULL,
  `sdl3` decimal(10,2) NOT NULL,
  `sdp3` decimal(10,2) NOT NULL,
  `sds4` decimal(10,2) NOT NULL,
  `sdh4` decimal(10,2) NOT NULL,
  `sdl4` decimal(10,2) NOT NULL,
  `sdp4` decimal(10,2) NOT NULL,
  `sdo1` decimal(10,2) NOT NULL,
  `sdo2` decimal(10,2) NOT NULL,
  `sdo3` decimal(10,2) NOT NULL,
  `sdo4` decimal(10,2) NOT NULL,
  `sdo5` decimal(10,2) NOT NULL,
  `sdo6` decimal(10,2) NOT NULL,
  `sdo7` decimal(10,2) NOT NULL,
  `sdo8` decimal(10,2) NOT NULL,
  `sdo9` decimal(10,2) NOT NULL,
  `sdo10` decimal(10,2) NOT NULL,
  `sdo11` decimal(10,2) NOT NULL,
  `sdo12` decimal(10,2) NOT NULL,
  `sdo13` decimal(10,2) NOT NULL,
  `sdo14` decimal(10,2) NOT NULL,
  `sdi1` decimal(10,2) NOT NULL,
  `sdi2` decimal(10,2) NOT NULL,
  `sdi3` decimal(10,2) NOT NULL,
  `sdi4` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

whole DB dump is in file: example-mysql-dump.sql

CRONTAB

add line below to the "/etc/crontab" file. It will

59 23 * * *     root    php /PATH_TO_THE_FILE/cron-fve-insert-to-mysql.php

About

Get information from FVE Wattrouter in XML format. Parse it and put it into database.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages