public async Task UpsertInsertTest()
{
var newUid = "UpsertTest_" + Guid.NewGuid().ToString();
var request = new SqlessEditRequest()
{
Table = Tables.User,
Queries = new List <Query.SqlessQuery>()
{
new Query.SqlessQuery()
{
Field = "Uid",
Value = newUid,
Type = Query.SqlessQueryType.Equal
}
}
};
request.LoadFromObject(new
{
Uid = newUid,
Name = DateTime.Now.ToString("hhmmss"),
Password = new Random().Next(100000, 999999).ToString()
});
using Sqless sqless = new Sqless(Global.AllowUnspecifiedConfig);
var result = await sqless.Upsert(request);
Assert.IsTrue(result > 0);
}
private async Task <string> CreateOrder(Product product)
{
var order = new Order()
{
Id = Guid.NewGuid().ToString(),
ProductId = product.Id,
Status = 1,
Time = DateTimeOffset.Now.ToUnixTimeSeconds(),
};
var request = new SqlessEditRequest()
{
Table = Tables.Order,
AccessParams = new string[] { User.Uid, User.Password },
};
request.LoadFromObject(order);
try
{
await SqlessClient.Insert(request);
return(order.Id);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
public void LoadEditRequestFromObjectTest()
{
var obj = new
{
Test1 = "111",
Test2 = "222"
};
var request = new SqlessEditRequest();
request.LoadFromObject(obj);
Assert.IsTrue(request.Fields.Count > 0);
Assert.AreEqual(request.Fields[0].Field, nameof(obj.Test1));;
Assert.AreEqual(request.Fields[0].Value, obj.Test1);
}
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);
}
