public void correct_migration_number()
        {
            var dir = CreateTempDir();
            try
            {

                var content = "--sql header comment";
                CreateFile(dir, "20150520.sql", content);
                var source = new FileSystemSource(dir);
                var migrations = source.LoadMigrations().ToList();
                Assert.AreEqual(1, migrations.Count());
                Assert.AreEqual("20150520",migrations.First().Number);
            }
            finally
            {

                Directory.Delete(dir, true);
            }
        }
        public void load_files()
        {
            var dir = CreateTempDir();
            try
            {

                var content = "--sql header comment";
                CreateFile(dir, "20150520.sql", content);
                CreateFile(dir, "20150521.sql", content);
                CreateFile(dir, "20150522.sql", content);
                var source = new FileSystemSource(dir);
                var migrations = source.LoadMigrations().ToList();
                Assert.AreEqual(3, migrations.Count());
                foreach (var migration in migrations)
                {
                    Assert.AreEqual(content, migration.Sql);
                }
            }
            finally
            {

                Directory.Delete(dir,true);
            }
        }