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;
		}
	}

}