public TableColumn( string tableOwner, string tableName, string columnName, OracleDbType?dataType, int dataLength, int?dataPrecision, int?dataScale, bool nullable, int?defaultLength, object dataDefault, int?charLength, bool?charUsed) { this.tableOwner = tableOwner; this.tableName = tableName; this.table = null; this.columnName = columnName; this.dataType = dataType; this.dataLength = dataLength; this.dataPrecision = dataPrecision; this.dataScale = dataScale; this.nullable = nullable; this.defaultLength = defaultLength; this.dataDefault = dataDefault; this.charLength = charLength; this.charUsed = charUsed; }
public Index( string owner, string tableOwner, string tableName, TableManager.Table tableRef, string indexName, EIndexType?indexType, EIndexUniqueness?indexUniqueness, bool?compression, int?prefixLength, string tablespaceName, EIndexStatus?indexStatus, bool?partitioned, bool?dropped) { }
public CheckConstraint( string owner, string tableName, TableManager.Table tableRef, string constraintName, EConstraintStatus?constraintStatus, EConstraintDeferrability?deferrableState, EConstraintDeferredState?deferredState, EConstraintValidation?validationState, EConstraintReliability?reliabilityState, bool?invalid, string searchCondition) : base(owner, tableName, constraintName, EConstraintType.Check, constraintStatus, deferrableState, deferredState, validationState, reliabilityState, invalid) { this.searchCondition = searchCondition; }
public bool Refresh(TableManager.Table table) { OracleCommand cmd = new OracleCommand(ALL_CONSTRAINTS_TABLE_SELECT, conn); cmd.BindByName = true; // set up parameters // schemaParam OracleParameter schemaParam = cmd.CreateParameter(); schemaParam.ParameterName = "owner"; schemaParam.OracleDbType = OracleDbType.Char; schemaParam.Direction = System.Data.ParameterDirection.Input; schemaParam.Value = table.Owner; cmd.Parameters.Add(schemaParam); // tableParam OracleParameter tableParam = cmd.CreateParameter(); tableParam.ParameterName = "table_name"; tableParam.OracleDbType = OracleDbType.Char; tableParam.Direction = System.Data.ParameterDirection.Input; tableParam.Value = table.Name; cmd.Parameters.Add(tableParam); // execute OracleDataReader odr = cmd.ExecuteReader(); if (!odr.HasRows) { return(false); } // purge old data purgeConstraintData(table); while (odr.Read()) { ConstraintBase constraint = LoadConstraint(odr); constraints.Add(constraint); } return(true); }
public ConstraintBase( string owner, string tableName, string constraintName, EConstraintType?constraintType, EConstraintStatus?constraintStatus, EConstraintDeferrability?deferrableState, EConstraintDeferredState?deferredState, EConstraintValidation?validationState, EConstraintReliability?reliabilityState, bool?invalid) { this.owner = owner; this.tableName = tableName; this.tableRef = null; this.constraintName = constraintName; this.constraintType = constraintType; this.deferrableState = deferrableState; this.deferredState = deferredState; this.validationState = validationState; this.reliabilityState = reliabilityState; this.invalid = invalid; }
public bool RefreshColumns(TableManager.Table table) { // set up command and parameters OracleCommand cmd = new OracleCommand(ALL_TAB_COLUMNS_TABLE_SELECT, conn); OracleParameter ownerParam = cmd.CreateParameter(); ownerParam.ParameterName = "owner"; ownerParam.OracleDbType = OracleDbType.Char; ownerParam.Direction = System.Data.ParameterDirection.Input; ownerParam.Value = table.Name; cmd.Parameters.Add(ownerParam); OracleParameter tableParam = cmd.CreateParameter(); tableParam.ParameterName = "table_name"; tableParam.OracleDbType = OracleDbType.Char; tableParam.Direction = System.Data.ParameterDirection.Input; tableParam.Value = table.Owner; cmd.Parameters.Add(tableParam); // prepare data reader OracleDataReader odr = cmd.ExecuteReader(); if (!odr.HasRows) { return(false); } // purge table columns data purgeTableColumnsData(table); while (odr.Read()) { TableColumn column = LoadColumn(odr); columns.Add(column); } return(true); }
private void purgeTableColumnsData(TableManager.Table table) { columns.RemoveAll((column) => (column.Table == table)); }
private void purgeConstraintData(TableManager.Table table) { constraints.RemoveAll((constraint) => (constraint.Table == table)); }
public ConstraintBase( string owner, string tableName, string constraintName, EConstraintType? constraintType, EConstraintStatus? constraintStatus, EConstraintDeferrability? deferrableState, EConstraintDeferredState? deferredState, EConstraintValidation? validationState, EConstraintReliability? reliabilityState, bool? invalid) { this.owner = owner; this.tableName = tableName; this.tableRef = null; this.constraintName = constraintName; this.constraintType = constraintType; this.deferrableState = deferrableState; this.deferredState = deferredState; this.validationState = validationState; this.reliabilityState = reliabilityState; this.invalid = invalid; }
public TableColumn( string tableOwner, string tableName, string columnName, OracleDbType? dataType, int dataLength, int? dataPrecision, int? dataScale, bool nullable, int? defaultLength, object dataDefault, int? charLength, bool? charUsed) { this.tableOwner = tableOwner; this.tableName = tableName; this.table = null; this.columnName = columnName; this.dataType = dataType; this.dataLength = dataLength; this.dataPrecision = dataPrecision; this.dataScale = dataScale; this.nullable = nullable; this.defaultLength = defaultLength; this.dataDefault = dataDefault; this.charLength = charLength; this.charUsed = charUsed; }
public bool Refresh(TableManager.Table table) { }