public override void Down()
{
try
{
_sh.DropTable <NovicellMapBuilderMapsModel>();
_sh.DropTable <NovicellMapBuilderDataModel>();
}
catch (Exception e)
{
_logger.Error <MapBuilderMigration>("Error dropping tables for NcMapBuilder", e);
}
}
private void DropTables()
{
if (_schemaHelper.TableExist(accountsTableName))
{
Logger.Info <CreateInitialTables>("Deleting Accounts Table");
_schemaHelper.DropTable(accountsTableName);
}
if (_schemaHelper.TableExist(accountSettingsTableName))
{
Logger.Info <CreateInitialTables>("Deleting AccountSettings Table");
_schemaHelper.DropTable(accountSettingsTableName);
}
}
/// <summary>
/// Drops all Umbraco tables in the db
/// </summary>
internal void UninstallDatabaseSchema()
{
_logger.Info <DatabaseSchemaCreation>("Start UninstallDatabaseSchema");
foreach (var item in OrderedTables.OrderByDescending(x => x.Key))
{
var tableNameAttribute = item.Value.FirstAttribute <TableNameAttribute>();
string tableName = tableNameAttribute == null ? item.Value.Name : tableNameAttribute.Value;
_logger.Info <DatabaseSchemaCreation>("Uninstall" + tableName);
try
{
if (_schemaHelper.TableExist(tableName))
{
_schemaHelper.DropTable(tableName);
}
}
catch (Exception ex)
{
//swallow this for now, not sure how best to handle this with diff databases... though this is internal
// and only used for unit tests. If this fails its because the table doesn't exist... generally!
_logger.Error <DatabaseSchemaCreation>("Could not drop table " + tableName, ex);
}
}
}
/// <summary>
/// Drops all Merchello tables in the database
/// </summary>
internal void UninstallDatabaseSchema()
{
_logger.Info <DatabaseSchemaCreation>("Start UninstallDatabaseSchema");
foreach (var item in OrderedTables.OrderByDescending(x => x.Key))
{
var tableNameAttribute = item.Value.FirstAttribute <TableNameAttribute>();
string tableName = tableNameAttribute == null ? item.Value.Name : tableNameAttribute.Value;
_logger.Info <DatabaseSchemaCreation>("Uninstall" + tableName);
try
{
if (_umbSchemaHelper.TableExist(tableName))
{
_umbSchemaHelper.DropTable(tableName);
}
}
catch (Exception ex)
{
_logger.Error <DatabaseSchemaCreation>("Could not drop table " + tableName, ex);
}
}
}
private void DeleteTables()
{
if (_dbSchemaHelper.TableExist("OrderedMeals"))
{
_dbSchemaHelper.DropTable <OrderedMealPoco>();
}
if (_dbSchemaHelper.TableExist("Orders"))
{
_dbSchemaHelper.DropTable <OrderPoco>();
}
if (_dbSchemaHelper.TableExist("Restaurants"))
{
_dbSchemaHelper.DropTable <RestaurantPoco>();
}
if (_dbSchemaHelper.TableExist("Statuses"))
{
_dbSchemaHelper.DropTable <StatusPoco>();
}
}
private void CheckFieldsDatabase()
{
var logger = LoggerResolver.Current.Logger;
var dbContext = ApplicationContext.Current.DatabaseContext;
var dbHelper = new DatabaseSchemaHelper(dbContext.Database, logger, dbContext.SqlSyntax);
if (dbHelper.TableExist(PackageConstants.DbStateTable))
{
dbHelper.DropTable(PackageConstants.DbStateTable);
dbHelper.CreateTable(false, typeof(TState));
}
var tables = new Dictionary <string, Type>
{
{ PackageConstants.DbStatisticTable, typeof(TImageStatistic) },
};
for (var i = 0; i < tables.Count; i++)
{
if (dbHelper.TableExist(tables.ElementAt(i).Key))
{
var checkColumn = new Sql(@"SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME = 'TinifierImagesStatistic' AND COLUMN_NAME = 'TotalSavedBytes'");
var checkHidePanel = new Sql(@"SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME = 'TinifierUserSettings' AND COLUMN_NAME = 'HideLeftPanel'");
var checkMetaData = new Sql(@"SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME = 'TinifierUserSettings' AND COLUMN_NAME = 'PreserveMetadata'");
int?exists = ApplicationContext.Current.DatabaseContext.Database.ExecuteScalar <int?>(checkColumn);
int?hidePanel = ApplicationContext.Current.DatabaseContext.Database.ExecuteScalar <int?>(checkHidePanel);
int?metaData = ApplicationContext.Current.DatabaseContext.Database.ExecuteScalar <int?>(checkMetaData);
if (exists == null || exists == -1)
{
ApplicationContext.Current.DatabaseContext.Database.Execute
(new Sql("ALTER TABLE TinifierImagesStatistic ADD COLUMN TotalSavedBytes bigint"));
}
if (hidePanel == null || hidePanel == -1)
{
ApplicationContext.Current.DatabaseContext.Database.Execute
(new Sql("ALTER TABLE TinifierUserSettings ADD COLUMN HideLeftPanel bit not null default(0)"));
}
if (metaData == null || metaData == -1)
{
ApplicationContext.Current.DatabaseContext.Database.Execute
(new Sql("ALTER TABLE TinifierUserSettings ADD COLUMN PreserveMetadata bit not null default(0)"));
}
}
}
}
public bool Undo(string packageName, XmlNode xmlData)
{
try
{
ApplicationContext appContext = ContextHelpers.EnsureApplicationContext();
DatabaseSchemaHelper databaseSchemaHelper = new DatabaseSchemaHelper(appContext.DatabaseContext.Database, ContextHelpers.EnsureApplicationContext().ProfilingLogger.Logger, appContext.DatabaseContext.SqlSyntax);
databaseSchemaHelper.DropTable <UserStartNodes>();
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 DeleteTinifierTables()
{
var logger = LoggerResolver.Current.Logger;
var dbContext = ApplicationContext.Current.DatabaseContext;
var dbHelper = new DatabaseSchemaHelper(dbContext.Database, logger, dbContext.SqlSyntax);
var tables = new Dictionary <string, Type>
{
{ PackageConstants.DbSettingsTable, typeof(TSetting) },
{ PackageConstants.DbHistoryTable, typeof(TinyPNGResponseHistory) },
{ PackageConstants.DbStatisticTable, typeof(TImageStatistic) },
{ PackageConstants.DbStateTable, typeof(TState) },
{ PackageConstants.MediaHistoryTable, typeof(TinifierMediaHistory) }
};
for (var i = 0; i < tables.Count; i++)
{
if (dbHelper.TableExist(tables.ElementAt(i).Key))
{
dbHelper.DropTable(tables.ElementAt(i).Key);
}
}
}
public override void Down()
{
_schemaHelper.DropTable <Dto.Ancestor.Ancestor100>();
_schemaHelper.DropTable <Dto.Entry.Entry100>();
}