Esempio n. 1
0
        static void Main()
        {
            /*
             * M2DB.TblB tb = null;
             *
             * Db.Transact(() =>
             * {
             *  tb = new M2DB.TblB
             *  {
             *      FldStr = "Sener",
             *      FldDate = DateTime.Now
             *  };
             *
             * });
             * TblaProxy a = ReflectionExample.ToProxy<TblaProxy, M2DB.TblB>(tb);
             * a.RowErr = "";
             *
             * Console.WriteLine("Deneme");
             *
             * a.FldStr = a.FldStr.ToUpper();
             * //a.RowPk = 0;
             *
             * Db.Transact(() =>
             * {
             *  // Converting the proxy object into the database object.
             *  // This will set the database object property values.
             *  // Those the changes made to the proxy object will be saved to the database.
             *  M2DB.TblB tblb = ReflectionExample.FromProxy<TblaProxy, M2DB.TblB>(a);
             * });
             */
            Console.WriteLine("Deneme");


            Server server = new Server
            {
                Services = { CRUDs.BindService(new CRUDsImpl()) },
                Ports    = { new ServerPort("localhost", Port, ServerCredentials.Insecure) }
                //Ports = { new ServerPort("217.160.13.102", Port, ServerCredentials.Insecure) }
                //Ports = { new ServerPort("192.168.1.20", Port, ServerCredentials.Insecure) }
            };

            server.Start();

            Console.WriteLine("Rest server listening on port " + Port);
        }
Esempio n. 2
0
        static void Main(string[] args)
        {
            var aaa = Db.FromId(362);
            int bbb = 0;

            Server server = new Server
            {
                Services = { CRUDs.BindService(new CRUDsImpl()) },
                Ports    = { new ServerPort("localhost", Port, ServerCredentials.Insecure) }
                //Ports = { new ServerPort("192.168.1.20", Port, ServerCredentials.Insecure) }
                //Ports = { new ServerPort("217.160.13.102", Port, ServerCredentials.Insecure) }
            };

            server.Start();

            Console.WriteLine("Server listening on port " + Port);
            Console.WriteLine("Press any key to stop the server...");
            Console.ReadKey();

            server.ShutdownAsync().Wait();
        }
