1 files changed, 41 insertions, 0 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/models/DbImage.java b/dozentenmodulserver/src/main/java/sql/models/DbImage.java
new file mode 100644
index 00000000..fe59dac8
--- /dev/null
+++ b/dozentenmodulserver/src/main/java/sql/models/DbImage.java
@@ -0,0 +1,41 @@
+package sql.models;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.List;
+
+import org.apache.log4j.Logger;
+import org.openslx.bwlp.thrift.iface.ImageSummaryRead;
+import org.openslx.bwlp.thrift.iface.UserInfo;
+
+import sql.MysqlConnection;
+import sql.MysqlStatement;
+import sql.SQL;
+
+public class DbImage {
+
+	private static final Logger LOGGER = Logger.getLogger(DbImage.class);
+
+	public static List<ImageSummaryRead> getAllVisible(UserInfo user, List<String> tagSearch) {
+		try (MysqlConnection connection = SQL.getConnection()) {
+			MysqlStatement stmt = connection.prepareStatement("SELECT"
+					+ " i.imagebaseid, i.currentversionid, i.latestversionid, i.displayname,"
+					+ " i.osid, i.virtid, i.createtime, i.updatetime, i.ownerid, i.uploaderid,"
+					+ " i.sharemode, i.istemplate, i.canlinkdefault, i.candownloaddefault,"
+					+ " i.caneditdefault, i.canadmindefault,"
+					+ " cur.filesize, cur.isenabled, cur.isrestricted, cur.isvalid," + " lat.isprocessed"
+					+ " FROM imagebase i"
+					+ " LEFT JOIN imageversion cur ON (cur.imageversionid = i.currentversionid)"
+					+ " LEFT JOIN imageversion lat ON (lat.imageversionid = i.latestversionid)");
+			ResultSet rs = stmt.executeQuery();
+			while (rs.next()) {
+				ImageSummaryRead entry = new ImageSummaryRead();
+			}
+			return null;
+		} catch (SQLException e) {
+			LOGGER.error("Query failed in DbImage.getAllVisible()", e);
+			return null;
+		}
+	}
+
+}