from sqlalchemy.orm import Session
from sqlalchemy import desc
from . import models, schemas

def get_records(db: Session):
    records = db.query(models.Record).order_by(desc(models.Record.time)).all()
    return records

def create_record(db: Session, record: schemas.RecordCreate):
    db_record = models.Record(
        time=record.time,
        temperature=record.temperature,
        humidity=record.humidity,
        room=record.room
    )

    db.add(db_record)
    db.commit()
    db.refresh(db_record)

    return db_record