[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); }