private void AssertScalePropertyIsEqualTo(string dataType, int expectedScale)
{
var a = new ColumnDataTypeDefinition(dataType, false);
Assert.That(a, Is.Not.Null, dataType);
Assert.That(a.Scale, Is.EqualTo(expectedScale), dataType);
}
private void AssertLengthPropertyIsEqualTo(string dataType, int expectedLength)
{
var a = new ColumnDataTypeDefinition(dataType, false);
Assert.That(a, Is.Not.Null, dataType);
Assert.That(a.MaxLength, Is.EqualTo(expectedLength), dataType);
}
public DataFieldEntity(string fieldName, Guid valueKey, ColumnDataTypeDefinition datatype, bool producesValue)
{
this.FieldName = fieldName;
this.KeyValue = valueKey;
this.ProducesValue = producesValue;
this.DataType = datatype;
}
public void ShouldGetDatatTypeStringFormatterForType()
{
var dt = new ColumnDataTypeDefinition("decimal", false);
// Console.WriteLine(string.Format(CultureInfo.InvariantCulture, "{0:0.00}", new decimal(55.5555)));
Assert.That(dt.StringFormatter, Is.EqualTo("{0}"));
}
private void AssertMinAndMaxValue(string dataType, decimal min, decimal max)
{
var a = new ColumnDataTypeDefinition(dataType, false);
Assert.That(a.MinValue, Is.EqualTo(min), dataType);
Assert.That(a.MaxValue, Is.EqualTo(max), dataType);
}
public void ShouldUseDefaultValuesWhenInvalidInputsInDecimalDatatype()
{
var a = new ColumnDataTypeDefinition("Decimal(0, 1)", false);
Assert.That(a.Scale, Is.EqualTo(ColumnDataTypeDefinition.DECIMAL_DEFAULT_SCALE));
Assert.That(a.MaxLength, Is.EqualTo(ColumnDataTypeDefinition.DECIMAL_DEFAULT_LENGTH));
}
public CountingUpDecimalGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.StartValue = new GeneratorParameter("StartValue", 0.0m,
GeneratorParameterParser.DecimalParser);
GeneratorParameters.Step = new GeneratorParameter("Step", 1.0m,
GeneratorParameterParser.DecimalParser);
}
public RandomNumberDecimalGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.MinValue = new GeneratorParameter("Min Value", 1m,
GeneratorParameterParser.DecimalParser);
GeneratorParameters.MaxValue = new GeneratorParameter("Max Value", datatype.MaxValue,
GeneratorParameterParser.DecimalParser);
}
protected DecimalGeneratorBase(string generatorName, ColumnDataTypeDefinition dataType)
: base(generatorName)
{
//GeneratorParameters.MinValue = new GeneratorParameter("MinValue", dataType.MinValue,
// GeneratorParameterParser.DecimalParser, false);
//GeneratorParameters.MaxValue = new GeneratorParameter("MaxValue", dataType.MaxValue,
// GeneratorParameterParser.DecimalParser, false);
}
public RandomForeignKeyIntGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.StartValue = new GeneratorParameter("StartValue", 1,
GeneratorParameterParser.IntegerParser);
GeneratorParameters.Step = new GeneratorParameter("Step", 1,
GeneratorParameterParser.IntegerParser);
}
public void ShouldGetMinAndMaxFromDecimal()
{
var a = new ColumnDataTypeDefinition("Decimal(3, 1)", false);
Assert.That(a.MaxValue, Is.EqualTo(99.9));
AssertMinAndMaxValue("Decimal(3, 1)", -99.9m, 99.9m);
AssertMinAndMaxValue("Decimal(1, 1)", -0.9m, 0.9m);
AssertMinAndMaxValue("Decimal(4, 2)", -99.99m, 99.99m);
}
public DaysSeriesDateTimeGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.Add(new GeneratorParameter("Shift Days", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Hours", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Minutes", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Seconds", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Milliseconds", 0, GeneratorParameterParser.IntegerParser));
}
public RandomExponentialIntGenerator(ColumnDataTypeDefinition dataType)
: base(GENERATOR_NAME, dataType)
{
GeneratorParameters.StartValue = new GeneratorParameter("Lambda", 1.1m,
GeneratorParameterParser.DecimalParser);
GeneratorParameters.MinValue = new GeneratorParameter("MinValue", dataType.MinValue, GeneratorParameterParser.LonglParser, false);
GeneratorParameters.MaxValue = new GeneratorParameter("MaxValue", dataType.MaxValue, GeneratorParameterParser.LonglParser, false);
}
public CountingUpIntGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.StartValue = new GeneratorParameter("StartValue", 1,
GeneratorParameterParser.IntegerParser);
GeneratorParameters.Step = new GeneratorParameter("Step", 1,
GeneratorParameterParser.IntegerParser);
GeneratorParameters.MaxValue = new GeneratorParameter("MaxValue", datatype.MaxValue, GeneratorParameterParser.LonglParser, false);
GeneratorParameters.MinValue = new GeneratorParameter("MinValue", datatype.MinValue, GeneratorParameterParser.LonglParser, false);
}
public CurrentDateTimeGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.StartDate = new GeneratorParameter("Start Date", DateTime.Now, GeneratorParameterParser.DateTimeParser);
GeneratorParameters.ShiftDays = new GeneratorParameter("Shift Days", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftHours = new GeneratorParameter("Shift Hours", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftMinutes = new GeneratorParameter("Shift Minutes", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftSeconds = new GeneratorParameter("Shift Seconds", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftMilliseconds = new GeneratorParameter("Shift Milliseconds", 0, GeneratorParameterParser.IntegerParser);
}
public static ColumnEntity CreateColumnEntity(string columnName, ColumnDataTypeDefinition columnDatatype, bool isIdentity, int ordinalPosition, bool isForeignKey, string constraintDefinition, ForeignKeyEntity foreignKeyEntity, string generatorName)
{
ColumnEntity c = new ColumnEntity(columnName, columnDatatype, isIdentity, ordinalPosition, isForeignKey, constraintDefinition, foreignKeyEntity);
var gens = Generators.GeneratorFactory.GetGeneratorsForColumn(c);
c.PossibleGenerators = gens;
c.Generator = gens.Where(g => g.GeneratorName == generatorName).First();
return(c);
}
public ValueFromOtherColumnDateTimeGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype, true)
{
GeneratorParameters.Add(new GeneratorParameter("Value From Column", null, GeneratorParameterParser.ObjectParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Days", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Hours", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Minutes", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Seconds", 0, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Shift Milliseconds", 0, GeneratorParameterParser.IntegerParser));
}
public void ShouldCreateInstanceOfDecimalUpCounter()
{
var dt = new ColumnDataTypeDefinition("decimal(19, 6)", false);
var gen = GeneratorFactory.CreateInstance(typeof(CountingUpDecimalGenerator), dt);
Assert.That(gen, Is.Not.Null);
var value = gen.GenerateValue(1);
Assert.That(value, Is.Not.Null);
}
public static ColumnEntity CreateColumnFromColumn(ColumnEntity originalColumn)
{
ColumnDataTypeDefinition dataType = new ColumnDataTypeDefinition(originalColumn.ColumnDataType.Raw, originalColumn.ColumnDataType.IsNullable);
var constraints = originalColumn.Constraints;
var foreignKeys = originalColumn.ForeignKey == null ? null : originalColumn.ForeignKey.Clone();
var newColumn = CreateColumnEntity(originalColumn.ColumnName, dataType, originalColumn.IsIdentity, originalColumn.OrdinalPosition, originalColumn.IsForeignKey, constraints, foreignKeys);
return(newColumn);
}
public void ShouldCloneColumnDataTypeDefinition()
{
var a = new ColumnDataTypeDefinition("decimal(20)", false);
ColumnDataTypeDefinition clone = a.Clone();
Assert.That(a.DBType, Is.EqualTo(clone.DBType));
Assert.That(a.IsNullable, Is.EqualTo(clone.IsNullable));
Assert.That(a.MaxLength, Is.EqualTo(clone.MaxLength));
Assert.That(a.MaxValue, Is.EqualTo(clone.MaxValue));
Assert.That(a.MinValue, Is.EqualTo(clone.MinValue));
Assert.That(a.Raw, Is.EqualTo(clone.Raw));
Assert.That(a.Scale, Is.EqualTo(clone.Scale));
Assert.That(a.StringFormatter, Is.EqualTo(clone.StringFormatter));
}
private void AssertRawStringIsTurnedIntoSqlDataType(string dataType, SqlDbType sqlDbType)
{
{
var a = new ColumnDataTypeDefinition(dataType, false);
Assert.That(a, Is.Not.Null, dataType);
Assert.That(a.DBType, Is.EqualTo(sqlDbType), dataType);
}
{
// Also test nullable
var a = new ColumnDataTypeDefinition(dataType, true);
Assert.That(a, Is.Not.Null, dataType);
Assert.That(a.DBType, Is.EqualTo(sqlDbType), dataType);
}
}
public HourDateTimeGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.StartDate = new GeneratorParameter("Start Date", DateTime.Now, GeneratorParameterParser.DateTimeParser);
GeneratorParameters.ShiftDays = new GeneratorParameter("Shift Days", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftHours = new GeneratorParameter("Shift Hours", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftMinutes = new GeneratorParameter("Shift Minutes", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftSeconds = new GeneratorParameter("Shift Seconds", 0, GeneratorParameterParser.IntegerParser);
GeneratorParameters.ShiftMilliseconds = new GeneratorParameter("Shift Milliseconds", 0, GeneratorParameterParser.IntegerParser);
foreach (var k in GeneratorParameters)
{
Console.WriteLine(k);
}
}
public CountingUpIntGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.Add(new GeneratorParameter("StartValue", 1, GeneratorParameterParser.IntegerParser));
GeneratorParameters.Add(new GeneratorParameter("Step", 1, GeneratorParameterParser.IntegerParser));
}
public NullValueDateTimeGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
}
public RandomLaplaceIntGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.MaxValue = new GeneratorParameter("MaxValue", datatype.MaxValue, GeneratorParameterParser.LonglParser, false);
GeneratorParameters.MinValue = new GeneratorParameter("MinValue", datatype.MinValue, GeneratorParameterParser.LonglParser, false);
}
public GuidGeneratorBase(string generatorName, ColumnDataTypeDefinition dataType)
: base(generatorName)
{
}
public StaticDateTimeGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.Date = new GeneratorParameter("Date", DateTime.Now, GeneratorParameterParser.DateTimeParser);
}
private static void AssertNotNullDataType(string dataType)
{
var a = new ColumnDataTypeDefinition(dataType, false);
Assert.That(a, Is.Not.Null, dataType);
}
public StaticIntGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype)
{
GeneratorParameters.Value = new GeneratorParameter("Value", 1,
GeneratorParameterParser.LonglParser);
}
public ValueFromOtherColumnStringGenerator(ColumnDataTypeDefinition datatype)
: base(GENERATOR_NAME, datatype, true)
{
GeneratorParameters.ValueFromOtherColumn = new GeneratorParameter("Value From Column", null,
GeneratorParameterParser.ObjectParser);
}
