Exemplo n.º 1
0
 /**
  * 
  * @param PCMapper $mapper
  * @param PCDatabaseQueryCondition $condition
  * @param PCDatabaseQueryLimit $limit
  * @param PCDatabaseQueryOrder $oder
  */
 public static function withMapper($mapper, $condition = NULL, $limit = NULL, $order = NULL)
 {
     return new PCDatabaseSelectQuery($mapper->getTableName(), $mapper->getRequiredAttributes(), $condition, $limit, $order);
 }
Exemplo n.º 2
0
 /**
  * Returns an array of instanced subclass of PCModelObject according to $name
  * @param PCMapper $mapper a subclass of PCMapper
  * @param array $keys a key value array of elements for filtering search in database
  * @param array $optionalAttributes an array of strings containing the names of the optional fields to fetch
  * @param boolean $useCache if use the cache or not
  * @param string $limit the sql query limit
  * @param string $order the order specification
  * @return array an array of instanced subclass of PCModelObject according to $name
  */
 public static function fetchModelObjectInstances($mapper, $keys, $optionalAttributes = null, $useCache = false, $limit = null, $order = NULL)
 {
     /* if(empty($keys)){
        throw new Exception("Illegal argument, \"keys\" is empty");
        } */
     if ($mapper == null) {
         throw new Exception("Mapper must not be null");
     }
     $required_field = $mapper->getRequiredAttributes();
     if ($useCache && isset($keys['identifier'])) {
         $identifier = $keys['identifier'];
         $cache = PCCache::cacheProvider();
         //error_log("GETTING : " . $mapper->getCacheKey($keys));
         $item = $cache->getItem($mapper->getCacheKey($keys));
         if (isset($item) && $item !== FALSE) {
             //error_log("GETTED : " . $mapper->getCacheKey($keys));
             return $item;
         }
     }
     $fields = NULL;
     //unisco parametri opzionali (se presenti) a parametri richiesti
     if ($optionalAttributes == null) {
         $fields = $required_field;
     } else {
         $fields = array_merge($optionalAttributes, $required_field);
     }
     //creo stringa da parametri separati da virgola
     $fields_string = implode(",", $fields);
     $table_name = $mapper->getTableName();
     $select_stm = "SELECT " . $fields_string . " FROM " . $table_name . " WHERE ";
     $prepared_keys_array = array();
     $count = 0;
     $tot = count($keys);
     foreach ($keys as $key => $value) {
         $count++;
         $placeHolder = ":{$key}";
         $select_stm .= $count == $tot ? " {$key} = {$placeHolder} " : " {$key} = {$placeHolder} AND ";
         $prepared_keys_array[$placeHolder] = $value;
     }
     if ($tot == NULL) {
         $select_stm .= " TRUE";
     }
     if (isset($order)) {
         $select_stm .= ' ORDER BY ' . $order;
     }
     if (isset($limit)) {
         $select_stm .= ' LIMIT ' . $limit;
     }
     $pdo = PCDatabase::getSharedDatabaseConnection();
     $prepared = $pdo->prepare($select_stm);
     if ($prepared->execute($prepared_keys_array) == FALSE) {
         $message = "Errore database: (" . $prepared->errorCode() . ") " . $prepared->errorInfo()[1] . " " . $prepared->errorInfo()[2];
         throw new Exception($message);
     }
     $result = null;
     $toReturn = array();
     while (($result = $prepared->fetch(PDO::FETCH_ASSOC)) != NULL) {
         $toReturn[] = $mapper->getMappedInstance($result);
     }
     if ($useCache && count($toReturn) == 1) {
         $identifier = $keys['identifier'];
         //error_log("STORING: " . $mapper->getCacheKey($keys));
         PCCache::cacheProvider()->setItem($toReturn, $mapper->getCacheKey($keys), 300);
     }
     $prepared = NULL;
     return $toReturn;
 }
Exemplo n.º 3
0
 /**
  * 
  * @param PCMapper $mapper
  * @param array $values
  * @param PCDatabaseQueryCondition $condition
  * @return PCDatabaseUpdateQuery
  */
 public static function withMapper($mapper, $values, $condition = NULL) {
     return new PCDatabaseUpdateQuery($mapper->getTableForInsertUpdate(), $values, $condition);
 }