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