public override string Generate(DeleteConstraintExpression expression)
{
return string.Format(DeleteConstraint, Quoter.QuoteTableName(expression.Constraint.TableName), Quoter.Quote(expression.Constraint.ConstraintName));
}
public override string Generate(DeleteConstraintExpression expression)
{
truncator.Truncate(expression);
return base.Generate(expression);
}
public IDeleteConstraintOnTableSyntax UniqueConstraint(string constraintName)
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
expression.Constraint.ConstraintName = constraintName;
_context.Expressions.Add(expression);
return new DeleteConstraintExpressionBuilder(expression);
}
public IDeleteConstraintOnTableSyntax PrimaryKey(string primaryKeyName)
{
var expression = new DeleteConstraintExpression(ConstraintType.PrimaryKey);
expression.Constraint.ConstraintName = primaryKeyName;
_context.Expressions.Add(expression);
return new DeleteConstraintExpressionBuilder(expression);
}
public static DeleteConstraintExpression GetDeleteUniqueConstraintExpression()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
expression.Constraint.TableName = TestTableName1;
expression.Constraint.ConstraintName = "TESTUNIQUECONSTRAINT";
return expression;
}
public override string Generate(DeleteConstraintExpression expression)
{
return string.Format("ALTER TABLE {0}.{1} DROP CONSTRAINT {2}", Quoter.QuoteSchemaName(expression.Constraint.SchemaName), Quoter.QuoteTableName(expression.Constraint.TableName), Quoter.Quote(expression.Constraint.ConstraintName));
}
public void Truncate(DeleteConstraintExpression expression)
{
Truncate(expression.Constraint);
}
public static DeleteConstraintExpression GetDeletePrimaryKeyExpression()
{
var expression = new DeleteConstraintExpression(ConstraintType.PrimaryKey);
expression.Constraint.TableName = TestTableName1;
expression.Constraint.ConstraintName = "TESTPRIMARYKEY";
return expression;
}
public abstract string Generate(DeleteConstraintExpression expression);
public void ErrorIsNotReturnedWhenTableNameIsNotNullEmptyString()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique) { Constraint = { TableName = "aTable" } };
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldNotContain(ErrorMessages.TableNameCannotBeNullOrEmpty);
}
public override string Generate(DeleteConstraintExpression expression)
{
return string.Format("ALTER TABLE {0}.{1}", Quoter.QuoteSchemaName(expression.Constraint.SchemaName), base.Generate(expression));
}
public virtual void Process(DeleteConstraintExpression expression)
{
Process(Generator.Generate(expression));
}
public void CanDeleteConstraintWithSchema()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
expression.Constraint.TableName = "ConstraintTable";
expression.Constraint.SchemaName = "Schema";
expression.Constraint.ConstraintName = "Constraint";
string sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE \"Schema\".\"ConstraintTable\" DROP CONSTRAINT \"Constraint\"");
}
public override string Generate(DeleteConstraintExpression expression)
{
return string.Format("{0};", base.Generate(expression));
}
public override string Generate(DeleteConstraintExpression expression)
{
if (expression.Constraint.IsPrimaryKeyConstraint)
{
return string.Format(DeleteConstraint, Quoter.QuoteTableName(expression.Constraint.TableName), "PRIMARY KEY","");
}
return string.Format(DeleteConstraint, Quoter.QuoteTableName(expression.Constraint.TableName),"INDEX ", Quoter.Quote(expression.Constraint.ConstraintName));
}