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)); }