Exemple #1
0
        public RecentQueries ChkIfRecentConnIsInDb()
        {
            RecentQueries recConnection = null;

            IObjectSet objSet = null;

            try
            {
                container = Db4oClient.RecentConn;
                IQuery qry = container.Query();
                qry.Constrain(typeof(RecentQueries));
                if (m_connParam.Host == null)
                {
                    qry.Descend("m_connParam").Descend("m_connection").Constrain(m_connParam.Connection);
                    objSet = qry.Execute();
                }
                else
                {
                    qry.Descend("m_connParam").Descend("m_host").Constrain(m_connParam.Host);
                    qry.Descend("m_connParam").Descend("m_port").Constrain(m_connParam.Port);
                    qry.Descend("m_connParam").Descend("m_userName").Constrain(m_connParam.UserName);
                    qry.Descend("m_connParam").Descend("m_passWord").Constrain(m_connParam.PassWord);
                    objSet = qry.Execute();
                }
                if (objSet.Count > 0)
                {
                    recConnection = (RecentQueries)objSet.Next();
                }
            }
            catch (Exception oEx)
            {
                LoggingHelper.HandleException(oEx);
            }
            return(recConnection);
        }
Exemple #2
0
 public long ReturnTimeWhenRecentQueriesCreated()
 {
     try
     {
         RecentQueries rQueries = ChkIfRecentConnIsInDb();
         if (rQueries != null)
         {
             return(rQueries.TimeOfCreation > 0 ? rQueries.TimeOfCreation : 0);
         }
     }
     catch (Exception oEx)
     {
         LoggingHelper.HandleException(oEx);
     }
     return(0);
 }
Exemple #3
0
        public List <OMQuery> FetchQueriesForAClass(string className)
        {
            List <OMQuery> qList = new List <OMQuery>();
            IObjectSet     objSet;

            try
            {
                container = Db4oClient.RecentConn;
                IQuery query = container.Query();
                query.Constrain(typeof(RecentQueries));
                query.Descend("m_connParam").Descend("m_connection").Constrain(m_connParam.Connection);
                objSet = query.Execute();
                if (objSet != null && objSet.Count > 0)
                {
                    RecentQueries recentQueries = (RecentQueries)objSet.Next();
                    foreach (OMQuery q in recentQueries.QueryList)
                    {
                        if (q != null && q.BaseClass.Equals(className))
                        {
                            qList.Add(q);
                        }
                    }

                    CompareQueryTimestamps comp = new CompareQueryTimestamps();
                    qList.Sort(comp);
                }
                else
                {
                    return(null);
                }
            }
            catch (Exception oEx)
            {
                LoggingHelper.HandleException(oEx);
                container = null;
                Db4oClient.CloseRecentConnectionFile();
            }
            return(qList);
        }
Exemple #4
0
        public void deleteRecentQueriesForAConnection()
        {
            List <OMQuery> qList  = new List <OMQuery>();
            IObjectSet     objSet = null;

            try
            {
                container = Db4oClient.RecentConn;
                IQuery query = container.Query();
                query.Constrain(typeof(RecentQueries));
                query.Descend("m_connParam").Descend("m_connection").Constrain(m_connParam.Connection);
                objSet = query.Execute();
                if (objSet != null)
                {
                    RecentQueries recQueries = (RecentQueries)objSet.Next();

                    for (int i = 0; i < recQueries.QueryList.Count; i++)
                    {
                        OMQuery q = recQueries.m_queryList[0];
                        if (q != null)
                        {
                            // m_queryList.Remove(q);
                            container.Delete(q);
                        }
                    }
                    recQueries.m_queryList.Clear();
                    recQueries.m_TimeOfCreation = Sharpen.Runtime.CurrentTimeMillis();
                    container.Ext().Store(recQueries, 5);
                    container.Commit();
                }
            }
            catch (Exception oEx)
            {
                LoggingHelper.HandleException(oEx);
            }
        }
Exemple #5
0
        //public RecentQueries PopulateParameters(DateTime date)
        //{
        //    this.Timestamp = date;
        //    this.ConnParam = m_connParam;
        //    return this;
        //}



        public void AddQueryToList(OMQuery query)
        {
            try
            {
                container = Db4oClient.RecentConn;
                if (QueryList != null)
                {
                    CompareQueryTimestamps comp = new CompareQueryTimestamps();

                    List <OMQuery> qList = FetchAllQueries();
                    //  qList.Sort(comp);


                    if (qList.Count >= 20)
                    {
                        bool check = false;
                        foreach (OMQuery qry in qList)
                        {
                            if (qry.QueryString == query.QueryString)
                            {
                                //check if the query string is among 5
                                check = true;
                            }
                        }
                        //if it is not among five then remove the last item from the list
                        if (check == false)
                        {
                            OMQuery q = qList[qList.Count - 1];
                            qList.RemoveAt(qList.Count - 1);
                            foreach (OMQuery qry1 in this.QueryList)
                            {
                                if (q.QueryString.Equals(qry1.QueryString))
                                {
                                    this.QueryList.Remove(qry1);
                                    break;
                                }
                            }
                            container.Delete(q);
                            container.Commit();
                        }
                    }

                    List <OMQuery> qListForClass = FetchQueriesForAClass(query.BaseClass);
                    if (qListForClass != null)
                    {
                        qListForClass.Sort(comp);
                        if (qListForClass.Count >= 5)
                        {
                            bool check = false;
                            foreach (OMQuery qry in qListForClass)
                            {
                                if (qry.QueryString == query.QueryString)
                                {
                                    //check if the query string is among 5
                                    check = true;
                                }
                            }
                            //if it is not among five then remove the last item from the list
                            if (check == false)
                            {
                                OMQuery q = qListForClass[qListForClass.Count - 1];
                                qListForClass.RemoveAt(qListForClass.Count - 1);
                                foreach (OMQuery qry1 in this.QueryList)
                                {
                                    if (q.QueryString.Equals(qry1.QueryString))
                                    {
                                        this.QueryList.Remove(qry1);
                                        break;
                                    }
                                }
                                container.Delete(q);
                                container.Commit();
                            }
                        }


                        // recent queries should always be 5 for a class therefore its checked
                        //against qListForClass.
                        foreach (OMQuery q in qListForClass)
                        {
                            if (q != null)
                            {
                                if (q.QueryString != null)
                                {
                                    if (q.QueryString.Equals(query.QueryString))
                                    {
                                        //if query string is same as already in the list then remove from the list
                                        //so that same string can be added again with updated timestamp

                                        foreach (OMQuery qry1 in this.QueryList)
                                        {
                                            if (q.QueryString.Equals(qry1.QueryString))
                                            {
                                                this.QueryList.Remove(qry1);
                                                break;
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                    //add query with latest timestamp.
                    this.QueryList.Add(query);
                    RecentQueries temprc = this.ChkIfRecentConnIsInDb();
                    if (temprc != null)
                    {
                        temprc.Timestamp = DateTime.Now;
                        temprc.QueryList = this.QueryList;
                    }
                    else
                    {
                        temprc = this;
                        temprc.m_TimeOfCreation = Sharpen.Runtime.CurrentTimeMillis();
                    }
                    container.Ext().Store(temprc, 5);
                    container.Commit();
                    container = null;
                    Db4oClient.CloseRecentConnectionFile();
                }
            }
            catch (Exception oEx)
            {
                LoggingHelper.HandleException(oEx);
                container = null;
                Db4oClient.CloseRecentConnectionFile();
            }
        }