Tkinter GUI Programming by Example

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