JSONQuery Class Reference

Inheritance diagram for JSONQuery:

Collaboration diagram for JSONQuery:

Public Member Functions
	__construct ($class, $constraints="")
	groupBy ($groupBy)
	execute ()
	executeSingle ()
	executeRaw ()
Public Member Functions inherited from AbstractQuery
	constraints ($constraints)
	Sets the constraint clause for the Query. More...
	filter ($filter)
	Sets a filter to constrain the fields retrieved when the query is executed. More...
	params ($params)
	Sets the bound parameters array. More...
	bind ()
	Binds placeholders to parameter values. More...

Static Public Member Functions
static	create ($class, $constraints="")

Public Attributes
	$groupBy
Public Attributes inherited from AbstractQuery
	$class
	$constraints
	$filter
	$params

Detailed Description

Definition at line 39 of file json_query.inc.

Constructor & Destructor Documentation

__construct()

JSONQuery::__construct	(		$class,
			$constraints = ""
	)

Reimplemented from AbstractQuery.

Definition at line 43 of file json_query.inc.

     {
          parent::__construct($class, $constraints);
          $this->groupBy = $groupBy;
     }

Member Function Documentation

create()

static JSONQuery::create (   $class,   $constraints = ""  )

static

Definition at line 132 of file json_query.inc.

     {
          return new JSONQuery($class, $constraints);
     }

execute()

JSONQuery::execute

(

)

Reimplemented from AbstractQuery.

Definition at line 55 of file json_query.inc.

     {
          $json = $this->executeRaw();
          if (!$json) return null;
          
          $json = json_decode($json);
     
          if (is_object($json)) $json = array($json);
          $items = array();
          foreach($json as $jsonItem)
          {
               $item = new $this->class;
               $item->filter = $this->filter;
               $item->fromJSON($jsonItem);
               
               $items[] = $item;
          }
          
          return $items;
     }

executeRaw()

JSONQuery::executeRaw

(

)

Definition at line 96 of file json_query.inc.

     {
          $json = null;
          
          $query = $this->constraints;
          if (!startsWith($query, "SELECT ")) $query = "SELECT $query";
          
          try
          {
               $db = ConnectionManager::getConnection();
               
               $result = $db->prepare($query);
               $result->execute($this->params);
 
               trace($query, 1);
               
               $line = $result->fetch();
               trace(print_r($line, true), 1);
               
               if ($line)
               {
                    $json = $line[0];
               }
          
               unset($result);
          }
          catch(PDOException $e)
          {
               $err = "JSONQuery failed - " . $e->getMessage();
               trace($err, 2);
               throw new DataItemException($err);
          }
          
          return $json;
     }

executeSingle()

JSONQuery::executeSingle

(

)

Definition at line 76 of file json_query.inc.

     {
          $json = $this->executeRaw();
          trace(print_r($json, true), 1);
          if (!$json) return null;
          
          if (is_array($json))
          {
               throw new FakoliException("Ambiguous Singleton Query - JSON");
          }
     
          $item = new $this->class;
          $item->filter = $this->filter;
          $item->fromJSON($json);
     
          trace(print_r($item, true), 1);
          
          return $item;
     }

groupBy()

JSONQuery::groupBy

(

$groupBy

)

Definition at line 49 of file json_query.inc.

     {
          $this->groupBy = $groupBy;
          return $this;
     }

Member Data Documentation

$groupBy

JSONQuery::$groupBy

Definition at line 41 of file json_query.inc.

---

The documentation for this class was generated from the following file:

• C:/code/cms.sonjara.com/framework/json_query.inc