Is not serialized by SQLite on complex field

[KiddoV]

I ran into two issues when using Brick + SQLite:

Serialization of nested objects with custom generators

@Sqlite(
  columnType: Column.text,
  fromGenerator: "PhoneMeta.fromJson(jsonDecode(%DATA_PROPERTY%))",
  toGenerator: "%INSTANCE_PROPERTY% == null ? null : jsonEncode(%INSTANCE_PROPERTY%?.toJson())"
)
final PhoneMeta? phone;

When select I got an error

WherePhrase([
  Where.exact("creatorId", currUser.localId),
  WherePhrase([
    Or("email").isExactly(email),
    Or("phone").isExactly(phone) // <<<====
  ])
])

Invalid argument(s): Field phone on Person is not serialized by SQLite

Isn't I already define it as text type column. Why is it still throw error?

[KiddoV]

I noticed my field was skipped in fieldsToSqliteColumns... Hmmm. I wonder why?

[KiddoV]

@tshedor Can you tell if this is a bug?

[mark-brin]

seem like you have a field with custom serialization using fromGenerator and toGenerator to convert PhoneMeta objects to/from JSON strings in SQLite. however, whn u try to query using this field directly in a where clause, brick throws the error Invalid argument(s): Field phone on Person is not serialized by SQLite

u can try query by a simple field instead, or use a computed/transient field

[KiddoV]

@mark-brin The problem is, my generated code does not include field phone at all in fieldsToSqliteColumns or fieldsToSupabaseColumns. Without that, I cannot query anything from those fields. Not sure why is it missing...

These fields are not included in final generated code...

  @Supabase(fromGenerator: "PhoneMeta.fromJson(jsonDecode(%DATA_PROPERTY%))", toGenerator: "%INSTANCE_PROPERTY%?.toJson()")
  @Sqlite(columnType: Column.text, fromGenerator: "PhoneMeta.fromJson(jsonDecode(%DATA_PROPERTY%))", toGenerator: "%INSTANCE_PROPERTY% == null ? null : jsonEncode(%INSTANCE_PROPERTY%?.toJson())")
  final PhoneMeta? phone;

  @Supabase(fromGenerator: "byteaDecode(%DATA_PROPERTY%)")
  @Sqlite(columnType: Column.blob, fromGenerator: "Uint8List.fromList(List<int>.from(%DATA_PROPERTY%))")
  final Uint8List? avatar;

  @Supabase(fromGenerator: "PhysAddress.fromJson(jsonDecode(%DATA_PROPERTY%))", toGenerator: "%INSTANCE_PROPERTY%?.toJson()")
  @Sqlite(columnType: Column.text, fromGenerator: "PhysAddress.fromJson(jsonDecode(%DATA_PROPERTY%))", toGenerator: "%INSTANCE_PROPERTY% == null ? null : jsonEncode(%INSTANCE_PROPERTY%?.toJson())")
  final PhysAddress? address;

What did I do wrong?

[KiddoV]

This solved by using extends OfflineFirstSerdes<Map<String, dynamic>, String> for the custom field class.

But I wonder why is the avatar field still doesn't make it to fieldsToSupabaseColumns or fieldsToSqliteColumns?

  @Supabase(fromGenerator: "byteaDecode(%DATA_PROPERTY%)", toGenerator: "byteaEncode(%INSTANCE_PROPERTY%)")
  @Sqlite(columnType: Column.blob)
  final Uint8List? avatar;

@tshedor can you tell me why?