Changeset 3974

Timestamp:

06/28/10 21:09:36 (14 years ago)

Author:

bfarka

Message:

added unit tests to check if the unique constraints on rolename username email are working (1046)

Location:

branches/HeuristicLab.Services.Authentication Prototype/UnitTests

Files:

• HeuristicLabMembershipProviderTest.cs (modified) (3 diffs)
• HeuristicLabRoleProviderTest.cs (modified) (2 diffs)

branches/HeuristicLab.Services.Authentication Prototype/UnitTests/HeuristicLabMembershipProviderTest.cs

@@ -7 +7 @@
 using System.Linq;
 using System.Collections.Generic;
+using System.Data.SqlClient;
 
 namespace UnitTests {
@@ -216 +217 @@
     public void ValidateUserTestHashed() {
       HeuristicLabMembershipProvider target = new HeuristicLabMembershipProvider();
-      NameValueCollection  config = new NameValueCollection();
+      NameValueCollection config = new NameValueCollection();
       config.Add("passwordFormat", "Hashed");
-      target.Initialize("",config);
+      target.Initialize("", config);
       MembershipCreateStatus status;
       target.CreateUser("testname", "newPassword", "testemail", "testquestion", "testanswer", true, null, out status);
@@ -490 +491 @@
       Assert.Inconclusive("TODO: Implement code to verify target");
     }
+
+    [TestMethod()]
+    public void NoDuplicateUserNameTest() {
+      try {
+        Persistence.HeuristicLabUser user = new Persistence.HeuristicLabUser("duplicateName", "mail", "myQuestion", "myComment");
+        db.HeuristicLabUsers.InsertOnSubmit(user);
+        Persistence.HeuristicLabUser user2 = new Persistence.HeuristicLabUser("duplicateName", "mail2", "myQuestion2", "myComment2");
+        db.HeuristicLabUsers.InsertOnSubmit(user2);
+        db.SubmitChanges();
+        Assert.Fail();
+      }
+      catch (SqlException) {
+        //swallowing Exception because it is expected that a SQL Exception is thrown        
+      }
+    }
+    [TestMethod()]
+    public void NoDuplicateEmailTest() {
+      try {
+        Persistence.HeuristicLabUser user = new Persistence.HeuristicLabUser("duplicateName", "mail", "myQuestion", "myComment");
+        db.HeuristicLabUsers.InsertOnSubmit(user);
+        Persistence.HeuristicLabUser user2 = new Persistence.HeuristicLabUser("duplicateName2", "mail", "myQuestion2", "myComment2");
+        db.HeuristicLabUsers.InsertOnSubmit(user2);
+        db.SubmitChanges();
+        Assert.Fail();
+      }
+      catch (SqlException) {
+        //swallowing Exception because it is expected that a SQL Exception is thrown        
+      }
+    }
   }
 }

branches/HeuristicLab.Services.Authentication Prototype/UnitTests/HeuristicLabRoleProviderTest.cs

@@ -3 +3 @@
 using System.Linq;
 using System.Collections.Generic;
+using System.Data.SqlClient;
 namespace UnitTests {
   /// <summary>
@@ -325 +326 @@
       Assert.IsNotNull(target);
     }
+    [TestMethod()]
+    public void NoDuplicateRoleTest() {
+      try {
+        Persistence.HeuristicLabRole role = new Persistence.HeuristicLabRole();
+        role.RoleName ="role1";
+        Persistence.HeuristicLabRole role1 = new Persistence.HeuristicLabRole();
+        role1.RoleName ="role1";
+        db.HeuristicLabRole.InsertOnSubmit(role);
+        db.HeuristicLabRole.InsertOnSubmit(role1);
+        db.SubmitChanges();
+        Assert.Fail();
+      }
+      catch (SqlException) {
+        //swallowing Exception because it is expected that a SQL Exception is thrown        
+      }
+    }
   }
 
+ 
+