* Restart entity id post migration after a restart
If the entity migration finished and Home Assistant was
restarted during the post migration it would never be resumed
which means the old index and space would never be recovered
* add migration resume test
* Raise an issue for SQL queries that will cause full table scans
* Raise an issue for SQL queries that will cause full table scans
* Raise an issue for SQL queries that will cause full table scans
* Raise an issue for SQL queries that will cause full table scans
* Update homeassistant/components/sql/sensor.py
Co-authored-by: Paulus Schoutsen <balloob@gmail.com>
* coverage
---------
Co-authored-by: Paulus Schoutsen <balloob@gmail.com>
* Fix NMBS AttributeError (Issue #90505)
* Set and use API_FAILURE
* Configure the logger to track API failures
* Remove broad exceptions and rewite logging
* Switch back to using call_later for the slow entity update warning
I had originally changed this to create a task and wait
in #41184 but that does not make sense anymore with newer
cpython as the profile now shows the original method is cheaper
(or I did it wrong the first time)
* fix missing block till done since there is no longer a task being created which would run the event loop once
* Raise an issue for SQL queries that will cause full table scans
* Raise an issue for SQL queries that will cause full table scans
* Raise an issue for SQL queries that will cause full table scans
* Raise an issue for SQL queries that will cause full table scans
* Update homeassistant/components/sql/sensor.py
Co-authored-by: Paulus Schoutsen <balloob@gmail.com>
* coverage
---------
Co-authored-by: Paulus Schoutsen <balloob@gmail.com>
* Fix NMBS AttributeError (Issue #90505)
* Set and use API_FAILURE
* Configure the logger to track API failures
* Remove broad exceptions and rewite logging
* Restart entity id post migration after a restart
If the entity migration finished and Home Assistant was
restarted during the post migration it would never be resumed
which means the old index and space would never be recovered
* add migration resume test
* Allow value_template to be used if json_attributes set
* Set state to None if no value_template and json_attributes used
* Refactor check for no value_template when json_attributes used
* Updated and additional unit test
* Updated to set _attr_native_value and return if value_template is None
* Update unit test docstring
* Updated test docstring based on feedback
* Allow value_template to be used if json_attributes set
* Set state to None if no value_template and json_attributes used
* Refactor check for no value_template when json_attributes used
* Updated and additional unit test
* Updated to set _attr_native_value and return if value_template is None
* Update unit test docstring
* Updated test docstring based on feedback