public async Task Database_CreateAndUpdate_UpdatesRunWithoutException()
{
// Arrange
var exampleFile = "UpdateTest.db";
var databaseFileHandler = new DatabaseFileHandler(exampleFile);
databaseFileHandler.DeleteDatabaseIfExists();
var testInfrastructure = new TestInfrastructure();
// Act && Assert
await testInfrastructure.CreateNewUnittestDatabaseAsync(exampleFile);
databaseFileHandler.DeleteDatabaseIfExists();
}
public void Database_Create_GetsCreated()
{
// Arrange
var exampleFile = "CreateFileTest.db";
var databaseFileHandler = new DatabaseFileHandler(exampleFile);
databaseFileHandler.DeleteDatabaseIfExists();
// Act && Assert
var fullexampleFile = Path.Combine(DataDirectories.GetUserApplicationDatabasesDirectory(), exampleFile);
Assert.DoesNotThrow(() => databaseFileHandler.CreateNewDatabase());
Assert.That(File.Exists(fullexampleFile));
databaseFileHandler.DeleteDatabaseIfExists();
}
private DatabaseFileHandler InitializeDatabase(InitializationSettings settings)
{
var databaseFileHandler = new DatabaseFileHandler(settings.DatabaseName);
if (settings.EnforceRecreationOfDatabase || !databaseFileHandler.DatabaseExists())
{
databaseFileHandler.DeleteDatabaseIfExists();
databaseFileHandler.CreateNewDatabase();
}
return(databaseFileHandler);
}
public void Database_Create_ConnectionCouldBeEstablished()
{
// Arrange
var exampleFile = "ConnectionAfterCreateTest.db";
var databaseFileHandler = new DatabaseFileHandler(exampleFile);
databaseFileHandler.DeleteDatabaseIfExists();
// Act && Assert
var fullexampleFile = Path.Combine(DataDirectories.GetUserApplicationDatabasesDirectory(), exampleFile);
Assert.DoesNotThrow(() => databaseFileHandler.CreateNewDatabase());
var fileWasCreated = File.Exists(fullexampleFile);
var connectionWasOpened = false;
using (var connection = databaseFileHandler.OpenConnection())
{
connectionWasOpened = connection.State == ConnectionState.Open;
}
Assert.That(fileWasCreated);
Assert.That(connectionWasOpened);
databaseFileHandler.DeleteDatabaseIfExists();
}
private static void DeleteUnittestDatabase(string databaseName)
{
var fileHandler = new DatabaseFileHandler(databaseName);
fileHandler.DeleteDatabaseIfExists();
}