Exemplo n.º 1
0
        public void UpdateNullValues()
        {
            _person = SamplePerson.GetSamplePerson();
              _person.Save();

              _person.Firstname = null;
              var id = _person.Save();
              _person = new SamplePerson { Identity = id, };
              _person.Load();
              Debug.Assert(_person.Firstname == null, "Update null string failed");

              _person.FkCompany = null;
              _person.Save();
              _person = new SamplePerson { Identity = id, };
              _person.Load();
              Debug.Assert(_person.FkCompany == null, "Update null int failed");

              _person.NullableDateTime = null;
              _person.Save();
              _person = new SamplePerson { Identity = id, };
              _person.Load();
              Debug.Assert(_person.NullableDateTime == null, "Update null datetime failed");
        }
Exemplo n.º 2
0
        public void BasicCrudTests()
        {
            _person = new SamplePerson();
              var li = _person.LoadList();
              foreach (var samplePerson in li)
              {
            samplePerson.Delete();
              }

              _person = SamplePerson.GetSamplePerson();
              Debug.Assert(_person.Save() != 0, "Failed to insert person");

              var id = _person.Identity;
              _person = new SamplePerson { Identity = id };
              Debug.Assert(_person.Load() && _person.FkMother == 1 && _person.Firstname != "" && _person.Lastname != "", "Load single object failed");

              var list = _person.LoadList();
              Debug.Assert(list.Count > 0 && list[0].FkCompany == 1 && list[0].FkMother == 1 && list[0].Firstname != "" && list[0].Lastname != "", "Load List failed");

              _person.Lastname = "UpdatedLastName";
              _person.Firstname = null;
              _person.FkCompany = 0;
              _person.FkMother = 100;
              _person.Boolean = false;
              _person.NullableDateTime = DateTime.Now;
              _person.Save();
              _person.Load();
              Debug.Assert(_person.Lastname == "UpdatedLastName" && _person.FkCompany == 0 && _person.FkMother == 100 && _person.Firstname != "", "Failed to update person");

              list = _person.LoadList("FkCompany", 0);
              Debug.Assert(list.Count > 0, "Failed to load List by Key");

              var qb = QueryBuilder.GetQueryBuilder(_person, new Query("SamplePersonId", _person.Identity, DatabaseOperator.Equal));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed query builder");

              qb = QueryBuilder.GetQueryBuilder(_person, new Query("SamplePersonId", 0, DatabaseOperator.GreaterThan));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed greater than query builder");

              qb = QueryBuilder.GetQueryBuilder(_person, new Query("SamplePersonId", _person.Identity, DatabaseOperator.GreaterThanOrEqual));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed greater than or equal query builder");

              qb = QueryBuilder.GetQueryBuilder(_person, new Query("SamplePersonId", Int32.MaxValue, DatabaseOperator.LessThan));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed less than query builder");

              qb = QueryBuilder.GetQueryBuilder(_person, new Query("SamplePersonId", _person.Identity, DatabaseOperator.LesserThanOrEqual));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed greater than query builder");

              qb = QueryBuilder.GetQueryBuilder(_person, new Query("SamplePersonId", 0, DatabaseOperator.NotEqualTo));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed not equal query builder");

              qb = QueryBuilder.GetQueryBuilder(_person, new Query("Lastname", _person.Lastname, DatabaseOperator.Equal));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed greater than query builder");

              qb = QueryBuilder.GetQueryBuilder(_person, new Query("Lastname", _person.Lastname.Substring(2), DatabaseStringOperator.Like));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed string query builder");

              var dt = new DateTime(2000, 10, 21);
              qb = QueryBuilder.GetQueryBuilder(_person, new Query("Date", dt, DatabaseOperator.GreaterThan));
              list = _person.LoadList(qb.GetQuery());
              Debug.Assert(list.Count > 0, "Failed datetime query builder");

              var pers = new SamplePerson
            {
              Lastname = "last",
              FkMother = 100,
              Boolean = false,
            };
              list = pers.LoadByClass();
              Debug.Assert(list.Count > 0, "Failed to load List by Class");

              Debug.Assert(_person.Delete(), "Failed to delete person");
        }
Exemplo n.º 3
0
        public void BasicSave()
        {
            _person = SamplePerson.GetSamplePerson();
              var id = _person.Save();
              Assert.AreNotEqual(id, 0);

              _person.Load();
              Assert.AreEqual(id, _person.Identity);
        }