private static ColumnDetailsModel BuildColumnDetailsModel(OracleDatabaseModelBase databaseModel, OracleColumnReference columnReference)
{
var columnOwner = columnReference.ValidObjectReference.SchemaObject.GetTargetSchemaObject().FullyQualifiedName;
var dataModel =
new ColumnDetailsModel
{
Owner = columnOwner.ToString(),
Name = OracleCodeCompletionProvider.GetPrettyColumnName(columnReference.ColumnDescription.Name),
Nullable = columnReference.ColumnDescription.Nullable,
Invisible = columnReference.ColumnDescription.Hidden,
Virtual = columnReference.ColumnDescription.Virtual,
IsSystemGenerated = columnReference.ColumnDescription.UserGenerated == false,
DataType = columnReference.ColumnDescription.FullTypeName,
DefaultValue = BuildDefaultValuePreview(columnReference.ColumnDescription.DefaultValue)
};
databaseModel.UpdateColumnDetailsAsync(columnOwner, columnReference.ColumnDescription.Name, dataModel, CancellationToken.None);
return(dataModel);
}
public ToolTipColumn(ColumnDetailsModel dataModel)
{
InitializeComponent();
DataContext = dataModel;
}
public ToolTipColumn(ColumnDetailsModel dataModel)
{
InitializeComponent();
DataContext = dataModel;
}
public override Task UpdateColumnDetailsAsync(OracleObjectIdentifier objectIdentifier, string columnName, ColumnDetailsModel dataModel, CancellationToken cancellationToken)
{
dataModel.DistinctValueCount = 567;
dataModel.LastAnalyzed = new DateTime(2014, 8, 19, 6, 18, 12);
dataModel.SampleSize = 12346;
dataModel.AverageValueSize = 7;
dataModel.NullValueCount = 1344;
dataModel.Comment = "This is a column comment. ";
dataModel.HistogramBucketCount = 6;
dataModel.HistogramType = "Frequency";
var previousValue = 0d;
dataModel.HistogramValues = Enumerable.Repeat(new Random(), dataModel.HistogramBucketCount).Select(r => (previousValue += r.NextDouble())).ToArray();
return Task.FromResult<object>(null);
}
private static ColumnDetailsModel BuildColumnDetailsModel(OracleDatabaseModelBase databaseModel, OracleColumnReference columnReference)
{
var columnOwner = columnReference.ValidObjectReference.SchemaObject.GetTargetSchemaObject().FullyQualifiedName;
var dataModel =
new ColumnDetailsModel
{
Owner = columnOwner.ToString(),
Name = OracleCodeCompletionProvider.GetPrettyColumnName(columnReference.ColumnDescription.Name),
Nullable = columnReference.ColumnDescription.Nullable,
Invisible = columnReference.ColumnDescription.Hidden,
Virtual = columnReference.ColumnDescription.Virtual,
IsSystemGenerated = columnReference.ColumnDescription.UserGenerated == false,
DataType = columnReference.ColumnDescription.FullTypeName,
DefaultValue = BuildDefaultValuePreview(columnReference.ColumnDescription.DefaultValue)
};
databaseModel.UpdateColumnDetailsAsync(columnOwner, columnReference.ColumnDescription.Name, dataModel, CancellationToken.None);
return dataModel;
}
