ExptCondition.java

/**
 * 
 */
package org.seqcode.data.core;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @author tdanford
 * Represents an entry in the core.exptcondition table.  
 * This is used as metadata for sequencing experiments.  
 * The name might describe cell stage like "ES" or a compact identifier of experimental conditions/treatments.
 */
public class ExptCondition implements Comparable<ExptCondition> {
    
	private int dbid;
	private String name;
    
    public ExptCondition(ResultSet rs) throws SQLException { 
        dbid = rs.getInt(1);
        name = rs.getString(2);
    }
	
	public String getName() { return name; }
	public int getDBID() { return dbid; }
    
    public String toString() { return name + " (#" + dbid + ")"; }
	
	public int hashCode() { 
		int code = 17;
		code += dbid; code *= 37;
		return code;
	}
	
	public boolean equals(Object o) { 
		if(!(o instanceof ExptCondition)) { return false; }
		ExptCondition c = (ExptCondition)o;
		if(dbid != c.dbid) { return false; }
		return true;
	}
    
    public int compareTo(ExptCondition c) { return name.compareTo(c.name); }
    
    
    public static PreparedStatement prepareLoadExperimentsByGenome(java.sql.Connection cxn) throws SQLException { 
        return cxn.prepareStatement("select e.id, e.name, e.version from experiment e, exptToGenome e2g " +
                "where e.id=e2g.experiment and e2g.genome=? and e.active=1 and (e.conditionone=? or e.conditiontwo=?)");
    }
}