Skip to Content
Tkinter GUI Programming by Example
book

Tkinter GUI Programming by Example

by David Love
April 2018
Beginner content levelBeginner
340 pages
7h 54m
English
Packt Publishing
Content preview from Tkinter GUI Programming by Example

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Tkinter GUI Application Development Blueprints, Second Edition - Second Edition

Tkinter GUI Application Development Blueprints, Second Edition - Second Edition

Bhaskar Chaudhary

Publisher Resources

ISBN: 9781788627481Supplemental Content