private void InstallLines()
{
string upgradeId = Guid.NewGuid().ToString("N").ToUpperInvariant();
ExportProcessor.EnsureSystemData(_conn, ref _itemTypes);
try
{
bool cont;
RecoverableErrorEventArgs args;
XmlNode query;
XmlElement newQuery;
ItemType itemType;
ReportProgress(0, "Starting install.");
_conn.GetItems("ApplyItem", string.Format(Properties.Resources.DbUpgrade_Start, upgradeId, Environment.UserDomainName, Environment.UserName, _script.Title, _script.Description));
IEnumerable <XmlElement> items;
foreach (var line in _lines.Skip(_currLine).ToList())
{
cont = true;
ReportProgress((int)(_currLine * 80.0 / _lines.Count), string.Format("Performing {0} ({1} of {2})", line.ToString(), _currLine + 1, _lines.Count));
query = line.Script;
while (cont)
{
try
{
// If the original item uses a where clause or is versionable or the target item is versionable
if (query.Attribute(XmlFlags.Attr_ConfigId) != null && query.Attribute("action") == "merge" &&
(query.Attribute("where") != null || (_itemTypes.TryGetValue(query.Attribute("type").ToLowerInvariant(), out itemType)) && itemType.IsVersionable))
{
newQuery = query.Clone() as XmlElement;
newQuery.InnerXml = "";
newQuery.SetAttribute("action", "get");
newQuery.SetAttribute("select", "id");
// The item type became versionable in the target database
if (newQuery.Attribute("where") == null)
{
newQuery.RemoveAttribute("id");
newQuery.SetAttribute("where", string.Format("[{0}].[config_id] = '{1}'", query.Attribute("type", "").Replace(' ', '_'), query.Attribute(XmlFlags.Attr_ConfigId)));
}
// If the item exists, get the id for use in the relationships
// If the item doesn't exist, make sure the id = config_id for the add
items = _conn.GetItems("ApplyItem", newQuery);
string sourceId = items.Any() ? items.First().Attribute("id") : query.Attribute(XmlFlags.Attr_ConfigId);
newQuery = query.Clone() as XmlElement;
newQuery.SetAttribute("id", sourceId);
newQuery.RemoveAttribute("where");
newQuery.RemoveAttribute(XmlFlags.Attr_ConfigId);
query = newQuery;
string relatedId;
string whereClause;
// Check relationships and match based on source_id and related_id where necessary
foreach (var rel in query.ElementsByXPath("Relationships/Item[related_id]").ToList())
{
if (rel.Element("related_id").Element("Item") == null)
{
relatedId = rel.InnerText;
}
else
{
relatedId = rel.Element("related_id").Element("Item").Attribute("id");
}
whereClause = string.Format("[{0}].[source_id]='{1}' and [{0}].[related_id]='{2}'"
, rel.Attribute("type", "").Replace(' ', '_'), sourceId, relatedId);
if (!string.IsNullOrEmpty(relatedId))
{
newQuery = rel.OwnerDocument.CreateElement("Item");
newQuery.SetAttribute("type", rel.Attribute("type"));
newQuery.SetAttribute("where", whereClause);
newQuery.SetAttribute("action", "get");
items = _conn.GetItems("ApplyItem", newQuery);
if (items.Any())
{
rel.RemoveAttribute("id");
rel.SetAttribute("where", whereClause);
rel.SetAttribute("action", "edit");
}
}
}
}
items = _conn.GetItems("ApplyItem", query, true);
if (line.Type == InstallType.Create)
{
line.InstalledId = items.First().Attribute("id");
}
// Execute any sql scripts
var sqlScripts = line.Script
.DescendantsAndSelf(e => e.Attribute(XmlFlags.Attr_SqlScript, "") != "")
.Select(e => e.Attribute(XmlFlags.Attr_SqlScript, ""));
if (sqlScripts.Any())
{
_conn.CallAction("ApplySQL", "<sql>" + sqlScripts.Aggregate((p, c) => p + Environment.NewLine + c) + "</sql>");
}
cont = false;
}
catch (ArasException ex)
{
_log.Append(DateTime.Now.ToString("s")).AppendLine(": ERROR");
_log.AppendLine(ex.ErrorNode.OuterXml);
_log.AppendLine(" for query ");
_log.AppendLine(ex.QueryNode.OuterXml);
args = new RecoverableErrorEventArgs()
{
Exception = ex
};
if (line.Type == InstallType.DependencyCheck && ex.ErrorNode.Element("faultcode", "") == "0")
{
args.Message = "Unable to find required dependency " + line.Reference.Type + ": " + line.Reference.KeyedName;
}
OnErrorRaised(args);
switch (args.RecoveryOption)
{
case RecoveryOption.Abort:
_log.Append(DateTime.Now.ToString("s")).AppendLine(": Install aborted.");
throw;
case RecoveryOption.Retry:
query = args.NewQuery ?? query;
_log.Append(DateTime.Now.ToString("s")).AppendLine(": Retrying install step with query:");
_log.AppendLine(query.OuterXml);
break;
case RecoveryOption.Skip:
_log.Append(DateTime.Now.ToString("s")).AppendLine(": Skipping install step.");
cont = false;
break;
}
}
}
_currLine++;
}
if (_script.AddPackage)
{
var pkg = new DatabasePackage(_conn);
pkg.Write(_script, e =>
{
args = new RecoverableErrorEventArgs()
{
Message = e
};
OnErrorRaised(args);
switch (args.RecoveryOption)
{
case RecoveryOption.Skip:
return(DatabasePackageAction.RemoveElementsFromPackages);
case RecoveryOption.Retry:
return(DatabasePackageAction.TryAgain);
default:
return(DatabasePackageAction.Abort);
}
}, (i, m) =>
{
ReportProgress((int)(i * 0.2 + 80), m);
});
}
_conn.GetItems("ApplyItem", "<Item type=\"DatabaseUpgrade\" action=\"merge\" id=\"" + upgradeId + "\"><upgrade_status>1</upgrade_status></Item>");
OnActionComplete(new ActionCompleteEventArgs());
}
catch (Exception ex)
{
_conn.GetItems("ApplyItem", "<Item type=\"DatabaseUpgrade\" action=\"merge\" id=\"" + upgradeId + "\"><upgrade_status>2</upgrade_status></Item>");
OnActionComplete(new ActionCompleteEventArgs()
{
Exception = ex
});
}
}
private void InstallLines()
{
string upgradeId = Guid.NewGuid().ToString("N").ToUpperInvariant();
ExportProcessor.EnsureSystemData(_conn, ref _itemTypes);
try
{
bool cont;
RecoverableErrorEventArgs args;
XmlNode query;
XmlElement newQuery;
ItemType itemType;
ReportProgress(0, "Starting install.");
_conn.GetItems("ApplyItem", string.Format(Properties.Resources.DbUpgrade_Start, upgradeId, Environment.UserDomainName, Environment.UserName, _script.Title, _script.Description));
IEnumerable<XmlElement> items;
foreach (var line in _lines.Skip(_currLine).ToList())
{
cont = true;
ReportProgress((int)(_currLine * 80.0 / _lines.Count), string.Format("Performing {0} ({1} of {2})", line.ToString(), _currLine + 1, _lines.Count));
query = line.Script;
while (cont)
{
try
{
// If the original item uses a where clause or is versionable or the target item is versionable
if (query.Attribute(XmlFlags.Attr_ConfigId) != null && query.Attribute("action") == "merge"
&& (query.Attribute("where") != null || (_itemTypes.TryGetValue(query.Attribute("type").ToLowerInvariant(), out itemType)) && itemType.IsVersionable ))
{
newQuery = query.Clone() as XmlElement;
newQuery.InnerXml = "";
newQuery.SetAttribute("action", "get");
newQuery.SetAttribute("select", "id");
// The item type became versionable in the target database
if (newQuery.Attribute("where") == null)
{
newQuery.RemoveAttribute("id");
newQuery.SetAttribute("where", string.Format("[{0}].[config_id] = '{1}'", query.Attribute("type", "").Replace(' ', '_'), query.Attribute(XmlFlags.Attr_ConfigId)));
}
// If the item exists, get the id for use in the relationships
// If the item doesn't exist, make sure the id = config_id for the add
items = _conn.GetItems("ApplyItem", newQuery);
string sourceId = items.Any() ? items.First().Attribute("id") : query.Attribute(XmlFlags.Attr_ConfigId);
newQuery = query.Clone() as XmlElement;
newQuery.SetAttribute("id", sourceId);
newQuery.RemoveAttribute("where");
newQuery.RemoveAttribute(XmlFlags.Attr_ConfigId);
query = newQuery;
string relatedId;
string whereClause;
// Check relationships and match based on source_id and related_id where necessary
foreach (var rel in query.ElementsByXPath("Relationships/Item[related_id]").ToList())
{
if (rel.Element("related_id").Element("Item") == null)
{
relatedId = rel.InnerText;
}
else
{
relatedId = rel.Element("related_id").Element("Item").Attribute("id");
}
whereClause = string.Format("[{0}].[source_id]='{1}' and [{0}].[related_id]='{2}'"
, rel.Attribute("type", "").Replace(' ', '_'), sourceId, relatedId);
if (!string.IsNullOrEmpty(relatedId))
{
newQuery = rel.OwnerDocument.CreateElement("Item");
newQuery.SetAttribute("type", rel.Attribute("type"));
newQuery.SetAttribute("where", whereClause);
newQuery.SetAttribute("action", "get");
items = _conn.GetItems("ApplyItem", newQuery);
if (items.Any())
{
rel.RemoveAttribute("id");
rel.SetAttribute("where", whereClause);
rel.SetAttribute("action", "edit");
}
}
}
}
items = _conn.GetItems("ApplyItem", query, true);
if (line.Type == InstallType.Create) line.InstalledId = items.First().Attribute("id");
// Execute any sql scripts
var sqlScripts = line.Script
.DescendantsAndSelf(e => e.Attribute(XmlFlags.Attr_SqlScript, "") != "")
.Select(e => e.Attribute(XmlFlags.Attr_SqlScript, ""));
if (sqlScripts.Any())
{
_conn.CallAction("ApplySQL", "<sql>" + sqlScripts.Aggregate((p, c) => p + Environment.NewLine + c) + "</sql>");
}
cont = false;
}
catch (ArasException ex)
{
_log.Append(DateTime.Now.ToString("s")).AppendLine(": ERROR");
_log.AppendLine(ex.ErrorNode.OuterXml);
_log.AppendLine(" for query ");
_log.AppendLine(ex.QueryNode.OuterXml);
args = new RecoverableErrorEventArgs() { Exception = ex };
if (line.Type == InstallType.DependencyCheck && ex.ErrorNode.Element("faultcode", "") == "0")
{
args.Message = "Unable to find required dependency " + line.Reference.Type + ": " + line.Reference.KeyedName;
}
OnErrorRaised(args);
switch (args.RecoveryOption)
{
case RecoveryOption.Abort:
_log.Append(DateTime.Now.ToString("s")).AppendLine(": Install aborted.");
throw;
case RecoveryOption.Retry:
query = args.NewQuery ?? query;
_log.Append(DateTime.Now.ToString("s")).AppendLine(": Retrying install step with query:");
_log.AppendLine(query.OuterXml);
break;
case RecoveryOption.Skip:
_log.Append(DateTime.Now.ToString("s")).AppendLine(": Skipping install step.");
cont = false;
break;
}
}
}
_currLine++;
}
if (_script.AddPackage)
{
var pkg = new DatabasePackage(_conn);
pkg.Write(_script, e =>
{
args = new RecoverableErrorEventArgs() { Message = e };
OnErrorRaised(args);
switch (args.RecoveryOption)
{
case RecoveryOption.Skip:
return DatabasePackageAction.RemoveElementsFromPackages;
case RecoveryOption.Retry:
return DatabasePackageAction.TryAgain;
default:
return DatabasePackageAction.Abort;
}
}, (i, m) =>
{
ReportProgress((int)(i * 0.2 + 80), m);
});
}
_conn.GetItems("ApplyItem", "<Item type=\"DatabaseUpgrade\" action=\"merge\" id=\"" + upgradeId + "\"><upgrade_status>1</upgrade_status></Item>");
OnActionComplete(new ActionCompleteEventArgs());
}
catch (Exception ex)
{
_conn.GetItems("ApplyItem", "<Item type=\"DatabaseUpgrade\" action=\"merge\" id=\"" + upgradeId + "\"><upgrade_status>2</upgrade_status></Item>");
OnActionComplete(new ActionCompleteEventArgs() { Exception = ex });
}
}