[server] Fix virtualizer store query

1 files changed, 25 insertions, 0 deletions

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbOrganization.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbOrganization.java
index dbc75944..f208f2c2 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbOrganization.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbOrganization.java
@@ -111,4 +111,29 @@ public class DbOrganization {
 		}
 	}
 
+	/**
+	 * Return list of known organizations. This is a backup solution for
+	 * fetching the list form them aster server, as this one doesn't fill all
+	 * fields.
+	 * 
+	 * @return list of all known organizations
+	 * @throws SQLException
+	 */
+	public static List<Organization> getAll() throws SQLException {
+		try (MysqlConnection connection = Database.getConnection()) {
+			MysqlStatement stmt = connection.prepareStatement("SELECT" + " o.organizationid, o.displayname"
+					+ " FROM organization o");
+			ResultSet rsOrg = stmt.executeQuery();
+			List<Organization> list = new ArrayList<>();
+			while (rsOrg.next()) {
+				list.add(new Organization(rsOrg.getString("organizationid"), rsOrg.getString("displayname"),
+						null, null));
+			}
+			return list;
+		} catch (SQLException e) {
+			LOGGER.error("Query failed in DbOrganization.getAll()", e);
+			throw e;
+		}
+	}
+
 }