public void ConfirmAccountReturnsFalseIfNoConfirmationTokenFromMultipleListMatchesInCase()
{
// Arrange
var database = new Mock <MockDatabase>(MockBehavior.Strict);
DynamicRecord recordA = GetRecord(98, "Foo");
DynamicRecord recordB = GetRecord(99, "fOo");
database.As <IDisposable>().Setup(d => d.Dispose());
database
.Setup(
d =>
d.Query(
"SELECT [UserId], [ConfirmationToken] FROM webpages_Membership WHERE [ConfirmationToken] = @0",
"foo"
)
)
.Returns(new[] { recordA, recordB });
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object);
// Act
bool result = simpleMembershipProvider.ConfirmAccount("foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountWithUserNameReturnsFalseIfConfirmationTokenDoesNotMatchInCase()
{
// Arrange
var database = new Mock <MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(98, "Foo");
database.As <IDisposable>().Setup(d => d.Dispose());
database
.Setup(
d =>
d.QuerySingle(
"SELECT m.[UserId], m.[ConfirmationToken] FROM webpages_Membership m JOIN [Users_bkp2_1] u ON m.[UserId] = u.[wishlist_site_real_user_id] WHERE m.[ConfirmationToken] = @0 AND u.[wishlist_site_real_user_name] = @1",
"foo",
"user13"
)
)
.Returns(record);
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object)
{
UserIdColumn = "wishlist_site_real_user_id",
UserNameColumn = "wishlist_site_real_user_name",
UserTableName = "Users_bkp2_1"
};
// Act
bool result = simpleMembershipProvider.ConfirmAccount("user13", "foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountWithUserNameReturnsFalseIfNoRecordExistsForToken()
{
// Arrange
var database = new Mock <MockDatabase>(MockBehavior.Strict);
database.As <IDisposable>().Setup(d => d.Dispose());
database
.Setup(
d =>
d.QuerySingle(
"SELECT m.[UserId], m.[ConfirmationToken] FROM webpages_Membership m JOIN [Users] u ON m.[UserId] = u.[UserId] WHERE m.[ConfirmationToken] = @0 AND u.[UserName] = @1",
"foo",
"user12"
)
)
.Returns(null);
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object)
{
UserIdColumn = "UserId",
UserNameColumn = "UserName",
UserTableName = "Users"
};
// Act
bool result = simpleMembershipProvider.ConfirmAccount("user12", "foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountReturnsFalseIfNoRecordExistsForToken()
{
// Arrange
var database = new Mock<MockDatabase>(MockBehavior.Strict);
database.Setup(d => d.Query("SELECT [UserId], [ConfirmationToken] FROM webpages_Membership WHERE [ConfirmationToken] = @0", "foo"))
.Returns(Enumerable.Empty<DynamicRecord>());
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object);
// Act
bool result = simpleMembershipProvider.ConfirmAccount("foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountReturnsFalseIfConfirmationTokenDoesNotMatchInCase()
{
// Arrange
var database = new Mock<MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(98, "Foo");
database.Setup(d => d.Query("SELECT [UserId], [ConfirmationToken] FROM webpages_Membership WHERE [ConfirmationToken] = @0", "foo"))
.Returns(new[] { record });
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object);
// Act
bool result = simpleMembershipProvider.ConfirmAccount("foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountReturnsFalseIfNoRecordExistsForToken()
{
// Arrange
var database = new Mock <MockDatabase>(MockBehavior.Strict);
database.Setup(d => d.Query("SELECT [UserId], [ConfirmationToken] FROM webpages_Membership WHERE [ConfirmationToken] = @0", "foo"))
.Returns(Enumerable.Empty <DynamicRecord>());
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object);
// Act
bool result = simpleMembershipProvider.ConfirmAccount("foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountReturnsFalseIfConfirmationTokenDoesNotMatchInCase()
{
// Arrange
var database = new Mock <MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(98, "Foo");
database.Setup(d => d.Query("SELECT [UserId], [ConfirmationToken] FROM webpages_Membership WHERE [ConfirmationToken] = @0", "foo"))
.Returns(new[] { record });
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object);
// Act
bool result = simpleMembershipProvider.ConfirmAccount("foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountUpdatesIsConfirmedFieldIfConfirmationTokenMatches()
{
// Arrange
var database = new Mock<MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(100, "foo");
database.Setup(d => d.Query("SELECT [UserId], [ConfirmationToken] FROM webpages_Membership WHERE [ConfirmationToken] = @0", "foo"))
.Returns(new[] { record }).Verifiable();
database.Setup(d => d.Execute("UPDATE webpages_Membership SET [IsConfirmed] = 1 WHERE [UserId] = @0", 100)).Returns(1).Verifiable();
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object);
// Act
bool result = simpleMembershipProvider.ConfirmAccount("foo");
// Assert
Assert.True(result);
database.Verify();
}
public void ConfirmAccountUpdatesIsConfirmedFieldIfConfirmationTokenMatches()
{
// Arrange
var database = new Mock <MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(100, "foo");
database.Setup(d => d.Query("SELECT [UserId], [ConfirmationToken] FROM webpages_Membership WHERE [ConfirmationToken] = @0", "foo"))
.Returns(new[] { record }).Verifiable();
database.Setup(d => d.Execute("UPDATE webpages_Membership SET [IsConfirmed] = 1 WHERE [UserId] = @0", 100)).Returns(1).Verifiable();
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object);
// Act
bool result = simpleMembershipProvider.ConfirmAccount("foo");
// Assert
Assert.True(result);
database.Verify();
}
public void ConfirmAccountWithUserNameUpdatesIsConfirmedFieldIfConfirmationTokenMatches()
{
// Arrange
var database = new Mock <MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(100, "foo");
database.As <IDisposable>().Setup(d => d.Dispose());
database
.Setup(
d =>
d.QuerySingle(
"SELECT m.[UserId], m.[ConfirmationToken] FROM webpages_Membership m JOIN [Users] u ON m.[UserId] = u.[Id] WHERE m.[ConfirmationToken] = @0 AND u.[UserName] = @1",
"foo",
"user14"
)
)
.Returns(record)
.Verifiable();
database
.Setup(
d =>
d.Execute(
"UPDATE webpages_Membership SET [IsConfirmed] = 1 WHERE [UserId] = @0",
100
)
)
.Returns(1)
.Verifiable();
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object)
{
UserTableName = "Users",
UserIdColumn = "Id",
UserNameColumn = "UserName"
};
// Act
bool result = simpleMembershipProvider.ConfirmAccount("user14", "foo");
// Assert
Assert.True(result);
database.Verify();
}
public void ConfirmAccountWithUserNameUpdatesIsConfirmedFieldIfConfirmationTokenMatches()
{
// Arrange
var database = new Mock<MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(100, "foo");
database.Setup(d => d.QuerySingle("SELECT m.[UserId], m.[ConfirmationToken] FROM webpages_Membership m JOIN [Users] u ON m.[UserId] = u.[Id] WHERE m.[ConfirmationToken] = @0 AND u.[UserName] = @1", "foo", "user14"))
.Returns(record).Verifiable();
database.Setup(d => d.Execute("UPDATE webpages_Membership SET [IsConfirmed] = 1 WHERE [UserId] = @0", 100)).Returns(1).Verifiable();
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object) { UserTableName = "Users", UserIdColumn = "Id", UserNameColumn = "UserName" };
// Act
bool result = simpleMembershipProvider.ConfirmAccount("user14", "foo");
// Assert
Assert.True(result);
database.Verify();
}
public void ConfirmAccountWithUserNameReturnsFalseIfConfirmationTokenDoesNotMatchInCase()
{
// Arrange
var database = new Mock<MockDatabase>(MockBehavior.Strict);
DynamicRecord record = GetRecord(98, "Foo");
database.Setup(d => d.QuerySingle("SELECT m.[UserId], m.[ConfirmationToken] FROM webpages_Membership m JOIN [Users_bkp2_1] u ON m.[UserId] = u.[wishlist_site_real_user_id] WHERE m.[ConfirmationToken] = @0 AND u.[wishlist_site_real_user_name] = @1", "foo", "user13")).Returns(record);
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object) { UserIdColumn = "wishlist_site_real_user_id", UserNameColumn = "wishlist_site_real_user_name", UserTableName = "Users_bkp2_1" };
// Act
bool result = simpleMembershipProvider.ConfirmAccount("user13", "foo");
// Assert
Assert.False(result);
}
public void ConfirmAccountWithUserNameReturnsFalseIfNoRecordExistsForToken()
{
// Arrange
var database = new Mock<MockDatabase>(MockBehavior.Strict);
database.Setup(d => d.QuerySingle("SELECT m.[UserId], m.[ConfirmationToken] FROM webpages_Membership m JOIN [Users] u ON m.[UserId] = u.[UserId] WHERE m.[ConfirmationToken] = @0 AND u.[UserName] = @1", "foo", "user12")).Returns(null);
var simpleMembershipProvider = new TestSimpleMembershipProvider(database.Object) { UserIdColumn = "UserId", UserNameColumn = "UserName", UserTableName = "Users" };
// Act
bool result = simpleMembershipProvider.ConfirmAccount("user12", "foo");
// Assert
Assert.False(result);
}
