private static bool HasParameterBeenRemoved(ModelRelationshipInstance parameter, TSqlObject oldProcedure)
{
/*
A parameter does not exist in the old model
*/
return
oldProcedure.GetReferencedRelationshipInstances(Procedure.Parameters)
.FirstOrDefault(p => p.ObjectName.Parts.Last() == parameter.ObjectName.Parts.Last()) == null;
}
private static bool HasParameterBeenRemoved(ModelRelationshipInstance parameter, TSqlObject oldProcedure)
{
/*
* A parameter does not exist in the old model
*/
return
(oldProcedure.GetReferencedRelationshipInstances(Procedure.Parameters)
.FirstOrDefault(p => p.ObjectName.Parts.Last() == parameter.ObjectName.Parts.Last()) == null);
}
public TSqlModelElementReference(ModelRelationshipInstance relationshipReference, ModelTypeClass typeClass) :
this(relationshipReference)
{
if (relationshipInstance.Object != null && relationshipInstance.Object.ObjectType != typeClass)
{
throw new ArgumentException(string.Format(CultureInfo.CurrentCulture,
ModelMessages.InvalidObjectType, relationshipInstance.Object.ObjectType.Name, typeClass.Name),
"typeClass");
}
predefinedTypeClass = typeClass;
}
private ColumnDescriptor CreateColumnDefinition(ModelRelationshipInstance column)
{
var definition = new ColumnDescriptor();
definition.Name = new Identifier {Value = column.ObjectName.GetName()};
var type = column.Object.GetReferenced(Column.DataType).FirstOrDefault();
if (type == null)
return null;//COMPUTED COLUMN
definition.LiteralType = LiteralConverter.GetLiteralType(type.Name);
return definition;
}
private ColumnDescriptor CreateColumnDefinition(ModelRelationshipInstance column)
{
var definition = new ColumnDescriptor();
definition.Name = new Identifier {
Value = column.ObjectName.GetName()
};
var type = column.Object.GetReferenced(Column.DataType).FirstOrDefault();
if (type == null)
{
return(null);//COMPUTED COLUMN
}
definition.LiteralType = LiteralConverter.GetLiteralType(type.Name);
return(definition);
}
private bool HasDefaultValueBeenRemoved(ModelRelationshipInstance parameter, TSqlObject oldProcedure)
{
var newParameterHasDefault = parameter.Object.GetProperty(Parameter.DefaultExpression) != null;
var parameterInOldModel =
oldProcedure.GetReferencedRelationshipInstances(Procedure.Parameters)
.FirstOrDefault(p => p.ObjectName.Parts.Last() == parameter.ObjectName.Parts.Last());
/*
* A parameter in the new model has no default but it had a default in the old model...
*/
if (parameterInOldModel != null && !newParameterHasDefault && (parameterInOldModel.Object.GetProperty(Parameter.DefaultExpression) != null))
{
return(true);
}
return(false);
}
private bool HasDefaultValueBeenRemoved(ModelRelationshipInstance parameter, TSqlObject oldProcedure)
{
var newParameterHasDefault = parameter.Object.GetProperty(Parameter.DefaultExpression) != null;
var parameterInOldModel =
oldProcedure.GetReferencedRelationshipInstances(Procedure.Parameters)
.FirstOrDefault(p => p.ObjectName.Parts.Last() == parameter.ObjectName.Parts.Last());
/*
A parameter in the new model has no default but it had a default in the old model...
*/
if (parameterInOldModel != null && !newParameterHasDefault && (parameterInOldModel.Object.GetProperty(Parameter.DefaultExpression) != null))
{
return true;
}
return false;
}
private static bool HasParameterBeenAddedWithoutDefaultValue(ModelRelationshipInstance parameter,
TSqlObject newProcedure)
{
var hasDefault = parameter.Object.GetProperty(Parameter.DefaultExpression) != null;
var parameterInOldModel =
newProcedure.GetReferencedRelationshipInstances(Procedure.Parameters)
.FirstOrDefault(p => p.ObjectName.Parts.Last() == parameter.ObjectName.Parts.Last());
/*
* A parameter did not exist in the old model and has no default
*/
if (parameterInOldModel == null && !hasDefault)
{
return(true);
}
return(false);
}
private static bool HasParameterBeenAddedWithoutDefaultValue(ModelRelationshipInstance parameter,
TSqlObject newProcedure)
{
var hasDefault = parameter.Object.GetProperty(Parameter.DefaultExpression) != null;
var parameterInOldModel =
newProcedure.GetReferencedRelationshipInstances(Procedure.Parameters)
.FirstOrDefault(p => p.ObjectName.Parts.Last() == parameter.ObjectName.Parts.Last());
/*
A parameter did not exist in the old model and has no default
*/
if (parameterInOldModel == null && !hasDefault)
{
return true;
}
return false;
}
public TSqlModelElementReference(ModelRelationshipInstance relationshipReference) :
base()
{
relationshipInstance = relationshipReference;
}
private static void DumpColumn(ModelRelationshipInstance column, string type)
{
Console.WriteLine("{0}: {1}", type, column.ObjectName);
}
private static void DumpColumn(ModelRelationshipInstance column, string type)
{
Console.WriteLine("{0}: {1}", type, column.ObjectName);
}
