Homeassistant

- Throttle multiple requests to the velux gateway ([marcelveldt] - [72974]) ([velux docs])
- Bump wallbox to 0.4.9 ([hesselonline] - [72978]) ([wallbox docs])
- Fix fibaro cover detection ([rappenze] - [72986]) ([fibaro docs])
- Reduce branching in generated lambda_stmts ([bdraco] - [73042]) ([recorder docs])
- Send an empty logbook response when all requested entity_ids are filtered away ([bdraco] - [73046]) ([logbook docs])
- Bump aiolookup to 0.1.1 ([bdraco] - [73048]) ([lookin docs])
- Bump simplisafe-python to 2022.06.0 ([bachya] - [73054]) ([simplisafe docs])
- Fix unhandled exception when RainMachine coordinator data doesn't exist ([bachya] - [73055]) ([rainmachine docs])
- Bump regenmaschine to 2022.06.0 ([bachya] - [73056]) ([rainmachine docs])
- Fix incompatiblity with live logbook and google_assistant ([bdraco] - [73063]) ([logbook docs])
- Fix elk attributes not being json serializable ([gwww] - [73096]) ([elkm1 docs])
- Mark counter domain as continuous to exclude it from logbook ([bdraco] - [73101]) ([logbook docs])
- Tomorrowio utc fix ([lymanepp] - [73102]) ([tomorrowio docs])
- Remove available property from Kodi ([Bikonja] - [73103]) ([kodi docs])
- Point iAlarm XR at PyPI fork ([balloob] - [73143]) ([ialarm_xr docs])
- Fix state_changes_during_period history query when no entities are passed ([bdraco] - [73139]) ([recorder docs])
- Remove unused code from logbook ([bdraco] - [72950]) ([logbook docs])

[72950]: https://github.com/home-assistant/core/pull/72950
[72974]: https://github.com/home-assistant/core/pull/72974
[72978]: https://github.com/home-assistant/core/pull/72978
[72986]: https://github.com/home-assistant/core/pull/72986
[73042]: https://github.com/home-assistant/core/pull/73042
[73046]: https://github.com/home-assistant/core/pull/73046
[73048]: https://github.com/home-assistant/core/pull/73048
[73054]: https://github.com/home-assistant/core/pull/73054
[73055]: https://github.com/home-assistant/core/pull/73055
[73056]: https://github.com/home-assistant/core/pull/73056
[73063]: https://github.com/home-assistant/core/pull/73063
[73096]: https://github.com/home-assistant/core/pull/73096
[73101]: https://github.com/home-assistant/core/pull/73101
[73102]: https://github.com/home-assistant/core/pull/73102
[73103]: https://github.com/home-assistant/core/pull/73103
[73139]: https://github.com/home-assistant/core/pull/73139
[73143]: https://github.com/home-assistant/core/pull/73143
[Bikonja]: https://github.com/Bikonja
[bachya]: https://github.com/bachya
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[gwww]: https://github.com/gwww
[hesselonline]: https://github.com/hesselonline
[lymanepp]: https://github.com/lymanepp
[marcelveldt]: https://github.com/marcelveldt
[rappenze]: https://github.com/rappenze
[elkm1 docs]: https://www.home-assistant.io/integrations/elkm1/
[fibaro docs]: https://www.home-assistant.io/integrations/fibaro/
[ialarm_xr docs]: https://www.home-assistant.io/integrations/ialarm_xr/
[kodi docs]: https://www.home-assistant.io/integrations/kodi/
[logbook docs]: https://www.home-assistant.io/integrations/logbook/
[lookin docs]: https://www.home-assistant.io/integrations/lookin/
[rainmachine docs]: https://www.home-assistant.io/integrations/rainmachine/
[recorder docs]: https://www.home-assistant.io/integrations/recorder/
[simplisafe docs]: https://www.home-assistant.io/integrations/simplisafe/
[tomorrowio docs]: https://www.home-assistant.io/integrations/tomorrowio/
[velux docs]: https://www.home-assistant.io/integrations/velux/
[wallbox docs]: https://www.home-assistant.io/integrations/wallbox/

