Commit graph

229 commits

Author SHA1 Message Date
J. Nick Koston
9fbde245d0
Fix performance of logbook entity and devices queries with large MySQL databases (#72898) 2022-06-02 14:54:06 -07:00
J. Nick Koston
5d2326386d
Fix logbook spinner never disappearing when all entities are filtered (#72816) 2022-06-01 12:33:46 +02:00
J. Nick Koston
c365454afb
Revert "Initial orjson support (#72754)" (#72789)
This was causing the wheels to fail to build. We need
to workout why when we don't have release pressure

This reverts commit d9d22a9556.
2022-05-31 13:51:55 -07:00
J. Nick Koston
35ee4ad55b
Prevent live logbook from sending state changed events when we only want device ids (#72780) 2022-05-31 13:08:04 -07:00
J. Nick Koston
935ef79156
Fix queries for logbook context_ids running in the wrong executor (#72778) 2022-05-31 12:24:18 -07:00
J. Nick Koston
d9d22a9556
Initial orjson support (#72754) 2022-05-31 12:18:11 -07:00
J. Nick Koston
5dc4c89acc
Small performance improvement for matching logbook rows (#72750) 2022-05-31 10:41:33 +02:00
J. Nick Koston
587fd05603
Make logbook inherit the recorder filter (#72728) 2022-05-30 17:34:32 -07:00
J. Nick Koston
bfa7693d18
Fixes for logbook filtering and add it to the live stream (#72501) 2022-05-25 15:17:08 -10:00
J. Nick Koston
1c25e1d7b1
Add metadata to logbook live stream websocket endpoint (#72394) 2022-05-23 22:37:47 -07:00
J. Nick Koston
9d95b9ab05
Chunk large logbook queries and add an end_time to the api so we stop sending events (#72351) 2022-05-23 15:40:00 -07:00
J. Nick Koston
0248a8710f
Always pass the source of the trigger for logbook context messages (#72333) 2022-05-23 13:35:45 -05:00
J. Nick Koston
9c3f949165
Add live streaming logbook websocket endpoint (#72258)
Co-authored-by: Paulus Schoutsen <paulus@home-assistant.io>
2022-05-22 14:57:54 -05:00
J. Nick Koston
d459a5c66e
Include context state in logbook responses to improve localization (#72222)
* Include context state in logbook responses to improve localization

* reduce payload, dont send context_event_type if sending context_state
2022-05-20 07:46:01 -07:00
J. Nick Koston
272e65f56d
Fix device_ids being filtered when entities also specified in the logbook (#72122) 2022-05-18 23:27:31 -05:00
J. Nick Koston
985bcb23f2
Fix SAWarning in logbook queries (#72101) 2022-05-18 12:33:58 -05:00
J. Nick Koston
c4fc84ec1e
Add support for selecting device_ids from the logbook (#72039)
Co-authored-by: Paulus Schoutsen <paulus@home-assistant.io>
2022-05-18 01:58:30 -05:00
J. Nick Koston
ec01e00184
Small cleanup to logbook context augmenter (#72043) 2022-05-17 21:10:28 -07:00
Paulus Schoutsen
5433c0a535
Make sure empty get_events results is always a list (#72021) 2022-05-17 10:43:58 -07:00
J. Nick Koston
089eb9960a
Reduce logbook websocket payload size and parse json attributes via the DBM (#71895) 2022-05-15 20:48:57 -07:00
J. Nick Koston
1f753ecd88
Relocate sqlalchemy filter builder to recorder/filters.py (#71883) 2022-05-14 23:04:23 -07:00
J. Nick Koston
8f33437507
Correct typo in internal logbook function names (#71882) 2022-05-14 20:04:31 -07:00
J. Nick Koston
0584e84c30
Add MySQL index hints to logbook (#71864)
* Add MySQL index hints to logbook

* fix mysql query planner
2022-05-14 17:01:36 -05:00
J. Nick Koston
68632cb267
Implement use_include_order in the history websocket api (#71839) 2022-05-14 12:37:35 -07:00
J. Nick Koston
8c2743bb67
Avoid storing last_changed in the database if its the same as last_updated (#71843) 2022-05-14 12:06:31 -07:00
J. Nick Koston
663f6f8340
Complete refactoring of logbook humanify (#71830) 2022-05-13 14:56:16 -07:00
J. Nick Koston
535ae56fe7
Remove unused entity_id argument in logbook context augmenter (#71829) 2022-05-13 13:17:41 -07:00
J. Nick Koston
2a2a7a62c5
Avoid matching entity_id/domain attributes in logbook when there is no entities_filter (#71825) 2022-05-13 13:16:33 -07:00
J. Nick Koston
9bd508c0bf
Generate json for history and logbook websocket responses in the executor (#71813) 2022-05-13 13:17:54 -04:00
J. Nick Koston
d215cdc563
Avoid buffering logbook rows unless we are selecting less than a days worth (#71809) 2022-05-13 09:10:43 -07:00
J. Nick Koston
e7e45209ec
Update stale docstring in logbook (#71814) 2022-05-13 09:07:26 -07:00
J. Nick Koston
24a0007785
Add additional context data to logbook events (#71721) 2022-05-12 17:21:14 -07:00
J. Nick Koston
04af9698d3
Add logbook/get_events websocket endpoint (#71706)
Co-authored-by: Paulus Schoutsen <paulus@home-assistant.io>
2022-05-11 22:28:06 -05:00
J. Nick Koston
19168227eb
Fix sqlalchemy warning about logbook query being converted from subquery (#71710) 2022-05-11 19:30:36 -07:00
J. Nick Koston
81e8d2ab86
Significantly improve logbook performance when selecting entities (#71657) 2022-05-11 15:27:02 -07:00
J. Nick Koston
26177bd080
Convert logbook to use lambda_stmt (#71624) 2022-05-10 08:23:13 -05:00
J. Nick Koston
2560d35f1c
Always show the start and stop event in logbook (#71600) 2022-05-09 15:21:21 -05:00
Erik Montnemery
347193055e
Rename logbook humanify function (#71597)
Co-authored-by: J. Nick Koston <nick@koston.org>
2022-05-09 23:10:26 +03:00
J. Nick Koston
24d7a464e1
Refactor logbook to reduce overhead and complexity (#71509) 2022-05-08 21:47:26 -07:00
J. Nick Koston
8f5e61ee80
Remove logbook split_entity_id caching (#71359) 2022-05-05 11:48:45 -07:00
Erik Montnemery
203bebe668
Include all non-numeric sensor events in logbook (#71331) 2022-05-05 13:16:36 -04:00
J. Nick Koston
0cdcdec809
Speed up and isolate legacy logbook context_id query (#71201) 2022-05-02 09:34:24 -07:00
J. Nick Koston
5db014666c
Avoid recording state_changed events in the events table (#71165)
* squash

fix mypy

* Update homeassistant/components/recorder/models.py

Co-authored-by: Paulus Schoutsen <paulus@home-assistant.io>

* pass all columns

* fix commented out code

* reduce logbook query complexity

* merge

* comment

Co-authored-by: Paulus Schoutsen <paulus@home-assistant.io>
2022-05-02 02:10:34 -05:00
J. Nick Koston
c23866e5e5
De-duplicate event data into a new event_data table (#71135) 2022-05-01 21:01:17 -05:00
J. Nick Koston
b8442d9340
Add json decode caching to logbook (#71080) 2022-05-01 19:33:31 -05:00
J. Nick Koston
3150915cb7
Convert unindexed domain queries to entity_id queries (#68404) 2022-03-20 01:28:17 -10:00
J. Nick Koston
9215702388
Separate attrs into another table (reduces database size) (#68224) 2022-03-18 00:23:13 -10:00
J. Nick Koston
bc862e97ed
Use a dedicated executor pool for database operations (#68105)
Co-authored-by: Erik Montnemery <erik@montnemery.com>
Co-authored-by: Franck Nijhof <git@frenck.dev>
2022-03-17 23:09:01 -10:00
jan iversen
0d8ff3d724
Add codeowner to internal integrations that are without (#67286) 2022-02-28 09:06:16 +01:00
Paulus Schoutsen
1bbc1f5f55
Validate in split_entity_id (#66835) 2022-02-18 16:11:17 -08:00