public void Returns_5_when_the_max_version_is_5()
        {
            var retriever = GetDatabaseRetrieverThatReturnsThisValueFromThisSqlStatement(5,
                                                                                         "SELECT MAX([version]) FROM [schema_migrations]");

            var result = new DatabaseVersionChecker(retriever).GetCurrentVersion();

            Assert.AreEqual(5, result);
        }
        public void Returns_4_when_the_previous_version_is_4()
        {
            var retriever = GetDatabaseRetrieverThatReturnsThisValueFromThisSqlStatement(4,
                                                                                         "SELECT MAX([version]) FROM [schema_migrations] WHERE [version] <> 5");

            var result = new DatabaseVersionChecker(retriever).GetPreviousDatabaseVersion(5);

            Assert.AreEqual(4, result);
        }