/// <inheritdoc />
public IDeleteConstraintOnTableSyntax UniqueConstraint()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
_context.Expressions.Add(expression);
return(new DeleteConstraintExpressionBuilder(expression));
}
public override string Generate(DeleteConstraintExpression expression)
{
return(string.Format(
"ALTER TABLE {0} DROP CONSTRAINT {1};",
Quoter.QuoteTableName(expression.Constraint.TableName, expression.Constraint.SchemaName),
Quoter.Quote(expression.Constraint.ConstraintName)));
}
public static DeleteConstraintExpression GetDeletePrimaryKeyExpression()
{
var expression = new DeleteConstraintExpression(ConstraintType.PrimaryKey);
expression.Constraint.TableName = TestTableName1;
expression.Constraint.ConstraintName = "TESTPRIMARYKEY";
return(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)));
}
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));
}
/// <inheritdoc />
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 void WhenDefaultSchemaConventionIsChangedAndSchemaIsNotSetThenSetSchema()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
var processed = expression.Apply(ConventionSets.WithSchemaName);
Assert.That(processed.Constraint.SchemaName, Is.EqualTo("testdefault"));
}
public void WhenDefaultSchemaConventionIsAppliedAndSchemaIsNotSetThenSchemaShouldBeNull()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
var processed = expression.Apply(ConventionSets.NoSchemaName);
Assert.That(processed.Constraint.SchemaName, Is.Null);
}
/// <inheritdoc />
public IDeleteConstraintBuilder UniqueConstraint(string constraintName)
{
var expression = new DeleteConstraintExpression(_context, ConstraintType.Unique)
{
Constraint = { ConstraintName = constraintName }
};
return(new DeleteConstraintBuilder(expression));
}
public override string Generate(DeleteConstraintExpression expression)
{
var withParts = GetWithOptions(expression);
var withPart = !string.IsNullOrEmpty(withParts)
? $" WITH ({withParts})"
: string.Empty;
return($"{base.Generate(expression)}{withPart}");
}
public override string Generate(DeleteConstraintExpression expression)
{
if (expression.Constraint.IsPrimaryKeyConstraint)
{
return(string.Format("ALTER TABLE {0} DROP PRIMARY KEY;", Quoter.QuoteTableName(expression.Constraint.TableName)));
}
return(string.Format("{0};", base.Generate(expression)));
}
/// <inheritdoc />
public IDeleteConstraintBuilder PrimaryKey(string primaryKeyName)
{
var expression = new DeleteConstraintExpression(_context, ConstraintType.PrimaryKey)
{
Constraint = { ConstraintName = primaryKeyName }
};
return(new DeleteConstraintBuilder(expression));
}
public IDeleteConstraintOnTableSyntax UniqueConstraint(string constraintName)
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique)
{
Constraint = { ConstraintName = constraintName }
};
_context.Expressions.Add(expression);
return(new DeleteConstraintBuilder(expression));
}
public IDeleteConstraintOnTableSyntax PrimaryKey(string primaryKeyName)
{
var expression = new DeleteConstraintExpression(_context.CurrentDatabaseProvider, _databaseProviders, _sqlSyntax, ConstraintType.PrimaryKey)
{
Constraint = { ConstraintName = primaryKeyName }
};
_context.Expressions.Add(expression);
return(new DeleteConstraintBuilder(expression));
}
public void ErrorIsNotReturnedWhenTableNameIsNotNullEmptyString()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique)
{
Constraint = { TableName = "aTable" }
};
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldNotContain(ErrorMessages.TableNameCannotBeNullOrEmpty);
}
public void CanDeleteConstraint()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
expression.Constraint.TableName = "ConstraintTable";
expression.Constraint.ConstraintName = "Constraint";
string sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE \"public\".\"ConstraintTable\" DROP CONSTRAINT \"Constraint\"");
}
public void ApplyDefaultContraintName()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique);
var builder = new DeleteConstraintExpressionBuilder(expression);
builder.FromTable("Users").Column("AccountId");
var processed = expression.Apply(ConventionSets.NoSchemaName);
Assert.That(processed.Constraint.ConstraintName, Is.EqualTo("UC_Users_AccountId"));
}
public void WhenDefaultSchemaConventionIsAppliedAndSchemaIsSetThenSchemaShouldNotBeChanged()
{
var expression = new DeleteConstraintExpression(ConstraintType.Unique)
{
Constraint =
{
SchemaName = "testschema",
},
};
var processed = expression.Apply(ConventionSets.WithSchemaName);
Assert.That(processed.Constraint.SchemaName, Is.EqualTo("testschema"));
}
public override string Generate(DeleteConstraintExpression expression)
{
if (!expression.Constraint.IsUniqueConstraint)
{
return(CompatibilityMode.HandleCompatibilty("Only UNIQUE constraints are supported in SQLite"));
}
// Convert the constraint into a drop UNIQUE index
var idx = new DeleteIndexExpression();
idx.Index.Name = expression.Constraint.ConstraintName;
idx.Index.SchemaName = expression.Constraint.SchemaName;
return(Generate(idx));
}
private IEnumerable <DifferentialExpression> GetAlters(CreateConstraintExpression from, CreateConstraintExpression to)
{
var deleteOld = new DeleteConstraintExpression(ConstraintType.PrimaryKey)
{
Constraint = from.Constraint
};
var createNew = to;
var deleteNew = new DeleteConstraintExpression(ConstraintType.PrimaryKey)
{
Constraint = to.Constraint
};
var createOld = from;
return(new DifferentialExpression[]
{
new DifferentialExpression(deleteOld, createOld),
new DifferentialExpression(createNew, deleteNew)
});
}
public override string Generate(DeleteConstraintExpression expression)
{
Truncator.Truncate(expression);
return(base.Generate(expression));
}
public virtual void Process(DeleteConstraintExpression expression)
{
Process(Generator.Generate(expression));
}
public override string Generate(DeleteConstraintExpression expression)
{
return(string.Format("ALTER TABLE {0}.{1}", Quoter.QuoteSchemaName(expression.Constraint.SchemaName), base.Generate(expression)));
}
public override string Generate(DeleteConstraintExpression expression)
{
return(CompatibilityMode.HandleCompatibilty("Constraints are not supported"));
}
public override void Process(DeleteConstraintExpression expression)
{
truncator.Truncate(expression);
RegisterExpression(expression, typeof(DeleteConstraintExpression));
InternalProcess(Generator.Generate(expression));
}
public abstract string Generate(DeleteConstraintExpression expression);
public override string Generate(DeleteConstraintExpression expression)
{
return(string.Format(DeleteConstraint,
Quoter.QuoteTableName(expression.Constraint.TableName, expression.Constraint.SchemaName),
Quoter.QuoteConstraintName(expression.Constraint.ConstraintName)));
}
public override string Generate(DeleteConstraintExpression expression)
{
return(string.Format(DeleteConstraint, Quoter.QuoteTableName(expression.Constraint.TableName), Quoter.Quote(expression.Constraint.ConstraintName), CommandDelimiter));
}
public override void Process(DeleteConstraintExpression expression)
{
Truncator.Truncate(expression);
InternalProcess(Generator.Generate(expression));
}
public void Truncate(DeleteConstraintExpression expression)
{
Truncate(expression.Constraint);
}