sqlQueryCreateFts method

String sqlQueryCreateFts()

Implementation

String sqlQueryCreateFts() => columnsFts.isEmpty
    ? ''
    : '''
  CREATE VIRTUAL TABLE IF NOT EXISTS $nameFts USING fts5(
    ${columnsFts.map(_columnsMapNames).join(', ')},
    content='$name', content_rowid='ROWID'
  );
  CREATE TRIGGER IF NOT EXISTS $_nameFtsI
    AFTER INSERT ON $name BEGIN
    $_sqlQueryCreateFtsI
  END;
  CREATE TRIGGER IF NOT EXISTS $_nameFtsD
    AFTER DELETE ON $name BEGIN
    $_sqlQueryCreateFtsD
  END;
  CREATE TRIGGER IF NOT EXISTS $_nameFtsU
    AFTER UPDATE ON $name BEGIN
    $_sqlQueryCreateFtsD
    $_sqlQueryCreateFtsI
  END;
''';