import sys

import time

import _thread

import ast

import configparser

import datetime

from canard import can, messaging

from canard.hw import socketcan

from canard.file import jsondb

from canard.utils import queue

from influxdb import InfluxDBClient

from influxdb import SeriesHelper

from apscheduler.schedulers.background import BackgroundScheduler

import PID

from pytz import timezone

import logging

import signal

#TODO

#fix temperature offsets

#add periodic output refresh

# load config file

config = configparser.ConfigParser(allow_no_value = True)

config.read("hydrobot.conf")

# set up logger

logger = logging.getLogger('hydrobot')

log_level = config.get("system", "log_level")

levels = {"CRITICAL" : 50, "ERROR" : 40, "WARNING" : 30, "INFO" : 20, "DEBUG" : 10, "NOTSET" : 0}

logger.setLevel(levels[log_level])

    class Meta:

        # The client should be an instance of InfluxDBClient.

        #client = myclient

        # The series name must be a string. Add dependent fields/tags in curly brackets.

        series_name = '{measurement}'

        # Defines all the fields in this time series.

        fields = ['value']

        # Defines all the tags for the series.

        tags = ['measurement']

        # Defines the number of data points to store prior to writing on the wire.

        bulk_size = 5

        # autocommit must be set to True when using bulk_size

        autocommit = True

class Database:

    def __init__(self):

        host = config.get("database", "host")

        port = config.get("database", "port")

        username = config.get("database", "username")

        password = config.get("database", "password")

        database = config.get("database", "database")

        self.name = config.get("system", "name")

        self.client = InfluxDBClient(host, port, username, password, database)

        MySeriesHelper.Meta.client = self.client

        MySeriesHelper.Meta.series_name = self.name + '.{measurement}'

        # To manually submit data points which are not yet written, call commit:

        #MySeriesHelper.commit()

    def log_data(self, msgdb, message):

        if message == msgdb.AirSense:

            MySeriesHelper(measurement='air_temp', value=(float)(message.Temperature.value))

            MySeriesHelper(measurement='air_humidity', value=(float)(message.Humidity.value))

            MySeriesHelper(measurement='air_pressure', value=(float)(message.Pressure.value))

        if message == msgdb.RelayDriveIn:

            MySeriesHelper(measurement='water_flow_rate', value=(float)(message.FlowRate.value))

            MySeriesHelper(measurement='input_1', value=(float)(message.Input1.value))

            MySeriesHelper(measurement='input_2', value=(float)(message.Input2.value))

            MySeriesHelper(measurement='input_3', value=(float)(message.Input3.value))

            MySeriesHelper(measurement='input_4', value=(float)(message.Input4.value))

        if message == msgdb.WaterSense:

            MySeriesHelper(measurement='water_level', value=(float)(message.PercentFull.value))

            MySeriesHelper(measurement='water_temp', value=(float)(message.Temperature.value))

class CanBus:

    def __init__(self, database):

        self.database = database

        self.dev = socketcan.SocketCanDev("can0")

        self.queue = queue.CanQueue(self.dev)

        parser = jsondb.JsonDbParser()

        self.msgdb = parser.parse('hydrobot_can.json')

        self.temp_msg = self.msgdb.AirSense

        self.relay_msg = self.msgdb.RelayDriveIn

        self.relay_send_msg = self.msgdb.RelayDriveOut

    def start(self):

        self.queue.start()

        _thread.start_new_thread(self.process_can, ())

    def process_can(self):

        while True:

            frame = self.queue.recv()

            if frame != None:

                message = self.msgdb.decode(frame)

                if message:

                    logger.debug("Received CAN message! ID: " + hex(message.id))

                    self.database.log_data(self.msgdb, message)

    def send_can(self):

        self.relay_send_msg.Nothing.value = 0