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); }