package org.openslx.satellitedaemon.db;

import java.util.List;

/**
 * Represents an image in the satellite's database (mostly from
 * m_VLData_imageInfo)
 */
public class DbImage
{
	
	public final String guid;
	public final String name;
	public final int rid;
	public final String path;
	public final String creator;
	public final long fileSize;
	
	public DbImage(String guid, String name, int rid, String path, String creator, long fileSize)
	{
		this.guid = guid;
		this.name = name;
		this.rid = rid;
		this.path = path;
		this.creator = creator;
		this.fileSize = fileSize;
	}

	/**
	 * Returns a list of all images on this satellite that should be
	 * uploaded to the central server.
	 * 
	 * @return list of images that are marked for upload, where the upload
	 *         was either not started yet, or is incomplete
	 */
	public static List<DbImage> getAllMarkedForUpload()
	{
		return MySQL.findAll( DbImage.class, "SELECT image.GUID_imageID, image.image_name, image.imageVersion, image.image_path," +
				" Concat(user.loginName, '@', institution.name) AS userID, image.filesize" +
				" FROM m_VLData_imageInfo image" +
				" INNER JOIN m_user user ON (image.image_owner = user.userID)" +
				" INNER JOIN m_institution institution ON (institution.institutionID = user.institution)" +
				" WHERE status_isReady <> 0" );
	}

}