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)
{
}
