started integrating the database into the program

1 files changed, 3 insertions, 1 deletions

diff --git a/app.py b/app.py
index b51369c..0467dd6 100644
--- a/app.py
+++ b/app.py
@@ -71,8 +71,10 @@ def join_submission(db: sqlite3.Connection):
         raise HTTPError(400, "Preferred role must be one of the options (DPS, Tank, Healer) ( idiot )")
     if motivation == None or motivation.strip() == "":
         raise HTTPError(400, "Motivitaion field is empty or missing.")
+    
+    db.execute("SELECT * FROM applications").fetchone()
 
-    db.execute(f"INSERT INTO applications(name, role, motivation) VALUES ({name}, {preferred_role}, {motivation})")
+    db.execute("INSERT INTO applications(name, role, motivation) VALUES (?, ?, ?)", (name, preferred_role, motivation))
 
 @app.route("/<type:re:styles|images>/<filename>")
 def server_static(type, filename):