Esempio n. 3
0
        const int Port = 50055; //6000; //50055;

        static void Main()
        {
            /*
             * // DROPs
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPRD_Idx").FirstOrDefault() != null)
             *  Db.SQL("DROP INDEX PPRD_Idx ON PPRD");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPR_PP").FirstOrDefault() != null)
             *  Db.SQL("DROP INDEX PPR_PP ON PPR");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPR_Dnm").FirstOrDefault() != null)
             *  Db.SQL("DROP INDEX PPR_Dnm ON PPR");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPR_Idx").FirstOrDefault() != null)
             *  Db.SQL("DROP INDEX PPR_Idx ON PPR");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPR_CC").FirstOrDefault() != null)
             *  Db.SQL("DROP INDEX PPR_CC ON PPR");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CTP_CTPP").FirstOrDefault() != null)
             *  Db.SQL("DROP INDEX CTP_CTPP ON CTP");
             *
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PP_Ad").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX PP_Ad ON PP (Ad)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PP_RnkIdx").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX PP_RnkIdx ON PP (RnkIdx)");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPRD_PPDnm").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX PPRD_PPDnm ON PPRD (PP, Dnm)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPRD_PP").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX PPRD_PP ON PPRD (PP)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPRd_Dnm").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX PPRD_Dnm ON PPRD (Dnm)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "PPRD_RnkIdx").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX PPRD_RnkIdx ON PPRD (RnkIdx)");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "MAC_CC").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX MAC_CC ON MAC (CC)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "MAC_CEB").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX MAC_CEB ON MAC (CEB)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "MAC_Trh").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX MAC_Trh ON MAC (Trh)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "MAC_hPP1").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX MAC_hPP1 ON MAC (HPP1)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "MAC_hPP2").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX MAC_hPP2 ON MAC (HPP2)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "MAC_gPP1").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX MAC_gPP1 ON MAC (GPP1)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "MAC_gPP2").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX MAC_gPP2 ON MAC (GPP2)");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CT_CC").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CT_CC ON CT (CC)");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CTP_CC").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CTP_CC ON CTP (CC)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CTP_CT").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CTP_CT ON CTP (CT)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CTP_PP").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CTP_PP ON CTP (PP)");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CET_CC").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CET_CC ON CET (CC)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CET_Trh").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CET_Trh ON CET (Trh)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CET_hCT").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CET_hCT ON CET (HCT)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CET_gCT").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CET_gCT ON CET (GCT)");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CF_CC").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CF_CC ON CF (CC)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CF_PP").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CF_PP ON CF (PP)");
             *
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CEF_CC").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CEF_CC ON CEF (CC)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CEF_Trh").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CEF_Trh ON CEF (Trh)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CEF_hPP").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CEF_hPP ON CEF (HPP)");
             * if (Db.SQL("SELECT i FROM Starcounter.Metadata.\"Index\" i WHERE Name = ?", "CEF_gPP").FirstOrDefault() == null)
             *  Db.SQL("CREATE INDEX CEF_gPP ON CEF (GPP)");
             */
            /*
             * Hook<CC>.CommitUpdate += (p, obj) =>
             * {
             *  Session.RunTaskForAll((s, id) =>
             *  {
             *      s.CalculatePatchAndPushOnWebSocket();
             *  });
             * };*/


            // Sadece Yeni DB ilk calistiginda yap
            //HBR.RestoreDB();    // Hic PP yoksa yapar

            //H.PopAll();
            //H.PPmove2baz(); // Eski Lig rank'i BazRnk'e koy

            /*
             * H.PopPP();
             * H.PopCC();
             * H.PopCT();
             * H.PopCTP();
             * H.PopCET();
             * H.PopMAC();
             */

            // Bunkara Gerek kalmadi

            /*
             * H.MAC_RefreshSonuc();
             * H.CEF_RefreshSonuc();
             * H.CF_RefreshSonuc();
             * H.CET_RefreshSonuc();
             * H.CT_RefreshSonuc();
             * H.CTP_RefreshSonucNew();
             * H.PP_RefreshSonuc();
             * H.MAC_RefreshGlobalRank();
             */
            //CTP.UpdateRnkBas(); //Yeni doneme basinda (bodved2 ye gecis)

            //CTP.UpdateRnkBit(); //Yeni doneme bitiminde

            //HBR.BackupDB();


            Server server = new Server
            {
                Services = { CRUDs.BindService(new CRUDsImpl()) },
                //Ports = { new ServerPort("localhost", 50055, ServerCredentials.Insecure) }
                Ports = { new ServerPort("217.160.13.102", 6000, ServerCredentials.Insecure) }
            };

            server.Start();
            Console.WriteLine("Rest server listening on port " + 6000);

            /*
             * Handle.GET("/RestStarcounterServer", () =>
             * {
             *  Task.Run(async () => { await server.ShutdownAsync(); }).Wait();
             *  //server.ShutdownAsync();
             *  return "ShutDown gRPC Server OK";
             * });
             */
        }
