Esempio n. 1
0
        public void Test_Select_SourceTraverse()
        {
            var store = DatabaseHelper.Default.Store;
            var model = new DeepModel()
            {
                Sub1 = new DeepModel.SubModel1()
                {
                    Sub2 = new DeepModel.SubModel2()
                    {
                        Sub3 = new List <DeepModel.SubModel3>()
                        {
                            new DeepModel.SubModel3()
                            {
                                Sub4 = new DeepModel.SubModel4()
                                {
                                    Sub5 = new List <DeepModel.SubModel5>()
                                    {
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 1
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 2
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 3
                                                },
                                            },
                                        },
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 4
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 5
                                                },
                                            },
                                        },
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 6
                                                },
                                            },
                                        }
                                    },
                                },
                            },
                            new DeepModel.SubModel3()
                            {
                                Sub4 = new DeepModel.SubModel4()
                                {
                                    Sub5 = new List <DeepModel.SubModel5>()
                                    {
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 7
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 8
                                                },
                                                null,
                                            },
                                        },
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 9
                                                },
                                            },
                                        },
                                    },
                                },
                            },
                            new DeepModel.SubModel3()
                            {
                                Sub4 = new DeepModel.SubModel4()
                                {
                                    Sub5 = new List <DeepModel.SubModel5>(),
                                },
                            },
                        },
                    },
                },
            };

            var valueAttr = "Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6.Item.Value";

            var rel1  = store.From(model).Select(valueAttr);
            var rel2  = rel1.Source.Lookup("Sub1").Select(valueAttr);
            var rel3  = rel2.Source.Lookup("Sub1.Sub2").Select(valueAttr);
            var rel4  = rel3.Source.Lookup("Sub1.Sub2.Sub3").Select(valueAttr);
            var rel5  = rel4.Source.Lookup("Sub1.Sub2.Sub3.Item").Select(valueAttr);
            var rel6  = rel5.Source.Lookup("Sub1.Sub2.Sub3.Item.Sub4").Select(valueAttr);
            var rel7  = rel6.Source.Lookup("Sub1.Sub2.Sub3.Item.Sub4.Sub5").Select(valueAttr);
            var rel8  = rel7.Source.Lookup("Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item").Select(valueAttr);
            var rel9  = rel8.Source.Lookup("Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6").Select(valueAttr);
            var rel10 = rel9.Source.Lookup("Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6.Item").Select(valueAttr);
            var rel11 = rel10.Source.Lookup("Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6.Item.Value").Select(valueAttr);

            rel1.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel2.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel3.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel4.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel5.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6 });
            rel6.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6 });
            rel7.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6 });
            rel8.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3 });
            rel9.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1, 2, 3 });
            rel10.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1 });
            rel11.Column().Select(f => (int?)f.Snapshot).ShouldBe(new int?[] { 1 });
        }
Esempio n. 2
0
        public void Test_Reading_OfDeepObjectGraphFromDifferentSources()
        {
            DeepModel model = new DeepModel()
            {
                Sub1 = new DeepModel.SubModel1()
                {
                    Sub2 = new DeepModel.SubModel2()
                    {
                        Sub3 = new List <DeepModel.SubModel3>()
                        {
                            new DeepModel.SubModel3()
                            {
                                Sub4 = new DeepModel.SubModel4()
                                {
                                    Sub5 = new List <DeepModel.SubModel5>()
                                    {
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 1
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 2
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 3
                                                },
                                            },
                                        },
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 4
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 5
                                                },
                                            },
                                        },
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 6
                                                },
                                            },
                                        }
                                    },
                                },
                            },
                            new DeepModel.SubModel3()
                            {
                                Sub4 = new DeepModel.SubModel4()
                                {
                                    Sub5 = new List <DeepModel.SubModel5>()
                                    {
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 7
                                                },
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 8
                                                },
                                                null,
                                            },
                                        },
                                        new DeepModel.SubModel5()
                                        {
                                            Sub6 = new List <DeepModel.SubModel6>()
                                            {
                                                new DeepModel.SubModel6()
                                                {
                                                    Value = 9
                                                },
                                            },
                                        },
                                    },
                                },
                            },
                            new DeepModel.SubModel3()
                            {
                                Sub4 = new DeepModel.SubModel4()
                                {
                                    Sub5 = new List <DeepModel.SubModel5>(),
                                },
                            },
                        },
                    },
                },
            };

            string valueAttr = "Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6.Item.Value";

            Relation rel1  = DatabaseHelper.Default.Relation(model, valueAttr);
            Relation rel2  = new Relation(new Relation(rel1, "Sub1").Scalar(), valueAttr);
            Relation rel3  = new Relation(new Relation(rel2, "Sub1.Sub2").Scalar(), valueAttr);
            Relation rel4  = new Relation(new Relation(rel3, "Sub1.Sub2.Sub3").Scalar(), valueAttr);
            Relation rel5  = new Relation(new Relation(rel4, "Sub1.Sub2.Sub3.Item").Scalar(), valueAttr);
            Relation rel6  = new Relation(new Relation(rel5, "Sub1.Sub2.Sub3.Item.Sub4").Scalar(), valueAttr);
            Relation rel7  = new Relation(new Relation(rel6, "Sub1.Sub2.Sub3.Item.Sub4.Sub5").Scalar(), valueAttr);
            Relation rel8  = new Relation(new Relation(rel7, "Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item").Scalar(), valueAttr);
            Relation rel9  = new Relation(new Relation(rel8, "Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6").Scalar(), valueAttr);
            Relation rel10 = new Relation(new Relation(rel9, "Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6.Item").Scalar(), valueAttr);
            Relation rel11 = new Relation(new Relation(rel10, "Sub1.Sub2.Sub3.Item.Sub4.Sub5.Item.Sub6.Item.Value").Scalar(), valueAttr);

            rel1.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel2.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel3.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel4.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6, 7, 8, null, 9 });
            rel5.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6 });
            rel6.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6 });
            rel7.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3, 4, 5, 6 });
            rel8.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3 });
            rel9.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1, 2, 3 });
            rel10.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1 });
            rel11.Column().Select(f => (int?)f.Value).ShouldBe(new int?[] { 1 });
        }