<?php
// ==================================================================
//
// WARNING : Do not edit this file by hand.  This file was created
// by SoProMach.  Edit the definition files and re-generate to make
// modifications.  Making modifications to this file directly will
// result in loss of work when the file is re-generated.
//
// ==================================================================
//
// ReviewerSS.php

require_once("pgdb.php");

require_once("ReviewerValue.php"); 

  // ===================================================================
  // SQL selects for each value object
  define('ReviewerSelectReviewerValue' ,"select Reviewer1.reviewerId,Reviewer1.name,Reviewer1.nickname,Reviewer1.age,Reviewer1.mainInterest from Reviewer Reviewer1  ");


class ReviewerSS {
  // ===================================================================
  // SS methods
  
  //--------------------------------------------------------------------
  function getReviewerValue(
    $reviewerId
    ) 
  {
      $params = array();
      $params[] = $reviewerId;
  
       $sql = ReviewerSelectReviewerValue
           . " where "
           . "  Reviewer1.reviewerId = ? "
        ;

      return
       pgdb_firstRow(
         pgdb_runSqlP($sql,
            create_function('$rs',
                '$t = new ReviewerValue(); $t->setFromRow($rs); return $t;'),$params
       )
      );
   
  }
  
  //--------------------------------------------------------------------
  /**
    * returns array of ReviewerValue
    */
  function getAllReviewerValue(
    $orderBy
    ) 
  {
      $params = array();
  
       $sql = ReviewerSelectReviewerValue
        ;

      if(!empty($orderBy)){
        $sql = $sql . " order by " . $orderBy;
      }

      return
         pgdb_runSqlP($sql,
            create_function('$rs',
                '$t = new ReviewerValue(); $t->setFromRow($rs); return $t;'),$params
      );
   
  }
  
  //--------------------------------------------------------------------
  function add(
    $value
    ) 
  {

    $sql = "insert into Reviewer ( " . 
       "reviewerId " .
       ",name " .
       ",nickname " .
       ",age " .
       ",mainInterest " .
      " ) values ( " .
       "nextval('Reviewer_reviewerId_seq') " .
       ",? " .
       ",? " .
       ",? " .
       ",? " .
      ")";

    $params = array();
    $params[] = $value->getName();
    $params[] = $value->getNickname();
    $params[] = $value->getAge();
    $params[] = $value->getMainInterest();
     
    pgdb_runSqlP($sql,null,$params);
   
  }
  
  //--------------------------------------------------------------------
  function update(
    $value
    ) 
  {

    $sql = "update Reviewer set " .
       "name = ? " .
       ",nickname = ? " .
       ",age = ? " .
       ",mainInterest = ? " .
       " where " .
       "reviewerId = ? " .
       "";
    $params = array();
    $params[] = $value->getName();
    $params[] = $value->getNickname();
    $params[] = $value->getAge();
    $params[] = $value->getMainInterest();
    $params[] = $value->getReviewerId();
     
    pgdb_runSqlP($sql,null,$params);
   
  }
  
  //--------------------------------------------------------------------
  function delete(
    $reviewerId
    ) 
  {

    $sql = "delete from Reviewer where " .
       "reviewerId = ? " .
       "";
    $params = array();
    $params[] = $reviewerId;

    pgdb_runSqlP($sql,null,$params);
   
  }

}

//
// ==================================================================
//
// WARNING : Do not edit this file by hand.  This file was created
// by SoProMach.  Edit the definition files and re-generate to make
// modifications.  Making modifications to this file directly will
// result in loss of work when the file is re-generated.
//
// ==================================================================
?>