private bool SetVersionedField(SqlItemData targetItem, string language, int version, SqlItemFieldValue currentField)
{
// check for corruption in SQL server tables (field values in wrong table) - a versioned field should have both a language and a version that's one or greater
if (version < 1)
{
if (string.IsNullOrEmpty(language))
{
Log.Error($"[Dilithium] Data corruption in {targetItem.DatabaseName}://{{{targetItem.Id}}}! Field {currentField.FieldId} (versioned) had a value in the shared fields table. The field value will be ignored.", this);
}
else
{
Log.Error($"[Dilithium] Data corruption in {targetItem.DatabaseName}://{{{targetItem.Id}}}! Field {currentField.FieldId} (versioned) had a value in the unversioned fields table. The field value will be ignored.", this);
}
return(false);
}
foreach (var versionFields in targetItem.RawVersions)
{
if (versionFields.Language.Name.Equals(language, StringComparison.Ordinal) && versionFields.VersionNumber == version)
{
versionFields.RawFields.Add(currentField);
return(true);
}
}
var newVersion = new SqlItemVersion();
newVersion.Language = new CultureInfo(language);
newVersion.VersionNumber = version;
newVersion.RawFields.Add(currentField);
targetItem.RawVersions.Add(newVersion);
return(true);
}
private bool SetUnversionedField(SqlItemData targetItem, SqlItemFieldValue currentField, int version, string language)
{
// check for corruption in SQL server tables (field values in wrong table) - an unversioned field should have a version less than 1 (SQL sends -1 back for unversioned) and a language
if (version >= 1)
{
Log.Error($"[Dilithium] Data corruption in {targetItem.DatabaseName}://{{{targetItem.Id}}}! Field {currentField.FieldId} (unversioned) had a value in the versioned fields table. The field value will be ignored.", this);
return(false);
}
if (string.IsNullOrEmpty(language))
{
Log.Error($"[Dilithium] Data corruption in {targetItem.DatabaseName}://{{{targetItem.Id}}}! Field {currentField.FieldId} (unversioned) had a value in the shared fields table. The field value will be ignored.", this);
return(false);
}
foreach (var languageFields in targetItem.RawUnversionedFields)
{
if (languageFields.Language.Name.Equals(language, StringComparison.Ordinal))
{
languageFields.RawFields.Add(currentField);
return(true);
}
}
var newLanguage = new SqlItemLanguage();
newLanguage.Language = new CultureInfo(language);
newLanguage.RawFields.Add(currentField);
targetItem.RawUnversionedFields.Add(newLanguage);
return(true);
}
private bool SetSharedField(SqlItemData targetItem, SqlItemFieldValue currentField, int version, string language)
{
// check for corruption in SQL server tables (field values in wrong table) - shared field should have neither language nor version one or greater (SQL sends version -1 for shared)
if (version >= 1)
{
Log.Error($"[Dilithium] Data corruption in {targetItem.DatabaseName}://{{{targetItem.Id}}}! Field {{{currentField.FieldId}}} (shared) had a value in the versioned fields table. The field value will be ignored.", this);
return(false);
}
if (!string.IsNullOrEmpty(language))
{
Log.Error($"[Dilithium] Data corruption in {targetItem.DatabaseName}://{{{targetItem.Id}}}! Field {currentField.FieldId} (shared) had a value in the unversioned fields table. The field value will be ignored.", this);
return(false);
}
targetItem.RawSharedFields.Add(currentField);
return(true);
}
private void IngestItemData(SqlDataReader reader)
{
// 8087 = prime. Lots of items will load in so we start with a large capacity to minimize expansions.
// Dictionary expands using primes, hence our choice.
var results = new Dictionary <Guid, SqlItemData>(8087);
SqlItemData currentItem;
while (reader.Read())
{
// NOTE: refer to SQL in Reactor (first query) to get column ordinals
currentItem = new SqlItemData(this);
currentItem.Id = reader.GetGuid(0);
currentItem.Name = reader.GetString(1);
currentItem.TemplateId = reader.GetGuid(2);
currentItem.BranchId = reader.GetGuid(3);
currentItem.ParentId = reader.GetGuid(4);
currentItem.DatabaseName = Database.Name;
results.Add(currentItem.Id, currentItem);
}
_itemsById = results;
}
public IList <SqlItemData> GetChildren(SqlItemData item)
{
return(GuidsToItems(item.Children));
}