From 048646123f79b2bfa2eaf0fdef5ffa4822d37838 Mon Sep 17 00:00:00 2001
From: Jonas Smedegaard <dr@jones.dk>
Date: Tue, 29 Apr 2025 23:32:26 +0200
Subject: fix SQL invert query for subject modules; rename method
 getAllModules() -> getAllSubjects()

---
 src/com.example.portfolio2/com/example/portfolio2/Controller.java | 2 +-
 src/com.example.portfolio2/com/example/portfolio2/Database.java   | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

(limited to 'src/com.example.portfolio2/com')

diff --git a/src/com.example.portfolio2/com/example/portfolio2/Controller.java b/src/com.example.portfolio2/com/example/portfolio2/Controller.java
index 154cf42..66519ae 100644
--- a/src/com.example.portfolio2/com/example/portfolio2/Controller.java
+++ b/src/com.example.portfolio2/com/example/portfolio2/Controller.java
@@ -92,7 +92,7 @@ class Controller {
 	) {
 
 		// remove chosen option from opposite subject module box
-		for (String sub: store.getAllModules()) {
+		for (String sub: store.getAllSubjects()) {
 			if (sub.equals(subject1.getValue())) {
 				subject2.getItems().remove(
 					subject1.getValue());
diff --git a/src/com.example.portfolio2/com/example/portfolio2/Database.java b/src/com.example.portfolio2/com/example/portfolio2/Database.java
index 0c11e31..22a7c5a 100644
--- a/src/com.example.portfolio2/com/example/portfolio2/Database.java
+++ b/src/com.example.portfolio2/com/example/portfolio2/Database.java
@@ -106,10 +106,10 @@ class Database {
 	/// list of available subject modules
 	///
 	/// @return  names of all subject modules as list of strings
-	List<String> getAllModules() {
+	List<String> getAllSubjects() {
 		return db.query(
 			"SELECT DISTINCT program FROM activity"
-			+ " WHERE program IN ("
+			+ " WHERE program NOT IN ("
 			+ "   SELECT program from activity"
 			+ "   WHERE name LIKE 'BP1 %')",
 			"program");
-- 
cgit v1.2.3