/rtlamr_processors

Some hackey scripts to process the output of rtlamr.

Primary LanguagePython

Contains some quick and dirty scripts to post-process the output of rtlamr when used with the -format json argument.

  • rtlamr_proc.py

    • accept records and put them in a mysql database. Schemas look like this:

    • create table meters (t timestamp default current_timestamp, id varchar(20),type int, tamperphy int, tamperenc int, consumption int);

    • create table types (type int, commodity varchar(10);

      I have pre-populated the 'types' table to look like this:

      • 5 - Electric
      • 11 - Water
      • 12 - Gas

    • A sample query looks like this:

      • select meters.t,meters.consumption,types.commodity from meters inner join types on types.type=meters.type where types.commodity='Water' order by t desc;

  • rtlamr_mqtt.py

    • accept records and publish them via MQTT.
    • Topic is <meter ID>/vol
    • This is used by me to get meter readings into homeassistant. Here is my configuration.yaml:
- platform: mqtt
  state_topic: 39818788/vol
  name: "dr-gas-meter"