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;

   }

 }