Shorten `OtaImageWithMetadata` repr to avoid logging fw bytes (#1807)

Fix Identify `EffectIdentifier.Channel_change` (#1800)

Move unsupported attribute marking to event handler (#1796)

Allow quirk loading to fail (#1784)

Bump zigpy-ota schema to v2 (#1782)

Drop pysqlite3-binary in favor of distribution sqlite (#1772)

Co-authored-by: Copilot <[email protected]>

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