5a26d4c039e8339d13d0b446dfa1a813657ec61f,homeassistant/components/recorder/purge.py,,purge_old_data,#Any#Any#,12

Before Change

        // will delete the protected state when deleting its associated
        // event. Also, we would be producing NULLed foreign keys otherwise.

        protected_event_ids = session.query(States.event_id).join(
            protected_states, States.state_id == protected_states.c.state_id)\
            .filter(~States.event_id is not None).subquery()

        deleted_rows = session.query(Events) \
            .filter((Events.time_fired < purge_before)) \
            .filter(~Events.event_id.in_(

After Change

                              .group_by(States.entity_id).all()

        protected_state_ids = tuple((state[0] for state in protected_states))
        protected_event_ids = tuple((state[1] for state in protected_states))

        deleted_rows = session.query(States) \
                              .filter((States.last_updated < purge_before)) \
                              .filter(~States.state_id.in_(

Instances