- Fix statistics_during_period being incorrectly cached ([bdraco] - [72947]) ([history docs])
- Allow `log` template function to return specified `default` on math domain error ([XaF] - [72960])
- Bump pynetgear to 0.10.4 ([starkillerOG] - [72965]) ([netgear docs])
- Bump bimmer_connected to 0.9.4 ([rikroe] - [72973]) ([bmw_connected_drive docs])
- fjaraskupan: Don't filter anything in backend ([elupus] - [72988]) ([fjaraskupan docs])
- Check ISY994 climate for unknown humidity value on Z-Wave Thermostat ([shbatm] - [72990]) ([isy994 docs])
- Fix google calendar bug where expired tokens are not refreshed ([allenporter] - [72994]) ([google docs])
- Provide Sonos media position if duration not available ([jjlawren] - [73001]) ([sonos docs])
- Bump pypck to 0.7.15 ([alengwenus] - [73009]) ([lcn docs])
- Fix missing historical context data in logbook for MySQL and PostgreSQL ([bdraco] - [73011]) ([recorder docs])
- Fix history stats not comparing all times in UTC ([bdraco] - [73040]) ([history_stats docs])

[72947]: https://github.com/home-assistant/core/pull/72947
[72960]: https://github.com/home-assistant/core/pull/72960
[72965]: https://github.com/home-assistant/core/pull/72965
[72973]: https://github.com/home-assistant/core/pull/72973
[72988]: https://github.com/home-assistant/core/pull/72988
[72990]: https://github.com/home-assistant/core/pull/72990
[72994]: https://github.com/home-assistant/core/pull/72994
[73001]: https://github.com/home-assistant/core/pull/73001
[73009]: https://github.com/home-assistant/core/pull/73009
[73011]: https://github.com/home-assistant/core/pull/73011
[73040]: https://github.com/home-assistant/core/pull/73040
[XaF]: https://github.com/XaF
[alengwenus]: https://github.com/alengwenus
[allenporter]: https://github.com/allenporter
[bdraco]: https://github.com/bdraco
[elupus]: https://github.com/elupus
[jjlawren]: https://github.com/jjlawren
[rikroe]: https://github.com/rikroe
[shbatm]: https://github.com/shbatm
[starkillerOG]: https://github.com/starkillerOG
[bmw_connected_drive docs]: https://www.home-assistant.io/integrations/bmw_connected_drive/
[fjaraskupan docs]: https://www.home-assistant.io/integrations/fjaraskupan/
[google docs]: https://www.home-assistant.io/integrations/google/
[history docs]: https://www.home-assistant.io/integrations/history/
[history_stats docs]: https://www.home-assistant.io/integrations/history_stats/
[isy994 docs]: https://www.home-assistant.io/integrations/isy994/
[lcn docs]: https://www.home-assistant.io/integrations/lcn/
[netgear docs]: https://www.home-assistant.io/integrations/netgear/
[recorder docs]: https://www.home-assistant.io/integrations/recorder/
[sonos docs]: https://www.home-assistant.io/integrations/sonos/

- Cleanup and use new MQTT_BASE_SCHEMA constants ([jbouwh] - [72283]) ([mqtt docs])
- Move MQTT config schemas and client to separate modules ([emontnemery] - [71995]) ([mqtt docs])
- Update MQTT tests to use the config entry setup ([jbouwh] - [72373]) ([mqtt docs])
- Remove announce workaround for Sonos ([jjlawren] - [72854]) ([sonos docs])
- Update frontend to 20220601.0 ([bramkragten] - [72855]) ([frontend docs])
- Ensure recorder shuts down when its startup future is canceled out from under it ([bdraco] - [72866]) ([recorder docs])
- Fix logbook not setting up with an recorder filter that has empty fields ([bdraco] - [72869]) ([recorder docs]) ([logbook docs])
- Only present history_stats state as unknown if the time is in the future ([bdraco] - [72880]) ([history_stats docs])
- Fix migration of MySQL data when InnoDB is not being used ([bdraco] - [72893]) ([recorder docs])
- Fix performance of logbook entity and devices queries with large MySQL databases ([bdraco] - [72898]) ([logbook docs])
- Fix reload of MQTT yaml config ([emontnemery] - [72901]) ([mqtt docs])
- Bump yolink-api to 0.0.6 ([matrixd2] - [72903]) ([yolink docs])
- Fix logging & exit code reporting to S6 on HA shutdown ([nojocodex] - [72921])
- Fix bug in caldav and avoid unnecessary copy of dataclass ([allenporter] - [72922]) ([caldav docs])
- Fix Hive authentication ([KJonline] - [72929]) ([hive docs])
- Only sync when HA is started up as we already sync at startup ([balloob] - [72940]) ([cloud docs])
- Fix misalignments between sql based filtering with the entityfilter based filtering ([bdraco] - [72936]) ([recorder docs])
- Only create auto comfort entities for BAF devices that support them ([bdraco] - [72948]) ([baf docs])

