obstechutils 0.1.2

Utilities for obstech

Obstech python utilities

Utilities for El Sauce observatory to make life easier dealing with MySQL, MQTT, Google sheets, mailing, Telegram, command line options and configuration files, socket/serial connections, etc.

Installation

• From local sources, within a virtual environment, pip install -e .
• From python repository, within a virtual environment, pip install obstechutils.

Utilities

• db: connect to MySQL
• google: down from google services like sheets
• roof: list roof info
• mqtt: MQTT client
• inventory: read inventory from the main Google Sheets database
• credentials: deal with logging into servers
• email: basic email sender
• telegram: basic Telegram client
• connection: unified interface to serial port/socket connections
• configparse: argparse extended to use configuration files and env. variables
• meteo: basic meteo functions

Scripts

• mqtt_console: display MQTT messages on the weather workstation
• report_device_status: check whether PCs and devices are turned on
• list_roofs: list roof parameters

Credentials file

The credentials file should be in ~/.config/obstechutils with the following format

mail:
    device_status:
        username:     [e-mail]
        password:     xxxx xxxx xxxx xxxx
        server:       smtp.xxxx.yyy
        port:         465
mqtt:
    generic_obstech:
        username:     obstech
        password:     xxxxxxxxxx
        server:       yyy.yyy.yyy
        port:         1883
        qos:          2
        timeout:      60
mysql:
    generic_obstech:
        username:     obstech
        password:     xxxxxxxxxx
        server:       yyy.yyy.yyy.yyy
        port:         3306
googleapi:
    generic_obstech:
        username:     [e-mail]
        token:        googleapi/token-generic_obstech.json
        credentials:  googleapi/credentials-generic_obstech.json
        scopes:
        - https://www.googleapis.com/auth/spreadsheets.readonly