public void TestGenerate()
{
SetupGenerateTest();
// run all migration on second database
Migrator migrator2 = new Migrator(ConnectionString2, DbPlatform);
migrator2.MigrateAll(typeof(IntegrationTestsBase).Assembly);
// generate base-line migration
var options = new GeneratorOptions
{
Namespace = GetType().Namespace,
IncludedSchemas = { "dbo", "Schema25", "Schema 29" }, // these schemas belong to the Default module
ExcludedTables = { "Order Space" }, // the excluded tables belong other modules
IncludeData = true,
};
SqlMigrationGeneratorFactory factory = new SqlMigrationGeneratorFactory(ConnectionString2);
IGenerator generator = factory.Create(options);
string migration = generator.Generate();
Assert.IsEmpty(generator.Errors);
Assert.IsTrue(migration.Contains("[AggregateMigrationExport"), "The generated migration should be an aggregated migration.");
// compile and execute base-line migration on usual test database
Assembly assembly = Compile(migration);
Migrator migrator = new Migrator(ConnectionString, DbPlatform);
migrator.MigrateAll(assembly, typeof(IntegrationTestsBase).Assembly);
// check if the schema of the two databases is equal
CollectionAssert.AreEqual(_database2.Tables.Cast<Table>().Select(t => t.Name).ToArray(), DatabaseSmo.Tables.Cast<Table>().Select(t => t.Name).ToArray(), "The tables differ.");
IEnumerable<string> script = ScriptDatabase(DatabaseSmo);
IEnumerable<string> script2 = ScriptDatabase(_database2);
CollectionAssert.AreEqual(script2.ToArray(), script.ToArray());
// check if the data was scripted too
VerifyResultsOfAllMigrations();
}
private static void Main()
{
CommandLineOptions options;
CommandLineParser parser;
if (DisplayHelp(Environment.CommandLine, out options, out parser))
{
Console.WriteLine(GetUsageMessage(parser));
Environment.Exit(SuccessExitCode);
}
string connectionString;
string migrationNamespace;
string moduleName;
string versioningTableName;
string versioningTableSchema;
string[] includedSchemas;
string[] excludedTables;
bool includeData;
try
{
ParseCommandLineArguments(options, parser, ConfigurationManager.ConnectionStrings,
out connectionString,
out migrationNamespace,
out moduleName,
out versioningTableName,
out versioningTableSchema,
out includedSchemas,
out excludedTables,
out includeData);
}
catch (InvalidCommandLineArgumentException x)
{
Console.Error.WriteLine(x.Message);
Environment.Exit(x.ExitCode);
throw; // will not be executed; just to satisfy R#
}
var factory = new SqlMigrationGeneratorFactory(connectionString);
var generateOptions = new GeneratorOptions
{
Namespace = migrationNamespace,
ModuleName = moduleName,
VersioningTableName = versioningTableName,
VersioningTableSchema = versioningTableSchema,
IncludeData = includeData,
};
foreach (string includedSchema in includedSchemas)
{
generateOptions.IncludedSchemas.Add(includedSchema);
}
foreach (string excludedTable in excludedTables)
{
generateOptions.ExcludedTables.Add(excludedTable);
}
IGenerator generator = factory.Create(generateOptions);
string migration = generator.Generate();
if (generator.Errors.Any())
{
Console.Error.WriteLine("Following errors have occured:");
Console.Error.WriteLine(string.Join(Environment.NewLine, generator.Errors));
Environment.Exit(UnsuccessfulExitCode);
}
Clipboard.SetText(migration, TextDataFormat.UnicodeText);
Console.WriteLine("The generation of the migration was successful and is now available in your clipboard.");
}
[STAThread] // for setting the clipboard
private static void Main()
{
CommandLineOptions options;
CommandLineParser parser;
if (DisplayHelp(Environment.CommandLine, out options, out parser))
{
Console.WriteLine(GetUsageMessage(parser));
Environment.Exit(SuccessExitCode);
}
string connectionString;
string migrationNamespace;
string moduleName;
string versioningTableName;
string versioningTableSchema;
string[] includedSchemas;
string[] excludedTables;
bool includeData;
try
{
ParseCommandLineArguments(options, parser, ConfigurationManager.ConnectionStrings,
out connectionString,
out migrationNamespace,
out moduleName,
out versioningTableName,
out versioningTableSchema,
out includedSchemas,
out excludedTables,
out includeData);
}
catch (InvalidCommandLineArgumentException x)
{
Console.Error.WriteLine(x.Message);
Environment.Exit(x.ExitCode);
throw; // will not be executed; just to satisfy R#
}
var factory = new SqlMigrationGeneratorFactory(connectionString);
var generateOptions = new GeneratorOptions
{
Namespace = migrationNamespace,
ModuleName = moduleName,
VersioningTableName = versioningTableName,
VersioningTableSchema = versioningTableSchema,
IncludeData = includeData,
};
foreach (string includedSchema in includedSchemas)
{
generateOptions.IncludedSchemas.Add(includedSchema);
}
foreach (string excludedTable in excludedTables)
{
generateOptions.ExcludedTables.Add(excludedTable);
}
IGenerator generator = factory.Create(generateOptions);
string migration = generator.Generate();
if (generator.Errors.Any())
{
Console.Error.WriteLine("Following errors have occured:");
Console.Error.WriteLine(string.Join(Environment.NewLine, generator.Errors));
Environment.Exit(UnsuccessfulExitCode);
}
Clipboard.SetText(migration, TextDataFormat.UnicodeText);
Console.WriteLine("The generation of the migration was successful and is now available in your clipboard.");
}