sienatime

Description="Bright Material"
Default        = { Colour="#757575" }
Canvas         = { Colour="#FAFAFA" }
Number         = { Colour="#ff9100" }
Escape         = { Colour="#6a5acd" }
String         = { Colour="#ff9100" }
StringPreProc  = { Colour="#ff9100" }
BlockComment   = { Colour="#BDBDBD", Italic=true }
PreProcessor   = { Colour="#9C27B0" }
LineNum        = { Colour="#BDBDBD" }

sienatime

@Database(entities = {
    Entry.class, Sense.class, CrossReference.class, EntryFts.class
}, version = 4, exportSchema = false) public abstract class AppDatabase extends RoomDatabase

sienatime

public LiveData<PagedList<SearchResultEntry>> search(String term) {
  String wildcardQuery = String.format("*%s*", term);
  return new LivePagedListBuilder<>(entryDao.searchByJapaneseTerm(wildcardQuery), PAGE_SIZE).build();
}

sienatime

@Transaction @Query(
      "SELECT entries.id, entries.primary_kanji, entries.primary_reading FROM entries "
          + "JOIN entriesFts ON (entries.id = entriesFts.docid) WHERE entriesFts MATCH :term")
  DataSource.Factory<Integer, SearchResultEntry> searchByJapaneseTerm(String term);

sienatime

@Fts4(contentEntity = Entry.class)
@Entity(tableName = "entriesFts")
public class EntryFts {
  @ColumnInfo(name = "primary_kanji")
  private String primaryKanji;

  @NonNull
  @ColumnInfo(name = "primary_reading")
  private String primaryReading;

sienatime

Room.databaseBuilder(...)
.addMigrations(new Migration(3, 4) {
  @Override public void migrate(@NonNull SupportSQLiteDatabase database) {
    database.execSQL("CREATE VIRTUAL TABLE IF NOT EXISTS `entriesFts` USING FTS4(`primary_kanji`, `primary_reading`, `other_kanji`, `other_readings`, content=`entries`)");
    database.execSQL("INSERT INTO entriesFts(entriesFts) VALUES ('rebuild')");
  }
})
.build();

sienatime

@Database(entities = {
    Entry.class, Sense.class, CrossReference.class, EntryFts.class
}, version = 4, exportSchema = false) public abstract class AppDatabase extends RoomDatabase