from models import db, Data, averageperhour, averageperday
from app import app
import statistics


def avph(offset, count):
    offset = int(offset)
    count = int(count)

    for i in range(100):
        offset = i*6
        print(offset)
        with app.app_context():
            data = db.session.query(Data).order_by(Data.id.desc()).slice(offset, offset + count).all()
            print(data)
            tmp1dict = []
            hum1dict = []
            tmp2dict = []
            hum2dict = []

            for item in data:
                tmp1dict.append(item.temp1)
                hum1dict.append(item.vlaz1)
                tmp2dict.append(item.temp2)
                hum2dict.append(item.vlaz2)

            temp1average = statistics.mean(tmp1dict)
            hum1average = statistics.mean(hum1dict)
            temp2average = statistics.mean(tmp2dict)
            hum2average = statistics.mean(hum2dict)

            newData = db.session.add(averageperhour(
                temp1=temp1average,
                vlaz1=hum1average,
                temp2=temp2average,
                vlaz2=hum2average
            ))
            db.session.commit()
        print(i)


if __name__ == '__main__':
    avph(6, 6)