Adding and blocking other users

To implement adding and blocking users, we are going to be creating a new table in our chat database. This table will be called friends and will contain information about each pairing of friends and whether or not communication between them has been blocked.

New database table

Once again, we can use the Python REPL to create a new table. Access your server folder and run a Python shell:

Python 3.6.4 (default, Jan 03 2018, 13:52:55) [GCC] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import database
>>> d = database.Database()
>>> sql = "CREATE TABLE friends (user_one text, user_two text, blocked integer)"
>>> params = []
>>> d.perform_insert(sql, params)
>>>

Our database will contain two users, called user_one and user_two, as well as an integer representing whether communication has been blocked. This integer will be treated as a Boolean, where 0 represents no blocking...