package org.paneris.jammyjoes.model;

 import java.sql.ResultSet;

 import java.util.LinkedList;

 import java.util.List;

 import org.melati.poem.Database;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.PoemException;

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

 public class OrderStatusTable extends OrderStatusTableBase {

   OrderStatus Incomplete;

   OrderStatus Paid;

   OrderStatus Fufilled;

   OrderStatus Outstanding;

   public OrderStatusTable(

       Database database, String name,

       DefinitionSource definitionSource) throws PoemException {

     super(database, name, definitionSource);

   }

   public synchronized void unifyWithDB(ResultSet colDescs)

       throws PoemException {

     super.unifyWithDB(colDescs);

     Incomplete = ensure("Incomplete");

     Paid = ensure("Paid");

     Fufilled = ensure("Fulfilled");

     Outstanding = ensure("Outstanding");

   }

   public OrderStatus ensure(String s) {

     OrderStatus status = (OrderStatus)getStatusColumn().firstWhereEq(s);

     if (status != null)

       return status;

     else {

       status = (OrderStatus)newPersistent();

       status.setStatus(s);

       return (OrderStatus)getStatusColumn().ensure(status);  

     }

   }

   public OrderStatus getIncomplete() {

     return Incomplete;

   }

   public OrderStatus getPaid() {

     return Paid;

   }

   public OrderStatus getFufilled() {

     return Fufilled;

   }

   public OrderStatus getOutstanding() {

     return Outstanding;

   }

   public List paidStatuses() {

     List statuses = new LinkedList();

     statuses.add(getFufilled());

     statuses.add(getPaid());

     statuses.add(getOutstanding());

     return statuses;

   }

 }