/// <summary>
/// A test for the successful schema write.
/// </summary>
/// <param name="migrationTable">If not empty then assumes the result should have the
/// migration inserts, otherwise assumes the migration inserts are not scripted.</param>
/// <remarks>
/// The logic for testing the schema writting, with or without the migration inserts, is almost
/// idendical hence it all lives here.
/// </remarks>
private void Success(string migrationTable)
{
// Clean-up the old file.
var resultSchemaFile = Path.Combine(Path.GetTempPath(), "ResultSchema.sql");
if (File.Exists(resultSchemaFile))
{
File.Delete(resultSchemaFile);
}
// Generate the schema.
var schema = new SchemaSql(_connString);
schema.WriteSchemaToFile(resultSchemaFile, migrationTable, null);
// Does the file exist?
Assert.IsTrue(File.Exists(resultSchemaFile));
// Read in the results.
var resultSchemaText = File.ReadAllText(resultSchemaFile);
// Get the intial draft of the expected test. Maybe a little bit of
// a cheat as we assume that the generated schema file matches the
// file that was used to initially create the database with a couple
// date sensative items removed.
var expectedSchemaText = File.ReadAllText(Path.Combine(_baseDirecotry, "Schema.sql"));
// If the migration table is empty then the inserts should NOT be scripted so remove that
// from the expected text.
if (migrationTable == "")
{
expectedSchemaText = expectedSchemaText.Substring(0, expectedSchemaText.IndexOf("-- Migrations", StringComparison.CurrentCultureIgnoreCase));
}
// For some reason SQL Server 2014 always puts one extra newline after it writes a
// stored proce. For example if the orginail file is:
//
// BEGIN
// <stroed proc>
// END
// GO
//
// SQL 2014 will put a newline between the END and the GO. Then if you put
// a new line in the originail file then SQL Server 2014 will add another one.
//
// To fix this problem remove the blank lines from both files before
// comparing them.
expectedSchemaText = Regex.Replace(expectedSchemaText, @"^\s+$[\r\n]*", "", RegexOptions.Multiline);
resultSchemaText = Regex.Replace(resultSchemaText, @"^\s+$[\r\n]*", "", RegexOptions.Multiline);
// Is it what we expect?
Assert.AreEqual(expectedSchemaText, resultSchemaText);
}
private void GenSchemaButton_Click(object sender, EventArgs e)
{
try
{
SchemaSql sch = new SchemaSql(ConnStringTextBox.Text);
sch.WriteSchemaToFile(SchemaFileTextBox.Text, GetMigrationTable(), AddResult);
AddResult("Schema successfully created at: " + SchemaFileTextBox.Text);
}
catch (Exception ex)
{
AddResult("Exception: " + ex.GetBaseException().Message);
}
}
