#!/usr/bin/env python3
''' common functions and stuff '''

import logging
import os
import sys
from datetime import datetime

QUEUE = bool(os.environ.get('el_QUEUE', False))

name = os.path.splitext(os.path.split(sys.argv[0])[-1])[0]

log = logging.getLogger(__name__)
log.setLevel(logging.INFO)
logging.basicConfig(format="%(name)s: %(levelname)s %(message)s")


# Use queue or postgres
if QUEUE is True:
    log.debug('Importing dbi from queue')
    from .queue import dbi
else:
    log.debug('Importing dbi from postgres')
    from .postgres import dbi


# Insert state
def statein(sensor, value, device_class, unit, **kwargs):
    ''' Insert new state in db '''
    verbose = bool(kwargs['verbose']) if 'verbose' in kwargs else False

    sql = """INSERT INTO states
                (sensor_id,
                 value,
                 device_class,
                 unit,
                 time)
             SELECT sensors.id, %s, %s, %s, %s
                 FROM sensors
                 WHERE sensors.name = %s;"""
    values = (value,
              device_class,
              unit,
              datetime.utcnow(),
              sensor)
    log.debug('dbi(' + sql + ',' + str(values) + ')')
    dbi(sql, values, verbose=verbose)