public void TestOriginalValue() { Helper.DropAllCollections(); var c = new Country {Code = "ES", Name = "España"}; c.Save(); var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Childs.Add( new Child {ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"}); p.Save(); p.Name = "Juan Sin Miedo"; object originalName = p.GetOriginalObject().Name; Assert.AreEqual(originalName.ToString(), "Pepito Perez"); }
public void TestOriginalObject() { (new InsertModifyDeleteTest()).TestInsert(); Person p = MongoMapperCollection <Person> .Instance.Find().FirstAsync().Result; p.Save(); p.Name = "hola 25"; var p2 = p.GetOriginalObject(); Assert.AreEqual("Pepito Perez", p2.Name); }
public void TestChildIncrementalId() { Helper.DropAllCollections(); var c = new Country {Code = "ES", Name = "España"}; c.Save(); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Childs.Add( new Child {ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"}); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child {ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez"}); p.Save(); var Persons = new List<Person>(); Persons.MongoFind(); long index = 1; foreach (Person person in Persons) { foreach (Child child in person.Childs) { Assert.AreEqual(child._id, index); index ++; } } }
public void TestServerUdpate() { Helper.DropAllCollections(); //Insert de Paises var c = new Country { Code = "ES", Name = "España" }; c.Save(); c.ServerUpdate(c.Update.Set(MongoMapperHelper.ConvertFieldName("Country", "Name"), "España 22")); Assert.AreEqual(c.Name, "España 22"); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Save(); p.ServerUpdate( p.Update.Push( MongoMapperHelper.ConvertFieldName("Person", "Childs"), new Child { ID = 2, Age = 3, BirthDate = DateTime.Now.AddDays(57).AddYears(-17), Name = "Laura Perez" })); Assert.AreEqual(p.Childs.Count, 2); Assert.AreEqual(p.Childs[1].Name, "Laura Perez"); }
public void TestFillByKeyExtension() { Helper.DropAllCollections(); //Insert de Paises var c = new Country { Code = "ES", Name = "España" }; c.Save(); var country = new Country(); country.FillByKey("ES"); Assert.AreEqual(country.Code, "ES"); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Childs.Add( new Child { ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" }); p.Save(); long id = p.m_id; p = new Person(); p.FillByKey(id); }
public void TestOriginalValue() { Helper.DropAllCollections(); var c = new Country { Code = "ES", Name = "España" }; c.Save(); var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Childs.Add( new Child { ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" }); p.Save(); p.Name = "Juan Sin Miedo"; object originalName = p.GetOriginalObject().Name; Assert.AreEqual(originalName.ToString(), "Pepito Perez"); }
public void TestGroupSum() { Helper.DropAllCollections(); var c = new Country { Code = "NL", Name = "Holanda" }; c.Save(); c = new Country { Code = "ES", Name = "SPAIN" }; c.Save(); for (int i = 0; i < 10; i++) { var p = new Person { Name = i.ToString(), Age = i, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Save(); } for (int i = 0; i < 5; i++) { var p = new Person { Name = i.ToString(), Age = i, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "NL", BankBalance = decimal.Parse("3500,00") }; p.Save(); } var operations = new[] { new BsonDocument { { //$Country es $c "$group", new BsonDocument { { "_id", "$" + MongoMapperHelper.ConvertFieldName("Person", "Country") }, { "Total", new BsonDocument { { "$sum", 1 } } }, } } } }; var mongoresult = MongoMapper <Person> .Aggregate(operations); foreach (var document in mongoresult) { if (document["_id"].ToString() == "ES") { Assert.AreEqual(10, int.Parse(document["Total"].ToString())); } else if (document["_id"].ToString() == "NL") { Assert.AreEqual(5, int.Parse(document["Total"].ToString())); } else { throw new InconclusiveException(""); } } }
public void TestInsert() { Helper.DropAllCollections(); //Insert de Paises var c = new Country {Code = "es", Name = "España"}; try { c.Save(); Assert.Fail(); } catch (ValidatePropertyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (ValidatePropertyException)); c.Code = "ES"; c.Save(); } c = new Country {Code = "UK", Name = "Reino Unido"}; c.Save(); c = new Country {Code = "UK", Name = "Reino Unido"}; try { c.Save(); Assert.Fail(); } catch (DuplicateKeyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (DuplicateKeyException)); } c = new Country {Code = "US", Name = "Estados Unidos"}; c.Save(); var Countries = new List<Country>(); Countries.MongoFind(C=>C.Code, "ES"); Assert.AreEqual(Countries.Count, 1); Countries.MongoFind(C=>C.Code, "UK"); Assert.AreEqual(Countries.Count, 1); Countries.MongoFind(C=>C.Code, "US"); Assert.AreEqual(Countries.Count, 1); Countries.MongoFind(); Assert.AreEqual(Countries.Count, 3); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Childs.Add( new Child {ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"}); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child {ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez"}); p.Save(); p = new Person { Name = "Andres Perez", Age = 25, BirthDate = DateTime.Now.AddDays(25).AddYears(-25), Married = false, Country = "ES", BankBalance = decimal.Parse("500,00") }; p.Save(); p = new Person { Name = "Marta Serrano", Age = 28, BirthDate = DateTime.Now.AddDays(28).AddYears(-28), Married = false, Country = "ES", BankBalance = decimal.Parse("9500,00") }; p.Childs.Add( new Child {ID = 1, Age = 2, BirthDate = DateTime.Now.AddDays(2).AddYears(-2), Name = "Toni Serrano"}); p.Save(); p = new Person { Name = "Jonh Smith", Age = 21, BirthDate = DateTime.Now.AddDays(21).AddYears(-21), Married = false, Country = "US", BankBalance = decimal.Parse("100,00") }; p.Save(); var persons = new List<Person>(); persons.MongoFind(); Assert.AreEqual(persons.Count, 5); persons.MongoFind("Childs.Age", 2); Assert.AreEqual(persons.Count, 1); }
public void Test() { Helper.DropAllCollections(); ConfigManager.Out = Console.Out; var c = new Country { Code = "es", Name = "España" }; try { c.Save(); Assert.Fail(); } catch (ValidatePropertyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(ValidatePropertyException)); c.Code = "ES"; c.Save(); } c = new Country { Code = "UK", Name = "Reino Unido" }; c.Save(); c = new Country { Code = "UK", Name = "Reino Unido" }; try { c.Save(); Assert.Fail(); } catch (DuplicateKeyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(DuplicateKeyException)); } using (var t = new MongoMapperTransaction()) { var c2 = new Country { Code = "US", Name = "Francia" }; c2.OnBeforeInsert += (s, e) => { ((Country)s).Name = "Estados Unidos"; }; c2.Save(); t.Commit(); } var c3 = new Country(); c3.FillByKey("US"); Assert.AreEqual(c3.Name, "Estados Unidos"); if (!c3.IsLastVersion()) { c3.FillFromLastVersion(); } var countries = new CountryCollection(); countries.Find(); Assert.AreEqual(countries.Count, 3); countries.Find().Limit(2).Sort(countries.Sort.Ascending(C => C.Name)); Assert.AreEqual(countries.Count, 2); Assert.AreEqual(countries.Total, 3); countries.Find( countries.Filter.Or(MongoQuery <Country> .Eq(co => co.Code, "ES"), MongoQuery <Country> .Eq(co => co.Code, "UK"))); Assert.AreEqual(countries.Count, 2); var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "XXXXX", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); try { p.Save(); Assert.Fail(); } catch (ValidateUpRelationException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(ValidateUpRelationException)); p.Country = "ES"; p.Save(); } p.ServerUpdate( p.Update.Push( MongoMapperHelper.ConvertFieldName("Person", "Childs"), new Child { ID = 2, Age = 2, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" })); var persons = new List <Person>(); persons.MongoFind(); persons.MongoFind("Childs.Age", 2); Assert.AreEqual(1, persons.Count); }
public void TestInsert() { Helper.DropAllCollections(); //Insert de Paises var c = new Country { Code = "es", Name = "España" }; try { c.Save(); Assert.Fail(); } catch (ValidatePropertyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(ValidatePropertyException)); c.Code = "ES"; c.Save(); } c = new Country { Code = "UK", Name = "Reino Unido" }; c.Save(); c = new Country { Code = "UK", Name = "Reino Unido" }; try { c.Save(); Assert.Fail(); } catch (DuplicateKeyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(DuplicateKeyException)); } c = new Country { Code = "US", Name = "Estados Unidos" }; c.Save(); var Countries = new List <Country>(); Countries.MongoFind(C => C.Code, "ES"); Assert.AreEqual(Countries.Count, 1); Countries.MongoFind(C => C.Code, "UK"); Assert.AreEqual(Countries.Count, 1); Countries.MongoFind(C => C.Code, "US"); Assert.AreEqual(Countries.Count, 1); Countries.MongoFind(); Assert.AreEqual(Countries.Count, 3); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Childs.Add( new Child { ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" }); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child { ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez" }); p.Save(); p = new Person { Name = "Andres Perez", Age = 25, BirthDate = DateTime.Now.AddDays(25).AddYears(-25), Married = false, Country = "ES", BankBalance = decimal.Parse("500,00") }; p.Save(); p = new Person { Name = "Marta Serrano", Age = 28, BirthDate = DateTime.Now.AddDays(28).AddYears(-28), Married = false, Country = "ES", BankBalance = decimal.Parse("9500,00") }; p.Childs.Add( new Child { ID = 1, Age = 2, BirthDate = DateTime.Now.AddDays(2).AddYears(-2), Name = "Toni Serrano" }); p.Save(); p = new Person { Name = "Jonh Smith", Age = 21, BirthDate = DateTime.Now.AddDays(21).AddYears(-21), Married = false, Country = "US", BankBalance = decimal.Parse("100,00") }; p.Save(); var persons = new List <Person>(); persons.MongoFind(); Assert.AreEqual(persons.Count, 5); persons.MongoFind("Childs.Age", 2); Assert.AreEqual(persons.Count, 1); }
public void TestGroupSum() { Helper.DropAllCollections(); var c = new Country {Code = "NL", Name = "Holanda"}; c.Save(); c = new Country {Code = "ES", Name = "SPAIN"}; c.Save(); for (int i = 0; i < 10; i++) { var p = new Person { Name = i.ToString(), Age = i, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Save(); } for (int i = 0; i < 5; i++) { var p = new Person { Name = i.ToString(), Age = i, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "NL", BankBalance = decimal.Parse("3500,00") }; p.Save(); } var operations = new []{ new BsonDocument { { //$Country es $c "$group", new BsonDocument{ { "_id" , "$" + MongoMapperHelper.ConvertFieldName("Person","Country") } , {"Total" , new BsonDocument{ {"$sum",1} } }, } } } }; var mongoresult = MongoMapper.Aggregate<Person>(operations); foreach (var document in mongoresult) { if (document ["_id"].ToString () == "ES") Assert.AreEqual (10, int.Parse (document ["Total"].ToString ())); else if (document ["_id"].ToString () == "NL") Assert.AreEqual (5, int.Parse (document ["Total"].ToString ())); else throw new InconclusiveException (""); } }
public void Test() { Helper.DropAllCollections(); ConfigManager.Out = Console.Out; var c = new Country {Code = "es", Name = "España"}; try { c.Save(); Assert.Fail(); } catch (ValidatePropertyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (ValidatePropertyException)); c.Code = "ES"; c.Save(); } c = new Country {Code = "UK", Name = "Reino Unido"}; c.Save(); c = new Country {Code = "UK", Name = "Reino Unido"}; try { c.Save(); Assert.Fail(); } catch (DuplicateKeyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (DuplicateKeyException)); } using (var t = new MongoMapperTransaction()) { var c2 = new Country {Code = "US", Name = "Francia"}; c2.OnBeforeInsert += (s, e) => { ((Country) s).Name = "Estados Unidos"; }; c2.Save(); t.Commit(); } var c3 = new Country(); c3.FillByKey("US"); Assert.AreEqual(c3.Name, "Estados Unidos"); if (!c3.IsLastVersion()) c3.FillFromLastVersion(); var countries = new CountryCollection(); countries.Find(); Assert.AreEqual(countries.Count, 3); countries.Find().Limit(2).Sort(countries.Sort.Ascending(C=>C.Name)); Assert.AreEqual(countries.Count, 2); Assert.AreEqual(countries.Total, 3); countries.Find( countries.Filter.Or(MongoQuery<Country>.Eq(co => co.Code, "ES"), MongoQuery<Country>.Eq(co => co.Code, "UK"))); Assert.AreEqual(countries.Count, 2); var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "XXXXX", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); try { p.Save(); Assert.Fail(); } catch (ValidateUpRelationException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (ValidateUpRelationException)); p.Country = "ES"; p.Save(); } p.ServerUpdate( p.Update.Push( MongoMapperHelper.ConvertFieldName("Person","Childs"), new Child {ID = 2, Age = 2, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"})); var persons = new List<Person>(); persons.MongoFind(); persons.MongoFind("Childs.Age", 2); Assert.AreEqual(1, persons.Count); }
public void TestChildIncrementalId() { Helper.DropAllCollections(); var c = new Country { Code = "ES", Name = "España" }; c.Save(); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Childs.Add( new Child { ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" }); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child { ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez" }); p.Save(); var Persons = new List <Person>(); Persons.MongoFind(); long index = 1; foreach (Person person in Persons) { foreach (Child child in person.Childs) { Assert.AreEqual(child._id, index); index++; } } }
public void TestInsert() { Helper.DropAllCollections(); //Paris var geoArea = new GeoArea(); geoArea.type = "Polygon"; var coordinates = new List<double[]>(); coordinates.Add(new double[] { 48.979766324449706, 2.098388671875 }); coordinates.Add(new double[] { 48.972555195463336, 2.5982666015625 }); coordinates.Add(new double[] { 48.683254235765325, 2.603759765625 }); coordinates.Add(new double[] { 48.66874533279169, 2.120361328125 }); coordinates.Add(new double[] { 48.979766324449706, 2.098388671875 }); geoArea.coordinates = new [] {coordinates.ToArray()}; //Insert de Paises var c = new Country {Code = "es", Name = "España", Area = geoArea}; try { c.Save(); Assert.Fail(); } catch (ValidatePropertyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (ValidatePropertyException)); c.Code = "ES"; c.Save(); } c = new Country { Code = "UK", Name = "Reino Unido", Area = geoArea}; c.Save(); c = new Country { Code = "UK", Name = "Reino Unido", Area = geoArea }; try { c.Save(); Assert.Fail(); } catch (DuplicateKeyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (DuplicateKeyException)); } c = new Country { Code = "US", Name = "Estados Unidos", Area = geoArea }; c.Save(); var countries = new CountryCollection(); countries.Find(x=>x.Code, "ES"); Assert.AreEqual(countries.Count, 1); countries.Find(x=>x.Code, "UK"); Assert.AreEqual(countries.Count, 1); countries.Find(x=>x.Code, "US"); Assert.AreEqual(countries.Count, 1); countries.Find(); Assert.AreEqual(countries.Count, 3); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Childs.Add( new Child {ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"}); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child {ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez"}); p.Save(); p = new Person { Name = "Andres Perez", Age = 25, BirthDate = DateTime.Now.AddDays(25).AddYears(-25), Married = false, Country = "ES", BankBalance = decimal.Parse("500,00") }; p.Save(); p = new Person { Name = "Marta Serrano", Age = 28, BirthDate = DateTime.Now.AddDays(28).AddYears(-28), Married = false, Country = "ES", BankBalance = decimal.Parse("9500,00") }; p.Childs.Add( new Child {ID = 1, Age = 2, BirthDate = DateTime.Now.AddDays(2).AddYears(-2), Name = "Toni Serrano"}); p.Save(); p = new Person { Name = "Jonh Smith", Age = 21, BirthDate = DateTime.Now.AddDays(21).AddYears(-21), Married = false, Country = "US", BankBalance = decimal.Parse("10000,00") }; p.Save(); var persons = new List<Person>(); persons.MongoFind(); Assert.AreEqual(persons.Count, 5); }
public void TestFindByPk() { //Llenamos datos Helper.DropAllCollections(); ConfigManager.Out = Console.Out; var c = new Country { Code = "ES", Name = "España" }; c.Save(); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Childs.Add( new Child { ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" }); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child { ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez" }); p.Save(); p = new Person { Name = "Andres Perez", Age = 25, BirthDate = DateTime.Now.AddDays(25).AddYears(-25), Married = false, Country = "ES", BankBalance = decimal.Parse("500,00") }; p.Save(); p = new Person { Name = "Marta Serrano", Age = 28, BirthDate = DateTime.Now.AddDays(28).AddYears(-28), Married = false, Country = "ES", BankBalance = decimal.Parse("9500,00") }; p.Childs.Add( new Child { ID = 1, Age = 2, BirthDate = DateTime.Now.AddDays(2).AddYears(-2), Name = "Toni Serrano" }); p.Save(); p = new Person { Name = "Jonh Smith", Age = 21, BirthDate = DateTime.Now.AddDays(21).AddYears(-21), Married = false, Country = "ES", BankBalance = decimal.Parse("100,00") }; p.Save(); List <Person> plist = MongoMapperCollection <Person> .Instance.Find().ToListAsync().Result; var p2 = new Person(); p2.FillByKey(plist[0].m_id); p2.Name = "FindBYKey Name"; p2.Save(); var Persons = MongoMapperCollection <Person> .Instance; plist = Persons.Find(x => x.m_id, p2.m_id).ToListAsync().Result; Assert.AreEqual(1, plist.Count); Assert.AreEqual(plist[0].Name, "FindBYKey Name"); c = new Country(); //Assert.Throws(typeof(FindByKeyNotFoundException), c.FillByKey("XXXXXX")); }
public void TestFillByKeyExtension() { Helper.DropAllCollections(); //Insert de Paises var c = new Country {Code = "ES", Name = "España"}; c.Save(); var country = new Country(); country.FillByKey("ES"); Assert.AreEqual(country.Code, "ES"); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Childs.Add( new Child {ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"}); p.Save(); long id = p.m_id; p = new Person(); p.FillByKey(id); }
public void TestFindByPk() { //Llenamos datos Helper.DropAllCollections(); ConfigManager.Out = Console.Out; var c = new Country {Code = "ES", Name = "España"}; c.Save(); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Childs.Add( new Child {ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"}); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child {ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez"}); p.Save(); p = new Person { Name = "Andres Perez", Age = 25, BirthDate = DateTime.Now.AddDays(25).AddYears(-25), Married = false, Country = "ES", BankBalance = decimal.Parse("500,00") }; p.Save(); p = new Person { Name = "Marta Serrano", Age = 28, BirthDate = DateTime.Now.AddDays(28).AddYears(-28), Married = false, Country = "ES", BankBalance = decimal.Parse("9500,00") }; p.Childs.Add( new Child {ID = 1, Age = 2, BirthDate = DateTime.Now.AddDays(2).AddYears(-2), Name = "Toni Serrano"}); p.Save(); p = new Person { Name = "Jonh Smith", Age = 21, BirthDate = DateTime.Now.AddDays(21).AddYears(-21), Married = false, Country = "ES", BankBalance = decimal.Parse("100,00") }; p.Save(); List<Person> plist = MongoMapperCollection<Person>.Instance.Find().ToList(); var p2 = new Person(); p2.FillByKey(plist[0].m_id); p2.Name = "FindBYKey Name"; p2.Save(); var Persons = MongoMapperCollection<Person>.Instance; plist = Persons.Find(x=>x.m_id, p2.m_id).ToList(); Assert.AreEqual(1, plist.Count); Assert.AreEqual(plist[0].Name, "FindBYKey Name"); c = new Country(); //Assert.Throws(typeof(FindByKeyNotFoundException), c.FillByKey("XXXXXX")); }
public void TestRelations() { Helper.DropAllCollections(); var c = new Country {Code = "ES", Name = "España"}; c.Save(); c = new Country {Code = "UK", Name = "Reino Unido"}; c.Save(); var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "XXXXX", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Childs.Add( new Child {ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez"}); try { p.Save(); } catch (Exception ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (ValidateUpRelationException)); p.Country = "ES"; p.Save(); } c = MongoMapper.FindByKey<Country>("ES"); try { c.Delete(); } catch (Exception ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof (ValidateDownRelationException)); List<Person> Persons = c.GetRelation<Person>("Person,Country"); foreach (Person p2 in Persons) { p2.Country = "UK"; p2.Save(); } c.Delete(); } c = MongoMapper.FindByKey<Country>("UK"); List<Person> PersonasEnUK = c.GetRelation<Person>("Person,Country"); foreach (Person PersonInUK in PersonasEnUK) { Assert.AreEqual(PersonInUK.Country, "UK"); Assert.AreEqual(PersonInUK.GetRelation<Country>("Country,Code").First().Code, "UK"); } }
public void TestServerUdpate() { Helper.DropAllCollections(); //Insert de Paises var c = new Country {Code = "ES", Name = "España"}; c.Save(); c.ServerUpdate(c.Update.Set(MongoMapperHelper.ConvertFieldName("Country", "Name"), "España 22")); Assert.AreEqual(c.Name, "España 22"); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child {ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez"}); p.Save(); p.ServerUpdate( p.Update.Push( MongoMapperHelper.ConvertFieldName("Person","Childs"), new Child {ID = 2, Age = 3, BirthDate = DateTime.Now.AddDays(57).AddYears(-17), Name = "Laura Perez"})); Assert.AreEqual(p.Childs.Count, 2); Assert.AreEqual(p.Childs[1].Name, "Laura Perez"); }
public void TestRelations() { Helper.DropAllCollections(); var c = new Country { Code = "ES", Name = "España" }; c.Save(); c = new Country { Code = "UK", Name = "Reino Unido" }; c.Save(); var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "XXXXX", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Childs.Add( new Child { ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" }); try { p.Save(); Assert.Fail(); } catch (ValidateUpRelationException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(ValidateUpRelationException)); p.Country = "ES"; p.Save(); } c = MongoMapper <Country> .FindByKey("ES"); try { c.Delete(); Assert.Fail(); } catch (ValidateDownRelationException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(ValidateDownRelationException)); List <Person> persons = new List <Person>(); persons.MongoFind(C => C.Country, "ES"); foreach (Person p2 in persons) { p2.Country = "UK"; p2.Save(); } c.Delete(); } List <Person> personsInUk = new List <Person>(); personsInUk.MongoFind(C => C.Country, "UK"); foreach (Person personInUk in personsInUk) { Assert.AreEqual(personInUk.Country, "UK"); } }
public void TestInsert() { Helper.DropAllCollections(); //Paris var geoArea = new GeoArea(); geoArea.type = "Polygon"; var coordinates = new List <double[]>(); coordinates.Add(new double[] { 48.979766324449706, 2.098388671875 }); coordinates.Add(new double[] { 48.972555195463336, 2.5982666015625 }); coordinates.Add(new double[] { 48.683254235765325, 2.603759765625 }); coordinates.Add(new double[] { 48.66874533279169, 2.120361328125 }); coordinates.Add(new double[] { 48.979766324449706, 2.098388671875 }); geoArea.coordinates = new [] { coordinates.ToArray() }; //Insert de Paises var c = new Country { Code = "es", Name = "España", Area = geoArea }; try { c.Save(); Assert.Fail(); } catch (ValidatePropertyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(ValidatePropertyException)); c.Code = "ES"; c.Save(); } c = new Country { Code = "UK", Name = "Reino Unido", Area = geoArea }; c.Save(); c = new Country { Code = "UK", Name = "Reino Unido", Area = geoArea }; try { c.Save(); Assert.Fail(); } catch (DuplicateKeyException ex) { Assert.AreEqual(ex.GetBaseException().GetType(), typeof(DuplicateKeyException)); } c = new Country { Code = "US", Name = "Estados Unidos", Area = geoArea }; c.Save(); var countries = new CountryCollection(); countries.Find(x => x.Code, "ES"); Assert.AreEqual(countries.Count, 1); countries.Find(x => x.Code, "UK"); Assert.AreEqual(countries.Count, 1); countries.Find(x => x.Code, "US"); Assert.AreEqual(countries.Count, 1); countries.Find(); Assert.AreEqual(countries.Count, 3); //Insert de personas var p = new Person { Name = "Pepito Perez", Age = 35, BirthDate = DateTime.Now.AddDays(57).AddYears(-35), Married = true, Country = "ES", BankBalance = decimal.Parse("3500,00") }; p.Childs.Add( new Child { ID = 1, Age = 10, BirthDate = DateTime.Now.AddDays(57).AddYears(-10), Name = "Juan Perez" }); p.Childs.Add( new Child { ID = 2, Age = 7, BirthDate = DateTime.Now.AddDays(57).AddYears(-7), Name = "Ana Perez" }); p.Save(); p = new Person { Name = "Juanito Sanchez", Age = 25, BirthDate = DateTime.Now.AddDays(52).AddYears(-38), Married = true, Country = "ES", BankBalance = decimal.Parse("1500,00") }; p.Childs.Add( new Child { ID = 1, Age = 5, BirthDate = DateTime.Now.AddDays(7).AddYears(-5), Name = "Toni Sanchez" }); p.Save(); p = new Person { Name = "Andres Perez", Age = 25, BirthDate = DateTime.Now.AddDays(25).AddYears(-25), Married = false, Country = "ES", BankBalance = decimal.Parse("500,00") }; p.Save(); p = new Person { Name = "Marta Serrano", Age = 28, BirthDate = DateTime.Now.AddDays(28).AddYears(-28), Married = false, Country = "ES", BankBalance = decimal.Parse("9500,00") }; p.Childs.Add( new Child { ID = 1, Age = 2, BirthDate = DateTime.Now.AddDays(2).AddYears(-2), Name = "Toni Serrano" }); p.Save(); p = new Person { Name = "Jonh Smith", Age = 21, BirthDate = DateTime.Now.AddDays(21).AddYears(-21), Married = false, Country = "US", BankBalance = decimal.Parse("10000,00") }; p.Save(); var persons = new List <Person>(); persons.MongoFind(); Assert.AreEqual(persons.Count, 5); }