path: root/src/main/java/org/openslx/imagemaster/db/DbSatellite.java

package org.openslx.imagemaster.db;

public class DbSatellite
{

	private String organization, address, name, prefix;

	// needs to be public in order to be found by MySQL
	public DbSatellite(String organization, String address, String name, String prefix)
	{
		this.organization = organization;
		this.address = address;
		this.name = name;
		this.prefix = prefix;
	}

	public static DbSatellite fromOrganization( String organization )
	{
		return MySQL
				.findUniqueOrNull(
						DbSatellite.class,
						"SELECT satellite.organization, satellite.address, satellite.name, satellite.prefix FROM satellite WHERE satellite.organization = ? LIMIT 1",
						organization );
	}

	public String getAddress()
	{
		return address;
	}

	public String getName()
	{
		return name;
	}

	public String getOrganization()
	{
		return organization;
	}

	public String getPrefix()
	{
		return this.prefix;
	}

	public static DbSatellite fromPrefix( String prefix )
	{
		return MySQL
				.findUniqueOrNull(
						DbSatellite.class,
						"SELECT satellite.organization, satellite.address, satellite.name, satellite.prefix FROM satellite WHERE satellite.prefix = ? LIMIT 1",
						prefix );
	}

	public static byte[] getKeyfromOrganization( String organization )
	{
		return MySQL.findUniqueOrNull( ByteArray.class, "SELECT publickey FROM satellite WHERE organization = ?", organization ).array;
	}

	class ByteArray
	{

		public final byte[] array;

		ByteArray(byte[] array)
		{
			this.array = array;
		}
	}
}