Table of Contents

1. Challenge

   Create DB Connection (connect_db.py)

   1. First, you will need to create a database user to use in your application. You can do this by connecting to the database as the postgres user using the psql command.

   2. Once connected as the postgres user, you can create a database user named cloud_user. Be sure to grant the user access to the contracts database.

   3. With the user created, you are ready to create the get_database_connection function in the connect_db.py file. This function will return a connection object that can be used to access the database.

2. Challenge

   Create and Populate Table (create_table.py)

   With the connection created, create a table and populate it with the create_table function.

3. Challenge

   Read Data (read_data.py)

   Now you can read the data from the table with the read_data_from_db function. The skeleton also has code to compare the read data to a known good copy and print it to the screen.

4. Challenge

   Update and Delete (update_data.py)

   With the data successfully loaded, you are now ready to make some updates via the update_data function.

   1. First, you need to update the due date for the author “Smith, Jackson”.

   2. Lastly, you'll need to resolve the failed assertation the number of Smith Jackson rows is incorrect by deleting the extra rows.