EDIT

*/

package eu.etaxonomy.cdm.vaadin.util;

import java.util.Collection;

import java.util.Iterator;

import java.util.List;

    public static final String ID = "id";

    public static final String UUID_ID = "uuid";

        String FROM_QUERY = " FROM TaxonBase tb " +

                "INNER JOIN TaxonNode tn on tn.taxon_id=tb.id " +

                "INNER JOIN TaxonNameBase tnb on tb.name_id=tnb.id " +

            String pb_id,

            String unp_id,

            String rank_id,

        String FROM_QUERY = " FROM TaxonBase tb " +

                "INNER JOIN TaxonNode tn on tn.taxon_id=tb.id " +

                "INNER JOIN TaxonNameBase tnb on tb.name_id=tnb.id " +

        return generateQueryDelegate(SELECT_QUERY, COUNT_QUERY, CONTAINS_QUERY);

    }

    	String idString = "";

    	Iterator<Integer> nodeIterator = taxonNodeIds.iterator();

        return generateQueryDelegate(SELECT_QUERY, COUNT_QUERY, CONTAINS_QUERY);

    }

    	String FROM_QUERY = " FROM TaxonBase tb " +

    			"INNER JOIN TaxonNameBase tnb on tb.name_id=tnb.id " +

    			"INNER JOIN SynonymRelationship sr on tb.id=sr.relatedfrom_id ";

            String reltype_id,

            String to_id,

            String touuid_id,

        String FROM_QUERY = "     FROM TaxonRelationship tr " +

                "INNER JOIN TaxonBase tb on tr.relatedto_id = tb.id " +

                "INNER JOIN TaxonNode tn on tb.id = tn.taxon_id ";

     *

     * @param tableName

     * @return

     */

        String FROM_QUERY = " FROM " + tableName;

        String SELECT_QUERY=" SELECT * " +

                FROM_QUERY;

        return generateQueryDelegate(SELECT_QUERY, COUNT_QUERY, CONTAINS_QUERY);

    }

        FreeformQuery query = new FreeformQuery("This query is not used", CdmSpringContextHelper.getCurrent().getConnectionPool(), ID);

        CdmStatementDelegate delegate = new CdmStatementDelegate(SELECT_QUERY, COUNT_QUERY, CONTAINS_QUERY);

        query.setDelegate(delegate);

        return query;

    }

}