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

Linking flask and sqlite

We now need to import and use our database module inside our server module. In order to make this easier, we should first wrap all of our functions in a class.

Update your database.py file, creating a class named Database and adding the necessary self instances to your methods. We can also move the database name out to an attribute in the __init__ method:

import sqlite3class Database:    def __init__(self):        self.database = "chat.db"    def perform_insert(self, sql, params):        conn = sqlite3.connect(self.database)        ...    def perform_select(self, sql, params):        conn = sqlite3.connect(self.database)        ...    # update the rest of your methods to include self where necessary

Now that we have that done, we can import and instantiate the ...

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