From d684cd4dbdadb11a0017556e802bdf3141336f2b Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Wed, 10 Jun 2015 20:22:04 +0200 Subject: [server] db stuff, new interface, ... --- .../src/main/java/sql/models/DbImage.java | 41 ++++++++++++++++++++++ 1 file changed, 41 insertions(+) create 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 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 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