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(), "");
    }
  }