package org.paneris.jammyjoes.model;

 import java.sql.ResultSet;

 import org.melati.poem.Database;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.PoemException;

 import org.paneris.jammyjoes.model.generated.SexTableBase;

 /**

  * Melati POEM generated, programmer modifiable stub 

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

  * <p>

  * Description: 

  *   Sex. 

  * </p>

  *

  * 

  * <table> 

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

  * Field summary for SQL table <code>Sex</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> sex </td><td> String </td><td> &nbsp; </td></tr> 

  * </table> 

  * 

  * @generator  org.melati.poem.prepro.TableDef#generateTableMainJava 

  */

 public class SexTable extends SexTableBase {

   Sex boy;

   Sex girl;

   public SexTable(

       Database database, String name,

       DefinitionSource definitionSource) throws PoemException {

     super(database, name, definitionSource);

   }

   public synchronized void unifyWithDB(ResultSet colDescs)

      throws PoemException {

    super.unifyWithDB(colDescs);

    boy = ensure("Boy");

    girl = ensure("Girl");

  }

  public Sex ensure(String s) {

    Sex sex = (Sex)getSexColumn().firstWhereEq(s);

    if (sex != null)

      return sex;

    else {

      sex = (Sex)newPersistent();

      sex.setSex(s);

      return (Sex)getSexColumn().ensure(sex);  

    }

  }

  public Sex getBoy() {

    return boy;

  }

  public Sex getGirl() {

    return girl;

  }

 }