from datetime import datetime
from typing import List

from database.mongo import mongo_measures


def get_finca_measures(
    station_code: str, start_datetime: datetime, end_datetime: datetime
) -> List:

    finca_data = mongo_measures[station_code]

    _filter = {"date": {"$gt": start_datetime, "$lte": end_datetime}}

    query = finca_data.find(_filter, sort=(("date", 1),))

    measures = []

    for measure in query:
        measures.append(
            {
                "temp": measure["temp"],
                "hum": measure["hum"],
                "precip": measure["precip"],
                "date": measure["date"],
            }
        )

    return measures