public async Task InsertTest()
{
using Sqless sqless = new Sqless(Global.AllowUnspecifiedConfig);
var result = await sqless.Insert(InsertRequest);
Assert.IsTrue(result > 0);
}
public async Task InsertTest2()
{
var request = new SqlessEditRequest()
{
Table = Tables.Product
};
request.LoadFromObject(new Product()
{
Id = Guid.NewGuid().ToString(),
Name = new Random().Next(100000, 999999).ToString(),
Price = new Random().Next(1, 100)
});
using Sqless sqless = new Sqless(Global.AllowUnspecifiedConfig);
var result = await sqless.Insert(request);
Assert.IsTrue(result > 0);
}
private async Task <string> Insert()
{
var id = "DeleteTest_" + Guid.NewGuid().ToString("D");
var request = new SqlessEditRequest()
{
Table = Tables.User
};
request.LoadFromObject(new User
{
Uid = id,
Name = DateTime.Now.ToString("hhmmss"),
Password = new Random().Next(100000, 999999).ToString()
});
using Sqless sqless = new Sqless(Global.AllowUnspecifiedConfig);
var result = await sqless.Insert(request);
Assert.IsTrue(result > 0);
return(id);
}
public async Task InsertTest3()
{
var request = new SqlessEditRequest()
{
Table = Tables.Order
};
request.LoadFromObject(new Order()
{
Id = Guid.NewGuid().ToString(),
ProductId = new Random().Next(1, 4).ToString(),
Uid = new Random().Next(1, 5).ToString(),
Status = 1,
Time = DateTimeOffset.Now.ToUnixTimeSeconds()
});
using Sqless sqless = new Sqless(Global.AllowUnspecifiedConfig);
var result = await sqless.Insert(request);
Assert.IsTrue(result > 0);
}
public async Task InsertTest()
{
var order = new Order()
{
Id = Guid.NewGuid().ToString(),
ProductId = "1",
Status = 1,
Time = DateTimeOffset.Now.ToUnixTimeSeconds(),
};
var request = new SqlessEditRequest()
{
Table = Tables.Order,
AccessParams = new string[] { "AccessTestUid", "123456" },
};
request.LoadFromObject(order);
var uid = await Global.PasswordAccessConfig.GetUid(request.AccessParams);
using Sqless sqless = new Sqless(Global.GetOwnerAccessConfig(uid));
var result = await sqless.Insert(request);
Assert.IsTrue(result > 0);
}
public virtual async Task <ActionResult> Insert(SqlessEditRequest request)
{
using Sqless sqless = await GetSqless(request);
return(Ok(await sqless.Insert(request)));
}