Remove lower bound for start time state query
With the new query in #133553 we do not need a lower bound
on the search since it will always use index now and we
always want the newest value in the index before the
provided timestamp. The lower bound is redudant at this
point as it will always be older than the oldest
time point for the state. It only made sense when
the query would have had to examine a time window
of states instead of doing an index only search.
* Change 'GSuite' to 'Workspace', fix 'Start' field label
Several years ago Google renamed "G Suite" to "Google Workspace", this commit applies the same change to one of the field descriptions of the set_vacation action.
In addition the "Start" field of the action currently uses the common action (!) for Start which is wrong in this context, it stands for the beginning here.
This commit changes this back to a local definition of this label just like "End".
In German for example "Start" needs to be "Beginn" in this context while the common action is translated as "Starten".
* Use "Google Workspace" for more clarity
Co-authored-by: Joost Lekkerkerker <joostlek@outlook.com>
---------
Co-authored-by: Joost Lekkerkerker <joostlek@outlook.com>
Several KNX actions contain a wrong "s" at the end of their verbs while those are missing in several of the descriptions.
This commit changes all those to make them consistent with the remaining actions in KNX and the standard terminology in Home Assistant.
* Improve field descriptions for Download file action
Currently two of the field descriptions for the Download file action don't explain exactly what should be entered but rather explain these like additional actions.
The third, the Overwrite file option is misleading as it does not refer to an existing file.
This commit fixes both issues by explaining the purpose of all three fields in a slightly more detailed fashion.
* Update homeassistant/components/downloader/strings.json
Co-authored-by: Josef Zweck <josef@zweck.dev>
* Update homeassistant/components/downloader/strings.json
Co-authored-by: Josef Zweck <josef@zweck.dev>
---------
Co-authored-by: Josef Zweck <josef@zweck.dev>
The two actions enable_motion_recording and disable_motion_recording use "Enables" and "Disables" in their names.
This is inconsistent with the name of the actions, all other actions of this component, and the standard way of naming them, too.
In addition the description of the latter misses the "s" which causes additional inconsistency – especially in translations.
* Ensure indices needed by data migrators exist
* Update test
* Improve test
* Ignore index error on char(0) columns
* Adjust tests
* Address review comments
* Add comment motivating magic number
Joakim SørensenandGitHub
G JohanssonandGitHub
ManuandGitHub
J. Nick KostonandGitHub
Christopher FennerandGitHub
QuentameandGitHub
Jan-Philipp BeneckeandGitHub
Joost LekkerkerkerandGitHub
adam-the-heroandGitHub
Abílio CostaandGitHub
Marcel van der VeldtandGitHub
epenetandGitHub
Andrew JacksonandGitHub
Allen PorterandGitHub
Erik MontnemeryandGitHub
Josef ZweckandGitHub
Noah HusbyandGitHub
Stefan AgnerandGitHub
Franck NijhofandGitHub
starkillerOGandGitHub