Example #1
0
 /**
  * Implementation for 'GET' method for Rest API
  *
  * @param  mixed $repVarUid Primary key
  *
  * @return array $result Returns array within multiple records or a single record depending if
  *                       a single selection was requested passing id(s) as param
  */
 protected function get($repVarUid = null)
 {
     $result = array();
     try {
         $noArguments = true;
         $argumentList = func_get_args();
         foreach ($argumentList as $arg) {
             if (!is_null($arg)) {
                 $noArguments = false;
             }
         }
         if ($noArguments) {
             $criteria = new Criteria('workflow');
             $criteria->addSelectColumn(ReportVarPeer::REP_VAR_UID);
             $criteria->addSelectColumn(ReportVarPeer::PRO_UID);
             $criteria->addSelectColumn(ReportVarPeer::REP_TAB_UID);
             $criteria->addSelectColumn(ReportVarPeer::REP_VAR_NAME);
             $criteria->addSelectColumn(ReportVarPeer::REP_VAR_TYPE);
             $dataset = AppEventPeer::doSelectRS($criteria);
             $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
             while ($dataset->next()) {
                 $result[] = $dataset->getRow();
             }
         } else {
             $record = ReportVarPeer::retrieveByPK($repVarUid);
             if ($record) {
                 $result = $record->toArray(BasePeer::TYPE_FIELDNAME);
             } else {
                 $paramValues = "";
                 foreach ($argumentList as $arg) {
                     $paramValues .= strlen($paramValues) ? ', ' : '';
                     if (!is_null($arg)) {
                         $paramValues .= "{$arg}";
                     } else {
                         $paramValues .= "NULL";
                     }
                 }
                 throw new RestException(417, "table ReportVar ({$paramValues})");
             }
         }
     } catch (RestException $e) {
         throw new RestException($e->getCode(), $e->getMessage());
     } catch (Exception $e) {
         throw new RestException(412, $e->getMessage());
     }
     return $result;
 }
Example #2
0
 /**
  * Remove the report var registry
  * @param array $aData
  * @return string
  **/
 public function remove($sRepVarUid)
 {
     $oConnection = Propel::getConnection(ReportVarPeer::DATABASE_NAME);
     try {
         $oReportVar = ReportVarPeer::retrieveByPK($sRepVarUid);
         if (!is_null($oReportVar)) {
             $oConnection->begin();
             $iResult = $oReportVar->delete();
             $oConnection->commit();
             return $iResult;
         } else {
             throw new Exception('This row doesn\'t exist!');
         }
     } catch (Exception $oError) {
         $oConnection->rollback();
         throw $oError;
     }
 }