/// <summary>
/// The create database schema.
/// </summary>
public void CreateDatabaseSchema()
{
_logger.Info <MerchelloDatabaseSchemaHelper>("Initializing database schema creation");
var creation = new DatabaseSchemaCreation(_db, _logger, _umbSchemaHelper, _syntaxProvider);
creation.InitializeDatabaseSchema();
_logger.Info <MerchelloDatabaseSchemaHelper>("Finalized database schema creation");
}
internal void CreateDatabaseSchemaDo(IMigrationEntryService migrationEntryService)
{
_logger.Info <Database>("Initializing database schema creation");
var creation = new DatabaseSchemaCreation(_db, _logger, _syntaxProvider);
creation.InitializeDatabaseSchema();
_logger.Info <Database>("Finalized database schema creation");
}
internal static void CreateDatabaseSchema(this Database db, bool guardConfiguration)
{
if (guardConfiguration && ApplicationContext.Current.IsConfigured)
{
throw new Exception("Umbraco is already configured!");
}
NewTable += PetaPocoExtensions_NewTable;
LogHelper.Info <Database>("Initializing database schema creation");
var creation = new DatabaseSchemaCreation(db);
creation.InitializeDatabaseSchema();
LogHelper.Info <Database>("Finalized database schema creation");
NewTable -= PetaPocoExtensions_NewTable;
}
/// <summary>
/// Executes the specified package name.
/// </summary>
/// <param name="packageName">Name of the package.</param>
/// <param name="xmlData">The XML data.</param>
/// <returns></returns>
public bool Execute(string packageName, System.Xml.XmlNode xmlData)
{
try
{
var creation = new DatabaseSchemaCreation(Umbraco.Core.ApplicationContext.Current.DatabaseContext.Database);
creation.InitializeDatabaseSchema();
var creationData = new BaseDataCreation(Umbraco.Core.ApplicationContext.Current.DatabaseContext.Database);
bool dataCreationResult = CreateInitialMerchelloData(creationData);
return(true);
}
catch (Exception ex)
{
var message = string.Concat("Error at install ", 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");
}
private void SetupSqlCe(string path, ILogger logger)
{
var dbName = string.Concat("Umb", Guid.NewGuid(), ".sdf");
AppDomain.CurrentDomain.SetData("DataDirectory", path);
var sqlCeConnectionString = $"Datasource=|DataDirectory|\\{dbName};Flush Interval=1;";
_dbFile = Path.Combine(path, dbName);
//only create the db one time
if (_initDbBytes == null)
{
using (var engine = new SqlCeEngine(sqlCeConnectionString))
{
engine.CreateDatabase();
}
//use the db to create the initial schema so we can reuse in each bench
using (_dbSqlCe = new UmbracoDatabase(
sqlCeConnectionString,
Constants.DatabaseProviders.SqlCe,
logger))
{
var creation = new DatabaseSchemaCreation(_dbSqlCe, logger, _sqlCeSyntax);
creation.InitializeDatabaseSchema();
}
_initDbBytes = File.ReadAllBytes(_dbFile);
}
else
{
File.WriteAllBytes(_dbFile, _initDbBytes);
}
//create the db
_dbSqlCe = new UmbracoDatabase(
sqlCeConnectionString,
Constants.DatabaseProviders.SqlCe,
logger);
}
public void Successfully_Create_Default_Database_Schema()
{
var creation = new DatabaseSchemaCreation(_database);
creation.InitializeDatabaseSchema();
}
/// <summary>
/// Creates a new version of Merchello's Database Schema
/// </summary>
public void InitializeDatabaseSchema()
{
var creation = new DatabaseSchemaCreation(_database);
creation.InitializeDatabaseSchema();
}