public void SqlServer_EMP_SAL_MustBeDecimal_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\""
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("public virtual decimal? SAL { get; set; }"));
}
public void SqlServer_DefaultParameters_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\""
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("public virtual int EMPNO { get; set; }"));
}
public void SqlServer_ValidationRange_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\"",
$"Validations=Range"
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("Range(-99999999999999999999999999999999999999.0d, 99999999999999999999999999999999999999.0d)]"));
}
public void Validation_ValidateMethod_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\"",
$"Validations=ValidateMethod",
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("internal static class __DataAnnotationValidator"));
Assert.IsTrue(code.Contains("Validate() =>"));
}
public void Validation_StringAttribute_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\"",
$"Validations=StringLength",
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("[StringLength(10)]"));
Assert.IsTrue(code.Contains("public virtual string ENAME { get; set; }"));
}
public void Validation_RangeAttribute_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\"",
$"Validations=Range",
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("[Range(-999999999999999999.0d, 999999999999999999.0d)]"));
Assert.IsTrue(code.Contains("public virtual decimal? SAL { get; set; }"));
}
public void Validation_NullAttribute_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\"",
$"Validations",
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsFalse(code.Contains("[Range"));
Assert.IsFalse(code.Contains("[StringLength"));
}
public void SqlServer_NullableRefTypes_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\"",
$"NullableRefTypes"
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("public virtual string? ENAME { get; set; }"));
Assert.IsTrue(code.Contains("public virtual int? MGR { get; set; }"));
}
public void Oracle_DefaultParameters_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.ORACLE_CONNECTION_STRING}\"",
$"ns=\"Actiris.CoreBusiness.Services.Data.Models.Ibis\"",
$"p=Oracle",
$"cf=NameOnly",
$"ca=\"AV1130, AV1507, AV1704, AV1706, AV1710\"",
$"os=IBIS",
$"a=\"System.ComponentModel.DataAnnotations.Schema.Column\"", // Include Column Attribute
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains("public virtual long ID_JOUR_OUVRE { get; set; }"));
}
public void SqlServer_SortProperties_Test()
{
var args = new[]
{
$"GenerateEntities",
$"cs=\"{Configuration.SQLSERVER_CONNECTION_STRING}\"",
$"SortProperties"
};
var generator = new Apps72.Dev.Data.Generator.Tools.Generator(new Arguments(args));
var code = generator.Code;
Assert.IsTrue(code.Contains(
@"
public partial class DEPT
{
/// <summary />
public virtual int DEPTNO { get; set; }
/// <summary />
public virtual string DNAME { get; set; }
/// <summary />
public virtual string LOC { get; set; }
}
/// <summary />
public partial class EMP
{
/// <summary />
public virtual int? COMM { get; set; }
/// <summary />
public virtual int? DEPTNO { get; set; }
/// <summary />
public virtual int EMPNO { get; set; }
/// <summary />
public virtual string ENAME { get; set; }
/// <summary />
public virtual DateTime? HIREDATE { get; set; }
/// <summary />
public virtual string JOB { get; set; }
/// <summary />
public virtual int? MGR { get; set; }
/// <summary />
public virtual decimal? SAL { get; set; }
}"));
}
