Exemple #1
0
        static void Main(string[] args)
        {
            bool verbose = false;

            if (args.Length == 1 && args[0] == "-v")
            {
                verbose = true;
            }
            try {
                // Connect to the GemFire Distributed System using the settings from the gfcpp.properties file by default.
                Properties prop = Properties.Create();
                prop.Insert("cache-xml-file", "clientCqQuery.xml");
                CacheFactory cacheFactory = CacheFactory.CreateCacheFactory(prop);
                Cache        cache        = cacheFactory.SetSubscriptionEnabled(true)
                                            .Create();

                Console.WriteLine("Created the GemFire Cache");

                // Get the Portfolios Region from the Cache which is declared in the Cache XML file.
                Region region = cache.GetRegion("Portfolios");

                Console.WriteLine("Obtained the Region from the Cache");

                region.GetAttributesMutator().SetCacheListener(new MyCacheListener(verbose));

                // Register our Serializable/Cacheable Query objects, viz. Portfolio and Position.
                Serializable.RegisterType(Portfolio.CreateDeserializable);
                Serializable.RegisterType(Position.CreateDeserializable);

                //Register all keys
                region.RegisterAllKeys();

                Console.WriteLine("Registered Serializable Query Objects");

                // Populate the Region with some Portfolio objects.
                Portfolio port1 = new Portfolio(1 /*ID*/, 10 /*size*/);
                Portfolio port2 = new Portfolio(2 /*ID*/, 20 /*size*/);
                Portfolio port3 = new Portfolio(3 /*ID*/, 30 /*size*/);
                region.Put("Key1", port1);
                region.Put("Key2", port2);
                region.Put("Key3", port3);

                Console.WriteLine("Populated some Portfolio Objects");

                // Get the QueryService from the Cache.
                QueryService qrySvc = cache.GetQueryService();

                Console.WriteLine("Got the QueryService from the Cache");

                //create CqAttributes with listener
                CqAttributesFactory cqFac    = new CqAttributesFactory();
                ICqListener         cqLstner = new MyCqListener(0, verbose);
                cqFac.AddCqListener(cqLstner);
                CqAttributes cqAttr = cqFac.Create();

                //create a new cqQuery
                CqQuery qry = qrySvc.NewCq(cqNames[0], queryStrings[0], cqAttr, true);

                // Execute a CqQuery with Initial Results
                ICqResults results = qry.ExecuteWithInitialResults();

                Console.WriteLine("ResultSet Query returned {0} rows", results.Size);

                SelectResultsIterator iter = results.GetIterator();

                while (iter.HasNext)
                {
                    IGFSerializable item = iter.Next();

                    if (item != null)
                    {
                        Struct st = item as Struct;

                        CacheableString key = st["key"] as CacheableString;

                        Console.WriteLine("Got key " + key.Value);

                        Portfolio port = st["value"] as Portfolio;

                        if (port == null)
                        {
                            Position pos = st["value"] as Position;
                            if (pos == null)
                            {
                                CacheableString cs = st["value"] as CacheableString;
                                if (cs == null)
                                {
                                    Console.WriteLine("Query got other/unknown object.");
                                }
                                else
                                {
                                    Console.WriteLine("Query got string : {0}.", cs.Value);
                                }
                            }
                            else
                            {
                                Console.WriteLine("Query got Position object with secId {0}, shares {1}.", pos.SecId, pos.SharesOutstanding);
                            }
                        }
                        else
                        {
                            Console.WriteLine("Query got Portfolio object with ID {0}, pkid {1}.", port.ID, port.Pkid);
                        }
                    }
                }
                //Stop the cq
                qry.Stop();
                //Restart the cq
                qry.Execute();

                for (int i = 1; i < cqNames.Length; i++)
                {
                    ICqListener cqLstner1 = new MyCqListener(i, verbose);
                    cqFac.AddCqListener(cqLstner1);
                    cqAttr = cqFac.Create();
                    qry    = qrySvc.NewCq(cqNames[i], queryStrings[i], cqAttr, true);
                }

                qry    = qrySvc.GetCq(cqNames[6]);
                cqAttr = qry.GetCqAttributes();
                ICqListener[] vl = cqAttr.getCqListeners();
                Console.WriteLine("number of listeners for cq[{0}] is {1}", cqNames[6], vl.Length);
                qry = qrySvc.GetCq(cqNames[0]);
                CqAttributesMutator cqam = qry.GetCqAttributesMutator();
                for (int i = 0; i < vl.Length; i++)
                {
                    cqam.AddCqListener(vl[i]);
                }

                //Stop the cq
                qry.Stop();

                //Start all Cq Query
                qrySvc.ExecuteCqs();

                for (int i = 0; i < cqNames.Length; i++)
                {
                    Console.WriteLine("get info for cq[{0}]:", cqNames[i]);
                    CqQuery      cqy     = qrySvc.GetCq(cqNames[i]);
                    CqStatistics cqStats = cqy.GetStatistics();
                    Console.WriteLine("Cq[{0}]: CqStatistics: numInserts[{1}], numDeletes[{2}], numUpdates[{3}], numEvents[{4}]",
                                      cqNames[i], cqStats.numInserts(), cqStats.numDeletes(), cqStats.numUpdates(), cqStats.numEvents());
                }

                CqServiceStatistics serviceStats = qrySvc.GetCqStatistics();
                Console.WriteLine("numCqsActive={0}, numCqsCreated={1}, numCqsClosed={2}, numCqsStopped={3}, numCqsOnClient={4}",
                                  serviceStats.numCqsActive(), serviceStats.numCqsCreated(), serviceStats.numCqsClosed(),
                                  serviceStats.numCqsStopped(), serviceStats.numCqsOnClient());

                while (true)
                {
                    Console.WriteLine("*******Type \'q\' to quit !!!! ******");
                    ConsoleKeyInfo ckey;
                    ckey = Console.ReadKey(true);
                    if (ckey.Key == ConsoleKey.Q)
                    {
                        break;
                    }
                }

                //Stop all cqs
                qrySvc.StopCqs();

                for (int i = 0; i < cqNames.Length; i++)
                {
                    Console.WriteLine("get info for cq[{0}]:", cqNames[i]);
                    CqQuery cqy = qrySvc.GetCq(cqNames[i]);
                    cqAttr = qry.GetCqAttributes();
                    vl     = cqAttr.getCqListeners();
                    Console.WriteLine("number of listeners for cq[{0}] is {1}", cqNames[i], vl.Length);
                    CqStatistics cqStats = cqy.GetStatistics();
                    Console.WriteLine("Cq[{0}]: CqStatistics: numInserts[{1}], numDeletes[{2}], numUpdates[{3}], numEvents[{4}]",
                                      cqNames[i], cqStats.numInserts(), cqStats.numDeletes(), cqStats.numUpdates(), cqStats.numEvents());
                }

                //Close all cqs
                qrySvc.CloseCqs();

                Console.WriteLine("numCqsActive={0}, numCqsCreated={1}, numCqsClosed={2}, numCqsStopped={3}, numCqsOnClient={4}",
                                  serviceStats.numCqsActive(), serviceStats.numCqsCreated(), serviceStats.numCqsClosed(), serviceStats.numCqsStopped(),
                                  serviceStats.numCqsOnClient());

                // Close the GemFire Cache.
                cache.Close();

                Console.WriteLine("Closed the GemFire Cache");
            }
            // An exception should not occur
            catch (GemFireException gfex) {
                Console.WriteLine("CqQuery GemFire Exception: {0}", gfex.Message);
            }
        }
        public void StepOnePdxQE(string locators)
        {
            CacheHelper.CreateTCRegion_Pool <object, object>(QERegionName, true, true,
                                                             null, locators, "__TESTPOOL1_", true);
            IRegion <object, object> region = CacheHelper.GetVerifyRegion <object, object>(QERegionName);
            PortfolioPdx             p1     = new PortfolioPdx(1, 100);
            PortfolioPdx             p2     = new PortfolioPdx(2, 100);
            PortfolioPdx             p3     = new PortfolioPdx(3, 100);
            PortfolioPdx             p4     = new PortfolioPdx(4, 100);

            region["1"] = p1;
            region["2"] = p2;
            region["3"] = p3;
            region["4"] = p4;

            var qs = CacheHelper.DCache.GetPoolManager().Find("__TESTPOOL1_").GetQueryService();
            CqAttributesFactory <object, object> cqFac    = new CqAttributesFactory <object, object>();
            ICqListener <object, object>         cqLstner = new MyCqListener <object, object>();

            cqFac.AddCqListener(cqLstner);
            CqAttributes <object, object> cqAttr = cqFac.Create();
            CqQuery <object, object>      qry    = qs.NewCq(CqName, "select * from /" + QERegionName + "  p where p.ID!=2", cqAttr, false);

            qry.Execute();
            Thread.Sleep(18000); // sleep 0.3min to allow server c query to complete
            region["4"] = p1;
            region["3"] = p2;
            region["2"] = p3;
            region["1"] = p4;
            Thread.Sleep(18000); // sleep 0.3min to allow server c query to complete

            qry = qs.GetCq <object, object>(CqName);

            CqServiceStatistics cqSvcStats = qs.GetCqStatistics();

            Assert.AreEqual(1, cqSvcStats.numCqsActive());
            Assert.AreEqual(1, cqSvcStats.numCqsCreated());
            Assert.AreEqual(1, cqSvcStats.numCqsOnClient());

            cqAttr = qry.GetCqAttributes();
            ICqListener <object, object>[] vl = cqAttr.getCqListeners();
            Assert.IsNotNull(vl);
            Assert.AreEqual(1, vl.Length);
            cqLstner = vl[0];
            Assert.IsNotNull(cqLstner);
            MyCqListener <object, object> myLisner = (MyCqListener <object, object>)cqLstner;// as MyCqListener<object, object>;

            Util.Log("event count:{0}, error count {1}.", myLisner.getEventCountBefore(), myLisner.getErrorCountBefore());

            CqStatistics cqStats = qry.GetStatistics();

            Assert.AreEqual(cqStats.numEvents(), myLisner.getEventCountBefore());
            if (myLisner.getEventCountBefore() + myLisner.getErrorCountBefore() == 0)
            {
                Assert.Fail("cq before count zero");
            }
            qry.Stop();
            Assert.AreEqual(1, cqSvcStats.numCqsStopped());
            qry.Close();
            Assert.AreEqual(1, cqSvcStats.numCqsClosed());
            // Bring down the region
            region.GetLocalView().DestroyRegion();
        }