public void TriggerMustNotSetVallueWhenSetManuallyOnUpdate()
{
using TestDatabase korm = CreateTestDatabase();
var dbSet = korm.Query <Data_AutoIncrementId_WithTriggerValue>().AsDbSet();
var item1 = new Data_AutoIncrementId_WithTriggerValue {
FirstName = "Lorem 10", Age = 150, AutoValue = 111
};
var item2 = new Data_AutoIncrementId_WithTriggerValue {
FirstName = "Lorem 20", Age = 500, AutoValue = 222
};
dbSet.Add(item1);
dbSet.Add(item2);
dbSet.CommitChanges();
dbSet.Clear();
item1.Age = item1.Id * 200;
item2.Age = item2.Id * 200;
item1.AutoValue = item1.Age / 2;
item2.AutoValue = item2.Age / 2;
dbSet.Edit(item1);
dbSet.Edit(item2);
dbSet.CommitChanges();
foreach (var item in korm.Query <Data_AutoIncrementId_WithTriggerValue>())
{
item.Age.Should().Be(item.Id * 200);
item.AutoValue.Should().Be(item.Age / 2);
}
}
public void ReturnCorrectAutoIncrementIdsAfterInsertTrigger_ValueSetManually()
{
using TestDatabase korm = CreateTestDatabase();
var dbSet = korm.Query <Data_AutoIncrementId_WithTriggerValue>().AsDbSet();
var item1 = new Data_AutoIncrementId_WithTriggerValue {
FirstName = "Lorem 10", Age = 10, AutoValue = -10
};
var item2 = new Data_AutoIncrementId_WithTriggerValue {
FirstName = "Lorem 20", Age = 20, AutoValue = -20
};
dbSet.Add(item1);
dbSet.Add(item2);
dbSet.CommitChanges();
item1.Id.Should().Be(1);
item2.Id.Should().Be(2);
foreach (var item in korm.Query <Data_AutoIncrementId_WithTriggerValue>())
{
item.AutoValue.Should().Be(item.Age * -1);
}
}
