Exemplo n.º 1
0
        //public async Task<EntityList<Entities.Emploee>> SayHello(string name, int[] age, Guid id, DateTime birthday)
        //{
        //    //var vs = new Entities.Order();
        //    //vs.CreateById = Guid.Empty;
        //    //await EntityStore.SaveAsync(vs);
        //    return null;
        //}

        //[InvokePermission(Permissions.Admin || Permissions.Developer)]
        //public async Task SayHello(Entities.Emploee emp)
        //{
        //    await EntityStore.SaveAsync(emp);
        //}

        //public async Task<EntityBase> LoadEmploee(Guid id)
        //{
        //    return await EntityStore.LoadAsync<Entities.Emploee>(id);
        //}

        //public Task<bool> TypeIdTest()
        //{
        //    ulong baseType = 0;
        //    var res = baseType == Entities.Emploee.TypeId;
        //    return Task.FromResult(res);
        //}

        //public async Task DeleteTest()
        //{
        //    await EntityStore.DeleteAsync<Entities.Emploee>(Guid.Empty);
        //}

        //public async Task<object> Test()
        //{
        //    var q = new TableScan<Entities.OrgUnit>();
        //    q.Include(o => o.Parent.Name);
        //    return await q.ToListAsync();
        //}

        //public async Task<object> Test()
        //{
        //    var id = Guid.Empty;
        //    var childs = await EntityStore.LoadEntitySetAsync<Entities.OrgUnit, Entities.OrgUnit>(id, t => t.Childs);
        //    return childs;
        //}

        //public async Task<object> Test()
        //{
        //    var q = new TableScan<Entities.VehicleState>();
        //    q.Partitions.Equal(t => t.VehicleId, 1);
        //    //q.Partitions.Equal(t => t.CreateTime, new DateTime(2019, 1, 1));
        //    return await q.ToListAsync();
        //}

        //public async Task<object> Test()
        //{
        //	var q = new TableScan<Entities.VehicleState>();
        //	q.Filter(t => t.Lng > 12f && t.Lat > 20f);
        //	return await q.ToListAsync();
        //}

        //public async Task<object> Test(DateTime date)
        //{
        //    var q = new IndexScan<Entities.Emploee, Entities.Emploee.UI_Account_Password>();
        //    q.Keys.Equal(t => t.Account, "Admin");
        //    return await q.ToListAsync();
        //}

        //      public async Task Test()
        //{
        //	var obj = new Entities.City(214000);
        //	obj.Name = "Wuxi";
        //	await DataStore.DemoDB.SaveAsync(obj);
        //}

        //      public async Task<object> Test()
        //{
        //	var q = new SqlQuery<Entities.City>();
        //	q.Where(t => t.Code > 1 && t.Code < 10);
        //	return await q.ToListAsync();
        //}

        //public async Task<object> Test()
        //{
        //	var q = new SqlQuery<Entities.City>();
        //	q.Where(t => t.Code > 1 && t.Code < 10);
        //	return await q.ToListAsync(t=> t.Code);
        //}

        ///// <summary>
        ///// 测试更新命令及返回
        ///// </summary>
        //public async Task Test()
        //{
        //    var cmd = new SqlUpdateCommand<Entities.City>();
        //    cmd.Update(t => t.Persons = t.Persons + 1);
        //    cmd.Where(t => t.Code == 1);
        //    var outs = cmd.Output(t => t.Persons);
        //    await DataStore.DemoDB.ExecCommandAsync(cmd);
        //    if (outs.Count == 1 && outs[0] > 1) { }
        //}

        /// <summary>
        /// 测试更新命令及返回
        /// </summary>
        public async Task Test()
        {
            var cmd = new SqlUpdateCommand <Entities.City>();

            cmd.Update(t => t.Persons = t.Persons + 1);
            cmd.Where(t => t.Code == 1);
            var outs = cmd.Output(t => new { t.Persons, t.Code });
            await DataStore.DemoDB.ExecCommandAsync(cmd);

            if (outs.Count == 1 && outs[0].Persons > 1)
            {
            }
        }
Exemplo n.º 2
0
        public void BuildUpdateTest()
        {
            var model = MakeTestSqlModel();
            var mockRunntimeContext = new MockRuntimContext();

            Runtime.RuntimeContext.Init(mockRunntimeContext, 10410);
            mockRunntimeContext.AddModel(model);

            var q = new SqlUpdateCommand(model.Id);

            q.Update(q.T["Code"].Assign(q.T["Code"] + 1));
            q.Where(q.T["Code"] == 2);

            var outs = q.Output(r => r.GetInt32(0), q.T["Code"]);
            //var outs = q.Output(r => new { Code = r.GetInt32(0), Name = r.GetString(1) }, q.T["Code"], q.T["Name"]);
            //outs[0].Code == 3;

            var store = new PgSqlStore(StoreSettings);
            var cmd   = store.BuidUpdateCommand(q);

            Assert.True(cmd != null);
            output.WriteLine(cmd.CommandText);
            //Update "Emploee" t Set "Code" = "Code" + @p1 Where t."Code" = @p2 RETURNING "Code"
        }