Book Image

Continuous Integration, Delivery, and Deployment

By : Sander Rossel
Book Image

Continuous Integration, Delivery, and Deployment

By: Sander Rossel

Overview of this book

The challenge faced by many teams while implementing Continuous Deployment is that it requires the use of many tools and processes that all work together. Learning and implementing all these tools (correctly) takes a lot of time and effort, leading people to wonder whether it's really worth it. This book sets up a project to show you the different steps, processes, and tools in Continuous Deployment and the actual problems they solve. We start by introducing Continuous Integration (CI), deployment, and delivery as well as providing an overview of the tools used in CI. You'll then create a web app and see how Git can be used in a CI environment. Moving on, you'll explore unit testing using Jasmine and browser testing using Karma and Selenium for your app. You'll also find out how to automate tasks using Gulp and Jenkins. Next, you'll get acquainted with database integration for different platforms, such as MongoDB and PostgreSQL. Finally, you'll set up different Jenkins jobs to integrate with Node.js and C# projects, and Jenkins pipelines to make branching easier. By the end of the book, you'll have implemented Continuous Delivery and deployment from scratch.
Table of Contents (15 chapters)

Adding the database

Now that we have what we pretty much started with in the previous chapters, this time, in C#, we can continue by adding a database connection. You can find all SQL scripts in this chapter in the GitHub repository in the sql folder in the chapter folder. We installed PostgreSQL and pgAdmin in Chapter 2, Setting Up A CI Environment, because we also needed it to run SonarQube. So, open up pgAdmin and find the connection you made in Chapter 2, Setting Up A CI Environment. If you do not have it anymore, you can read how to get it in Chapter 2, Setting Up A CI Environment, so I will not repeat that here. Now that you are connected to the server in pgAdmin, we can create the webshop database. Either right-click on the Databases node and select Create and then Database; just give the database the name webshop and save. Or you can connect to the default postgres database...