* tweaks
* mysql
* mysql
* Update homeassistant/components/recorder/history/modern.py
* Update homeassistant/components/recorder/history/modern.py
* Update homeassistant/components/recorder/const.py
* Update homeassistant/components/recorder/statistics.py
* Apply suggestions from code review
* mysql
* mysql
* cover
* make sure db is fully init on old schema
* fixes
* fixes
* coverage
* coverage
* coverage
* s/slow_dependant_subquery/slow_dependent_subquery/g
* reword
* comment that callers are responsible for staying under the limit
* comment that callers are responsible for staying under the limit
* switch to kwargs
* reduce branching complexity
* split stats query
* preen
* split tests
* split tests
* Update NS integration to show first next train instead of just the first.
* Handle no first or next trip.
* Remove debug statement.
* Remove seconds and revert back to minutes.
* Make use of dt_util.now().
* Fix issue with next train if no first train.
* tweaks
* mysql
* mysql
* Update homeassistant/components/recorder/history/modern.py
* Update homeassistant/components/recorder/history/modern.py
* Update homeassistant/components/recorder/const.py
* Update homeassistant/components/recorder/statistics.py
* Apply suggestions from code review
* mysql
* mysql
* cover
* make sure db is fully init on old schema
* fixes
* fixes
* coverage
* coverage
* coverage
* s/slow_dependant_subquery/slow_dependent_subquery/g
* reword
* comment that callers are responsible for staying under the limit
* comment that callers are responsible for staying under the limit
* switch to kwargs
* reduce branching complexity
* split stats query
* preen
* split tests
* split tests
* Update NS integration to show first next train instead of just the first.
* Handle no first or next trip.
* Remove debug statement.
* Remove seconds and revert back to minutes.
* Make use of dt_util.now().
* Fix issue with next train if no first train.
Add native arm vacation mode support to elkm1
Vacation mode is currently implemented as a custom
service which will be deprecated in a future PR.
Note that the custom service was added long before
HA had a native vacation mode which was added
in #45980
* Treat "Core" as name, fix grammar in `reload_core_config` action
Change three occurrences of "core" to "Core" so they are not translated but kept as a name instead.
Fix singular/plural mismatch in the field description of the `reload_core_config` action.
* Change "us customary" to "US customary"
* Update binary_sensor.py to included OUTDOOR_ALARM_SECURITY_BELL_BOX device type
Add support for DeviceTypes.OUTDOOR_ALARM_SECURITY_BELL_BOX
This is an external siren device in Simplisafe which is not currently discovered with the HA integration
* Fixed formatting error
---------
Co-authored-by: Franck Nijhof <git@frenck.dev>
Make the field descriptions of `source_ieee` and `install_code` UI-friendly by cross-referencing them using their friendly names to allow matching translations.
Better explain the alternative of using the `qr_code` field by adding that this contains both the IEEE address and the Install code of the joining device.