[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 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 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
}
[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);
}
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);
}
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);
}
[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 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 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);
}
[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 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);
}
public void ShouldAddGetDeleteComment()
{
//arrange
var comment = new Comment
{
UserId = Guid.Parse("3c8fddae-8ebc-4cd4-9eb2-30ce678d6c23") /*Guid.NewGuid()*/,
PostId = Guid.Parse("82243a65-d1e6-440c-a906-5dffb9cd653c") /*Guid.NewGuid()*/,
Date = DateTime.Now,
CommentText = "This is my comment"/*Guid.NewGuid().ToString()*/
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(_connectionString);
var addComment = dataLayer.AddComment(comment);
var dataLayer1 = new DataLayer.Sql.DataLayer(_connectionString);
var getComment = dataLayer1.GetComment(addComment.CommentId);
var dataLayer2 = new DataLayer.Sql.DataLayer(_connectionString);
int isDeleted = dataLayer2.DeleteComment(getComment.CommentId);
//asserts
Assert.AreEqual(addComment.CommentId, getComment.CommentId);
Assert.AreEqual(addComment.UserId, getComment.UserId);
Assert.AreEqual(addComment.PostId, getComment.PostId);
//Assert.AreEqual(addComment.Date, getComment.Date);
Assert.AreEqual(addComment.CommentText, getComment.CommentText);
Assert.IsNotNull(isDeleted);
}
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);
}
public void ShouldNotGetUser()
{
//arrange
var user = GenerateUser();
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);
user = dataLayer.GetUser(user.Id);
//assert
Assert.AreEqual(user.Id, Guid.Empty);
}
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 ShouldAddPost()
{
//arrange
var post = new Post
{
UserId = Guid.NewGuid(),
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(ConnectionString);
post = dataLayer.AddPost(post);
//asserts
var resultPost = dataLayer.GetPost(post.Id);
Assert.AreEqual(post.UserId, resultPost.UserId);
}
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);
}
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 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);
}
[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 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 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 ShouldAddGetDeleteLike()
{
//arrange
var like = new Like
{
UserId = Guid.Parse("3c8fddae-8ebc-4cd4-9eb2-30ce678d6c23") /*Guid.NewGuid()*/,
PostId = Guid.Parse("82243a65-d1e6-440c-a906-5dffb9cd653c") /*Guid.NewGuid()*/,
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(_connectionString);
var addLike = dataLayer.AddLike(like);
var dataLayer1 = new DataLayer.Sql.DataLayer(_connectionString);
var getLike = dataLayer1.GetLike(addLike.LikeId);
var dataLayer2 = new DataLayer.Sql.DataLayer(_connectionString);
int isDeleted = dataLayer2.DeleteLike(getLike.LikeId);
//asserts
Assert.AreEqual(addLike.LikeId, getLike.LikeId);
Assert.AreEqual(addLike.UserId, getLike.UserId);
Assert.AreEqual(addLike.PostId, getLike.PostId);
Assert.IsNotNull(isDeleted);
}
public void ShouldAddGetDeleteReference()
{
//arrange
var reference = new Reference
{
CommentId = Guid.Parse("6a4121a7-2b12-41e6-a408-8b13ef7d0b53") /*Guid.NewGuid()*/,
UserId = Guid.Parse("3c8fddae-8ebc-4cd4-9eb2-30ce678d6c23")/*Guid.NewGuid()*/
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(_connectionString);
var addReference = dataLayer.AddReference(reference);
var dataLayer1 = new DataLayer.Sql.DataLayer(_connectionString);
var getReference = dataLayer1.GetReference(addReference.ReferenceId);
var dataLayer2 = new DataLayer.Sql.DataLayer(_connectionString);
int isDeleted = dataLayer2.DeleteReference(getReference.ReferenceId);
//asserts
Assert.AreEqual(addReference.ReferenceId, getReference.ReferenceId);
Assert.AreEqual(addReference.CommentId, getReference.CommentId);
Assert.AreEqual(addReference.UserId, getReference.UserId);
Assert.IsNotNull(isDeleted);
}
public void ShouldAddGetDeleteHashtag()
{
//arrange
var hashtag = new Hashtag
{
PostId = Guid.Parse("82243a65-d1e6-440c-a906-5dffb9cd653c") /*Guid.NewGuid()*/,
HashtagText = "#hashtag"/*Guid.NewGuid().ToString()*/
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(_connectionString);
var addHashtag = dataLayer.AddHashtag(hashtag);
var dataLayer1 = new DataLayer.Sql.DataLayer(_connectionString);
var getHashtag = dataLayer1.GetHashtag(addHashtag.HashtagId);
var dataLayer2 = new DataLayer.Sql.DataLayer(_connectionString);
int isDeleted = dataLayer2.DeleteHashtag(getHashtag.HashtagId);
//asserts
Assert.AreEqual(addHashtag.HashtagId, getHashtag.HashtagId);
Assert.AreEqual(addHashtag.PostId, getHashtag.PostId);
Assert.AreEqual(addHashtag.HashtagText, getHashtag.HashtagText);
Assert.IsNotNull(isDeleted);
}
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);
}
public void ShouldAddGetDeletePost()
{
//arrange
var post = new Post
{
UserId = Guid.Parse("3c8fddae-8ebc-4cd4-9eb2-30ce678d6c23") /*Guid.NewGuid()*/,
Picture = Guid.NewGuid().ToByteArray(),
Date = DateTime.Now
};
//act
var dataLayer = new DataLayer.Sql.DataLayer(_connectionString);
var addPost = dataLayer.AddPost(post);
var dataLayer1 = new DataLayer.Sql.DataLayer(_connectionString);
var getPost = dataLayer1.GetPost(addPost.PostId);
var dataLayer2 = new DataLayer.Sql.DataLayer(_connectionString);
var isDeleted = dataLayer2.DeletePost(getPost.PostId);
//asserts
Assert.AreEqual(addPost.PostId, getPost.PostId);
Assert.AreEqual(addPost.UserId, getPost.UserId);
//Assert.AreEqual(addPost.Picture, getPost.Picture);
//Assert.AreEqual(addPost.Date, getPost.Date);
Assert.IsNotNull(isDeleted);
}
