package org.paneris.bibliomania;

 import java.sql.Timestamp;

 import java.util.Enumeration;

 import java.util.Vector;

 import org.melati.poem.Database;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.PoemException;

 import org.melati.poem.PoemThread;

 import org.melati.poem.util.EnumUtils;

 import org.paneris.bibliomania.generated.StockingsSearchTableBase;

 public class StockingsSearchTable<T extends StockingsSearch> extends StockingsSearchTableBase<StockingsSearch> {

   public BibliomaniaDatabase getBibliomaniaDatabase () {

       return (BibliomaniaDatabase)getDatabase();

   }

   public StockingsSearchTable(

       Database database, String name,

       DefinitionSource definitionSource) throws PoemException {

     super(database, name, definitionSource);

   }

   // protected Integer troidFor(Persistent persistent) {

   //     Integer it = new Integer(troidColumn().firstFree(null));

   //     return it;

   //   }

   private void trim() {

     int excess =

         count(null) - getBibliomaniaDatabase().getBookStockingsCacheSizeMax();

     if (excess > 5) {

       Vector togo = EnumUtils.vectorOf(

                         selection(null, "lastaccessed LIMIT " + excess, false));

       try {

         for (Enumeration s = togo.elements(); s.hasMoreElements();)

           ((StockingsSearch)s.nextElement()).delete_unsafe();

       }

       finally {

         PoemThread.commit();

       }

     }

   }

   public StockingsSearch searchFor(String author, String title) {

     if (author == null) author = "";

     if (title == null) title = "";

     StockingsSearch it;

     boolean created;

     synchronized (this) {

       it = (StockingsSearch)firstSelection(

                getTitletermColumn().eqClause(title) + " AND " +

                getAuthortermColumn().eqClause(author));

       if (it == null) {

         it = (StockingsSearch)newPersistent();

         it.setTitleterm(title);

         it.setAuthorterm(author);

         it.makePersistent();

         created = true;

       }

       else

         created = false;

     }

     if (created)

       trim();

     it.setLastaccessed(new Timestamp(System.currentTimeMillis()));

     PoemThread.commit();

     return it;

   }

   public StockingsSearch searchFor(Book book) {

     return searchFor(book.getAuthor().getLongname(), book.getFulltitle());

   }

   public StockingsSearch searchFor(Author author) {

     return searchFor(author.getLongname(), "");

   }

 }