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();
}