private void PopulateFromStagingTable()
{
var stagingTableName = DatabaseUtils.GetQualifiedTableName(
PublicStagingSchema.StagingSchemaName, EntityUtils.ToCtTableName(Entity.Event));
string federatedEventIdCol = EntityUtils.GetFederatedFieldName("event_id");
var s = new SqlBuilder();
s.AppendFormat("select {0}, day_of_week, start_time, end_time from {1}", federatedEventIdCol, stagingTableName);
s.AppendFormat(
"where {0} in ('{1}', '{2}')",
HistorySchema.HistoryStatusColumnName,
HistorySchema.HistoryStatusInsert,
HistorySchema.HistoryStatusUpdate);
DatabaseUtils.EnumerateResults(_connectionString, s.ToString(), _timeoutSecs, r =>
{
var times = new EventStartEndTime
{
Start = (DateTime)r["start_time"],
End = (DateTime)r["end_time"],
DayOfWeek = Utils.ConvertFromCt7DayOfWeek((int)r["day_of_week"])
};
var eventId = (long)r[federatedEventIdCol];
_eventTimes.Add(eventId, times);
});
}
public void AddConsolidatedOrFederatedIdMapping(DataStoreConfiguration c, Entity e, string publicColName)
{
var fldName = c.Consolidation.Get(e).None
? EntityUtils.GetFederatedFieldName(publicColName)
: EntityUtils.GetConsolidatedFieldName(publicColName);
var m = new ColumnMappingStandard(publicColName, fldName);
_mappings.Add(m);
}
public void AddResourceIdColumnMapping(string publicResIdColName, string publicResTypeColName)
{
var m = new ColumnMappingResourceId(
publicResIdColName,
publicResTypeColName,
EntityUtils.GetFederatedFieldName(publicResIdColName),
EntityUtils.GetConsolidatedFieldName(publicResIdColName));
_mappings.Add(m);
}
private void PopulateFromStagingTable(Entity et, ResourceNameCache cache, DataStoreConfiguration c)
{
var idFldName = c.Consolidation.Get(et).None
? EntityUtils.GetFederatedFieldName(EntityUtils.GetIdFldName(et))
: ConsolidationTypeUtils.GetConsolidatedFieldName(EntityUtils.GetIdFldName(et));
var tableName = DatabaseUtils.GetQualifiedTableName(
PublicStagingSchema.StagingSchemaName, EntityUtils.ToCtTableName(et));
PopulateFromTable(et, cache, tableName, idFldName, true);
}
protected void RegisterFederatedIdCol(string colName, Entity e, string entityDefColName = null)
{
if (!ColumnExists(colName))
{
throw new ApplicationException(string.Format("Column does not exist: {0}", colName));
}
var def = new FederationDefinition
{
Entity = e,
OriginalColName = colName,
FederationIdColName = EntityUtils.GetFederatedFieldName(colName),
EntityDefinitionColName = entityDefColName
};
_federatedIdCols.Add(def);
}
private string GetFederatedOrConsolidatedIdColName(DataStoreConfiguration c, Entity e, string idColName)
{
return(c.Consolidation.Get(e).None
? EntityUtils.GetFederatedFieldName(idColName)
: EntityUtils.GetConsolidatedFieldName(idColName));
}
public void AddFederatedIdMapping(string publicColName)
{
var m = new ColumnMappingStandard(publicColName, EntityUtils.GetFederatedFieldName(publicColName));
_mappings.Add(m);
}
