Example #1
0
        public void Insert(SpecialKeyword specialKeyword)
        {
            using (Transaction transaction = _engine.GetTransaction())
            {
                Insert(transaction, specialKeyword);

                transaction.Commit();
            }
        }
Example #2
0
        public SpecialKeyword Max()
        {
            using (Transaction transaction = _engine.GetTransaction())
            {
                DBreezeObject <SpecialKeyword> obj = transaction.Max <byte[], byte[]>(_table)
                                                     .ObjectGet <SpecialKeyword>();

                if (obj != null)
                {
                    SpecialKeyword entity = obj.Entity;
                    return(entity);
                }

                return(null);
            }
        }
Example #3
0
        public SpecialKeyword Select(int searchEngineId, int regionId, int keywordId)
        {
            using (Transaction transaction = _engine.GetTransaction())
            {
                DBreezeObject <SpecialKeyword> obj = transaction
                                                     .Select <byte[], byte[]>(
                    _table, 1.ToIndex(searchEngineId, regionId, keywordId))
                                                     .ObjectGet <SpecialKeyword>();

                if (obj != null)
                {
                    SpecialKeyword entity = obj.Entity;
                    return(entity);
                }

                return(null);
            }
        }
Example #4
0
 /// <summary>
 /// Does an object insert and creates the necessary indexes for
 /// a keyword
 /// </summary>
 /// <param name="transaction"></param>
 /// <param name="specialKeyword"></param>
 private void Insert(Transaction transaction, SpecialKeyword specialKeyword)
 {
     transaction.ObjectInsert(_table, new DBreezeObject <SpecialKeyword>
     {
         Entity  = specialKeyword,
         Indexes = new List <DBreezeIndex>
         {
             new DBreezeIndex(1, specialKeyword.SearchEngineID, specialKeyword.RegionID, specialKeyword.KeywordID)
             {
                 PrimaryIndex = true
             },
             new DBreezeIndex(2, specialKeyword.RowRevision)
             {
                 AddPrimaryToTheEnd = false
             }
         }
     });
 }
Example #5
0
        public IEnumerable <SpecialKeyword> SelectAll()
        {
            using (Transaction transaction = _engine.GetTransaction())
            {
                List <SpecialKeyword> entities           = new List <SpecialKeyword>();
                IEnumerable <Row <byte[], byte[]> > rows = transaction
                                                           .SelectForwardFromTo <byte[], byte[]>(
                    _table, 1.ToIndex(int.MinValue, int.MinValue, int.MinValue), true,
                    1.ToIndex(int.MaxValue, int.MaxValue, int.MaxValue), true);

                foreach (Row <byte[], byte[]> row in rows)
                {
                    DBreezeObject <SpecialKeyword> obj = row.ObjectGet <SpecialKeyword>();

                    if (obj != null)
                    {
                        SpecialKeyword entity = obj.Entity;
                        entities.Add(entity);
                    }
                }

                return(entities);
            }
        }