public void TestCount() { bool result = DAO.CreateTable ().Result; Assert.AreEqual (true, result); TestEntity entity = new TestEntity (); entity.Id = 0; TestEntity entity1 = new TestEntity (); entity1.Id = 1; entity.TestString = "TEST"; bool result3 = DAO.SaveOrReplaceMultiple (new List<TestEntity> (){ entity, entity1 }).Result; Assert.AreEqual (true, result3); SelectQuery<TestEntity> query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Equal ("TestString", "TEST"); long count = DAO.Count (query).Result; Assert.AreEqual (1, count); }
public void TestCountAll() { bool result = DAO.CreateTable ().Result; Assert.AreEqual (true, result); TestEntity entity = new TestEntity (); entity.Id = 0; TestEntity entity1 = new TestEntity (); entity1.Id = 1; bool result3 = DAO.SaveOrReplaceMultiple (new List<TestEntity> (){ entity, entity1 }).Result; Assert.AreEqual (true, result3); long count = DAO.CountAll (true).Result; Assert.AreEqual (2, count); }
private void AssertTestEntity(TestEntity retreived) { Assert.AreEqual ("plz", retreived.TestString); Assert.AreEqual (false, retreived.TestBool); Assert.AreEqual (244, retreived.TestByte); Assert.AreEqual (-50, retreived.TestNegativeByte); Assert.AreEqual (500, retreived.TestDecimal); Assert.AreEqual (-500, retreived.TestNegativeDecimal); Assert.AreEqual (new List<string> (new[]{ "hello", "dolly", "the", "sheep" }), retreived.TestList); }
public void TestSelect() { //[SimpleDBDomain("TestDao")] bool result = DAO.CreateTable ().Result; Assert.AreEqual (true, result); TestEntity entity = new TestEntity (); entity.Id = 0; //[SimpleDBField("TestString")] entity.TestString = "plz"; //[SimpleDBField("TestBool")] entity.TestBool = false; //[SimpleDBField("TestByte",3)] entity.TestByte = 244; //[SimpleDBField("TestNegativeByte",3, 255)] entity.TestNegativeByte = -50; //[SimpleDBField("TestDecimal",5,1000)] entity.TestDecimal = 500; //[SimpleDBField("TestNegativeDecimal",5,1000)] entity.TestNegativeDecimal = -500; //[SimpleDBField("TestList")] entity.TestList = new List<string> (new[]{ "hello", "dolly", "the", "sheep" }); bool result2 = DAO.SaveOrReplace (entity).Result; Assert.AreEqual (true, result2); //Equal SelectQuery<TestEntity> query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Equal ("TestString", "plz"); List<TestEntity> list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); TestEntity retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Like ("TestString", "hello"); list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //Or query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Or ("TestString", "hello", "TestByte", "244"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Or ("TestString", "hello", "TestNegativeDecimal", "-500"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Or ("TestString", "hello", "TestByte", "243"); list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //NotEqual query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.NotEqual ("TestString", "hello"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.NotEqual ("TestString", "plz"); list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //GreatherThan query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.GreatherThan ("TestDecimal", "499"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.GreatherThan ("TestDecimal", "500"); list = DAO.Select (query).Result; list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //GreatherThanOrEqual query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.GreatherThanOrEqual ("TestDecimal", "500"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.GreatherThanOrEqual ("TestDecimal", "501"); list = DAO.Select (query).Result; list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //LessThan query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.LessThan ("TestDecimal", "501"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.LessThan ("Created", DateTime.Now.ToString ("o")); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.LessThan ("TestDecimal", "500"); list = DAO.Select (query).Result; list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //LessThanOrEqual query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.LessThanOrEqual ("TestDecimal", "500"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.LessThanOrEqual ("TestDecimal", "499"); list = DAO.Select (query).Result; list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //Like query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Like ("TestString", "pl"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Like ("TestString", "hello"); list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //NotLike query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.NotLike ("TestString", "hello"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.NotLike ("TestString", "plz"); list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); //Between query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Between ("TestDecimal", "499", "501"); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list [0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.Between ("TestDecimal", "450", "499"); list = DAO.Select (query).Result; list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); /* //In query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.In ("TestList", new string[] {"hello"}); list = DAO.Select (query).Result; Assert.AreEqual (1, list.Count); retreived = list[0]; AssertTestEntity (retreived); query = new SelectQuery<TestEntity> (); query.ConsistentRead = true; query.In ("TestList", new string[] {"mucho"}); list = DAO.Select (query).Result; list = DAO.Select (query).Result; Assert.AreEqual (0, list.Count); */ }
public void TestSaveOrReplaceMultiple() { bool result = DAO.CreateTable ().Result; Assert.AreEqual (true, result); TestEntity entity = new TestEntity (); entity.Id = 0; TestEntity entity1 = new TestEntity (); entity1.Id = 1; bool result3 = DAO.SaveOrReplaceMultiple (new List<TestEntity> (){ entity, entity1 }).Result; Assert.AreEqual (true, result3); //Wait for save to be propagated System.Threading.Thread.Sleep (3000); DomainMetadataRequest request = new DomainMetadataRequest ("TestDao"); DomainMetadataResponse response = Client.DomainMetadata (request).Result; Assert.AreEqual (HttpStatusCode.OK, response.HttpStatusCode); Assert.AreEqual ("2", response.DomainMetadataResult.ItemCount); }
public void TestSaveOrReplace() { //[SimpleDBDomain("TestDao")] bool result = DAO.CreateTable ().Result; Assert.AreEqual (true, result); TestEntity entity = new TestEntity (); entity.Id = 0; //[SimpleDBField("TestString")] entity.TestString = "TestString"; //[SimpleDBField("TestBool")] entity.TestBool = false; //[SimpleDBField("TestByte",3)] entity.TestByte = 244; //[SimpleDBField("TestNegativeByte",3, 255)] entity.TestNegativeByte = -50; //[SimpleDBField("TestDecimal",5,1000)] entity.TestDecimal = 500; //[SimpleDBField("TestNegativeDecimal",5,1000)] entity.TestNegativeDecimal = -500; //[SimpleDBField("TestList")] entity.TestList = new List<string> (new[]{ "hello", "dolly", "the", "sheep" }); bool result2 = DAO.SaveOrReplace (entity).Result; Assert.AreEqual (true, result2); GetAttributesRequest request = new GetAttributesRequest ("TestDao", "0", true); GetAttributesResponse response = Client.GetAttributes (request).Result; Assert.AreEqual (HttpStatusCode.OK, response.HttpStatusCode); Attribute TestString = Array.Find (response.GetAttributesResult, s => s.Name.Equals ("TestString")); Assert.IsNotNull (TestString); Assert.AreEqual ("TestString", TestString.Value); Attribute TestBool = Array.Find (response.GetAttributesResult, s => s.Name.Equals ("TestBool")); Assert.IsNotNull (TestBool); Assert.AreEqual ("False", TestBool.Value); Attribute TestByte = Array.Find (response.GetAttributesResult, s => s.Name.Equals ("TestByte")); Assert.IsNotNull (TestByte); Assert.AreEqual ("244", TestByte.Value); Attribute TestNegativeByte = Array.Find (response.GetAttributesResult, s => s.Name.Equals ("TestNegativeByte")); Assert.IsNotNull (TestNegativeByte); Assert.AreEqual ("205", TestNegativeByte.Value); Attribute TestDecimal = Array.Find (response.GetAttributesResult, s => s.Name.Equals ("TestDecimal")); Assert.IsNotNull (TestDecimal); Assert.AreEqual ("01500", TestDecimal.Value); Attribute TestNegativeDecimal = Array.Find (response.GetAttributesResult, s => s.Name.Equals ("TestNegativeDecimal")); Assert.IsNotNull (TestNegativeDecimal); Assert.AreEqual ("00500", TestNegativeDecimal.Value); Attribute TestList = Array.Find (response.GetAttributesResult, s => s.Name.Equals ("TestList")); Assert.IsNotNull (TestList); Assert.AreEqual ("[\"hello\",\"dolly\",\"the\",\"sheep\"]", TestList.Value); }
public void TestDelete() { bool result = DAO.CreateTable ().Result; Assert.AreEqual (true, result); TestEntity entity = new TestEntity (); entity.Id = 0; bool result2 = DAO.SaveOrReplace (entity).Result; Assert.AreEqual (true, result2); //Wait for save to be propagated System.Threading.Thread.Sleep (3000); DomainMetadataRequest request = new DomainMetadataRequest ("TestDao"); DomainMetadataResponse response = Client.DomainMetadata (request).Result; Assert.AreEqual (HttpStatusCode.OK, response.HttpStatusCode); Assert.AreEqual ("1", response.DomainMetadataResult.ItemCount); bool result3 = DAO.Delete (entity).Result; Assert.AreEqual (true, result3); //Wait for save to be propagated System.Threading.Thread.Sleep (3000); DomainMetadataRequest request2 = new DomainMetadataRequest ("TestDao"); DomainMetadataResponse response2 = Client.DomainMetadata (request2).Result; Assert.AreEqual (HttpStatusCode.OK, response2.HttpStatusCode); Assert.AreEqual ("0", response2.DomainMetadataResult.ItemCount); }