public void Issue2433Test(
[IncludeDataSources(TestProvName.AllSQLite, TestProvName.AllPostgreSQL)] string context)
{
using (var db = GetDataContext(context))
{
using (var itb = db.CreateLocalTable <InventoryResourceDTO>())
{
var dto1 = new InventoryResourceDTO
{
ResourceID = Guid.NewGuid(),
Status = InventoryResourceStatus.Used,
ModifiedTimeStamp = DateTime.UtcNow - TimeSpan.FromHours(2),
Id = Guid.NewGuid()
};
((DataConnection)db).BulkCopy(new BulkCopyOptions
{
CheckConstraints = true,
BulkCopyType = BulkCopyType.ProviderSpecific,
MaxBatchSize = 5000,
UseInternalTransaction = false,
NotifyAfter = 2000,
BulkCopyTimeout = 0,
RowsCopiedCallback = i =>
{
}
},
new[] { dto1 });
}
}
}
public void Issue2468Test(
[IncludeDataSources(TestProvName.AllSQLite)]
string context)
{
using (var db = (DataConnection)GetDataContext(context))
using (var itb = db.CreateLocalTable <InventoryResourceDTO>())
{
var dto1 = new InventoryResourceDTO
{
Color = ColorEnum.Blue, Id = TestData.Guid1, CMYKColor = CMYKEnum.Cyan, Status = StatusEnum.Open
};
db.Insert(dto1);
var list = itb
.Where(x =>
x.Color.ToString().Contains("Bl") &&
x.CMYKColor.ToString().Contains("Cya") &&
x.Status.ToString().Contains("en")
)
.ToList();
Assert.That(list.Count, Is.EqualTo(1));
}
}
public void Issue2372Test(
[IncludeDataSources(true, TestProvName.AllSQLite, TestProvName.AllPostgreSQL)] string context)
{
Model.ITestDataContext?db1 = null;
try
{
var ms1 = new MappingSchema();
var fmb1 = ms1.GetFluentMappingBuilder();
fmb1.Entity <InventoryResourceDTO>()
.HasTableName("InventoryResource")
.Property(e => e.Id).IsPrimaryKey()
.Property(e => e.Status).HasDataType(DataType.NVarChar);
var ms2 = new MappingSchema();
ms2.SetConverter <InventoryResourceStatus, string>((obj) =>
{
return(obj.ToString());
});
ms2.SetConverter <InventoryResourceStatus, DataParameter>((obj) =>
{
return(new DataParameter {
Value = obj.ToString()
});
});
ms2.SetConverter <string, InventoryResourceStatus>((txt) =>
{
return((InventoryResourceStatus)Enum.Parse(typeof(InventoryResourceStatus), txt, true));
});
var fmb2 = ms2.GetFluentMappingBuilder();
fmb2.Entity <InventoryResourceDTO>()
.HasTableName("InventoryResource")
.Property(e => e.Id).IsPrimaryKey()
.Property(e => e.Status);
db1 = GetDataContext(context, ms1);
db1.DropTable <InventoryResourceDTO>(throwExceptionIfNotExists: false);
db1.CreateLocalTable <InventoryResourceDTO>();
using (var db2 = GetDataContext(context, ms2))
{
var dto1 = new InventoryResourceDTO
{
Status = InventoryResourceStatus.Used,
Id = TestData.Guid1
};
db2.Insert(dto1);
}
}
finally
{
if (db1 != null)
{
db1.Dispose();
}
}
}
public void Issue2375Test(
[IncludeDataSources(TestProvName.AllSQLite, TestProvName.AllPostgreSQL)] string context)
{
using (var db = GetDataContext(context))
{
using (var itb = db.CreateLocalTable <InventoryResourceDTO>())
using (var lctb = db.CreateLocalTable <WmsLoadCarrierDTO>())
{
var res = new WmsLoadCarrierDTO {
Id = Guid.NewGuid(), ResourceLabel = "b"
};
db.Insert(res);
var dto1 = new InventoryResourceDTO
{
ResourceID = res.Id,
Status = InventoryResourceStatus.Used,
ModifiedTimeStamp = DateTime.UtcNow - TimeSpan.FromHours(2),
Id = Guid.NewGuid()
};
db.Insert(dto1);
var dto2 = new InventoryResourceDTO
{
ResourceID = res.Id,
Status = InventoryResourceStatus.Used,
ModifiedTimeStamp = DateTime.UtcNow - TimeSpan.FromHours(2),
Id = Guid.NewGuid()
};
db.Insert(dto2);
var qry = from inventory in itb
join lc in lctb on inventory.ResourceID equals lc.Id
group inventory by new
{
inventory.Status,
lc.ResourceLabel
}
into grp
where grp.Count() > 1
select grp;
var groups = new List <KeyValuePair <string, IEnumerable <InventoryResourceDTO> > >();
foreach (var group in qry)
{
groups.Add(new KeyValuePair <string, IEnumerable <InventoryResourceDTO> >(group.Key.ResourceLabel, group.OrderBy(x => x.ModifiedTimeStamp).ToList()));
}
var sql = ((DataConnection)db).LastQuery;
}
}
}
