Waiting time component

backend/db/crud.py

@@ -17,4 +17,10 @@ def create_record(new_record: schemas.RecordBase, db: Session):
     db.add(db_record)
     db.commit()
     db.refresh(db_record)
-    return db_record
\ No newline at end of file
+    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