public void ShouldUpgradeFrom1ToLatest()
{
DatabaseTestSetup.SetupSqlServer(ConnectionStrings.SqlServer, schemaVersion: 1);
using (var c = new SqlConnection(ConnectionStrings.SqlServer))
c.Execute("INSERT INTO HangfireConfiguration.Configuration ([Key], Value) VALUES ('GoalWorkerCount', 52)");
install();
Assert.AreEqual(52, read().Single().GoalWorkerCount);
Assert.AreEqual(HangfireConfigurationSchemaInstaller.SchemaVersion, version());
}
public void Setup()
{
if (_isSqlServer)
{
DatabaseTestSetup.SetupSqlServer(ConnectionString);
}
else
{
DatabaseTestSetup.SetupPostgres(ConnectionString);
}
}
public void ShouldUpgradeFrom2To3()
{
DatabaseTestSetup.SetupSqlServer(ConnectionStrings.SqlServer, schemaVersion: 2);
Assert.AreEqual(2, version());
using (var c = new SqlConnection(ConnectionStrings.SqlServer))
{
c.Execute(@"INSERT INTO HangfireConfiguration.Configuration (ConnectionString) VALUES (@ConnectionString)", new values());
c.Execute(@"INSERT INTO HangfireConfiguration.Configuration (ConnectionString) VALUES (@ConnectionString)", new values());
}
install(3);
Assert.AreEqual(DefaultConfigurationName.Name(), read().First().Name);
Assert.AreEqual(3, version());
}
public void ShouldUpgradeFrom2ToLatest()
{
DatabaseTestSetup.SetupSqlServer(ConnectionStrings.SqlServer, schemaVersion: 2);
Assert.AreEqual(2, version());
using (var c = new SqlConnection(ConnectionStrings.SqlServer))
c.Execute(@"
INSERT INTO
HangfireConfiguration.Configuration
(ConnectionString, SchemaName, GoalWorkerCount, Active)
VALUES (@ConnectionString, @SchemaName, @GoalWorkerCount, @Active)
", new values {
GoalWorkerCount = 99
});
install();
Assert.AreEqual(99, read().Single().GoalWorkerCount);
Assert.AreEqual(HangfireConfigurationSchemaInstaller.SchemaVersion, version());
}
public void ShouldInstallSchemaVersion3()
{
DatabaseTestSetup.SetupSqlServer(ConnectionStrings.SqlServer, schemaVersion: 3);
Assert.AreEqual(3, version());
}