package org.paneris.bibliomania;
   
   import java.util.Enumeration;
   
   import org.paneris.bibliomania.generated.AuthorWebSiteTableBase;
   import org.melati.poem.DefinitionSource;
   import org.melati.poem.Database;
   import org.melati.poem.Persistent;
   import org.melati.poem.PoemException;
  
  /**
   * Melati POEM generated, programmer modifiable stub 
   * for a <code>AuthorWebSiteTable</code> object.
   * <p>
   * Description: 
   *   A web site devoted to an author. 
   * </p>
   *
   * 
   * <table> 
   * <tr><th colspan='3'>
   * Field summary for SQL table <code>AuthorWebSite</code>
   * </th></tr>
   * <tr><th>Name</th><th>Type</th><th>Description</th></tr>
   * <tr><td> id </td><td> Integer </td><td> &nbsp; </td></tr> 
   * <tr><td> author </td><td> Author </td><td> The author to whom the site is 
   * dedicated </td></tr> 
   * <tr><td> url </td><td> String </td><td> The full URL for the site's front 
   * page </td></tr> 
   * <tr><td> displayname </td><td> String </td><td> The site's name </td></tr> 
   * <tr><td> displayorder </td><td> Integer </td><td> &nbsp; </td></tr> 
   * <tr><td> description </td><td> String </td><td> &nbsp; </td></tr> 
   * </table> 
   * 
   * @see  org.melati.poem.prepro.TableDef#generateTableJava 
   */
  public class AuthorWebSiteTable<T extends AuthorWebSite> extends AuthorWebSiteTableBase<AuthorWebSite> {
  
   /**
    * Constructor.
    * 
    * @see org.melati.poem.prepro.TableDef#generateTableJava 
    * @param database          the POEM database we are using
    * @param name              the name of this <code>Table</code>
    * @param definitionSource  which definition is being used
    * @throws PoemException    if anything goes wrong
    */
    public AuthorWebSiteTable(
        Database database, String name,
        DefinitionSource definitionSource) throws PoemException {
      super(database, name, definitionSource);
    }
  
    // programmer's domain-specific code here
    
    public AuthorWebSite ensure(Author a, String url, String name, String description) {
      System.err.println("Entering Ensure for " + name);
      
      AuthorWebSite criteria = (AuthorWebSite)newPersistent();
      criteria.setAuthor(a);
      Enumeration<AuthorWebSite> existing = selection(criteria, "displayorder");
      System.err.println("Got existing");
      int order = 1;
      while (existing.hasMoreElements()) { 
        System.err.println("Order:" + order);
        existing.nextElement();
        order++;
      }
      criteria.setUrl(url);
      criteria.setDisplayname(name);
      criteria.setDescription(description);
      
      Enumeration<AuthorWebSite> some = selection(criteria);
      if (some.hasMoreElements()) { 
        return some.nextElement();
      } else { 
        criteria.setDisplayorder(order);
        create(criteria);
        return criteria;
      }
    }
    
    public void ensureStillValid() {
      Enumeration them = selection();
      while(them.hasMoreElements()) { 
       ((AuthorWebSite)them.nextElement()).isStillLive(); 
      }
    }
  }