GenerateVersionCheck() public method

public GenerateVersionCheck ( ) : string
return string
DatabaseSchemaVersionManager Class Documentation
Exemplo n.º 1
0
        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());
        }
Exemplo n.º 2
0
		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());
		}
Exemplo n.º 3
0
 public void TestCanGenerateVersionCheck()
 {
     databaseSchemaVersion = new DatabaseSchemaVersionManager(new DbmsFactory(DBMS, CONNECTION_STRING), "Main", 5);
     Assert.AreEqual(@"execute versionCheck('Main', 5, 'changelog');"
     , databaseSchemaVersion.GenerateVersionCheck());
 }
Exemplo n.º 4
0
 public void TestCanGenerateVersionCheck()
 {
     databaseSchemaVersion = new DatabaseSchemaVersionManager(new DbmsFactory(DBMS, CONNECTION_STRING), "Main", 5);
     Assert.AreEqual(@"execute versionCheck('Main', 5, 'changelog');"
                     , databaseSchemaVersion.GenerateVersionCheck());
 }