Refactor group state logic #188504

Job	Run time
Collect information & changes data	14s
Prepare dependencies (3.12)	12s
Prepare pre-commit base	12s
Check other linters	54s
Check ruff-format	14s
Check ruff	12s
Check pylint	8m 28s
Check hassfest	32s
Check mypy	2m 15s
Check all requirements	21s
Split tests for full run	6m 2s
Run postgres:12.14 tests Python 3.12	10m 9s
Run mariadb:10.3.32 tests Python 3.12	9m 7s
Run tests Python ${{ matrix.python-version }} (${{ matrix.group }})	0s
Run postgres:15.2 tests Python 3.12	10m 46s
Run mariadb:10.6.10 tests Python 3.12	9m 20s
Run mariadb:10.10.3 tests Python 3.12	9m 48s
Run mariadb:10.11.2 tests Python 3.12	9m 41s
Run mysql:8.0.32 tests Python 3.12	12m 51s
Upload test coverage to Codecov (partial suite)	0s
Run tests Python 3.12 (1)	6m 53s
Run tests Python 3.12 (2)	6m 11s
Run tests Python 3.12 (3)	5m 57s
Run tests Python 3.12 (4)	10m 39s
Run tests Python 3.12 (5)	9m 57s
Run tests Python 3.12 (6)	10m 49s
Run tests Python 3.12 (7)	8m 12s
Run tests Python 3.12 (8)	9m 35s
Run tests Python 3.12 (9)	11m 18s
Run tests Python 3.12 (10)	10m 58s
Upload test coverage to Codecov (full suite)	20s
	3h 2m 7s

Provide feedback