Exemplo n.º 1
0
        public void CanListEntitiesByPage()
        {
            // Arrange
            var conn    = GetConnectionString();
            var repo    = new SqlitePostRepository(conn);
            var entity1 = new Post(0, 1, "Title1", "Description1", 1, "Snippet1", DateTime.Now.AddDays(1), true);
            var entity2 = new Post(0, 2, "Title2", "Description2", 2, "SnippeTKey", DateTime.Now.AddDays(2), false);
            var entity3 = new Post(0, 1, "Title3", "Description3", 1, "Snippet3", DateTime.Now.AddDays(3), true);
            var entity4 = new Post(0, 2, "Title4", "Description4", 2, "Snippet4", DateTime.Now.AddDays(4), false);
            var entity5 = new Post(0, 2, "Title5", "Description5", 2, "Snippet5", DateTime.Now.AddDays(5), false);

            repo.AddOrUpdate(entity1);
            var savedEntity1 = repo.AddOrUpdate(entity2);
            var savedEntity2 = repo.AddOrUpdate(entity3);

            repo.AddOrUpdate(entity4);
            repo.AddOrUpdate(entity5);

            // Act
            var listEntities = repo.ListEntities(take: 2, skip: 1)
            ;

            // Assert
            Assert.IsTrue(listEntities.IsValid);
            Assert.IsTrue(listEntities.Value.Count == 2);
            Assert.IsTrue(savedEntity1.Value.Equals(listEntities.Value[0]));
            Assert.IsTrue(savedEntity2.Value.Equals(listEntities.Value[1]));
        }
Exemplo n.º 2
0
        public void CanUpdateEntity()
        {
            // Arrange
            var conn   = GetConnectionString();
            var repo   = new SqlitePostRepository(conn);
            var entity = new Post(0, 1, "Title", "Description", 1, "Snippet1", DateTime.Now, true);

            ;
            var savedEntity = repo.AddOrUpdate(entity);

            // Act
            var updatedEntity = new Post(savedEntity.Value,
                                         author: 2,
                                         title: "newTitle",
                                         description: "newDesciprtion",
                                         language: 2,
                                         snippet: "newSnippet",
                                         published: DateTime.Now.AddDays(1),
                                         isActive: false);

            var newUpdatedEntity = repo.AddOrUpdate(updatedEntity);

            // Assert
            Assert.IsTrue(newUpdatedEntity.IsValid);
            Assert.IsTrue(newUpdatedEntity.Value.Equals(updatedEntity));
            Assert.IsTrue((newUpdatedEntity.Value as Entity <uint>).Equals(savedEntity.Value));
        }
Exemplo n.º 3
0
        public void CanListEntitiesBetweenDates()
        {
            // Arrange
            var conn    = GetConnectionString();
            var repo    = new SqlitePostRepository(conn);
            var date2   = DateTime.Now.AddDays(2);
            var date4   = DateTime.Now.AddDays(4);
            var entity1 = new Post(0, 1, "Title1", "Description1", 1, "Snippet1", DateTime.Now.AddDays(1), true);
            var entity2 = new Post(0, 2, "Title2", "Description2", 2, "SnippeTKey", date2, false);
            var entity3 = new Post(0, 1, "Title3", "Description3", 1, "Snippet3", DateTime.Now.AddDays(3), true);
            var entity4 = new Post(0, 2, "Title4", "Description4", 2, "Snippet4", date4, false);
            var entity5 = new Post(0, 2, "Title5", "Description5", 2, "Snippet5", DateTime.Now.AddDays(5), false);

            repo.AddOrUpdate(entity1);
            var savedEntity1 = repo.AddOrUpdate(entity2);
            var savedEntity2 = repo.AddOrUpdate(entity3);
            var savedEntity3 = repo.AddOrUpdate(entity4);

            repo.AddOrUpdate(entity5);
            var filters = ImmutableList.Create(new Filter <Post>("BetweenPublished", (date2, date4)));

            // Act
            var listEntities = repo.ListEntities(filters, 50)
            ;

            // Assert
            Assert.IsTrue(listEntities.IsValid);
            Assert.IsTrue(listEntities.Value.Count == 3);
            Assert.IsTrue(savedEntity1.Value.Equals(listEntities.Value[0]));
            Assert.IsTrue(savedEntity2.Value.Equals(listEntities.Value[1]));
            Assert.IsTrue(savedEntity3.Value.Equals(listEntities.Value[2]));
        }
        public static void ListPostInThread(SqlitePostRepository repository, int threadId)
        {
            var thread = repository.GetThreadWithId(threadId);
            var posts  = repository.GetPostsFromThread(thread);

            Console.WriteLine($"Topic: {thread.Topic}\nText: {thread.Text}\n");
            foreach (var post in posts)
            {
                Console.WriteLine($"PostId: {post.PostId} {post.User.FirstName} (UserId: {post.UserId}): {post.Text}");
            }
            Console.WriteLine();
        }
