1.29.0

Added

• New flowmachine query CalendarActivity, which retrives subscribers pattern of active days
• New flowmachine queries PerValueAggregate and RedactedPerValueAggregate, which group by the value column of another query and apply an aggregate to subscribers with that grouping.
• New flowapi queries and flowclient functions for calendar_activity and localised_calendar_activity, which return counts of subscribers per sequence of active days, and per sequence of active days additionally grouped by the subscribers reference location
• Added new StringStatistic enum, which enumerates valid statistics for use with postgres string types

Changed

• HistogramAggregation has moved to flowmachine.features.nonspatial_aggregates
• Statistic moved to flowmachine.core.statistic_types
• TotalActivePeriodsSubscriber no longer returns an extra inactive_periods column

What's Changed

• Bump certifi from 2024.2.2 to 2024.7.4 in /flowclient by @dependabot in #6688
• Bump certifi from 2024.2.2 to 2024.7.4 in /flowauth by @dependabot in #6689
• Bump certifi from 2024.2.2 to 2024.7.4 in /flowkit_jwt_generator by @dependabot in #6690
• Bump certifi from 2024.6.2 to 2024.7.4 in /flowmachine by @dependabot in #6691
• Bump approvaltests from 12.2.1 to 14.0.0 in /flowmachine by @dependabot in #6692
• Bump python deps and base images by @jc-harrison in #6696
• Bump cachetools from 5.3.3 to 5.4.0 in /flowmachine by @dependabot in #6699
• Bump pytest-asyncio from 0.23.7 to 0.23.8 in /flowmachine by @dependabot in #6700
• Bump pyarrow from 16.1.0 to 17.0.0 in /flowdb/testdata/synthetic_data by @dependabot in #6702
• Bump structlog from 24.2.0 to 24.4.0 in /flowmachine by @dependabot in #6701
• Bump shapely from 2.0.4 to 2.0.5 in /flowmachine by @dependabot in #6698
• Bump pytest-asyncio from 0.23.7 to 0.23.8 in /flowapi by @dependabot in #6704
• Bump structlog from 24.2.0 to 24.4.0 in /flowapi by @dependabot in #6705
• Bump structlog from 24.2.0 to 24.4.0 in /flowauth by @dependabot in #6706
• Bump pytest from 8.2.2 to 8.3.1 in /flowmachine by @dependabot in #6708
• Bump numpy from 2.0.0 to 2.0.1 in /flowdb/testdata/synthetic_data by @dependabot in #6709
• Bump cryptography from 42.0.8 to 43.0.0 in /flowapi by @dependabot in #6711
• Bump pytest from 8.2.2 to 8.3.1 in /flowapi by @dependabot in #6712
• Bump pytest from 8.2.2 to 8.3.1 in /flowkit_jwt_generator by @dependabot in #6713
• Bump cryptography from 42.0.8 to 43.0.0 in /flowkit_jwt_generator by @dependabot in #6714
• Bump deps by @jc-harrison in #6715
• Bump pytest from 8.3.1 to 8.3.2 in /flowapi by @dependabot in #6716
• Bump pytest from 8.3.1 to 8.3.2 in /flowmachine by @dependabot in #6717
• Bump pytest from 8.3.1 to 8.3.2 in /flowkit_jwt_generator by @dependabot in #6718
• Bump structlog from 24.2.0 to 24.4.0 in /flowdb/testdata/synthetic_data by @dependabot in #6703
• Bump deps by @jc-harrison in #6725
• Bump husky from 9.0.11 to 9.1.4 in /flowauth/frontend by @dependabot in #6726
• Bump prettier from 3.3.2 to 3.3.3 in /flowauth/frontend by @dependabot in #6721
• Bump black from 24.3.0 to 24.4.2 in /flowkit_jwt_generator by @dependabot in #6527
• Bump cypress from 13.12.0 to 13.13.1 in /flowauth/frontend by @dependabot in #6729
• Revert fdw back to main branch pending a new release by @greenape in #6750
• Bump watchdog from 4.0.1 to 4.0.2 in /flowmachine by @dependabot in #6753
• Bump pyzmq from 26.0.3 to 26.1.0 in /flowmachine by @dependabot in #6735
• Bump redis from 5.0.7 to 5.0.8 in /flowmachine by @dependabot in #6727
• Bump python-rapidjson from 1.19 to 1.20 in /flowmachine by @dependabot in #6746
• Bump pyyaml from 6.0.1 to 6.0.2 in /flowmachine by @dependabot in #6749
• Bump sqlalchemy from 2.0.31 to 2.0.32 in /flowmachine by @dependabot in #6747
• Bump black from 24.4.2 to 24.8.0 in /flowmachine by @dependabot in #6736
• Bump deps by @jc-harrison in #6754
• Bump black from 24.4.2 to 24.8.0 in /flowdb by @dependabot in #6737
• Bump black from 24.4.2 to 24.8.0 in /flowkit_jwt_generator by @dependabot in #6734
• Bump pyyaml from 5.3.1 to 6.0.2 in /flowapi by @dependabot in #6748
• Bump cypress from 13.13.1 to 13.13.3 in /flowauth/frontend by @dependabot in #6758
• Calendar activity by @greenape in #6756

Full Changelog: 1.28.1...1.29.0