public override string GetSqlString()
{
var collectionToStringTool = new CollectionToString(null, string.Empty);
var packageHeaderString = collectionToStringTool.GetAsString(
DbContext.DBA_SOURCE
.Where(
s =>
s.OWNER == _package.OWNER &&
s.NAME == _package.OBJECT_NAME &&
s.TYPE == _package.OBJECT_TYPE)
.OrderBy(s => s.LINE)
.Select(s => s.TEXT)
.ToList());
var packageBodyString = collectionToStringTool.GetAsString(
DbContext.DBA_SOURCE
.Where(
s =>
s.TYPE == "PACKAGE BODY" &&
s.OWNER == _package.OWNER &&
s.NAME == _package.OBJECT_NAME)
.OrderBy(s => s.LINE)
.Select(s => s.TEXT)
.ToList());
return(TemplateStrings.GetTemplate(TemplateFileName)
.Replace("[PACKAGE_HEADER]", packageHeaderString)
.Replace("[PACKAGE_BODY]", packageBodyString));
}
public override string GetSqlString()
{
LoadReferencedConstraint();
var constraintColumns = LoadConstraintColumns(_foreignKeyConstraint);
var refConstraintColumns = LoadConstraintColumns(_refConstraint);
var collectionToStringTool = new CollectionToString();
var constraintColumnsString = collectionToStringTool.GetAsString(
constraintColumns
.Select(c => c.COLUMN_NAME.ToLowerInvariant())
.ToList());
var refConstraintColumnsString = collectionToStringTool.GetAsString(
refConstraintColumns
.Select(c => c.COLUMN_NAME.ToLowerInvariant())
.ToList());
return(TemplateStrings.GetTemplate(TemplateFileName)
.Replace("[TABLENAME]", _foreignKeyConstraint.TABLE_NAME.ToLowerInvariant())
.Replace("[CONSTRAINTNAME]", _foreignKeyConstraint.CONSTRAINT_NAME.ToLowerInvariant())
.Replace("[CONSTRAINTCOLUMNS]", constraintColumnsString)
.Replace("[REFTABLENAME]", _refConstraint.TABLE_NAME.ToLowerInvariant())
.Replace("[REFCONSTRAINTCOLUMNS]", refConstraintColumnsString)
.Replace("[CONSTRAINTSTATE]", _foreignKeyConstraint.STATUS.Equals("DISABLED") ? " disable" : string.Empty));
}
public override string GetSqlString()
{
LoadReferencedConstraint();
var constraintColumns = LoadConstraintColumns(_foreignKeyConstraint);
var refConstraintColumns = LoadConstraintColumns(_refConstraint);
var collectionToStringTool = new CollectionToString();
var constraintColumnsString = collectionToStringTool.GetAsString(
constraintColumns
.Select(c => c.COLUMN_NAME.ToLowerInvariant())
.ToList());
var refConstraintColumnsString = collectionToStringTool.GetAsString(
refConstraintColumns
.Select(c => c.COLUMN_NAME.ToLowerInvariant())
.ToList());
return TemplateStrings.GetTemplate(TemplateFileName)
.Replace("[TABLENAME]",_foreignKeyConstraint.TABLE_NAME.ToLowerInvariant())
.Replace("[CONSTRAINTNAME]",_foreignKeyConstraint.CONSTRAINT_NAME.ToLowerInvariant())
.Replace("[CONSTRAINTCOLUMNS]",constraintColumnsString)
.Replace("[REFTABLENAME]",_refConstraint.TABLE_NAME.ToLowerInvariant())
.Replace("[REFCONSTRAINTCOLUMNS]",refConstraintColumnsString)
.Replace("[CONSTRAINTSTATE]",_foreignKeyConstraint.STATUS.Equals("DISABLED") ? " disable" : string.Empty);
}
public override string GetSqlString()
{
var collectionToStringTool = new CollectionToString(null, string.Empty);
var packageHeaderString = collectionToStringTool.GetAsString(
DbContext.DBA_SOURCE
.Where(
s =>
s.OWNER == _package.OWNER &&
s.NAME == _package.OBJECT_NAME &&
s.TYPE == _package.OBJECT_TYPE)
.OrderBy(s => s.LINE)
.Select(s => s.TEXT)
.ToList());
var packageBodyString = collectionToStringTool.GetAsString(
DbContext.DBA_SOURCE
.Where(
s =>
s.TYPE == "PACKAGE BODY" &&
s.OWNER == _package.OWNER &&
s.NAME == _package.OBJECT_NAME)
.OrderBy(s => s.LINE)
.Select(s => s.TEXT)
.ToList());
return TemplateStrings.GetTemplate(TemplateFileName)
.Replace("[PACKAGE_HEADER]", packageHeaderString)
.Replace("[PACKAGE_BODY]", packageBodyString);
}
public override string GetSqlString()
{
LoadPrimaryKeysCollection();
LoadOtherConstraintsCollection();
const string separatorString = ",";
const bool newLineBetweenCollectionItems = true;
var collectionToStringTool = new CollectionToString(
null,
separatorString,
newLineBetweenCollectionItems);
var primaryKeyString = collectionToStringTool.GetAsString(
_primaryKeysCollection
.Select(c => new PrimaryKeyConstraintSqlGenerator(DbContext, c).GetSqlString())
.ToList());
var otherConstraintsString = collectionToStringTool.GetAsString(
_otherConstraintsCollection
.Select(c => new OtherConstraintSqlGenerator(DbContext, c).GetSqlString())
.ToList());
var sqlStringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(primaryKeyString))
{
sqlStringBuilder.AppendLine(separatorString);
sqlStringBuilder.AppendLine();
sqlStringBuilder.Append(primaryKeyString);
}
if (!string.IsNullOrEmpty(otherConstraintsString))
{
sqlStringBuilder.AppendLine(separatorString);
sqlStringBuilder.AppendLine();
sqlStringBuilder.Append(otherConstraintsString);
}
return(sqlStringBuilder.ToString());
}
public override string GetSqlString()
{
LoadPrimaryKeysCollection();
LoadOtherConstraintsCollection();
const string separatorString = ",";
const bool newLineBetweenCollectionItems = true;
var collectionToStringTool = new CollectionToString(
null,
separatorString,
newLineBetweenCollectionItems);
var primaryKeyString = collectionToStringTool.GetAsString(
_primaryKeysCollection
.Select(c => new PrimaryKeyConstraintSqlGenerator(DbContext, c).GetSqlString())
.ToList());
var otherConstraintsString = collectionToStringTool.GetAsString(
_otherConstraintsCollection
.Select(c => new OtherConstraintSqlGenerator(DbContext, c).GetSqlString())
.ToList());
var sqlStringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(primaryKeyString))
{
sqlStringBuilder.AppendLine(separatorString);
sqlStringBuilder.AppendLine();
sqlStringBuilder.Append(primaryKeyString);
}
if (!string.IsNullOrEmpty(otherConstraintsString))
{
sqlStringBuilder.AppendLine(separatorString);
sqlStringBuilder.AppendLine();
sqlStringBuilder.Append(otherConstraintsString);
}
return sqlStringBuilder.ToString();
}
