O'Reilly logo

Tkinter GUI Programming by Example by David Love

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adjusting the database

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required