package org.paneris.jammyjoes.model;

 import java.sql.ResultSet;

 import org.melati.poem.Database;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.PoemException;

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

 public class ProductStatusTable extends ProductStatusTableBase {

   private ProductStatus discontinued, normallystocked, notstocked, newItem;

   public ProductStatusTable(

       Database database, String name,

       DefinitionSource definitionSource) throws PoemException {

     super(database, name, definitionSource);

   }

   public synchronized void unifyWithDB(ResultSet colDescs)

       throws PoemException {

     super.unifyWithDB(colDescs);

     normallystocked = ensure("Normally Stocked");

     notstocked = ensure("Do Not Reorder");

                 discontinued = ensure("Discontinued");

                 newItem = ensure("New");

   }

   public ProductStatus ensure(String status) {

     ProductStatus p = (ProductStatus)newPersistent();

     p.setStatus(status);

     return (ProductStatus)getStatusColumn().ensure(p);

   }

   public ProductStatus getNormallyStocked() {

     return normallystocked;

   }

   public ProductStatus getNotStocked() {

     return notstocked;

   }

         public ProductStatus getDiscontinued() {

                 return discontinued;

         }

         public ProductStatus getNew() {

                 return newItem;

         }

 }