public void Inserts_HappyPath()
{
ISqlLiteService service = new SqlLiteService(TestHelper.GetAppConfiguration());
var inserts = service.Inserts(200);
inserts.ToString();
Assert.IsTrue(inserts.Length > 5000, "The inserts scripts are incorrect.");
}
public void Creates_HappyPath()
{
using (var conn = new SqlCacheConnection(TestHelper.GetAppConfiguration().ConnectionString))
{
System.IO.File.WriteAllLines(@"C:\temp\Humanitas.sql", conn.DbScripts());
}
ISqlLiteService service = new SqlLiteService(TestHelper.GetAppConfiguration());
var creates = service.CreatesTables();
var tables = service.Tables();
foreach (var table in tables)
{
Assert.IsTrue(creates.Contains($"CREATE TABLE IF NOT EXISTS {table}"), $"The create script for table '{table}' was not found.");
}
}
