#!/usr/bin/env python3
import datetime
import mariadb
import sys

################################## DB DATA ##################################
db_name='termik'
db_host=''
db_port=3307
db_user='termik'
db_password=''

if __name__ == "__main__":
    now = datetime.datetime.now()
    today = '2020-07-16' ##now.strftime('%Y-%m-%d')
    try:
        conn = mariadb.connect(
            user=db_user,
            password=db_password,
            host=db_host,
            port=db_port,
            database=db_name
        )
    except mariadb.Error as e:
        print(f"Error connecting to MariaDB Platform: {e}")
        sys.exit(1)
    cur = conn.cursor()
    try:
        print(f"WRONG VALUES")
        cur.execute("SELECT date, time, id, value FROM odczyty WHERE date=? ORDER BY seq_no DESC LIMIT 10", (today, ) )
        for (date, time, id, value) in cur:
            print(f"Date: {date} {time} | id: {id} | value: {value}")

        print(f"GOOD VALUES")
        cur.execute("SELECT date, time, id, value FROM odczyty WHERE date='2020-07-16' ORDER BY seq_no DESC LIMIT 10")
        for (date, time, id, value) in cur:
            print(f"Date: {date} {time} | id: {id} | value: {value}")
    except mariadb.Error as e:
        print(f"Error getting data from DB: {e}")
        sys.exit(1)