public string CreateDatabaseStructure(IConceptInfo conceptInfo)
{
var info = (ReferencePropertyDbConstraintInfo)conceptInfo;
var reference = info.Reference;
return(Sql.Format("ReferencePropertyConstraintDatabaseDefinition_Create",
SqlUtility.Identifier(reference.DataStructure.Module.Name) + "." + SqlUtility.Identifier(reference.DataStructure.Name),
GetConstraintName(reference),
reference.GetColumnName(),
ForeignKeyUtility.GetSchemaTableForForeignKey(reference.Referenced),
ForeignKeyConstraintOptions.Evaluate(info)));
}
public string CreateDatabaseStructure(IConceptInfo conceptInfo)
{
var info = (DataStructureExtendsInfo)conceptInfo;
if (ShouldCreateConstraint(info))
{
return(Sql.Format("DataStructureExtendsDatabaseDefinition_Create",
SqlUtility.Identifier(info.Extension.Module.Name) + "." + SqlUtility.Identifier(info.Extension.Name),
GetConstraintName(info),
ForeignKeyUtility.GetSchemaTableForForeignKey(info.Base),
ForeignKeyConstraintOptions.Evaluate(info)));
}
// TODO: else - Generate a Filter+InvalidData validation in the server application that checks for invalid items.
return("");
}
public string CreateDatabaseStructure(IConceptInfo conceptInfo)
{
var info = (ReferencePropertyInfo)conceptInfo;
if (IsSupported(info))
{
return(Sql.Format("ReferencePropertyConstraintDatabaseDefinition_Create",
SqlUtility.Identifier(info.DataStructure.Module.Name) + "." + SqlUtility.Identifier(info.DataStructure.Name),
GetConstraintName(info),
info.GetColumnName(),
ForeignKeyUtility.GetSchemaTableForForeignKey(info.Referenced),
ForeignKeyConstraintOptions.Evaluate(info)));
}
return("");
}
private static bool ShouldCreateConstraint(DataStructureExtendsInfo info)
{
return(info.Extension is EntityInfo &&
ForeignKeyUtility.GetSchemaTableForForeignKey(info.Base) != null);
}
public static bool IsSupported(UniqueReferenceInfo info)
{
return(info.Extension is EntityInfo &&
ForeignKeyUtility.GetSchemaTableForForeignKey(info.Base) != null);
}
public static bool ShouldCreateConstraint(UniqueReferenceInfo info)
{
return(info.Extension is EntityInfo &&
ForeignKeyUtility.GetSchemaTableForForeignKey(info.Base) != null);
}
public static bool IsSupported(ReferencePropertyInfo info)
{
return(ReferencePropertyDatabaseDefinition.IsSupported(info) &&
ForeignKeyUtility.GetSchemaTableForForeignKey(info.Referenced) != null);
}
