/// <summary>
/// The uninstall database schema.
/// </summary>
internal void UninstallDatabaseSchema()
{
_logger.Info <MerchelloDatabaseSchemaHelper>("Uninstalling Merchello database schema");
var creation = new DatabaseSchemaCreation(_db, _logger, _umbSchemaHelper, _syntaxProvider);
creation.UninstallDatabaseSchema();
_logger.Info <MerchelloDatabaseSchemaHelper>("Merchello database schema removed");
}
public virtual void Initialize()
{
// Disable medium trust
var transform = TransformWebConfig("Release");
var assemblyPath = TestHelper.CurrentAssemblyDirectory;
assemblyPath = Path.Combine(assemblyPath, @"..\..\..\Umbraco.Web.UI\");
var webUiPath = Path.GetFullPath(new Uri(assemblyPath).LocalPath);
var installedPackagesConfig = string.Format("{0}App_Data\\packages\\installed\\installedPackages.config", webUiPath);
if (File.Exists(installedPackagesConfig))
{
File.Delete(installedPackagesConfig);
}
var databaseDataPath = string.Format(@"{0}\App_Data\Umbraco.sdf", webUiPath);
var connectionString = string.Format(@"Data Source={0}", databaseDataPath);
//Create the Sql CE database
using (var engine = new SqlCeEngine(connectionString))
{
if (File.Exists(databaseDataPath) == false)
{
engine.CreateDatabase();
}
}
var syntaxProvider = new SqlCeSyntaxProvider();
SqlSyntaxContext.SqlSyntaxProvider = syntaxProvider;
_database = new UmbracoDatabase(connectionString, Constants.DatabaseProviders.SqlCe, Mock.Of <ILogger>());
// First remove anything in the database
var creation = new DatabaseSchemaCreation(_database, Mock.Of <ILogger>(), syntaxProvider);
creation.UninstallDatabaseSchema();
// Then populate it with fresh data
_database.CreateDatabaseSchema(false);
_database.Execute("UPDATE umbracoUser SET userName = '******', userPassword = '******', userEmail = 'none' WHERE id = 0"); // password: test
// Recycle app pool so the new user can log in
//var webConfigFilePath = string.Format(@"{0}\web.config", webUiPath);
//File.SetLastWriteTime(webConfigFilePath, DateTime.Now);
// Disable medium trust
transform = TransformWebConfig("Release");
Driver = new FirefoxDriver();
BaseUrl = "http://localhost:61639/";
_verificationErrors = new StringBuilder();
}
public void Init()
{
var syntax = (DbSyntax)Enum.Parse(typeof(DbSyntax), ConfigurationManager.AppSettings["syntax"]);
var worker = new DbPreTestDataWorker {
SqlSyntax = syntax
};
_database = worker.Database;
var deletions = new DatabaseSchemaCreation(_database);
deletions.UninstallDatabaseSchema();
}
public void Init()
{
var syntax = (DbSyntax)Enum.Parse(typeof(DbSyntax), ConfigurationManager.AppSettings["syntax"]);
_worker = new DbPreTestDataWorker {
SqlSyntax = syntax
};
var schemaHelper = new DatabaseSchemaHelper(_worker.Database, _worker.TestLogger, _worker.SqlSyntaxProvider);
var deletions = new DatabaseSchemaCreation(_worker.Database, _worker.TestLogger, schemaHelper, _worker.SqlSyntaxProvider);
deletions.UninstallDatabaseSchema();
}
/// <summary>
/// Undoes the specified package name.
/// </summary>
/// <param name="packageName">Name of the package.</param>
/// <param name="xmlData">The XML data.</param>
/// <returns></returns>
public bool Undo(string packageName, System.Xml.XmlNode xmlData)
{
try
{
var deletions = new DatabaseSchemaCreation(Umbraco.Core.ApplicationContext.Current.DatabaseContext.Database);
deletions.UninstallDatabaseSchema();
return(true);
}
catch (Exception ex)
{
var message = string.Concat("Error at undo ", this.Alias(), " package action: ", ex);
LogHelper.Error(typeof(CreateDatabase), message, ex);
}
return(false);
}
private void RebuildDatabase()
{
// migration
var schema = new DatabaseSchemaCreation(Database);
// drop all the tables
schema.UninstallDatabaseSchema();
// install the schema
schema.InitializeDatabaseSchema();
// add the default data
var baseDataCreation = new BaseDataCreation(Database);
baseDataCreation.InitializeBaseData("merchDBTypeField");
baseDataCreation.InitializeBaseData("merchInvoiceStatus");
baseDataCreation.InitializeBaseData("merchOrderStatus");
baseDataCreation.InitializeBaseData("merchWarehouse");
baseDataCreation.InitializeBaseData("merchGatewayProviderSettings");
baseDataCreation.InitializeBaseData("merchStoreSetting");
}
internal void UninstallDatabaseSchema()
{
var creation = new DatabaseSchemaCreation(_db, _logger, _syntaxProvider);
creation.UninstallDatabaseSchema();
}
public void Can_Drop_All_Database_Tables()
{
var deletions = new DatabaseSchemaCreation(_database);
deletions.UninstallDatabaseSchema();
}
internal static void UninstallDatabaseSchema(this Database db)
{
var creation = new DatabaseSchemaCreation(db);
creation.UninstallDatabaseSchema();
}
/// <summary>
/// Completely uninstalls Merchello's database schema
/// </summary>
public void UninstallDatabaseSchema()
{
var uninstaller = new DatabaseSchemaCreation(_database);
uninstaller.UninstallDatabaseSchema();
}
