package org.paneris.bibliomania;

 import java.sql.ResultSet;

 import org.paneris.bibliomania.generated.BoardTypeTableBase;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.Database;

 import org.melati.poem.PoemException;

 /**

  * Melati POEM generated, programmer modifiable stub 

  * for a <code>BoardTypeTable</code> object.

  *

  * 

  * <table> 

  * <tr><th colspan='3'>

  * Field summary for SQL table <code>BoardType</code>

  * </th></tr>

  * <tr><th>Name</th><th>Type</th><th>Description</th></tr>

  * </table> 

  * 

  * see  org.melati.poem.prepro.TableDef#generateTableJava 

  */

 public class BoardTypeTable<T extends BoardType> extends BoardTypeTableBase<BoardType> {

  /**

   * 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 BoardTypeTable(

       Database database, String name,

       DefinitionSource definitionSource) throws PoemException {

     super(database, name, definitionSource);

   }

   // programmer's domain-specific code here

   protected BoardType general;

   protected BoardType sectionGroup;

   protected BoardType section;

   protected BoardType author;

   protected BoardType book;

   protected BoardType chapter;

   public synchronized void unifyWithDB(ResultSet colDescs)

       throws PoemException {

     super.unifyWithDB(colDescs,"id");

      general =  ensure("General","Top level boards");

      sectionGroup = ensure("SectionGroup","SectionGroup messageboard");

      section = ensure("Section","Section messageboard");

      author = ensure("Author","Author messageboard");

      book = ensure("Book","Book messageboard");

      chapter = ensure("Chapter","Chapter messageboard");

   }

   public BoardType ensure(String type, String description) {

     BoardType t = (BoardType)newPersistent();

     t.setType(type);

     t.setDescription(description);

     return (BoardType)getTypeColumn().ensure(t);

   }

   public BoardType general() {

     return general;

   }

   public BoardType sectionGroup() {

     return sectionGroup;

   }

   public BoardType section() {

     return section;

   }

   public BoardType author() {

     return author;

   }

   public BoardType book() {

     return book;

   }

   public BoardType chapter() {

     return chapter;

   }

 }