Features with a list of values

[AlexTrovato]

We have an increasing number of features that can have different values; not all of them are available on all devices.
In order to provide more precise information about the possible values for a particular feature, we therefore need to be able to know and store these values.

Source thread:

Thermostat avec Zigbee2MQTT

Pour ton information, le eco_mode (binary) n’est disponible que sur un seul device zigbee : Sinon on parle également de : system_mode (enum) : 'off', 'heat', 'cool', 'auto', 'dry', 'fan_only', 'sleep', 'emergency_heating' away_mode (binary) : que se passe-t-il lorsque je suis absent ? regulator_mode (binary) : régulateur vs thermostat Je parle uniquement de ce que j’ai trouvé dans les documentations zigbee2mqtt. Mais je pense qu’on va vite être bloqué si on n’ajoute pas la notion de ‹ …

Here we will discuss possible solutions to carry out this project.

[AlexTrovato]

For a first draft,
I think it would therefore be useful to add an optional list of values managed_values to the model object feature:

{
 device: {
    ...,
    features: [
      {
        name: '...',
        ...,
        last_value: 2,
        managed_values: [0, 1, 2, 7, 8

[pierre-gilles]

@AlexTrovato

I think it would therefore be useful to add an optional list of values managed_values on the model object feature:

I remind you we’re using a relational model, so there are several options for that:

• The relational way would be to create a table device_feature_managed_value that would be in a 1-N relationship with the device_feature table. It’s stricter, but also more cumbersome to manage on insert/delete.
• Or the way you mention, but then you have to serialize/deserialize the array on write/read and store that as a SQLite string. That also opens the door to all sorts of nonsense since you have to handle data consistency in the application layer, and implement any eventual data migrations in JS rather than in SQL.

To be honest, both approaches have their advantages and disadvantages!