Make `update_attribute` manufacturer code aware (#1760)

* Make `update_attribute` manufacturer code aware

* Add test for manufacturer code `update_attribute` handling

* Remove legacy cache fallback in `_legacy_apply_quirk_attribute_update`

* Adjust comments

* Use `mock_attribute_report` in test

* Mark attribute as unsupported initially

Fix interaction between `is_manufacturer_specific` and `manufacturer_…

…id_override` (#1758)

* Only apply cluster-level `manufacturer_id_override` if the definition asks

* Fix `find_attribute` and add tests

* Update invalid comment and replace with explicit test

* One more explicit test for `is_manufacturer_specific=False` hint

* Typo

* Test commands as well, for coverage

* Skip registry for subclassed `Basic` cluster

* Use correct range for ZCL command IDs

Allow attribute writes to skip updating cache or emitting events (#1757)

* Add `update_cache` to suppress attribute writing events

* Update typing for `update_attribute`

* Add a test

* Reduce indentation

* Thoroughly test

Correctly handle `manufacturer_code=None` for attributes and commands (…

…#1756)

* Correctly handle `manufacturer_code` being `None` vs `UNDEFINED`

* Convert `UNDEFINED` to `None` when storing in cache

* Fix tests

* Add an explicit test for the Sonoff situation

* Drop `_get_effective_manufacturer_code` manufacturer kwarg in appdb

* Address review comments

Suppress ZCL read/update events more granularly (#1754)

* Suppress ZCL read/update events more granularly

* Use the attribute definition where possible

* Deal with reads

* Clean up duplicated logic

* Test reads as well

* Test passthrough

* Suppress read events if attributes are updated instead

* Handle quirks with attribute ID collisions

* Explicitly test the Aqara motion sensor scenario

* Handle quirks swallowing attributes

* Increase coverage

Fix type annotations for Core (#1753)

* Fix type annotations for Core

* Regenerate ignores

* Use `ClassVar` to get tests passing

Accept `None` in `Device.last_seen` setter (#1752)

Accept `None` in `last_seen`

Read OTA info for newly joining devices (#1631)

* Read OTA info for newly joining devices

* Mock individual attribute reads better

* Add a test for reading the OTA `current_file_version` during init

* Add an explicit test for unsupported attributes

Mention ThirdReality (3reality) OTA provider in README (#1726)

Ignore aiosqlite 0.22.0 (#1729)