Exemplo n.º 5
0
        public void ListEntitiesIsSafe()
        {
            // Arrange
            var conn = GetConnectionString();
            var repo = new SqlitePostRepository(conn);

            // Act
            _conn.Dispose();
            var listEntities = repo.ListEntities();

            // Assert
            Assert.IsFalse(listEntities.IsValid);
        }
Exemplo n.º 6
0
        public void AddOrUpdateEntityIsRequired()
        {
            // Arrange
            var conn = GetConnectionString();
            var repo = new SqlitePostRepository(conn);

            // Act
            var result = repo.AddOrUpdate(null);

            // Assert
            Assert.IsFalse(result.IsValid);
            Assert.IsTrue(result.Exception is ArgumentNullException);
        }
Exemplo n.º 7
0
        public void CanCreateEntity()
        {
            // Arrange
            var conn   = GetConnectionString();
            var repo   = new SqlitePostRepository(conn);
            var entity = new Post(0, 0, "Title", "Description", 0, "Snippet");

            // Act
            var newEntity = repo.AddOrUpdate(entity);

            // Assert
            Assert.IsTrue(newEntity.IsValid);
            Assert.IsTrue(newEntity.Value.Id == 1);
        }
Exemplo n.º 8
0
        public void AddOrUpdateIsSafe()
        {
            // Arrange
            var conn   = GetConnectionString();
            var entity = new Post(0, 0, "Title", "Description", 0, "Snippet");
            var repo   = new SqlitePostRepository(conn);

            // Act
            _conn.Dispose();
            var newEntity = repo.AddOrUpdate(entity);

            // Assert
            Assert.IsFalse(newEntity.IsValid);
        }
Exemplo n.º 9
0
        public void CanGetEntityById()
        {
            // Arrange
            var conn        = GetConnectionString();
            var repo        = new SqlitePostRepository(conn);
            var entity      = new Post(0, 0, "Title", "Description", 0, "Snippet");
            var savedEntity = repo.AddOrUpdate(entity);

            // Act
            var result = repo.GetById(savedEntity.Value.Id);

            // Assert
            Assert.IsTrue(result.IsValid);
            Assert.IsTrue(result.Value.Equals(savedEntity.Value));
        }
Exemplo n.º 10
0
        public void CanListEntities()
        {
            // Arrange
            var conn = GetConnectionString();

            var repo        = new SqlitePostRepository(conn);
            var entity      = new Post(0, 0, "Title", "Description", 0, "Snippet");
            var savedEntity = repo.AddOrUpdate(entity);

            // Act
            var listEntities = repo.ListEntities();

            // Assert
            Assert.IsTrue(listEntities.IsValid);
            Assert.IsTrue(listEntities.Value.Any());
            Assert.IsTrue(savedEntity.Value.Equals(listEntities.Value.First()));
        }
Exemplo n.º 11
0
        public void CanListEntitiesByIdAndTitleNotFound()
        {
            // Arrange
            var conn    = GetConnectionString();
            var repo    = new SqlitePostRepository(conn);
            var entity1 = new Post(0, 1, "Title1", "Description1", 1, "Snippet1", DateTime.Now.AddDays(1), true);
            var entity2 = new Post(0, 2, "Title2", "Description2", 2, "SnippeTKey", DateTime.Now.AddDays(2), false);

            repo.AddOrUpdate(entity1);
            repo.AddOrUpdate(entity2);
            var filters = ImmutableList.Create(new[] { new Filter <Post>("Id", (uint)1), new Filter <Post>("Title", "Title2") });

            // Act
            var listEntities = repo.ListEntities(filters);

            // Assert
            Assert.IsTrue(listEntities.IsValid);
            Assert.IsFalse(listEntities.Value.Any());
        }
Exemplo n.º 12
0
        public void CanListEntitiesInactive()
        {
            // Arrange
            var conn = GetConnectionString();

            var repo    = new SqlitePostRepository(conn);
            var entity1 = new Post(0, 0, "Title1", "Description1", 0, "Snippet1", isActive: true);

            _ = repo.AddOrUpdate(entity1);
            var entity2      = new Post(0, 0, "Title2", "Description2", 0, "SnippeTKey", isActive: false);
            var savedEntity2 = repo.AddOrUpdate(entity2);

            // Act
            var listEntities = repo.ListEntities(status: Status.Inactive);

            // Assert
            Assert.IsTrue(listEntities.IsValid);
            Assert.IsTrue(listEntities.Value.Count == 1);
            Assert.IsTrue(savedEntity2.Value.Equals(listEntities.Value.First()));
        }
Exemplo n.º 13
0
        public void CanListEntitiesDesc()
        {
            // Arrange
            var conn = GetConnectionString();

            var repo    = new SqlitePostRepository(conn);
            var entity1 = new Post(0, 1, "Title1", "Description1", 1, "Snippet1", DateTime.Now.AddDays(1), false);
            var entity2 = new Post(0, 2, "Title2", "Description2", 2, "SnippeTKey", DateTime.Now.AddDays(2), true);

            repo.AddOrUpdate(entity1);
            var savedEntity2 = repo.AddOrUpdate(entity2);

            // Act
            var listEntities = repo.ListEntities(desc: true);

            // Assert
            Assert.IsTrue(listEntities.IsValid);
            Assert.IsTrue(listEntities.Value.Any());
            Assert.IsTrue(savedEntity2.Value.Equals(listEntities.Value.First()));
        }
