static int Main(string[] args)
{
try
{
Paths.InitializeRhetosServerRootPath(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ".."));
string connectionString = SqlUtility.ConnectionString;
Console.WriteLine("SQL connection string: " + SqlUtility.MaskPassword(connectionString));
var sqlExecuter = GetSqlExecuterImplementation(connectionString);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), sqlExecuter);
databaseCleaner.DeleteAllMigrationData();
return 0;
}
catch (Exception ex)
{
Console.WriteLine();
DeploymentUtility.WriteError(ex.Message);
Console.WriteLine("Details:");
Console.WriteLine(ex);
if (Environment.UserInteractive)
Thread.Sleep(3000);
return 1;
}
}
public DatabaseDeployment(
ILogProvider logProvider,
ISqlExecuter sqlExecuter,
DatabaseCleaner databaseCleaner,
DataMigrationScriptsExecuter dataMigrationScriptsExecuter,
IDatabaseGenerator databaseGenerator,
IConceptDataMigrationExecuter dataMigrationFromCodeExecuter)
{
_logger = logProvider.GetLogger(GetType().Name);
_sqlExecuter = sqlExecuter;
_databaseCleaner = databaseCleaner;
_dataMigrationScriptsExecuter = dataMigrationScriptsExecuter;
_databaseGenerator = databaseGenerator;
_dataMigrationFromCodeExecuter = dataMigrationFromCodeExecuter;
}
public ApplicationGenerator(
ILogProvider logProvider,
ISqlExecuter sqlExecuter,
IDslModel dslModel,
IDomGenerator domGenerator,
IPluginsContainer<IGenerator> generatorsContainer,
DatabaseCleaner databaseCleaner,
DataMigration dataMigration,
IDatabaseGenerator databaseGenerator,
IDslScriptsProvider dslScriptsLoader)
{
_deployPackagesLogger = logProvider.GetLogger("DeployPackages");
_performanceLogger = logProvider.GetLogger("Performance");
_sqlExecuter = sqlExecuter;
_dslModel = dslModel;
_domGenerator = domGenerator;
_generatorsContainer = generatorsContainer;
_databaseCleaner = databaseCleaner;
_dataMigration = dataMigration;
_databaseGenerator = databaseGenerator;
_dslScriptsLoader = dslScriptsLoader;
}
public ApplicationGenerator(
ILogProvider logProvider,
ISqlExecuter sqlExecuter,
IDslModel dslModel,
IDomGenerator domGenerator,
IPluginsContainer <IGenerator> generatorsContainer,
DatabaseCleaner databaseCleaner,
DataMigration dataMigration,
IDatabaseGenerator databaseGenerator,
IDslScriptsProvider dslScriptsLoader)
{
_deployPackagesLogger = logProvider.GetLogger("DeployPackages");
_performanceLogger = logProvider.GetLogger("Performance");
_sqlExecuter = sqlExecuter;
_dslModel = dslModel;
_domGenerator = domGenerator;
_generatorsContainer = generatorsContainer;
_databaseCleaner = databaseCleaner;
_dataMigration = dataMigration;
_databaseGenerator = databaseGenerator;
_dslScriptsLoader = dslScriptsLoader;
}
static int Main(string[] args)
{
try
{
string connectionString = SqlUtility.ConnectionString;
Console.WriteLine("SQL connection string: " + SqlUtility.MaskPassword(connectionString));
var sqlExecuter = GetSqlExecuterImplementation(connectionString);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), sqlExecuter);
databaseCleaner.DeleteAllMigrationData();
return 0;
}
catch (Exception ex)
{
Console.WriteLine();
DeploymentUtility.WriteError(ex.Message);
Console.WriteLine("Details:");
Console.WriteLine(ex);
Thread.Sleep(3000);
return 1;
}
}
public void TestCleanupOldData(string description,
string oldTables, string oldSchemas,
string expectedDeletedTables, string expectedDeletedSchemas)
{
var mockSqlExecuter = new MockSqlExecuter("", oldTables, oldSchemas);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), mockSqlExecuter);
Console.WriteLine("Report: " + databaseCleaner.DeleteAllMigrationData());
Assert.AreEqual("", TestUtility.DumpSorted(mockSqlExecuter.DroppedColumns), description + ": Deleted columns.");
Assert.AreEqual(expectedDeletedTables, TestUtility.DumpSorted(mockSqlExecuter.DroppedTables), description + ": Deleted tables.");
Assert.AreEqual(expectedDeletedSchemas, TestUtility.DumpSorted(mockSqlExecuter.DroppedSchemas), description + ": Deleted schemas.");
}
public void TestCleanupRedundantOldData(string description,
string oldColumns, string oldTables, string oldSchemas,
string expectedDeletedColumns, string expectedDeletedTables, string expectedDeletedSchemas)
{
var mockSqlExecuter = new MockSqlExecuter(oldColumns, oldTables, oldSchemas);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), mockSqlExecuter);
databaseCleaner.RemoveRedundantMigrationColumns();
Assert.AreEqual(expectedDeletedColumns, TestUtility.DumpSorted(mockSqlExecuter.DroppedColumns), description + ": Deleted columns.");
Assert.AreEqual(expectedDeletedTables, TestUtility.DumpSorted(mockSqlExecuter.DroppedTables), description + ": Deleted tables.");
Assert.AreEqual(expectedDeletedSchemas, TestUtility.DumpSorted(mockSqlExecuter.DroppedSchemas), description + ": Deleted schemas.");
}
