public void TestInsert()
{
Skip.IfNot(EnvUtils.IntegrationTestMachine);
var id = _repository.Insert(null);
Assert.Equal(0, id);
var dataInfo = new TestTableInfo();
_repository.Insert(dataInfo);
Assert.Equal(1, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Null(dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(0, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.False(dataInfo.Date.HasValue);
Assert.True(dataInfo.Date == null);
Assert.False(dataInfo.Locked);
dataInfo = new TestTableInfo
{
Guid = "wrong guid",
TypeVarChar100 = "string",
Num = -100,
Date = DateTime.Now,
Locked = true
};
_repository.Insert(dataInfo);
Assert.Equal(2, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Equal("string", dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(-100, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.True(dataInfo.Date.HasValue);
Assert.True(dataInfo.Locked);
_output.WriteLine(dataInfo.Guid);
_output.WriteLine(dataInfo.LastModifiedDate.ToString());
}
public async Task InsertTest()
{
Skip.IfNot(TestEnv.IsTestMachine);
var id = await _repository.InsertAsync(null);
Assert.Equal(0, id);
id = await _repository.InsertAsync(null);
Assert.Equal(0, id);
var dataInfo = new TestTableInfo();
await _repository.InsertAsync(dataInfo);
Assert.Equal(1, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Null(dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(0, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.False(dataInfo.Date.HasValue);
Assert.True(dataInfo.Date == null);
Assert.False(dataInfo.Locked);
dataInfo = new TestTableInfo();
await _repository.InsertAsync(dataInfo);
Assert.Equal(2, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
dataInfo = new TestTableInfo
{
Guid = "wrong guid",
TypeVarChar100 = "string",
Num = -100,
Date = DateTime.Now,
Locked = true
};
await _repository.InsertAsync(dataInfo);
Assert.Equal(3, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Equal("string", dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(-100, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.True(dataInfo.Date.HasValue);
Assert.True(dataInfo.Locked);
_output.WriteLine(dataInfo.Guid);
_output.WriteLine(dataInfo.LastModifiedDate.ToString());
dataInfo = await _repository.GetAsync(1);
Assert.NotNull(dataInfo);
Assert.Equal(1, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Null(dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(0, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.False(dataInfo.Date.HasValue);
Assert.True(dataInfo.Date == null);
_output.WriteLine(dataInfo.Guid);
_output.WriteLine(dataInfo.LastModifiedDate.ToString());
dataInfo = await _repository.GetAsync(3);
Assert.NotNull(dataInfo);
Assert.Equal(3, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Equal("string", dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(-100, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.True(dataInfo.Date.HasValue);
dataInfo = await _repository.GetAsync(new Query().Where(Attr.TypeVarChar100, "string"));
Assert.NotNull(dataInfo);
Assert.Equal(3, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Equal("string", dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(-100, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.True(dataInfo.Date.HasValue);
dataInfo = await _repository.GetAsync(dataInfo.Guid);
Assert.NotNull(dataInfo);
Assert.Equal(3, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Equal("string", dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(-100, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.True(dataInfo.Date.HasValue);
dataInfo = await _repository.GetAsync(dataInfo.Guid);
Assert.NotNull(dataInfo);
Assert.Equal(3, dataInfo.Id);
Assert.True(Utilities.IsGuid(dataInfo.Guid));
Assert.True(dataInfo.LastModifiedDate.HasValue);
Assert.Equal("string", dataInfo.TypeVarChar100);
Assert.Null(dataInfo.TypeVarCharDefault);
Assert.Null(dataInfo.Content);
Assert.Equal(-100, dataInfo.Num);
Assert.Equal(0, dataInfo.Currency);
Assert.True(dataInfo.Date.HasValue);
dataInfo = await _repository.GetAsync(new Query().Where(Attr.TypeVarChar100, "not exists"));
Assert.Null(dataInfo);
var exists = await _repository.ExistsAsync(new Query()
.Where(nameof(TestTableInfo.TypeVarChar100), "string"));
Assert.True(exists);
exists = await _repository.ExistsAsync(new Query().Where(nameof(TestTableInfo.TypeVarChar100), "not exists"));
Assert.False(exists);
exists = await _repository.ExistsAsync(new Query());
Assert.True(exists);
await _repository.DeleteAsync();
}
