public void ErrorIsNotReturnedWhenSequenceNameIsSet() { var expression = new CreateSequenceExpression { Sequence = new SequenceDefinition { Name = "sequence1" } }; var errors = ValidationHelper.CollectErrors(expression); Assert.That(errors.Count, Is.EqualTo(0)); }
public void ErrorIsReturnedWhenSequenceNameIsEmptyString() { var expression = new CreateSequenceExpression { Sequence = new SequenceDefinition { Name = String.Empty } }; var errors = ValidationHelper.CollectErrors(expression); errors.ShouldContain(ErrorMessages.SequenceNameCannotBeNullOrEmpty); }
public override string Generate(CreateSequenceExpression expression) { var result = new StringBuilder(string.Format("CREATE SEQUENCE ")); var seq = expression.Sequence; if (string.IsNullOrEmpty(seq.SchemaName)) { result.AppendFormat(Quoter.QuoteSequenceName(seq.Name)); } else { result.AppendFormat("{0}.{1}", Quoter.QuoteSchemaName(seq.SchemaName), Quoter.QuoteSequenceName(seq.Name)); } if (seq.Increment.HasValue) { result.AppendFormat(" INCREMENT BY {0}", seq.Increment); } if (seq.MinValue.HasValue) { result.AppendFormat(" MINVALUE {0}", seq.MinValue); } if (seq.MaxValue.HasValue) { result.AppendFormat(" MAXVALUE {0}", seq.MaxValue); } if (seq.StartWith.HasValue) { result.AppendFormat(" START WITH {0}", seq.StartWith); } if (seq.Cache.HasValue) { result.AppendFormat(" CACHE {0}", seq.Cache); } if (seq.Cycle) { result.Append(" CYCLE"); } result.Append(";"); return result.ToString(); }
public void CanCreateSequenceWithoutSchema() { var expression = new CreateSequenceExpression { Sequence = { Cache = 10, Cycle = true, Increment = 2, MaxValue = 100, MinValue = 0, Name = "Sequence", StartWith = 2 } }; var sql = generator.Generate(expression); sql.ShouldBe("CREATE SEQUENCE \"Sequence\" INCREMENT 2 MINVALUE 0 MAXVALUE 100 START WITH 2 CACHE 10 CYCLE"); }
public void CanAlterSequence() { var expression = new CreateSequenceExpression { Sequence = { Cache = 10, Cycle = true, Increment = 2, MaxValue = 100, MinValue = 0, Name = "Sequence", SchemaName = "Schema", StartWith = 2 } }; var result = generator.GenerateAlterSequence(expression.Sequence); result.ShouldBe("ALTER SEQUENCE \"Sequence\" RESTART WITH 2"); }
public override string Generate(CreateSequenceExpression expression) { truncator.Truncate(expression); return String.Format("CREATE SEQUENCE {0}", Quoter.QuoteSequenceName(expression.Sequence.Name)); }
public ICreateSequenceInSchemaSyntax Sequence(string sequenceName) { var expression = new CreateSequenceExpression { Sequence = { Name = sequenceName } }; _context.Expressions.Add(expression); return new CreateSequenceExpressionBuilder(expression); }
public override string Generate(CreateSequenceExpression expression) { return compatabilityMode.HandleCompatabilty("Sequences are not supported in SqlServer2000"); }
public void Truncate(CreateSequenceExpression expression) { Truncate(expression.Sequence); }
public abstract string Generate(CreateSequenceExpression expression);
public override string Generate(CreateSequenceExpression expression) { return compatabilityMode.HandleCompatabilty("Sequences is not supporteed for MySql"); }
public void CanCreateSequence() { var expression = new CreateSequenceExpression { Sequence = { Cache = 10, Cycle = true, Increment = 2, MaxValue = 100, MinValue = 0, Name = "Sequence", SchemaName = "Schema", StartWith = 2 } }; var sql = generator.Generate(expression); sql.ShouldBe("CREATE SEQUENCE \"Sequence\""); }
public virtual void Process(CreateSequenceExpression expression) { Process(Generator.Generate(expression)); }
public override string Generate(CreateSequenceExpression expression) { throw new NotImplementedException(); }
public override string Generate(CreateSequenceExpression expression) { return String.Format("{0};", base.Generate(expression)); }