Creating a database for testing

Now we will create the PostgreSQL database that we will use as a repository for our testing environment. Notice that the testing computer or server must have PostgreSQL 10.5 installed on it, as explained in the previous chapters for the development environment. I assume that you are running the tests on the same computer in which you worked with the previous examples.

Note

Remember to make sure that the PostgreSQL bin folder is included in the PATH environmental variable. You should be able to execute the psql command-line utility from your current Terminal, Command Prompt, or Windows PowerShell.

We will use the PostgreSQL command-line tools to create a new database named test_flask_notifications. If you already have a PostgreSQL database with this name, make sure that you use another name in all the commands and configurations. You can perform the same task with any PostgreSQL GUI tool. If you are developing on Linux, it is necessary to run the commands as the...