Exemplo n.º 1
0
        public void Test()
        {
            TestClass t1 = new TestClass();

            t1.Id   = 1;
            t1.Data = "test1";

            TestClass t2 = new TestClass();

            t2.Id             = 2;
            t2.Data           = "test2";
            t2.FakeNameColumn = "2222";

            var result = repo.Insert(t1);

            Assert.Equal(1, result);

            result = repo.Insert(t2);
            Assert.Equal(1, result);

            var item1 = repo.GetItem(new TestClass()
            {
                Id = 1
            });

            Assert.Equal("test1", item1.Data);

            var item2 = repo.GetItem(new TestClass()
            {
                Id = 2
            });

            Assert.Equal("test2", item2.Data);

            // update 테스트
            t1.Data           = "test1-1";
            t1.FakeNameColumn = "1111";

            result = repo.Update(t1);

            Assert.Equal(1, result);

            item1 = repo.GetItem(new TestClass()
            {
                Id = 1
            });
            Assert.Equal("test1-1", item1.Data);

            // 조건 리스트
            var list = repo.GetList(t1, new ParamColumn("Id", "<", "3"));

            Assert.Equal(2, list.Count);

            // 조건 아이템

            var item4 = repo.GetItem(t1, new ParamColumn(nameof(t1.LDate), "is not null", ""));

            Assert.Equal(1, item4.Id);

            item4 = repo.GetItem(t1, new ParamColumn(nameof(t1.LDate), "is null", null));

            Assert.Equal(2, item4.Id);

            item4 = repo.GetItem(t1, new ParamColumn(nameof(t1.Data), "like", "'%1-1'"));

            Assert.Equal(1, item4.Id);

            // Delete
            result = repo.Delete(new TestClass()
            {
                Id = 1, Data = "test1-1"
            });

            Assert.Equal(1, result);

            result = repo.Delete(new TestClass()
            {
                Id = 2
            });

            Assert.Equal(1, result);
        }