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(); 

     }

   }

 }