From e0005ceecfd9281230c4add7575b18ee88307774 Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Thu, 11 Jun 2015 18:40:49 +0200 Subject: [server] On mah way (lots of restructuring, some early db classes, sql dump of current schema) --- .../src/main/java/sql/models/DbImage.java | 41 ---------------------- 1 file changed, 41 deletions(-) delete mode 100644 dozentenmodulserver/src/main/java/sql/models/DbImage.java (limited to 'dozentenmodulserver/src/main/java/sql/models') 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 getAllVisible(UserInfo user, List 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; - } - } - -} -- cgit v1.2.3-55-g7522