package org.paneris.bibliomania;
   
   import java.sql.ResultSet;
   
   import org.melati.poem.Database;
   import org.melati.poem.DefinitionSource;
   import org.melati.poem.PoemException;
   import org.paneris.bibliomania.generated.OrderStatusTableBase;
   
  public class OrderStatusTable<T extends OrderStatus> extends OrderStatusTableBase<OrderStatus> {
  
    OrderStatus NotAuthorised;
    OrderStatus Authorised;
    OrderStatus Fufilled;
    OrderStatus PartFufilled;
  
    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,"id");
      NotAuthorised = ensure("Not Authorised");
      Authorised = ensure("Authorised");
      Fufilled = ensure("Fufilled");
      PartFufilled = ensure("Part Fufilled");
    }
    
    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 getNotAuthorised() {
      return NotAuthorised;
    }
    
    public OrderStatus getAuthorised() {
      return Authorised;
    }
    
    public OrderStatus getFufilled() {
      return Fufilled;
    }
    
    public OrderStatus getPartFufilled() {
      return PartFufilled;
    }
  }