CheckboxListTile Relationships

[wesleytoshio]

I need to make a list of CheckboxListTile looking for all the favorites and from the noteID check the checkbox, can anyone help me?

//TABLE Relationships many to many
class NoteHasBookmarks extends Table {
  IntColumn get note => integer().customConstraint('NOT NULL REFERENCES notes (id)')();
  IntColumn get bookmark => integer().customConstraint('NOT NULL REFERENCES bookmarks (id)')();

  @override
  Set<Column> get primaryKey => {note, bookmark};
}
//TABLE Bookmarks
class Bookmarks extends Table {
  IntColumn get id => integer().autoIncrement()();
  TextColumn get name => text().nullable()();
  DateTimeColumn get updatedAt => dateTime().nullable()();
}

EX:

[simolus3]

I don't fully understand what you're trying to do here: Which table stores whether an entry should be selected?

[wesleytoshio]

i need select Bookmarks basead on NoteHasBookmarks

// MY TABLE
class NoteHasBookmarks extends Table {
  IntColumn get note =>
      integer().customConstraint('NOT NULL REFERENCES notes (id)')();
  IntColumn get bookmark =>
      integer().customConstraint('NOT NULL REFERENCES bookmarks (id)')();

  @override
  Set<Column> get primaryKey => {note, bookmark};
}
// MY CLASS
class BookmarkWithChecked {
  final Bookmark bookmark;
  final bool checked;

  BookmarkWithChecked (this.bookmark, this.checked);
}
```

[wesleytoshio]

you can help-me?

[simolus3]

So you have a fixed bookmark, and then need to find all notes with that bookmark? I don't understand which query you need based on your screenshot.

[wesleytoshio]

I need a select that searches all favorites, with an isChecked(boolean) value based on my NoteID

[simolus3]

I see, something like this should work then

final isFavorite = existsQuery(select(noteHasBookmarks)..where((row) => row.bookmark.equalsExp(bookmarks.id)));
final query = select(bookmarks)..addColumn(isFavorite);

return query.map((row) => BookmarkWithChecked(row.readTable(bookmarks), row.read(isFavorite)));

[wesleytoshio]

any suggestion?