/*
 * Created on 29-Apr-2009
 *
 * TODO 
 */
package uk.ac.roe.wfau;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

/**
 * @author MAR
 *
 */
public class VESPAQueryRetrieverThread extends QueryRetrieverThread{
    static String [] RANAMES={"ra","obs"};
    static String [] DECNAMES={"dec","obsdec"};
    
    String []  getRANames(){
        return RANAMES;
    }
    String []  getDecNames(){
        return DECNAMES;
    }

    /**
     * @param dbURL
     */
    public VESPAQueryRetrieverThread(String dbURL) {
        super(dbURL);
        // TODO Auto-generated constructor stub
    }

    public static String [][] showArray = { {"specObjId"}};
   // boolean [] showBoolean = new boolean [] {false};
    
    
    public StringBuffer getLinkInfo () {
        StringBuffer st=new StringBuffer("");
        if (showBoolean[1]) {
            st.append("The CAS column can be used to display the SDSS spectrum.<p>");
        }
   
        return st;
    }
    

    public StringBuffer getShowTitles () {
        StringBuffer st=new StringBuffer("");
            if (showBoolean[1]) {
                st.append("<th nowrap=\"nowrap\">CAS</th>");
            }
        return st;
    }
    public StringBuffer getShowLinks (ResultSet rs) {
        StringBuffer st=new StringBuffer("");
        try {
            if (showBoolean[1]) {
                st.append("<td><a href=\"http://cas.sdss.org/astro/en/tools/explore/obj.asp?sid="
                        +rs.getString("specObjID") + 
                        "\"  onclick=\"popWin=open('http://cas.sdss.org/astro/en/tools/explore/obj.asp?sid=" +
                        rs.getString("specObjID") + 
                        "','cas','');popWin.focus();return false\">cas</a></td>");
            }
            
        }
        catch (Exception e){
          return EMPTYSTRINGBUFFER;  
        }
        
        return st;
    }
    
    public void setShowBoolean(ResultSetMetaData rsmd) {
        
        showBoolean=showArrayPresent(rsmd,showArray);
        //logger.info(showBoolean[0]+" "+showBoolean[1]);
    }

}