How to query with enum column?

[PandaGeek1024]

Hi, I have a column with an enum converter. How do I query with this enum column?
Here is my code:

enum SyncStatus { deleted, created, updated }

class SyncStatusConverter implements TypeConverter<SyncStatus, String> {
  const SyncStatusConverter();

  @override
  SyncStatus? mapToDart(String? fromDb) {
    if (fromDb == null) {
      return null;
    }
    return SyncStatus.values.firstWhere((element) =>describeEnum(element) == fromDb);
  }

  @override
  String? mapToSql(SyncStatus? value) {
    if (value == null) {
      return null;
    }
    return describeEnum(value);
  }
}

Table:
TextColumn get status => text().map(const SyncStatusConverter())();

// Is it the right way to query?
query.where((entity) => entity.status.equals(describeEnum(SyncStatus.deleted)));

[simolus3]

Yes, that should work. In moor 4.4 you can also use equalsValue(SyncStatus.deleted) which will apply the type converter by default.

[PandaGeek1024]

thanks, you have done really awesome work. Do you have a donation channel? wish i can contribute a bit to support you.