/// <summary>
/// Ensures the Merchello database has been installed.
/// </summary>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
internal bool EnsureDatabase()
{
var databaseSchemaCreation = new DatabaseSchemaCreation(_database, _logger, new DatabaseSchemaHelper(_database, _logger, _sqlSyntaxProvider), _sqlSyntaxProvider);
var schemaResult = databaseSchemaCreation.ValidateSchema();
var databaseVersion = schemaResult.DetermineInstalledVersion();
if (databaseVersion != new Version("0.0.0"))
{
return(true);
}
// install the database
var schemaHelper = new MerchelloDatabaseSchemaHelper(this._database, this._logger, this._sqlSyntaxProvider);
schemaHelper.CreateDatabaseSchema();
var baseDataCreation = new BaseDataCreation(this._database, this._logger);
baseDataCreation.InitializeBaseData("merchTypeField");
baseDataCreation.InitializeBaseData("merchInvoiceStatus");
baseDataCreation.InitializeBaseData("merchOrderStatus");
baseDataCreation.InitializeBaseData("merchWarehouse");
baseDataCreation.InitializeBaseData("merchGatewayProviderSettings");
baseDataCreation.InitializeBaseData("merchStoreSetting");
baseDataCreation.InitializeBaseData("merchShipmentStatus");
return(false);
}
/// <summary>
/// Installs Merchello default data.
/// </summary>
/// <param name="baseDataCreation">
/// The base data creation.
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
private bool CreateInitialMerchelloData(BaseDataCreation baseDataCreation)
{
baseDataCreation.InitializeBaseData("merchTypeField");
baseDataCreation.InitializeBaseData("merchInvoiceStatus");
baseDataCreation.InitializeBaseData("merchOrderStatus");
baseDataCreation.InitializeBaseData("merchWarehouse");
baseDataCreation.InitializeBaseData("merchGatewayProviderSettings");
baseDataCreation.InitializeBaseData("merchStoreSetting");
baseDataCreation.InitializeBaseData("merchShipmentStatus");
return(true);
}
public void Can_Populate_typeFieldData_Into_merchTypeField()
{
//// Arrange
const int expected = 32;
//// Act
_creation.InitializeBaseData("merchTypeField");
//// Assert
var dtos = _database.Query <TypeFieldDto>("SELECT * FROM merchTypeField");
var count = dtos.Count();
Assert.AreEqual(expected, count);
}
private void RebuildDatabase()
{
// migration
var schema = new DatabaseSchemaCreation(Database, TestLogger, new DatabaseSchemaHelper(Database, TestLogger, this.SqlSyntaxProvider), this.SqlSyntaxProvider);
// drop all the tables
schema.UninstallDatabaseSchema();
// install the schema
schema.InitializeDatabaseSchema();
// add the default data
var baseDataCreation = new BaseDataCreation(Database, TestLogger);
baseDataCreation.InitializeBaseData("merchDBTypeField");
baseDataCreation.InitializeBaseData("merchInvoiceStatus");
baseDataCreation.InitializeBaseData("merchOrderStatus");
baseDataCreation.InitializeBaseData("merchWarehouse");
baseDataCreation.InitializeBaseData("merchGatewayProviderSettings");
baseDataCreation.InitializeBaseData("merchStoreSetting");
baseDataCreation.InitializeBaseData("merchShipmentStatus");
}
/// <summary>
/// Ensures the Merchello database has been installed.
/// </summary>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
internal bool EnsureDatabase()
{
var databaseSchemaCreation = new DatabaseSchemaCreation(_database, _logger, new DatabaseSchemaHelper(_database, _logger, _sqlSyntaxProvider), _sqlSyntaxProvider);
var schemaResult = databaseSchemaCreation.ValidateSchema();
var databaseVersion = schemaResult.DetermineInstalledVersion();
if (databaseVersion != new Version("0.0.0"))
{
return(true);
}
// install the database
var schemaHelper = new MerchelloDatabaseSchemaHelper(this._database, this._logger, this._sqlSyntaxProvider);
schemaHelper.CreateDatabaseSchema();
var baseDataCreation = new BaseDataCreation(this._database, this._logger);
baseDataCreation.InitializeBaseData("merchTypeField");
baseDataCreation.InitializeBaseData("merchInvoiceStatus");
baseDataCreation.InitializeBaseData("merchOrderStatus");
baseDataCreation.InitializeBaseData("merchWarehouse");
baseDataCreation.InitializeBaseData("merchGatewayProviderSettings");
baseDataCreation.InitializeBaseData("merchStoreSetting");
baseDataCreation.InitializeBaseData("merchShipmentStatus");
// Add 'merchello' to the admin group
var ug = new UserGroup2AppDto {
UserGroupId = 1, AppAlias = "merchello"
};
_database.Insert(ug);
// TODO clear cache
return(false);
}
public void CreateTable(bool overwrite, Type modelType)
{
var tableDefinition = DefinitionFactory.GetTableDefinition(modelType);
var tableName = tableDefinition.Name;
string createSql = _syntaxProvider.Format(tableDefinition);
string createPrimaryKeySql = _syntaxProvider.FormatPrimaryKey(tableDefinition);
var foreignSql = _syntaxProvider.Format(tableDefinition.ForeignKeys);
var indexSql = _syntaxProvider.Format(tableDefinition.Indexes);
var tableExist = _db.TableExist(tableName);
if (overwrite && tableExist)
{
_db.DropTable(tableName);
tableExist = false;
}
if (tableExist == false)
{
using (var transaction = _db.GetTransaction())
{
//Execute the Create Table sql
int created = _db.Execute(new Sql(createSql));
_logger.Info <Database>(string.Format("Create Table sql {0}:\n {1}", created, createSql));
//If any statements exists for the primary key execute them here
if (!string.IsNullOrEmpty(createPrimaryKeySql))
{
int createdPk = _db.Execute(new Sql(createPrimaryKeySql));
_logger.Info <Database>(string.Format("Primary Key sql {0}:\n {1}", createdPk, createPrimaryKeySql));
}
//Turn on identity insert if db provider is not mysql
if (_syntaxProvider.SupportsIdentityInsert() && tableDefinition.Columns.Any(x => x.IsIdentity))
{
_db.Execute(new Sql(string.Format("SET IDENTITY_INSERT {0} ON ", _syntaxProvider.GetQuotedTableName(tableName))));
}
//Call the NewTable-event to trigger the insert of base/default data
//OnNewTable(tableName, _db, e, _logger);
_baseDataCreation.InitializeBaseData(tableName);
//Turn off identity insert if db provider is not mysql
if (_syntaxProvider.SupportsIdentityInsert() && tableDefinition.Columns.Any(x => x.IsIdentity))
{
_db.Execute(new Sql(string.Format("SET IDENTITY_INSERT {0} OFF;", _syntaxProvider.GetQuotedTableName(tableName))));
}
//Special case for MySql
if (_syntaxProvider is MySqlSyntaxProvider && tableName.Equals("umbracoUser"))
{
_db.Update <UserDto>("SET id = @IdAfter WHERE id = @IdBefore AND userLogin = @Login", new { IdAfter = 0, IdBefore = 1, Login = "******" });
}
//Loop through index statements and execute sql
foreach (var sql in indexSql)
{
int createdIndex = _db.Execute(new Sql(sql));
_logger.Info <Database>(string.Format("Create Index sql {0}:\n {1}", createdIndex, sql));
}
//Loop through foreignkey statements and execute sql
foreach (var sql in foreignSql)
{
int createdFk = _db.Execute(new Sql(sql));
_logger.Info <Database>(string.Format("Create Foreign Key sql {0}:\n {1}", createdFk, sql));
}
transaction.Complete();
}
}
_logger.Info <Database>(string.Format("New table '{0}' was created", tableName));
}
private static void PetaPocoExtensions_NewTable(string tableName, Database db, TableCreationEventArgs e)
{
var baseDataCreation = new BaseDataCreation(db);
baseDataCreation.InitializeBaseData(tableName);
}
