/**
* The class <code>Landmark</code> represents a site
* specific reference name.
*/
@Entity
@Table(uniqueConstraints = { @UniqueConstraint(columnNames = {"col", "row", "label_id" }) })
public class Landmark {

    private int id;
   
    private int row;
    private int column;
    private double distance;
    private LandmarkLabel label;
    private int landmarkTypeOrdinal;

    /**
     * Create new landmark label.
     */
    public Landmark() {
       
    }
   
    /**
     * @return Returns the column.
     */
    @Column(name = "col", nullable = false)   
    public int getColumn() {
        return column;
    }

    /**
     * @param column
     *            The column to set.
     */
    public void setColumn(int column) {
        this.column = column;
    }
   
    /**
     * @return Returns the distance.
     */
    public double getDistance() {
        return distance;
    }

    /**
     * @param distance The distance to set.
     */
    public void setDistance(double distance) {
        this.distance = distance;
    }


    /**
     * @return Returns the label.
     */
    @ManyToOne
    public LandmarkLabel getLabel() {
        return label;
    }

    /**
     * @param label The label to set.
     */
    public void setLabel(LandmarkLabel label) {
        this.label = label;
    }

    /**
     * Gets the implementation specific <code>ID</code> for this
     * <code>LandmarkLabel</code>.
     *
     * @return Returns the id.
     */
    @Id
    @GeneratedValue(strategy = AUTO)
    public int getId() {
        return id;
    }

    /**
     * Sets the <code>ID</code> for this <code>Landmark</code>.
     *
     * @param id
     *            The id to set.
     */
    public void setId(int id) {
        this.id = id;
    }
   
    /**
     * @return Returns the landmarkType.
     */
    @Transient
    public LandmarkType getLandmarkType() {
        LandmarkType[] values = LandmarkType.values();
        return values[landmarkTypeOrdinal];
    }
   
    /**
     * @param landmarkType The landmarkType to set.
     */
    public void setLandmarkType(LandmarkType landmarkType) {
        this.landmarkTypeOrdinal = landmarkType.ordinal();
    }

    /**
     * @return Returns the landmarkTypeOrdinal.
     */
    public int getLandmarkTypeOrdinal() {
        return landmarkTypeOrdinal;
    }

    /**
     * @param landmarkTypeOrdinal The landmarkTypeOrdinal to set.
     */
    public void setLandmarkTypeOrdinal(int landmarkTypeOrdinal) {
        this.landmarkTypeOrdinal = landmarkTypeOrdinal;
    }
   
    /**
     * @return Returns the row.
     */
    @Column(nullable = false)
    public int getRow() {
        return row;
    }

    /**
     * @param row
     *            The row to set.
     */
    public void setRow(int row) {
        this.row = row;
    }
     
}

/**
* The class <code>LandmarkLabel</code> represents
* the distance of a landmark in a particular tube from
* that tube's inlet end.
*/
@Entity
@Table
public class LandmarkLabel {

    private int id;
    private String label;
   
    /**
     * Create new landmark label.
     */
    public LandmarkLabel() {
       
    }
   
    /**
     * @param label
     *     label to create
     */
    public LandmarkLabel(String label) {
        this.label = label;
    }
   
    /**
     * Gets the implementation specific <code>ID</code> for this
     * <code>LandmarkLabel</code>.
     *
     * @return Returns the id.
     */
    @Id
    @GeneratedValue(strategy = AUTO)
    public int getId() {
        return id;
    }

    /**
     * Sets the <code>ID</code> for this <code>Plant</code>.
     *
     * @param id
     *            The id to set.
     */
    public void setId(int id) {
        this.id = id;
    }

    /**
     * @return Returns the label.
     */
    @Column(nullable = false, unique = true)
    public String getLabel() {
        return label;
    }

    /**
     * @param label
     *            The label to set
     */
    public void setLabel(String label) {
        this.label = label;
    }
   
    /**
     * {@inheritDoc}
     */
    public String toString() {
        return getLabel();
    }
}

    public Landmark findByRowColumnName(int row, int column, String name) {
        LandmarkLabel label = new LandmarkLabel();
        label.setLabel(name);
       
        LandmarkLabelDAO llDAO = (LandmarkLabelDAO) this.getDatabaseConnection().getDAO(LandmarkLabel.class);
        LandmarkLabel found = llDAO.findByExample(label, new String[0]).get(0);
       
        Landmark example = new Landmark();
        example.setRow(row);
        example.setColumn(column);
        example.setLabel(found);
       
        return findByExample(example, new String[0]).get(0);
    }