public void GenerateDeployScript_should_generate_correct_script_on_disk() { var generator = new SqlScriptGenerator(); SqlScriptingInput input = generator.GetSqlScriptingInput(@"dsql02.ada-dev.nl\v2012", @"SMS"); input.RootFolder = @"C:\Temp\Generated"; SqlDeployScriptResult result = generator.GenerateDeployScript(input); string template = Assembly.GetExecutingAssembly().GetFileAsString("Research.EndToEndTests.CodeGeneration.SqlScriptGeneratorTester_GenerateDatabaseDeployScript_result.cmd"); string content = string.Format(template, result.Schemas, result.Tables, result.Functions, result.StoredProcedures); var file = new FileInfoDto { Path = Path.Combine(input.RootFolder, "Deploy.cmd") }; file.Content = content; var fs = new FileSystem(); Task deleteDirectoryTask = fs.DeleteDirectoryAsync(input.RootFolder); deleteDirectoryTask.Wait(); Task generateFilesTask = fs.GenerateFileAsync(file); generateFilesTask.Wait(); Assert.AreEqual(true, true); }
public void GenerateSqlScripts_should_generate_correct_scripts_on_disk() { var generator = new SqlScriptGenerator(); SqlScriptingInput input = generator.GetSqlScriptingInput(@"dsql02.ada-dev.nl\v2012", @"Cris"); input.RootFolder = @"C:\Temp\Generated"; SqlScriptingResult result = generator.GenerateSqlScripts(input); var fs = new FileSystem(); Task deleteDirectoryTask = fs.DeleteDirectoryAsync(input.RootFolder); deleteDirectoryTask.Wait(); Task generateFilesTask = fs.GenerateFilesAsync(result.Scripts); generateFilesTask.Wait(); Assert.AreEqual(true, true); }
public static void Main(string[] args) { var generator = new SqlScriptGenerator(); string server = ConfigurationManager.AppSettings["Server"]; string database = ConfigurationManager.AppSettings["Database"]; string generatedScriptsPath = ConfigurationManager.AppSettings["GeneratedScriptsPath"]; SqlScriptingInput input = generator.GetSqlScriptingInput(server, database); input.RootFolder = generatedScriptsPath; SqlScriptingResult result = generator.GenerateSqlScripts(input); var fs = new FileSystem(); Task deleteDirectoryTask = fs.DeleteDirectoryAsync(input.RootFolder); deleteDirectoryTask.Wait(); Task generateFilesTask = fs.GenerateFilesAsync(result.Scripts); generateFilesTask.Wait(); }