Esempio n. 4
0
        static void Main()
        {
            /*
             * Hook<AFD>.AfterCommitInsert += (sender, id) => {
             *  var afd = Db.FromId<AFD>(id);
             *  AHP.AhpTopUpdAfd(afd.AHP);
             * };
             * Hook<AFD>.AfterCommitUpdate += (sender, id) => {
             *  var afd = Db.FromId<AFD>(id);
             *  AHP.AhpTopUpdAfd(afd.AHP);
             * };
             */

            // DB'nin ilk kaydi Sirketin kendi
            if (Db.SQL <KFT>("select r from KFT r").FirstOrDefault() == null)
            {
                Db.Transact(() =>
                {
                    new KFT
                    {
                        Kd = "",
                        Ad = "Sirket",
                    };
                });
            }

            M2DB.AccOps.PopAHP();
            M2DB.AccOps.PopABK();
            M2DB.GnlOps.PopXGT();
            M2DB.KimOps.PopKDT();
            M2DB.NeOps.initNNT();

            //NNN curNe = Db.FromId<NNN>(279);  // Suzan
            //NNN apndNe = Db.FromId<NNN>(288);  // Kemal
            //NNN.CanAppend(curNe, apndNe);

            // Kullanilmiyor
            //NNR.KidsParents();

            //NNN.NeMaliyet(274); // Suzan
            //NNR.NodeGerekenKidsMik(274, 1);
            //NNR.NodesInParents();

            ////NNN.UretenUrunTuketimleri("ureten", 295, 1);   //295Suzan

            /*
             * NNR.DenemeUp();
             * NNR.DenemeDown();
             *
             * NNR.Deneme2();
             * NNR.Deneme();
             */

            ////NNN.DenemeCanAddSibling();

            //NNR.DenemeYetki();
            //NNR.CanAddSibling(303, 299); //Veli, Sener false
            //NNR.CanAddSibling(303, 301); //Veli, Sener true
            ////NNR.DenemeGetAvailableParents();
            //NNR.CanAddSibling(303, 297); //Veli, Umut
            //NNR.CanAddSibling(295, 293); //Suzan, Ahmet
            ////NNN.DenemeYtkParentsDictionary();
            dnmC.dnm();


            Db.Transact(() =>
            {
                //NNN nazli = Db.FromId<NNN>(277);
                //nazli.Fyt = 0;
                new dnmA
                {
                    Ad = "CAN"
                };

                var sener = new dnmB
                {
                    Ad    = "Sener",
                    Soyad = "Demiral"
                };
                new dnmC
                {
                    A = sener,
                };

                new AVM
                {
                    Drm = "A",
                    Trh = DateTime.Today,
                };

                /*
                 * var afb = new AFB
                 * {
                 *  Info = "deneme",
                 *  AoK = "A",
                 *  Trh = DateTime.Now
                 * };
                 *
                 * new AFD
                 * {
                 *  ObjAFB = afb,
                 *  Tut = 100,
                 * };
                 * new AFD
                 * {
                 *  ObjAFB = afb,
                 *  Tut = -300,
                 * };
                 * new AFD
                 * {
                 *  ObjAFB = afb,
                 *  Info = null,
                 * };*/

                //ReflectionExample.deneme<M2DB.AHT>(3);
            });


            /*
             * M2DB.TblB tb = null;
             *
             * Db.Transact(() =>
             * {
             *  tb = new M2DB.TblB
             *  {
             *      FldStr = "Sener",
             *      FldDate = DateTime.Now
             *  };
             *
             * });
             * TblaProxy a = ReflectionExample.ToProxy<TblaProxy, M2DB.TblB>(tb);
             * a.Row.Err = "";
             *
             * Console.WriteLine("Deneme");
             *
             * a.FldStr = a.FldStr.ToUpper();
             * //a.Key = 0;
             *
             * Db.Transact(() =>
             * {
             *  // Converting the proxy object into the database object.
             *  // This will set the database object property values.
             *  // Those the changes made to the proxy object will be saved to the database.
             *  M2DB.TblB tblb = ReflectionExample.FromProxy<TblaProxy, M2DB.TblB>(a);
             * });
             */
            Console.WriteLine("Deneme");


            Server server = new Server
            {
                Services = { CRUDs.BindService(new CRUDsImpl()), LookupService.BindService(new LookupServiceImpl()) },
                Ports    = { new ServerPort("localhost", Port, ServerCredentials.Insecure) }
                //Ports = { new ServerPort("217.160.13.102", Port, ServerCredentials.Insecure) }
                //Ports = { new ServerPort("192.168.1.20", Port, ServerCredentials.Insecure) }
            };

            server.Start();

            Console.WriteLine("Rest server listening on port " + Port);
        }