[server] On mah way (lots of restructuring, some early db classes, sql dump of current schema)

1 files changed, 0 insertions, 41 deletions

diff --git a/dozentenmodulserver/src/main/java/sql/models/DbImage.java b/dozentenmodulserver/src/main/java/sql/models/DbImage.java
deleted file mode 100644
index fe59dac8..00000000
--- a/dozentenmodulserver/src/main/java/sql/models/DbImage.java
+++ /dev/null
@@ -1,41 +0,0 @@
-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;
-		}
-	}
-
-}