public void TestCanGenerateVersionCheck() { databaseSchemaVersion = new DatabaseSchemaVersionManager(new DbmsFactory(DBMS, CONNECTION_STRING), "Main", 5); Assert.AreEqual(@"DECLARE @currentDatabaseVersion INTEGER, @errMsg VARCHAR(1000) SELECT @currentDatabaseVersion = MAX(ChangeNumber) FROM changelog WHERE Project = 'Main' IF (@currentDatabaseVersion <> 5) BEGIN SET @errMsg = 'Error: current database version on Project <Main> is not 5, but ' + CONVERT(VARCHAR, @currentDatabaseVersion) RAISERROR (@errMsg, 16, 1) END GO ", databaseSchemaVersion.GenerateVersionCheck()); }
public void TestCanGenerateVersionCheck() { databaseSchemaVersion = new DatabaseSchemaVersionManager(new DbmsFactory(DBMS, CONNECTION_STRING), "Main", 5); Assert.AreEqual(@"DECLARE @currentDatabaseVersion INTEGER, @errMsg VARCHAR(1000) SELECT @currentDatabaseVersion = MAX(change_number) FROM changelog WHERE delta_set = 'Main' IF (@currentDatabaseVersion <> 5) BEGIN SET @errMsg = 'Error: current database version on delta_set <Main> is not 5, but ' + CONVERT(VARCHAR, @currentDatabaseVersion) RAISERROR (@errMsg, 16, 1) END GO ", databaseSchemaVersion.GenerateVersionCheck()); }
public void TestCanGenerateVersionCheck() { databaseSchemaVersion = new DatabaseSchemaVersionManager(new DbmsFactory(DBMS, CONNECTION_STRING), "Main", 5); Assert.AreEqual(@"execute versionCheck('Main', 5, 'changelog');" , databaseSchemaVersion.GenerateVersionCheck()); }
public void TestCanGenerateVersionCheck() { databaseSchemaVersion = new DatabaseSchemaVersionManager(new DbmsFactory(DBMS, CONNECTION_STRING), "Main", 5); Assert.AreEqual(@"execute versionCheck('Main', 5, 'changelog');" , databaseSchemaVersion.GenerateVersionCheck()); }