Coverage for polar/kit/time_queries.py: 81%
21 statements
« prev ^ index » next coverage.py v7.10.6, created at 2025-12-05 16:17 +0000
1from datetime import date, datetime 1a
2from enum import StrEnum 1a
4from sqlalchemy import ( 1a
5 CTE,
6 Function,
7 SQLColumnExpression,
8 TextClause,
9 cte,
10 func,
11 select,
12 text,
13)
16class TimeInterval(StrEnum): 1a
17 year = "year" 1a
18 month = "month" 1a
19 week = "week" 1a
20 day = "day" 1a
21 hour = "hour" 1a
23 def sql_interval(self) -> TextClause: 1a
24 return text(f"'1 {self.value}'::interval")
26 def sql_date_trunc( 1a
27 self, column: SQLColumnExpression[datetime] | datetime
28 ) -> Function[datetime]:
29 return func.date_trunc(self.value, column)
32def get_timestamp_series_cte( 1a
33 start_timestamp: datetime, end_timestamp: datetime, interval: TimeInterval
34) -> CTE:
35 return cte(
36 select(
37 func.generate_series(
38 start_timestamp, end_timestamp, interval.sql_interval()
39 ).column_valued("timestamp")
40 )
41 )
44MIN_DATETIME = datetime(2023, 1, 1) # Before that, Polar didn't even exist! 🚀 1a
45MIN_DATE = MIN_DATETIME.date() 1a
47MAX_INTERVAL_DAYS: dict[TimeInterval, int] = { 1a
48 TimeInterval.hour: 7,
49 TimeInterval.day: 366,
50 TimeInterval.week: 7 * 53,
51 TimeInterval.month: 365 * 4,
52 TimeInterval.year: 365 * 10,
53}
55MIN_INTERVAL_DAYS: dict[TimeInterval, int] = { 1a
56 TimeInterval.hour: 0,
57 TimeInterval.day: 0,
58 TimeInterval.week: 14,
59 TimeInterval.month: 60,
60 TimeInterval.year: 366,
61}
64def is_under_limits(start_date: date, end_date: date, interval: TimeInterval) -> bool: 1a
65 return end_date.toordinal() - start_date.toordinal() <= MAX_INTERVAL_DAYS[interval]