Ci

backend/db/crud.py

@@ -18,3 +18,9 @@ def create_record(new_record: schemas.RecordBase, db: Session):
     db.commit()
     db.refresh(db_record)
     return db_record
+
+
+def get_waiting_time(place: str, db: Session):
+    """ Get the last estimated waiting time for the given place """
+    db_record = db.query(models.Records).filter(models.Records.place == place).order_by(models.Records.date.desc()).one()
+    return db_record.waiting_time