[71995]: https://github.com/home-assistant/core/pull/71995
[72283]: https://github.com/home-assistant/core/pull/72283
[72373]: https://github.com/home-assistant/core/pull/72373
[72854]: https://github.com/home-assistant/core/pull/72854
[72855]: https://github.com/home-assistant/core/pull/72855
[72866]: https://github.com/home-assistant/core/pull/72866
[72869]: https://github.com/home-assistant/core/pull/72869
[72880]: https://github.com/home-assistant/core/pull/72880
[72893]: https://github.com/home-assistant/core/pull/72893
[72898]: https://github.com/home-assistant/core/pull/72898
[72901]: https://github.com/home-assistant/core/pull/72901
[72903]: https://github.com/home-assistant/core/pull/72903
[72921]: https://github.com/home-assistant/core/pull/72921
[72922]: https://github.com/home-assistant/core/pull/72922
[72929]: https://github.com/home-assistant/core/pull/72929
[72936]: https://github.com/home-assistant/core/pull/72936
[72940]: https://github.com/home-assistant/core/pull/72940
[72948]: https://github.com/home-assistant/core/pull/72948
[KJonline]: https://github.com/KJonline
[allenporter]: https://github.com/allenporter
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[bramkragten]: https://github.com/bramkragten
[emontnemery]: https://github.com/emontnemery
[jbouwh]: https://github.com/jbouwh
[jjlawren]: https://github.com/jjlawren
[matrixd2]: https://github.com/matrixd2
[nojocodex]: https://github.com/nojocodex
[baf docs]: https://www.home-assistant.io/integrations/baf/
[caldav docs]: https://www.home-assistant.io/integrations/caldav/
[cloud docs]: https://www.home-assistant.io/integrations/cloud/
[frontend docs]: https://www.home-assistant.io/integrations/frontend/
[history_stats docs]: https://www.home-assistant.io/integrations/history_stats/
[hive docs]: https://www.home-assistant.io/integrations/hive/
[logbook docs]: https://www.home-assistant.io/integrations/logbook/
[mqtt docs]: https://www.home-assistant.io/integrations/mqtt/
[recorder docs]: https://www.home-assistant.io/integrations/recorder/
[sonos docs]: https://www.home-assistant.io/integrations/sonos/
[yolink docs]: https://www.home-assistant.io/integrations/yolink/

https://www.home-assistant.io/blog/2022/06/01/release-20226/

- Ensure the statistics_meta table is using the dynamic row format (bdraco - 72784)
- Improve cast HLS detection (emontnemery - 72787)
- Stringify mikrotik device_tracker name (emontnemery - 72788)
- Sync entities when enabling/disabling Google Assistant (balloob - 72791)
- Fix 72749 (dgomes - 72794)
- Support add/next/play/replace enqueue options in Sonos (jjlawren - 72800)

- Add empty string to list of invalid states (eyager1 - 72590)
- Fix SmartThings issue with unique_id (alexeyzimarev - 72715)
- Fix hive authentication process (KJonline - 72719)
- Alter RainMachine to not create entities if the underlying data is missing (bachya - 72733)
- Small performance improvement for matching logbook rows (bdraco - 72750)
- Make zone condition more robust by ignoring unavailable and unknown entities (exxamalte - 72751)
- Improve integration sensor's time unit handling (emontnemery - 72759)
- Bump ZHA quirks lib to 0.0.75 (dmulcahey - 72765)
- Update frontend to 20220531.0 (bramkragten - 72775)
- Fix queries for logbook context_ids running in the wrong executor (bdraco - 72778)
- Don't set headers kwargs multiple times (elupus - 72779)
- Prevent live logbook from sending state changed events when we only want device ids (bdraco - 72780)