package client;

import net.ivoa.www.xml.ADQL.v0_7_4.*;
import fr.u_strasbg.vizier.xml.VOTable_1_1_xsd.*;

public class SkyNodeClient {

    public static void main(String [] args) throws Exception {

	
	String addr = "http://localhost:8080/basicskynode/services/SkyNodeSoap";
	if (args.length > 0) addr = args[0];
	
	testService(addr);		

    }

   public static void testService(String addr) throws Exception {	
	
	System.out.println("Testing "+ addr);

	java.net.URL url = new java.net.URL(addr);

    java.lang.String testTable = "";
    java.lang.String testColumn = "";

	net.ivoa.SkyNode.SkyNodeLocator adilSrv = 
            new  net.ivoa.SkyNode.SkyNodeLocator();	
	net.ivoa.SkyNode.SkyNodeSoap soap = adilSrv.getSkyNodeSoap(url);
	
	System.out.println("Testing tables() method");

	net.ivoa.SkyNode.ArrayOfMetaTable tNames = soap.tables();

    net.ivoa.SkyNode.MetaTable [] tb = tNames.getMetaTable();
	
	for(int i=0;i<tb.length;i++)
	{
        net.ivoa.SkyNode.MetaTable table = tb[i];
		String t = table.getName();
	
           
		System.out.println("Table Name: " + t);
		System.out.println("Table Description: " + table.getDescription());
		System.out.println("Number of Rows: " + table.getRows());

		net.ivoa.SkyNode.ArrayOfMetaColumn cNames = soap.columns(t);
		net.ivoa.SkyNode.MetaColumn[] col = cNames.getMetaColumn();
		for(int j=0;j<col.length;j++)
		{
			String c = col[j].getName();
            if (i == 0 && j == 0) { //grab a table and column for 
                                    //the rest of the tests
                testTable = t;
                testColumn = c;
            }	
			String u = col[j].getUCD();
			System.out.println("Column { " + c + " } + UCD{ "+ u+" }");	
		}	
	}

	System.out.println("Testing table method");

    try {
	    net.ivoa.SkyNode.MetaTable metaTable = soap.table(testTable);

        System.out.println("Name: " + metaTable.getName() + "\n");
        System.out.println("Description: " + metaTable.getDescription() + "\n");
    } 
    catch (NullPointerException e)
    { 

         System.out.println("No information on table " + testTable);
    }


	System.out.println("Testing column method");

    try {
	    net.ivoa.SkyNode.MetaColumn metaColumn = soap.column(testTable, testColumn);

        System.out.println("Name: " + metaColumn.getName() + "\n");
        System.out.println("Description: " + metaColumn.getDescription() + "\n");
        System.out.println("UCD: " + metaColumn.getUCD()+ "\n");
        System.out.println("Unit: " + metaColumn.getUnit()+ "\n");
    } 
    catch (NullPointerException e)
    { 

         System.out.println("No information on column " + testColumn);
    }
    //Test performQuery

    // SQL Query: select top 5 a.testColumn from testTable a
    //Create a Select object and fill it
     SelectType selectType = new SelectType(); 
     SelectionLimitType restrict = new SelectionLimitType();
     restrict.setTop(new org.apache.axis.types.UnsignedInt(5));
     selectType.setRestrict(restrict);
     SelectionListType sl = new SelectionListType(); 
     //Columns
     ColumnReferenceType[] cr = new ColumnReferenceType[1]; 
     ColumnReferenceType cr0 = new ColumnReferenceType();
     cr0.setTable("a");
     cr0.setName(testColumn);
     cr[0] = cr0;
     sl.setItem(cr);
     selectType.setSelectionList(sl);

    // From Clause
     FromType from = new FromType(); 
     TableType[] tabArr = new TableType[1];
     TableType arcTable = new TableType();
     arcTable.setName(testTable);
     arcTable.setAlias("a");

     tabArr[0] = arcTable;
     from.setTable(tabArr);
     selectType.setFrom(from);

	net.ivoa.SkyNode.VOData vod= null;
	   try
	   {
	       System.out.println("Perform the Query: 'SELECT TOP 5 a." + testColumn + " FROM " + testTable + " a");
		   vod = soap.performQuery(selectType, "VOTABLE");
	   }
	   catch (Exception pe)
	   {
		   pe.printStackTrace(System.out);
	   }
    // Test for ErrorData being returned
    if (vod instanceof net.ivoa.SkyNode.ErrorData) {
       net.ivoa.SkyNode.ErrorData err =  (net.ivoa.SkyNode.ErrorData)vod;
       System.out.println("Error: " + err.getError());
    } else if (vod instanceof net.ivoa.SkyNode.VOTableData ){ // VOTableData returned 
        net.ivoa.SkyNode.VOTableData votd = 
                (net.ivoa.SkyNode.VOTableData)vod;
        VOTABLE vot = votd.getVOTABLE();

        // Output info about the VOTABLE

        System.out.println("Output is a VOTABLE");
    
        RESOURCE resource = vot.getRESOURCE(0);
        TABLE table = resource.getTABLE(0);
        FIELD[] fields = table.getFIELD();
        int cols = fields.length;
        TR [] tr  = table.getDATA().getTABLEDATA().getTR();
        System.out.println("Data: " );
        for (int j = 1; j <= cols; j++) {
            System.out.print(table.getFIELD(j-1).getName() + (j < cols ? "\t\t" : "\n"));    
        }
        for (int j = 1; j <= cols; j++) {
            System.out.print("----------" + (j < cols ? "\t" : "\n"));    
        }
	if (null == tr ) { // no rows
	     System.out.println(" No rows returned");
	} else {
	    for (int i = 1; i <= tr.length; i++) {
		TR myRow = tr[i-1];
		TD[] row = myRow.getTD();
		for (int j = 1; j <= cols; j++) {
		    System.out.print(row[j-1] + (j < cols ? "\t" : "\n"));    
		}
	    }
	}
    }
  }
}