April 2018
Beginner
340 pages
7h 54m
English
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 linuxType "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 and 1 represents the conversation being blocked.
We now need to write some new methods in our ...