private static void OptimizedNativeQuery(IObjectContainer container) { IList<Pilot> result = container.Query( delegate(Pilot pilot) { return pilot.Name.StartsWith("J"); }); ListResult(result); }
public static void RetrieveAllPilots(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof(Pilot)); IObjectSet result = query.Execute(); ListResult(result); }
public virtual IObjectSet Query(IObjectContainer db) { var query = db.Query(); query.Constrain(this); query.Descend("_flag").Constrain(true).Not(); return query.Execute(); }
public static void RetrieveAllSensorReadoutsQuery(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof(SensorReadout)); IObjectSet result = query.Execute(); ListResult(result); }
private int obtemNovoIdEng() { try { db = ServidorSingleton.obterServidor().OpenClient(); IQuery query = db.Query(); query.Constrain(typeof(EngenheiroCampo)).Greater(); query.Descend("codigo").OrderDescending(); IObjectSet leitor = query.Execute(); if (leitor.HasNext()) { EngenheiroCampo objEng = (EngenheiroCampo)leitor.Next(); leitor = null; return Convert.ToInt32(objEng.Codigo) + 1; } else { leitor = null; return 1; } } catch (Exception ex) { throw new Exception("Erro obtendo o id do engenheiro :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
private void IndexDatabase(IndexWriter writer, IObjectContainer container) { IEnumerable<Versiculo> versiculos = container.Query<Versiculo>(); foreach(Versiculo versiculo in versiculos){ Document doc = CreateVersiculoDoc(container.Ext().GetID(versiculo), versiculo); writer.AddDocument(doc); } }
public static void RetrievePilotByName(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof(Pilot)); query.Descend("_name").Constrain("Michael Schumacher"); IObjectSet result = query.Execute(); ListResult(result); }
private Item GetByName(IObjectContainer oc, string name) { var q = oc.Query(); q.Constrain(typeof (Item)); q.Descend("name").Constrain(name); var objectSet = q.Execute(); return (Item) objectSet.Next(); }
private IObjectSet QueryItems(IObjectContainer container) { var q = container.Query(); q.Constrain(typeof (Item)); q.Descend("value").OrderAscending(); var found = q.Execute(); return found; }
public static void RetrievePilotByExactPoints(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof(Pilot)); query.Descend("_points").Constrain(100); IObjectSet result = query.Execute(); ListResult(result); }
public void PrepareData() { container = Db4oEmbedded.OpenFile(DatabaseFile); if (container.Query().Execute().Count == 0) { StoreTestData(container); } }
private static IObjectSet RunSODAQuery(IObjectContainer db, SimpleEnum value) { IQuery query = db.Query(); query.Constrain(typeof(Container)); query.Descend("_simpleEnum").Constrain(value); return query.Execute(); }
public static void QueryWithEvaluation(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof (Car)); query.Constrain(new EvenHistoryEvaluation()); IObjectSet result = query.Execute(); Util.ListResult(result); }
private IObjectSet QueryItems(IObjectContainer container) { IQuery q = container.Query(); q.Constrain(typeof(LegacyDatabaseDefragTestCase.Item)); q.Descend("value").OrderAscending(); IObjectSet found = q.Execute(); return found; }
private static void ReadALot(IObjectContainer container) { IList<DataObject> allObjects = container.Query<DataObject>(); foreach (DataObject obj in allObjects) { obj.ToString(); } }
private static void Equality(IObjectContainer container) { // #example: Check for equality of the name IList<Pilot> result = container.Query( delegate(Pilot pilot) { return pilot.Name == "John"; }); // #end example ListResult(result); }
private static void RageOfValues(IObjectContainer container) { // #example: Query for a particular rage of values IList<Pilot> result = container.Query( delegate(Pilot pilot) { return pilot.Age > 18 && pilot.Age < 30; }); // #end example ListResult(result); }
private Db4objects.Db4o.Tests.Common.Concurrency.RefreshTestCase GetByName(IObjectContainer oc, string name) { IQuery q = oc.Query(); q.Constrain(typeof(Db4objects.Db4o.Tests.Common.Concurrency.RefreshTestCase)); q.Descend("name").Constrain(name); IObjectSet objectSet = q.Execute(); return (Db4objects.Db4o.Tests.Common.Concurrency.RefreshTestCase)objectSet.Next(); }
private PathContainer PathContainerFor(IObjectContainer database) { IQuery query = database.Query(); query.Constrain(typeof (PathContainer)); query.Descend("_connectionPath").Constrain(_path).Contains(); IObjectSet paths = query.Execute(); return paths.Count == 0 ? new PathContainer(new SearchPathImpl()) : (PathContainer) paths[0]; }
private RefreshTestCase GetByName(IObjectContainer oc, string name) { var q = oc.Query(); q.Constrain(typeof (RefreshTestCase)); q.Descend("name").Constrain(name); var objectSet = q.Execute(); return (RefreshTestCase) objectSet.Next(); }
private static void Comparison(IObjectContainer container) { // #example: Compare values to each other IList<Pilot> result = container.Query( delegate(Pilot pilot) { return pilot.Age < 18; }); // #end example ListResult(result); }
private static IQuery QueryLeaf(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof (Person)); query.Descend("name").Constrain("Caroline").Equal(); return query; }
private static void RunQuery(IObjectContainer container) { IQuery query = container.Query(); query.Constrain(typeof (Item)); foreach(var obj in query.Execute()) { } }
public Db4oHistoryService(Uri baseUri, bool resume) { m_Db = Db4oEmbedded.OpenFile(Db4oEmbedded.NewConfiguration(), "NCrawlerHist_{0}.Yap".FormatWith(baseUri.GetHashCode())); if (!resume) { m_Db.Query<StringWrapper>().ForEach(entry => m_Db.Delete(entry)); } }
public void RunWith(IObjectContainer db) { IStoredClass storedClass = db.Ext().StoredClass(targetClazz); IStoredField storedField = storedClass.StoredField(fieldName, fieldType); IObjectSet result = db.Query(targetClazz); Assert.AreEqual(1, result.Count); object obj = result.Next(); object value = (object)storedField.Get(obj); Assert.AreEqual(fieldValue, value); }
public static void Export(string version, IObjectContainer db, Stream stream) { var export = new JsonExportHolder { Version = version, EndStats = db.Query<EndOfGameStats>().ToList(), Players = db.Query<PlayerEntry>().ToList(), }; ActivateList(db, export.EndStats); ActivateList(db, export.Players); var serializer = new JsonSerializer(); serializer.TypeNameHandling = TypeNameHandling.Auto; using (var json = new JsonTextWriter(new StreamWriter(stream))) { json.Formatting = Formatting.Indented; serializer.Serialize(json, export); } }
private static void NativeQuerySorting(IObjectContainer container) { // #example: Native query with sorting IList<Pilot> pilots = container.Query( delegate(Pilot p) { return p.Age > 18; }, delegate(Pilot p1, Pilot p2) { return p1.Name.CompareTo(p2.Name); }); // #end example ListResult(pilots); }
private Item RetrieveItem(IObjectContainer session) { var query = session.Query(); query.Constrain(typeof (Item)); var objectSet = query.Execute(); var sessionItem = ((Item ) objectSet.Next()); return sessionItem; }
public static Object GetByStringID(IObjectContainer oc, System.Type type, string idField, string id) { IQuery query = oc.Query(); query.Constrain(type); query.Descend(idField).Constrain(id); IObjectSet result = query.Execute(); if (result.HasNext()) return result.Next(); return null; }
private EmbeddedObjectContainerSessionTestCase.Item RetrieveItem(IObjectContainer session) { IQuery query = session.Query(); query.Constrain(typeof(EmbeddedObjectContainerSessionTestCase.Item)); IObjectSet objectSet = query.Execute(); EmbeddedObjectContainerSessionTestCase.Item sessionItem = ((EmbeddedObjectContainerSessionTestCase.Item )objectSet.Next()); return sessionItem; }
private static void DescendIntoCollectionMembers(IObjectContainer container) { Console.WriteLine("Descend into collection members"); // #example: Descend into collection members IQuery query = container.Query(); query.Constrain(typeof(BlogPost)); query.Descend("authors").Descend("name").Constrain("Jenny"); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private static void ContainsOnMaps(IObjectContainer container) { Console.WriteLine("Dictionary contains a key constrain"); // #example: Dictionary contains a key constrain IQuery query = container.Query(); query.Constrain(typeof(BlogPost)); query.Descend("metaData").Constrain("source"); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private static void GenericConstrains(IObjectContainer container) { Console.WriteLine("Pure field constrains"); // #example: Pure field constrains IQuery query = container.Query(); // You can simple filter objects which have a certain field query.Descend("name").Constrain(null).Not(); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private void Retrieve() { IObjectContainer db = Db4oEmbedded.OpenFile(Config(_memoryStorage), Uri); var result = db.Query(typeof(Item )); Assert.AreEqual(NumItems / 2, result.Count); while (result.HasNext()) { Assert.IsTrue((((Item)result.Next( ))._id % 2) == 1); } db.Close(); }
private static void RegexEvaluator(IObjectContainer container) { Console.WriteLine("Regex-Evaluation"); // #example: Regex-evaluation on a field IQuery query = container.Query(); query.Constrain(typeof(Pilot)); query.Descend("name").Constrain(new RegexConstrain("J.*nn.*")); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private void saveBtn_Click(object sender, RoutedEventArgs e) { var isBook = TypeCombo.SelectedIndex == 1; if (TypeCombo.SelectedIndex == -1 || TitleTxtBox.Text == String.Empty || PublisherTxtBox.Text == String.Empty || YearTxtBox.Text == String.Empty || (isBook && PriceTxtBox.Text == String.Empty) || (!isBook && PageFromTxtBox.Text == String.Empty) || (!isBook && PageToTxtBox.Text == String.Empty) ) { MessageBox.Show("Wypełnij wszystkie pola"); return; } dynamic publication; if (isBook) { publication = new Book(); publication.Price = Convert.ToDecimal(PriceTxtBox.Text); } else { publication = new Article(); publication.PageFrom = Convert.ToInt32(PageFromTxtBox.Text); publication.PageTo = Convert.ToInt32(PageToTxtBox.Text); } publication.Title = TitleTxtBox.Text.Replace(";", "").Trim(); publication.Publisher = PublisherTxtBox.Text.Replace(";", "").Trim(); publication.Year = Convert.ToInt32(YearTxtBox.Text); publication.Authors = new List <Author>(); _db.Store(publication); var all = _db.Query <Author>().ToList(); foreach (var item in authorsGrid.Items) { var itemObj = item as AuthorEditableGrid; var one = all.Where(x => x.LastName == itemObj.LastName).First(); if (itemObj.IsPublication) { publication.Authors.Add(one); one.Publications.Add(publication); } } _db.Store(publication.Authors); isClosedWithSave = true; this.Close(); }
private static void SessionsIsolation() { CleanUp(); using (IObjectContainer rootContainer = Db4oEmbedded.OpenFile(DatabaseFileName)) { using (IObjectContainer session1 = rootContainer.Ext().OpenSession(), session2 = rootContainer.Ext().OpenSession()) { // #example: Session are isolated from each other session1.Store(new Person("Joe")); session1.Store(new Person("Joanna")); // the second session won't see the changes until the changes are committed PrintAll(session2.Query <Person>()); session1.Commit(); // new the changes are visiable for the second session PrintAll(session2.Query <Person>()); // #end example } } }
private void button2_Click(object sender, EventArgs e) { IObjectContainer db = null;//Deklaration des Db-Arbeitsobjekt. bool updated = false; try { db = Db4oFactory.OpenFile("a"); //Db-Arbeitsobjekt wird durch die OpenFile methode zugewiesen. IList <Duesenflugzeug> fluege = db.Query <Duesenflugzeug>(delegate(Duesenflugzeug flieger) //Die Methode Query verwendet in mehrfacher Hinsicht eine sehr spezielle //Syntax,die gibt eine Ilist mit Typ düsenflugzeug zurück,und die methode //hat einen Predicate delegate als parameter ,Diese delegate hat eine anonyme Methode gespeichert,die methode nimmt düsenflugzeug //objekt,und dann prüfen ob diese kennung schon existiert, //wenn ja,wird dieses düsenflugzeug object in der IList gespeichert. { return(flieger.Kennung == textBoxKennung.Text); } ); foreach (Duesenflugzeug flieger in fluege) { Console.WriteLine("Fllug mit der Kennung {0} in Datenbank gefunden", flieger.Kennung); } if (fluege.Count > 0) { flieger = fluege.First(); updated = true; } this.initializeFlieger(); db.Store(flieger); if (updated) { Console.WriteLine("Datenbank-Update für den Flug mit der Kennung {0}", flieger.Kennung); } else { Console.WriteLine("Flug mit der Kennung {0} in der Datenbank gespeichert", flieger.Kennung); } } catch (Exception ex) { Console.WriteLine(ex.GetType() + ":" + ex.Message); } finally { if (db != null) { db.Close(); } } }
public static void RetrieveComplexSODA(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof(Pilot)); IQuery pointQuery = query.Descend("_points"); query.Descend("_name").Constrain("Rubens Barrichello") .Or(pointQuery.Constrain(99).Greater() .And(pointQuery.Constrain(199).Smaller())); IObjectSet result = query.Execute(); ListResult(result); }
private static void SimpleEvaluation(IObjectContainer container) { Console.WriteLine("Simple evaluation"); // #example: Simple evaluation IQuery query = container.Query(); query.Constrain(typeof(Pilot)); query.Constrain(new OnlyOddAge()); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private static void GreaterThanOrEqualConstrain(IObjectContainer container) { Console.WriteLine("A greater than or equals constrain"); // #example: A greater than or equals constrain IQuery query = container.Query(); query.Constrain(typeof(Pilot)); query.Descend("age").Constrain(42).Greater().Equal(); IObjectSet result = query.Execute(); // #end example ListResult(result); }
public static void RetrieveByDefaultFieldValue(IObjectContainer db) { Pilot somebody = new Pilot("Somebody else", 0); db.Store(somebody); IQuery query = db.Query(); query.Constrain(typeof(Pilot)); query.Descend("_points").Constrain(0); IObjectSet result = query.Execute(); ListResult(result); db.Delete(somebody); }
private void DeleteTemporaryObjects(IObjectContainer objectContainer) { var query = objectContainer.Query(); query.Constrain(typeof(Item)); query.Descend("name").Constrain("temp"); var objectSet = query.Execute(); while (objectSet.HasNext()) { objectContainer.Delete(((Item)objectSet.Next())); } objectContainer.Commit(); }
private static void ContainsOnCollection(IObjectContainer container) { Console.WriteLine("Collection contains constrain"); // #example: Collection contains constrain IQuery query = container.Query(); query.Constrain(typeof(BlogPost)); query.Descend("tags").Constrain("db4o"); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private static void EqualsConstrain(IObjectContainer container) { Console.WriteLine("A simple constrain on a field"); // #example: A simple constrain on a field IQuery query = container.Query(); query.Constrain(typeof(Pilot)); query.Descend("name").Constrain("John"); IObjectSet result = query.Execute(); // #end example ListResult(result); }
public void AddGroupPermission(int groupId, Permission permission) { Hashtable groupPerms = null; ArrayList permissions = null; IObjectContainer container = GetStorage(); try { IList <Hashtable> groupPermissionsList = container.Query <Hashtable>(delegate(Hashtable groupPermissions) { return(true); }); if (groupPermissionsList.Count == 0) { groupPerms = new Hashtable(); } else { groupPerms = groupPermissionsList[0]; } if (groupPerms[groupId] != null) { permissions = (ArrayList)groupPerms[groupId]; } else { permissions = new ArrayList(); groupPerms.Add(groupId, permissions); } int index = permissions.IndexOf(permission); // only add it if it is not already in the array if (index < 0) { permissions.Add(permission); } groupPerms[groupId] = permissions; container.Set(groupPerms); } finally { container.Close(); } }
private static void EvaluationOnField(IObjectContainer container) { Console.WriteLine("Evaluation on field"); // #example: Evaluation on field IQuery query = container.Query(); query.Constrain(typeof(Car)); query.Descend("pilot").Constrain(new OnlyOddAge()); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private static void RefreshAfterRollback(IObjectContainer container) { // #example: Refresh objects after rollback Pilot pilot = container.Query <Pilot>()[0]; pilot.Name = "New Name"; container.Store(pilot); container.Rollback(); // use refresh to return the in memory objects back // to the state in the database. container.Ext().Refresh(pilot, int.MaxValue); // #end example }
public static void RetrieveByConjunction(IObjectContainer db) { IQuery query = db.Query(); query.Constrain(typeof(Pilot)); IConstraint constr = query.Descend("_name") .Constrain("Michael Schumacher"); query.Descend("_points") .Constrain(99).And(constr); IObjectSet result = query.Execute(); ListResult(result); }
private static void CustomOrder(IObjectContainer container) { Console.WriteLine("Order by your comparator"); // #example: Order by your comparator IQuery query = container.Query(); query.Constrain(typeof(Pilot)); query.SortBy(new NameLengthComperator()); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private static void SortingOnField(IObjectContainer container) { Console.WriteLine("Order by a field"); // #example: Order by a field IQuery query = container.Query(); query.Constrain(typeof(Pilot)); query.Descend("name").OrderAscending(); IObjectSet result = query.Execute(); // #end example ListResult(result); }
private static void CombineComparisons(IObjectContainer container) { // #example: Combine different comparisons with the logical operators IList <Pilot> result = container.Query( delegate(Pilot pilot) { return((pilot.Age > 18 && pilot.Age < 30) || pilot.Name == "John"); }); // #end example ListResult(result); }
public void loadData() { //Header Transaction DB = Db4oFactory.OpenFile("Header Transaction.yap"); currHT = (from x in DB.Query <HeaderTransaction>() where x.UserId == currentUser.ID select x).ToList(); DB.Close(); if (currHT.Count() <= 0) { MessageBox.Show("Please Buy First!"); } else { List <ShoeClass> shoeList = new List <ShoeClass>(); //Detail Transaction for (int i = 0; i < currHT.Count; i++) { DB = Db4oFactory.OpenFile("Detail Transaction.yap"); List <DetailTransaction> dtList = DB.Query <DetailTransaction>(delegate(DetailTransaction dt) { return(dt.HeaderTransactionID == currHT.ElementAt(i).HeaderTransactionID); }).ToList(); //ShoeClass DB.Close(); DB = Db4oFactory.OpenFile("Shoe Database.yap"); foreach (var obj in dtList) { ShoeClass shoe = (from x in DB.Query <ShoeClass>() where x.ShoeID == obj.ShoeID select x).FirstOrDefault(); shoeList.Add(shoe); } //IList<ShoeClass> shoeList = DB.Query<ShoeClass>(delegate(ShoeClass shoe){ //}); //Query Detail Transaction to get Shoes from ShoeClass //IQuery dtQuery = DB.Query(); //dtQuery.Constrain(typeof(ShoeClass)); //dtQuery.Descend("ShoeID").Constrain(dtList.) dgvMSF.DataSource = shoeList.ToList(); //dgvMSF.DataSource = shoeList.ToList(); DB.Close(); } } }
private static void NotConstrain(IObjectContainer container) { Console.WriteLine("Not constrain"); // #example: Not constrain IQuery query = container.Query(); query.Constrain(typeof(Pilot)); query.Descend("age").Constrain(42).Not(); IObjectSet result = query.Execute(); // #end example ListResult(result); }
public virtual void TestOpenWithStaticConfiguration() { Db4oFactory.Configure().ReadOnly(true); Assert.Expect(typeof(DatabaseReadOnlyException), new _ICodeBlock_53(this)); Db4oFactory.Configure().ReadOnly(false); IObjectContainer db = Db4oFactory.OpenFile(TempFile()); db.Store(new GlobalVsNonStaticConfigurationTestCase.Data(1)); db.Close(); db = Db4oFactory.OpenFile(TempFile()); Assert.AreEqual(1, db.Query(typeof(GlobalVsNonStaticConfigurationTestCase.Data)). Count); db.Close(); }
private static void BlowReferenceSystem(IObjectContainer container) { IList <DataObject> dataObjects = container.Query <DataObject>(); List <DataObject> hardReferences = new List <DataObject>(); while (!Console.KeyAvailable) { foreach (DataObject reference in dataObjects) { hardReferences.Add(reference); } hardReferences.Clear(); } }
private void AssertItems(IObjectContainer objectContainer, int count) { var items = objectContainer.Query(typeof (Item)); Assert.AreEqual(count, items.Count); Assert.AreEqual(count, items.Count); var countCheck = 0; for (var itemIter = items.GetEnumerator(); itemIter.MoveNext();) { var item = ((Item) itemIter.Current); Assert.IsGreater(0, item._id); countCheck++; } Assert.AreEqual(count, countCheck); }
private void Btn_show_Click(object sender, EventArgs e) { DB = Db4oFactory.OpenFile("Nhanvien.yup"); IList <NhanVien> employes = DB.Query <NhanVien>(); if (employes.Count >= 0) { foreach (NhanVien em in employes) { displaycom.DataSource = employes.ToArray(); } } DB.Close(); }
public void DeleteGroup(GroupStorageView groupToDelete) { if (groupToDelete == null) { return; } IObjectContainer container = GetStorage(); try { IList <UserStorageView> users = container.Query <UserStorageView>(delegate(UserStorageView userFinder) { return(userFinder.GroupId == groupToDelete.GroupId); }); foreach (UserStorageView user in users) { container.Delete(user); } IList <GroupStorageView> groups = container.Query <GroupStorageView>(delegate(GroupStorageView groupFinder) { return(groupFinder.GroupId == groupToDelete.GroupId); }); if (groups.Count > 0) { container.Delete(groups[0]); } } finally { container.Close(); } }
protected void Button1_Click(object sender, EventArgs e) { try { int i = 0, flag = 0, PageFlag = 0; Config path = new Config(); DB = Db4oFactory.OpenFile(path.addressOfDocument); IList <Document_model> allDocumentList = DB.Query <Document_model>(); List <Document_model> resultDocuments = new List <Document_model>(); List <String> searchKeywordList = new List <string>(); searchKeywordList = SearchKeyword.Text.Split(',').ToList(); if (allDocumentList.Count > 0) { foreach (Document_model l1 in allDocumentList) { foreach (String key in l1.List_documentKeywords) { foreach (String searchKeyword in searchKeywordList) { if ((key.Trim().Equals(searchKeyword.Trim())) && (l1.DocumentStatus.Equals("Complete"))) { flag = 1; break; } } } if (flag == 1) { resultDocuments.Add(l1); flag = 0; PageFlag = 1; } } Session["searchKey"] = SearchKeyword.Text; Session["searchResultdocuments"] = resultDocuments; } if (PageFlag != 1) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('No relevant results found')", true); } DB.Close(); Response.Redirect("./SearchResult.aspx"); } catch { } }