From 7a563afac3a74e9a64fd0df32d198d513511aabf Mon Sep 17 00:00:00 2001
From: Jakub Czajka <jakub@ekhem.eu.org>
Date: Fri, 12 Apr 2024 23:39:07 +0200
Subject: [PATCH] Actually associate exercise with category.

---
 insert.sh | 12 ++++++++----
 1 file changed, 8 insertions(+), 4 deletions(-)

diff --git a/insert.sh b/insert.sh
index 097e5aa..29a71bb 100755
--- a/insert.sh
+++ b/insert.sh
@@ -65,15 +65,19 @@ case ${RECORD_TYPE} in
     category=$(get_query_param category)
     exercise=$(get_query_param exercise)
 
+    exercise_id=$(query_db "\
+    SELECT id
+    FROM exercises
+    WHERE name='${exercise}'")
+
     category_id=$(query_db "\
     SELECT id
     FROM categories
     WHERE name='${category}'")
 
-    exercise_id=$(query_db "\
-    SELECT id
-    FROM exercises
-    WHERE name='${exercise}'")
+    query_db "\
+    INSERT INTO exercises_categories (exercise_id, category_id)
+    VALUES ('${exercise_id}', '${category_id}')"
 
     echo "Associated exercise '${exercise}' (id=${exercise_id}) with category\
  ${category} (id=${category_id})."
-- 
2.39.5