Extract stats

backend/db/crud.py

@@ -44,16 +44,16 @@ def get_stats(place: str, weekday: int, min_time_hour: int, min_time_mn: int, ma
                     60 * func.extract('MINUTE', models.Records.waiting_time) +
                     func.extract('SECOND', models.Records.waiting_time))
             )) / 60
-            ).filter(
-                models.Records.place == place,
-                func.weekday(models.Records.date) == weekday,
-                (func.extract('HOUR', models.Records.date) > start_time.hour) | 
-                    ((func.extract('HOUR', models.Records.date) == start_time.hour) &
-                    (func.extract('MINUTE', models.Records.date) >= start_time.minute)),
-                (func.extract('HOUR', models.Records.date) < end_time.hour) | 
-                    ((func.extract('HOUR', models.Records.date) == end_time.hour) &
-                    (func.extract('MINUTE', models.Records.date) < end_time.minute)),
-            ).one()
+        ).filter(
+            models.Records.place == place,
+            func.weekday(models.Records.date) == weekday,
+                (func.extract('HOUR', models.Records.date) > start_time.hour) |
+            ((func.extract('HOUR', models.Records.date) == start_time.hour) &
+             (func.extract('MINUTE', models.Records.date) >= start_time.minute)),
+            (func.extract('HOUR', models.Records.date) < end_time.hour) |
+            ((func.extract('HOUR', models.Records.date) == end_time.hour) &
+             (func.extract('MINUTE', models.Records.date) < end_time.minute)),
+        ).one()
         if records[0]:
             return int(records[0])
         return None