private string ParseConstraint(DataConstraint constraint)
{
if (constraint == null)
{
throw new ArgumentNullException(nameof(constraint));
}
var result = string.Empty;
switch (constraint.Type)
{
case DataConstraintType.Group:
result = ParseGroup(constraint as DataConstraintGroup);
break;
case DataConstraintType.Expression:
result = ParseExpression(constraint as DataConstraintExpression);
break;
default:
throw new InvalidOperationException($"Unsupported type of {constraint.Type}");
}
return(result);
}
public string Parse(DataConstraint constraint)
{
if (constraint == null)
{
return(null);
}
return(this.ParseConstraint(constraint));
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr)
{
DataConstraint t = new DataConstraint();
int field = 0;
t.ConstraintName = rdr.GetAsString(field++);
t.TableSchema = rdr.GetAsString(field++);
t.TableName = rdr.GetAsString(field++);
t.ColumnName = rdr.GetAsString(field++);
return(t);
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr)
{
var constraint = new DataConstraint();
int field = 0;
constraint.TableSchema = rdr.GetAsString(field++);
constraint.ConstraintName = rdr.GetAsString(field++);
constraint.TableName = rdr.GetAsString(field++);
constraint.ColumnName = rdr.GetAsString(field++);
constraint.ConstraintType = rdr.GetAsString(field++);
constraint.ReverseConstraintName = rdr.GetAsString(field++);
return constraint;
}
public Boolean isValidDataConstraint(DataConstraint constraints)
{
CustomTuple stDataSet = constraints.constraintStandards.standards;
if (!constraintStandards.isPassStandard(stDataSet))
{
return(false);
}
else
{
return(true);
}
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr)
{
DataConstraint constraint = new DataConstraint();
int field = 0;
constraint.ConstraintName = rdr.GetAsString(field++);
constraint.TableSchema = rdr.GetAsString(field++);
constraint.TableName = rdr.GetAsString(field++).Trim();
constraint.ColumnName = rdr.GetAsString(field++).Trim();
constraint.ReferencedTableSchema = rdr.GetAsString(field++);
constraint.ReferencedTableName = rdr.GetAsString(field++).Trim();
constraint.ReferencedColumnName = rdr.GetAsString(field++).Trim();
return constraint;
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr)
{
var constraint = new DataConstraint();
int field = 0;
constraint.TableSchema = rdr.GetAsString(field++);
constraint.ConstraintName = rdr.GetAsString(field++);
constraint.TableName = rdr.GetAsString(field++);
constraint.ColumnName = rdr.GetAsString(field++);
constraint.ConstraintType = rdr.GetAsString(field++);
constraint.ReverseConstraintName = rdr.GetAsString(field++);
return(constraint);
}
protected override void LoadConstraints(Database schema, SchemaName schemaName, IDbConnection conn, NameFormat nameFormat, Names names)
{
var constraints = ReadConstraints(conn, schemaName.DbName);
foreach (DataConstraint constraint in constraints)
{
//find my table:
string constraintFullDbName = GetFullDbName(constraint.TableName, constraint.TableSchema);
DbLinq.Schema.Dbml.Table table = schema.Tables.FirstOrDefault(t => constraintFullDbName == t.Name);
if (table == null)
{
WriteErrorLine("ERROR L100: Table '" + constraint.TableName + "' not found for column " + constraint.ColumnName);
continue;
}
//if (table.Name.StartsWith("E"))
// Logger.Write("---Dbg");
if (constraint.ConstraintType == "P")
{
//A) add primary key
DbLinq.Schema.Dbml.Column pkColumn = table.Type.Columns.Where(c => c.Name == constraint.ColumnName).First();
pkColumn.IsPrimaryKey = true;
}
else if (constraint.ConstraintType == "R")
{
//if not PRIMARY, it's a foreign key. (constraint_type=="R")
//both parent and child table get an [Association]
DataConstraint referencedConstraint = constraints.FirstOrDefault(c => c.ConstraintName == constraint.ReverseConstraintName);
if (constraint.ReverseConstraintName == null || referencedConstraint == null)
{
WriteErrorLine("ERROR L127: given R_contraint_name='" + constraint.ReverseConstraintName + "', unable to find parent constraint");
continue;
}
LoadForeignKey(schema, table, constraint.ColumnName, constraint.TableName, constraint.TableSchema,
referencedConstraint.ColumnName, referencedConstraint.TableName,
referencedConstraint.TableSchema,
constraint.ConstraintName, nameFormat, names);
}
// custom type, this is a trigger
else if (constraint.ConstraintType == "T" && constraint.ColumnName != null)
{
var column = table.Type.Columns.Where(c => c.Name == constraint.ColumnName).First();
column.Expression = constraint.Expression;
column.IsDbGenerated = true;
}
}
//GuessSequencePopulatedFields(schema);
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr)
{
DataConstraint constraint = new DataConstraint();
int field = 0;
constraint.ConstraintName = rdr.GetAsString(field++);
constraint.TableSchema = rdr.GetAsString(field++);
constraint.TableName = rdr.GetAsString(field++).Trim();
constraint.ColumnName = rdr.GetAsString(field++).Trim();
constraint.ReferencedTableSchema = rdr.GetAsString(field++);
constraint.ReferencedTableName = rdr.GetAsString(field++).Trim();
constraint.ReferencedColumnName = rdr.GetAsString(field++).Trim();
return(constraint);
}
public static ShortMeasTask[] GetShortMeasTasks(DataConstraint constraint)
{
var otherArgs = new CommonOperationArguments()
{
UserId = MD.Employee.GetCurrentUserId()
};
var result = Execute(contract => contract.GetShortMeasTasks(constraint, otherArgs));
if (result == null)
{
return(new ShortMeasTask[] { });
}
return(result);
}
MeasurementResults[] ISdrnsController.GetMeasResults(DataConstraint constraint, CommonOperationArguments otherArgs)
{
var result =
Operation <SdrnsControllerAppService.GetMeasResultsAppOperation, MeasurementResults[]>()
.Invoke(
new GetMeasResultsAppOperationOptions
{
Constraint = constraint,
OtherArgs = otherArgs
},
this.OperationContext
);
return(result);
}
CommonOperationDataResult <int> ISdrnsController.DeleteMeasResults(DataConstraint constraint, CommonOperationArguments otherArgs)
{
var result =
Operation <SdrnsControllerAppService.DeleteMeasResultsAppOperation, CommonOperationDataResult <int> >()
.Invoke(
new DeleteMeasResultsAppOperationOptions
{
Constraint = constraint,
OtherArgs = otherArgs
},
this.OperationContext
);
return(result);
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr)
{
DataConstraint t = new DataConstraint();
const int K_ID = 0;
//const int K_SEQ = 1;
const int K_TABLE = 1;
const int K_FROM = 3;
const int K_TO = 4;
t.TableSchema = "main";
//t.ReferencedTableSchema = "main";
t.ConstraintName = rdr.GetAsString(0);
t.TableName = rdr.GetString(1);
t.ColumnName = rdr.GetAsString(2);
//t.ReferencedTableName = UnquoteSqlName(rdr.GetAsString(K_TABLE));
//t.ReferencedColumnName = rdr.GetAsString(K_TO);
return(t);
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr, string table)
{
DataConstraint t = new DataConstraint();
const int K_ID = 0;
//const int K_SEQ = 1;
const int K_TABLE = 2;
const int K_FROM = 3;
const int K_TO = 4;
t.TableSchema = "main";
t.ReferencedTableSchema = "main";
t.ConstraintName = "fk_" + table + "_" + rdr.GetAsNumeric <int>(K_ID).ToString();
t.TableName = table;
t.ColumnName = rdr.GetAsString(K_FROM);
t.ReferencedTableName = UnquoteSqlName(rdr.GetAsString(K_TABLE));
t.ReferencedColumnName = rdr.GetAsString(K_TO);
return(t);
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr, string table)
{
DataConstraint t = new DataConstraint();
const int K_ID = 0;
//const int K_SEQ = 1;
const int K_TABLE = 2;
const int K_FROM = 3;
const int K_TO = 4;
t.TableSchema = "main";
t.ReferencedTableSchema = "main";
t.ConstraintName = "fk_" + table + "_" + rdr.GetAsNumeric<int>(K_ID).ToString();
t.TableName = table;
t.ColumnName = rdr.GetAsString(K_FROM);
t.ReferencedTableName = UnquoteSqlName(rdr.GetAsString(K_TABLE));
t.ReferencedColumnName = rdr.GetAsString(K_TO);
return t;
}
protected virtual DataConstraint ReadTrigger(IDataReader rdr)
{
var constraint = new DataConstraint();
int field = 0;
constraint.ConstraintName = rdr.GetAsString(field++);
constraint.TableSchema = rdr.GetAsString(field++);
constraint.TableName = rdr.GetAsString(field++);
constraint.ConstraintType = "T";
string body = rdr.GetAsString(field++);
//BEGIN
// IF (:new."EmployeeID" IS NULL) THEN
// SELECT Employees_seq.NEXTVAL INTO :new."EmployeeID" FROM DUAL;
// END IF;
//END;
string expression, column;
if (MatchTrigger(TriggerMatch1, body, out expression, out column))
{
constraint.ColumnNames.Add(column.Trim('"'));
constraint.Expression = expression;
}
return constraint;
}
protected virtual DataConstraint ReadTrigger(IDataReader rdr)
{
var constraint = new DataConstraint();
int field = 0;
constraint.ConstraintName = rdr.GetAsString(field++);
constraint.TableSchema = rdr.GetAsString(field++);
constraint.TableName = rdr.GetAsString(field++);
constraint.ConstraintType = "T";
string body = rdr.GetAsString(field++);
//BEGIN
// IF (:new."EmployeeID" IS NULL) THEN
// SELECT Employees_seq.NEXTVAL INTO :new."EmployeeID" FROM DUAL;
// END IF;
//END;
string expression, column;
if (MatchTrigger(TriggerMatch1, body, out expression, out column))
{
constraint.ColumnNames.Add(column.Trim('"'));
constraint.Expression = expression;
}
return(constraint);
}
protected virtual DataConstraint ReadConstraint(IDataReader rdr)
{
DataConstraint t = new DataConstraint();
int field = 0;
t.ConstraintName = rdr.GetAsString(field++);
t.TableSchema = rdr.GetAsString(field++);
t.TableName = rdr.GetAsString(field++);
t.ColumnName = rdr.GetAsString(field++);
return t;
}
