Add failing UpsertBy tests

JamesKyburz · JamesKyburz · commit 5a61b7063ceb · 2012-10-15T20:23:19.000+02:00
diff --git a/Simple.Data.SqlTest/UpsertTests.cs b/Simple.Data.SqlTest/UpsertTests.cs
@@ -414,5 +414,49 @@ public void TestUpsertWithSingleArgumentAndExistingObject()
             Assert.AreEqual(1, actual.Id);
             Assert.IsNotNull(actual.Name);
         }
+
+        [Test]
+        public void TestUpsertUserBySecondaryField()
+        {
+          var db = DatabaseHelper.Open();
+
+          var id = db.Users.UpsertByName(new User() { Age = 20, Name = "Black sheep", Password = "Bah" }).Id;
+          User actual = db.Users.FindById(id);
+
+          Assert.AreEqual(id, actual.Id);
+          Assert.AreEqual("Black sheep", actual.Name);
+          Assert.AreEqual("Bah", actual.Password);
+          Assert.AreEqual(20, actual.Age);
+        }
+
+        [Test]
+        public void TestUpsertUserByTwoSecondaryFields()
+        {
+          var db = DatabaseHelper.Open();
+
+          var id = db.Users.UpsertByNameAndPassword(new User() { Age = 20, Name = "Black sheep", Password = "Bah" }).Id;
+          User actual = db.Users.FindById(id);
+
+          Assert.AreEqual(id, actual.Id);
+          Assert.AreEqual("Black sheep", actual.Name);
+          Assert.AreEqual("Bah", actual.Password);
+          Assert.AreEqual(20, actual.Age);
+        }
+
+        [Test]
+        public void TestUpsertExisting()
+        {
+          var db = DatabaseHelper.Open();
+
+          var id = db.Users.UpsertByNameAndPassword(new User() { Age = 20, Name = "Black sheep", Password = "Bah" }).Id;
+          db.Users.UpsertById(new User() { Id = id, Age = 12, Name = "Dog", Password = "Bark" });
+
+          User actual = db.Users.FindById(id);
+
+          Assert.AreEqual(id, actual.Id);
+          Assert.AreEqual("Dog", actual.Name);
+          Assert.AreEqual("Bark", actual.Password);
+          Assert.AreEqual(12, actual.Age);
+        }
     }
 }
