April 2018
Beginner
340 pages
7h 54m
English
To store an avatar against a particular user, we will need to add a column to our users database. We can do this via the Python REPL from our server folder, as follows:
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 = "ALTER TABLE users ADD avatar text">>> params = []>>> d.perform_insert(sql, params)>>>
In order to add a column to an existing table, we use an alter table command. We then specify the table name, new column name, and new column type.
With the preceding statement, we have added a column named avatar of the text type. This is the column which we will use to hold our avatar ...