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

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

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