package org.paneris.jammyjoes.model;

 import java.util.Enumeration;

 import org.melati.poem.Database;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.PoemException;

 import org.melati.util.StringUtils;

 import org.paneris.jammyjoes.controller.ParameterProvider;

 import org.paneris.jammyjoes.controller.SearchAge;

 import org.paneris.jammyjoes.model.generated.AgeTableBase;

 public class AgeTable extends AgeTableBase {

   public AgeTable(

       Database database, String name,

       DefinitionSource definitionSource) throws PoemException {

     super(database, name, definitionSource);

   }

   public SearchAge fromParameter(ParameterProvider provider) {

     String ageString = provider.getParam("field_age", 2);

     if (ageString != null) {

       int hyphen = ageString.indexOf('_');

       if (hyphen > 0) {

         String[] ages = StringUtils.split(ageString, '_');

         Integer minAge = new Integer(ages[0]);

         Integer maxAge = new Integer(ages[1]);

         String where = minAge + " = " + q("minage") + " AND " + maxAge + " = " + q("maxage");

         Enumeration en = selection(where);

         if (en.hasMoreElements()) {

           return new SearchAge((Age)en.nextElement());

         }

         return new SearchAge(minAge, maxAge);

       } else {

         Enumeration en = getNameColumn().selectionWhereEq(ageString);

         if (en.hasMoreElements()) {

           return new SearchAge((Age) en.nextElement());

         }

         en = getPluralNameColumn().selectionWhereEq(ageString);

         if (en.hasMoreElements()) {

           return new SearchAge((Age) en.nextElement());

         }

       }

     }

     return new SearchAge();

   }

   public String q(String name) {

     StringBuffer b = new StringBuffer();

     StringUtils.appendQuoted(b, name, '"');

     return b.toString();

   }

 }