Exemplo n.º 14
0
        public void CanListEntitiesActiveAndByTitle()
        {
            // Arrange
            var conn = GetConnectionString();

            var repo         = new SqlitePostRepository(conn);
            var entity1      = new Post(0, 0, "Title1", "Description1", 0, "Snippet1", isActive: true);
            var savedEntity1 = repo.AddOrUpdate(entity1);
            var entity2      = new Post(0, 0, "Title2", "Description2", 0, "SnippeTKey", isActive: false);

            _ = repo.AddOrUpdate(entity2);
            var filters = ImmutableList.Create(new Filter <Post>("Title", "Title1"));

            // Act
            var listEntities = repo.ListEntities(filters: filters, status: Status.Active);

            // Assert
            Assert.IsTrue(listEntities.IsValid);
            Assert.IsTrue(listEntities.Value.Count == 1);
            Assert.IsTrue(savedEntity1.Value.Equals(listEntities.Value.First()));
        }
        static void Main(string[] args)
        {
            var repo = new SqliteInitialization();

            repo.PrintVersion();

            var postRepo   = new SqlitePostRepository();
            var threadRepo = new SqliteThreadRepository();
            var userRepo   = new SqliteUserRepository();

            while (true)
            {
                Console.WriteLine("Write 1 to show all threads. \n" +
                                  "Write 2 to show all users. \n");

                string x = "";
                x = Console.ReadLine();

                if (x == "1")
                {
                    Console.Clear();
                    threadRepo.GetThreads();

                    while (true)
                    {
                        PrintThreads(threadRepo);

                        var people = threadRepo.GetThreads();
                        Console.WriteLine("Write the id of the thread you want to view." +
                                          "\nWrite c to create a new thread." +
                                          "\nWrite x to go back.");

                        string input = Console.ReadLine();

                        if (input == "x")
                        {
                            Console.Clear();
                            break;
                        }

                        if (input == "c")
                        {
                            Console.Clear();

                            Thread newThread = new Thread();
                            Console.WriteLine("Write a topic:");
                            newThread.Topic = Console.ReadLine();

                            Console.WriteLine("Write a text:");
                            newThread.Text      = Console.ReadLine();
                            newThread.PostCount = 100;

                            threadRepo.AddThread(newThread);

                            Console.WriteLine("Thread added!");

                            continue;
                        }

                        int threadId = int.Parse(input);

                        Console.Clear();
                        var threadCreator = userRepo.GetPersonWithIdWhoCreatedThread(threadId);
                        Console.WriteLine("User: "******"Write 1 to add a post");
                            Console.WriteLine("Write 2 to edit a post");
                            Console.WriteLine("Write 3 to delete a post");
                            Console.WriteLine("Write x to go back.");

                            string threadInput = Console.ReadLine();

                            if (threadInput == "x")
                            {
                                Console.Clear();
                                break;
                            }

                            if (threadInput == "1")
                            {
                                Console.WriteLine(threadId);

                                Post newPost = new Post();
                                Console.WriteLine("Write a text:");
                                newPost.Text = Console.ReadLine();

                                Console.WriteLine("Write the owners ID:");
                                newPost.UserId   = Console.ReadLine();
                                newPost.ThreadId = threadId.ToString();
                                postRepo.AddPost(newPost);

                                var obj = threadRepo.GetThreadWithId(threadId);
                                obj.PostCount = obj.PostCount + 1;
                                threadRepo.UpdateThreadPostCount(obj);


                                Console.Clear();
                                break;
                            }

                            if (threadInput == "2")
                            {
                                Console.WriteLine("What is the ID of the post you want to edit?");
                                string editPostId = Console.ReadLine();

                                int editPostInt = int.Parse(editPostId);

                                Post postObject = new Post();

                                postObject = postRepo.GetPostWithId(editPostInt);

                                Console.WriteLine("Write the new text.");
                                string newText = Console.ReadLine();

                                postObject.Text = newText;

                                postRepo.UpdatePost(postObject);
                            }

                            if (threadInput == "3")
                            {
                                Console.WriteLine("What is the ID of the post you want to delete?");
                                string deletePostId = Console.ReadLine();

                                int editPostInt = int.Parse(deletePostId);

                                Post postObject = new Post();

                                postObject = postRepo.GetPostWithId(editPostInt);

                                postRepo.DeletePost(postObject);

                                var obj = threadRepo.GetThreadWithId(threadId);
                                obj.PostCount = obj.PostCount - 1;
                                threadRepo.UpdateThreadPostCount(obj);

                                Console.Clear();
                                break;
                            }
                        }
                    }
                    continue;
                }

                if (x == "2")
                {
                    Console.Clear();

                    userRepo.GetUsers();
                    PrintUsers(userRepo);
                    continue;
                }
                x = "";
            }
        }