public void ShouldGetLikes()
{
//arrange
var user = GenerateUser();
var userAnother = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
dataLayer.AddUser(userAnother);
var photo = GeneratePhoto(user.Id);
dataLayer.AddPhoto(photo);
dataLayer.AddLike(photo, user);
dataLayer.AddLike(photo, userAnother);
photo.UsersThatLike = dataLayer.GetLikes(photo);
var resAllLikes = true;
foreach (var usersLikes in photo.UsersThatLike)
{
if (usersLikes.Id != user.Id && usersLikes.Id != userAnother.Id)
{
resAllLikes = false;
}
}
//assert
Assert.AreEqual(resAllLikes, true);
}
public void ShouldGetSubscriptions()
{
//arrange
var user = GenerateUser();
var userSubscription = GenerateUser();
var userSubscription2 = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
dataLayer.AddUser(userSubscription);
dataLayer.AddUser(userSubscription2);
dataLayer.AddSubscription(user, userSubscription);
dataLayer.AddSubscription(user, userSubscription2);
user.Subscriptions = dataLayer.GetSubscription(user);
var trueSubscription = true;
foreach (var subscription in user.Subscriptions)
{
if (!dataLayer.HaveSubscription(user, subscription))
{
trueSubscription = false;
}
}
//assert
Assert.AreEqual(trueSubscription, true);
}
[TestMethod]//ok
public void DeleteFollowerTest()
{
//arrange
var user = new Users
{
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var follower = new Users
{
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
//act
user = dataLayer.AddUser(user);
follower = dataLayer.AddUser(follower);
dataLayer.AddSubscription(user.UserId, follower);
dataLayer.DeleteFollower(user, follower);
//asserts
Assert.AreEqual(dataLayer.IsFollower(user, follower), false);
}
public void ShouldGetSubscribers()
{
//arrange
var user = GenerateUser();
var userSubscriber = GenerateUser();
var userSubscriber2 = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
dataLayer.AddUser(userSubscriber);
dataLayer.AddUser(userSubscriber2);
dataLayer.AddSubscription(userSubscriber, user);
dataLayer.AddSubscription(userSubscriber2, user);
user.Subscribers = dataLayer.GetSubscribers(user);
var allSubscribers = true;
foreach (var subscriber in user.Subscribers)
{
if (subscriber.Id != userSubscriber.Id && subscriber.Id != userSubscriber2.Id)
{
allSubscribers = false;
}
}
//assert
Assert.AreEqual(allSubscribers, true);
}
public void ShouldDeleteHashtag()
{
//arrange
var user = GenerateUser();
var hashtag = Guid.NewGuid().ToString();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
var photo = GeneratePhoto(user.Id);
dataLayer.AddPhoto(photo);
var comment = GenerateComment(user.Id, photo.Id);
dataLayer.AddComment(comment);
comment = dataLayer.AddHashtag(comment, hashtag);
dataLayer.DeleteHashtag(comment, hashtag);
var haveHashtag = dataLayer.HaveHashtag(comment, hashtag);
//assert
Assert.AreEqual(haveHashtag, false);
}
public void ShouldGetAllCommentsOfPhoto()
{
//arrange
var user = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
var photo = GeneratePhoto(user.Id);
dataLayer.AddPhoto(photo);
var comment = GenerateComment(user.Id, photo.Id);
dataLayer.AddComment(comment);
var anotherComment = GenerateComment(user.Id, photo.Id);
dataLayer.AddComment(anotherComment);
photo.AllComments = dataLayer.GetAllComments(photo.Id);
foreach (var currentComment in photo.AllComments)
{
Assert.AreEqual(currentComment.PhotoId, photo.Id);
}
//assert
}
public void ShouldUpdateComment()
{
//arrange
var user = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
var photo = GeneratePhoto(user.Id);
dataLayer.AddPhoto(photo);
var comment = GenerateComment(user.Id, photo.Id);
dataLayer.AddComment(comment);
var commentUpdate = GenerateComment(user.Id, photo.Id);
dataLayer.UpdateComment(comment.Id, commentUpdate);
commentUpdate = dataLayer.GetComment(comment.Id);
var resComment = dataLayer.GetComment(comment.Id);
//assert
Assert.AreEqual(resComment.Id, commentUpdate.Id);
}
[TestMethod]//ok
public void DeletePostTest()
{
//firstly, add user to add him post
var user = new Users
{
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
user = dataLayer.AddUser(user);
//add post to user
var post = new Posts
{
UserId = user.UserId,
Date = DateTime.Now,
Photo = Guid.NewGuid().ToString().Substring(10)
};
post = dataLayer.AddPost(post);
var resultPost = dataLayer.GetPost(post.PostId);
dataLayer.DeletePost(post.PostId);
var delpost = dataLayer.GetPost(post.PostId);
Assert.AreNotEqual(delpost.PostId, resultPost.PostId);
}
[TestMethod]//ok
public void GetLikeTest()
{
//arrange
var user = new Users
{
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
user = dataLayer.AddUser(user);
//add post to user
var post = new Posts
{
UserId = user.UserId,
Date = DateTime.Now,
Photo = Guid.NewGuid().ToString().Substring(10)
};
post = dataLayer.AddPost(post);
var like = new Likes
{
PostId = post.PostId,
UserId = user.UserId
};
dataLayer.AddLike(like);
Assert.AreEqual(dataLayer.IsLiked(post.PostId, user.UserId), true);
}
[TestMethod]//ok
public void DeleteComTest()
{
//firstly, add user to add him post
var user = new Users
{
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
user = dataLayer.AddUser(user);
//add post to user
var post = new Posts
{
UserId = user.UserId,
Date = DateTime.Now,
Photo = Guid.NewGuid().ToString().Substring(10)
};
post = dataLayer.AddPost(post);
//add com to post
var com = new Comments()
{
Date = DateTime.Now,
FromId = user.UserId,
PostId = post.PostId,
Text = Guid.NewGuid().ToString().Substring(10)
};
dataLayer.AddCommentToPost(post.PostId, com);
dataLayer.DeleteComment(com.ComId);
Assert.AreEqual(dataLayer.IsComment(com.ComId), false);
}
[TestMethod]//ok
public void UpdateUserTest()
{
//arrange
var user = new Users
{
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var newuser = new Users
{
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
//act
user = dataLayer.AddUser(user);
dataLayer.UpdateUser(user.UserId, newuser);
//asserts
var resultUser = dataLayer.GetUser(user.UserId);
Assert.AreEqual(user.UserId, resultUser.UserId);
}
[TestMethod]//ok
public void GetPostTest()
{
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
var user = new Users
{
UserId = Guid.NewGuid(),
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
var post = new Posts
{
UserId = user.UserId,
Date = DateTime.Now,
Photo = Guid.NewGuid().ToString().Substring(10)
};
//act
user = dataLayer.AddUser(user);
post = dataLayer.AddPost(post);
//asserts
var resultPost = dataLayer.GetPost(post.PostId);
Assert.AreEqual(post.Photo, resultPost.Photo);
}
public void ShouldGetSubscription()
{
//arrange
var user = GenerateUser();
var userSubscription = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
dataLayer.AddUser(userSubscription);
dataLayer.AddSubscription(user, userSubscription);
var haveSubscription = dataLayer.HaveSubscription(user, userSubscription);
//assert
Assert.AreEqual(haveSubscription, true);
}
public void ShouldAddSubscription()
{
//arrange
var user = GenerateUser();
var userSubscriber = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
dataLayer.AddUser(userSubscriber);
dataLayer.AddSubscription(user, userSubscriber);
bool areFriends = dataLayer.HaveSubscription(user, userSubscriber);
//assert
Assert.AreEqual(areFriends, true);
}
public void ShouldAddUser()
{
//arrange
var user = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
var resUser = dataLayer.GetUser(user.Id);
//assert
Assert.AreEqual(resUser.Id, user.Id);
}
public void ShouldAddUser()
{
//arrange
var user = new User
{
Name = Guid.NewGuid().ToString().Substring(10)
};
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
//act
user = dataLayer.AddUser(user);
//asserts
var resultUser = dataLayer.GetUser(user.Id);
Assert.AreEqual(user.Name, resultUser.Name);
}
[TestMethod]//ok
public void GetUserTest()
{
var user = new Users
{
UserId = Guid.NewGuid(),
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
user = dataLayer.AddUser(user);
//asserts
var resultUser = dataLayer.GetUser(user.UserId);
Assert.AreEqual(user.Nickname, resultUser.Nickname);
}
public void ShouldGetPhoto()
{
//arrange
var user = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
var photo = GeneratePhoto(user.Id);
dataLayer.AddPhoto(photo);
var resPhoto = dataLayer.GetPhoto(photo.Id);
//assert
Assert.AreEqual(photo.Id, resPhoto.Id);
}
public void ShouldGetSession()
{
//arrange
var user = GenerateUser();
var session = GenerateSession(user.Id);
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
session.UserId = user.Id;
session = dataLayer.AddSession(session);
var resSession = dataLayer.GetSession(session.Id);
//assert
Assert.AreEqual(resSession.Id, session.Id);
}
[TestMethod]//ok
public void DeleteUserTest()
{
//arrange
var user = new Users
{
//UserId = Guid.NewGuid(),
Nickname = Guid.NewGuid().ToString().Substring(10),
Username = Guid.NewGuid().ToString().Substring(10),
Info = Guid.NewGuid().ToString().Substring(10)
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
user = dataLayer.AddUser(user);
dataLayer.DeleteUser(user.UserId);
var resultUser = dataLayer.GetUser(user.UserId);
//asserts
Assert.AreNotEqual(user.UserId, resultUser.UserId);
}
public void ShouldAddLike()
{
//arrange
var user = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
var photo = GeneratePhoto(user.Id);
dataLayer.AddPhoto(photo);
dataLayer.AddLike(photo, user);
var haveLike = dataLayer.HaveLike(photo, user);
//assert
Assert.AreEqual(haveLike, true);
}
public void ShouldAddGetDeleteUser()
{
//arrange
var user = new User
{
UserName = "******" /*Guid.NewGuid().ToString()*/
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(_connectionString);
var addUser = dataLayer.AddUser(user);
var dataLayer1 = new DataLayer.Sql.DataLayer(_connectionString);
var getUser = dataLayer1.GetUser(addUser.UserId);
var dataLayer2 = new DataLayer.Sql.DataLayer(_connectionString);
var isDeleted = dataLayer2.DeleteUser(getUser.UserId);
//asserts
Assert.AreEqual(addUser.UserId, getUser.UserId);
Assert.AreEqual(addUser.UserName, getUser.UserName);
Assert.IsNotNull(isDeleted);
}
public void ShouldAddComment()
{
//arrange
var user = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
dataLayer.AddUser(user);
var photo = GeneratePhoto(user.Id);
dataLayer.AddPhoto(photo);
var comment = GenerateComment(user.Id, Guid.NewGuid());
dataLayer.AddComment(comment);
var resultComment = dataLayer.GetComment(comment.Id);
//assert
Assert.AreNotEqual(resultComment.Id, Guid.Empty);
}
