public static void TruncateTables(this SqlSyncScopeProvisioning provision, SqlConnection connection, List <Sitecore.Takeaway.DistributedDb.Configuration.SyncTable> tables)
{
Assert.IsNotNull(provision, "[DistributedDb] provision is null");
var scopeProvisioningWrapper = new SqlSyncScopeProvisioningWrapper();
foreach (var table in tables)
{
scopeProvisioningWrapper.TruncateTable(table.Name, connection);
}
}
public static void RebuildIndexes(this SqlSyncScopeProvisioning provision, SqlConnection connection, List <Sitecore.Takeaway.DistributedDb.Configuration.SyncTable> tables)
{
Assert.IsNotNull(provision, "[DistributedDb] provision is null");
var scopeProvisioningWrapper = new SqlSyncScopeProvisioningWrapper();
foreach (var table in tables)
{
foreach (var idx in scopeProvisioningWrapper.GetFragmentedIndexes(table.Name, connection))
{
scopeProvisioningWrapper.RebuildTableIndexes(idx.TableName, idx.IndexName, connection);
}
}
}
public static void ApplyTriggerAndProcedureUpdates(this SqlSyncScopeProvisioning provision, SqlConnection connection)
{
Assert.IsNotNull(provision, "[DistributedDb] provision is null");
var scopeProvisioningWrapper = new SqlSyncScopeProvisioningWrapper();
foreach (var table in provision.Tables)
{
foreach (var trigger in table.GetUpdateTriggerScripts())
{
scopeProvisioningWrapper.UpdateTriggerScripts(table.LocalName, trigger, connection);
}
foreach (var procedure in table.GetUpdateProcedureScripts())
{
scopeProvisioningWrapper.UpdateProcedureScripts(table.LocalName, procedure, connection);
}
}
}
