private static ColumnDescriptionItem GetExpandedColumn(OracleReference objectReference, OracleColumn column, bool isPseudocolumn) { var nullable = objectReference?.SchemaObject.GetTargetSchemaObject() is OracleView ? (bool?)null : column.Nullable; return (new ColumnDescriptionItem { OwnerIdentifier = objectReference?.FullyQualifiedObjectName ?? OracleObjectIdentifier.Empty, ColumnName = OracleCodeCompletionProvider.GetPrettyColumnName(column.Name), DataType = column.FullTypeName, Nullable = nullable, IsPseudocolumn = isPseudocolumn, IsHidden = column.Hidden }); }
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); }
private void ConfigureSettings() { ExecutionContext.EnsureSettingsProviderAvailable(); _settingsModel = ExecutionContext.SettingsProvider.Settings; _settingsModel.IsTextInputVisible = false; var columnNames = FillColumnNames(); foreach (var column in columnNames) { var isSelected = _settingsModel.UseDefaultSettings == null || !_settingsModel.UseDefaultSettings() ? _existingColumns.Contains(column.Name.ToQuotedIdentifier()) : _settingsModel.UseDefaultSettings(); var columnDescription = new ColumnDescriptionItem { DataType = column.FullTypeName, ColumnName = OracleCodeCompletionProvider.GetPrettyColumnName(column.Name), IsHidden = column.Hidden, Nullable = column.Nullable }; _settingsModel.AddBooleanOption( new BooleanOption { OptionIdentifier = column.Name.ToSimpleIdentifier(), DescriptionContent = ExpandAsteriskCommand.BuildColumnOptionDescription(columnDescription), Value = isSelected, Tag = column }); } _settingsModel.Title = "Add/Modify Columns"; _settingsModel.Heading = _settingsModel.Title; }