public void SetTableAutoIncrementStartTest()
{
using (var ds = new SQLiteDatastore())
{
ds.Execute("CREATE TABLE tbl (id INTEGER PRIMARY KEY AUTOINCREMENT);");
ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(0);
ds.Execute("INSERT INTO tbl DEFAULT VALUES;");
ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(1);
ds.SetTableAutoIncrementStart("tbl", 100);
ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(1);
ds.Execute("INSERT INTO tbl DEFAULT VALUES;");
ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(101);
}
}
