Ejemplo n.º 1
0
        public void GetVersions_gets_all_versions_from_specified_database_table()
        {
            // Arrange
              string[] expectedVersions = new[] { "1.0", "1.5", "2.0" };

              try
              {
            DbVersionProviderTestUtils.CreateAndFillTable(_TableName, _ColumnName, expectedVersions);

            var dbVersionProvider = new DbVersionProvider(
              new List<DbVersionTableInfo>
            {
              new DbVersionTableInfo
                {
                  TableName = _TableName,
                  ColumnName = _ColumnName
                }
            });

            // Act
            List<string> currentVersions =
              dbVersionProvider.GetVersions(_DbName, _SqlServerName).ToList();

            // Assert
            Assert.AreEqual(expectedVersions.Length, currentVersions.Count());

            foreach (var expectedVersion in expectedVersions)
            {
              Assert.IsTrue(currentVersions.Contains(expectedVersion));
            }
              }
              finally
              {
            DbVersionProviderTestUtils.DropTableIfExists(_TableName);
              }
        }
Ejemplo n.º 2
0
 public void SetUp()
 {
     _dbVersionProvider = new DbVersionProvider(_versionTableInfos);
 }
Ejemplo n.º 3
0
        public void GetVersions_returns_empty_list_when_specified_version_table_was_not_found()
        {
            try
              {
            // Arrange
            DbVersionProviderTestUtils.CreateAndFillTable(_TableName, _ColumnName, new[] { "1.2" });

            var dbVersionProvider = new DbVersionProvider(
              new List<DbVersionTableInfo>
            {
              new DbVersionTableInfo
                {
                  TableName = "OtherTableName",
                  ColumnName = "OtherColumnName"
                }
            });

            // Act
            var versions = dbVersionProvider.GetVersions(_DbName, _SqlServerName);

            // Assert
            Assert.IsFalse(versions.Any());
              }
              finally
              {
            DbVersionProviderTestUtils.DropTableIfExists(_TableName);
              }
        }