public void Fts5CommandOptimize([IncludeDataSources(TestProvName.AllSQLite)] string context)
{
using (var db = new TestDataConnection(context))
{
db.AddMappingSchema(SetupFtsMapping(SQLiteFTS.FTS5));
try
{
db.FTS5Optimize(db.GetTable <FtsTable>());
}
catch
{
// we don't have FTS5 table, but we need to get sql for validation
}
finally
{
Assert.AreEqual("INSERT INTO [FTS5_TABLE]([FTS5_TABLE]) VALUES('optimize')", db.LastQuery);
}
}
}