web/private_php/ams/autoload/querycache.php

   1 <?php
   2
   3 /**
   4 * class for storing changes when shard is offline.
   5 * @todo make sure that the querycache class is being used by the sync class and also for inserting the queries themselfs into it.
   6 * Atm this class isn't used yet if I remember correctly
   7 * @author Daan Janssens, mentored by Matthew Lagoe
   8 */
   9
  10 class Querycache{
  11
  12     private $SID;  /**< The queries ID */
  13     private $type;  /**< The type of query*/
  14     private $query;  /**< The query itself (json encoded) */
  15     private $db;  /**< the db where the query  should be performed */
  16
  17     ////////////////////////////////////////////Functions////////////////////////////////////////////////////
  18
  19
  20
  21     ////////////////////////////////////////////Methods////////////////////////////////////////////////////
  22
  23
  24     /**
  25     * A constructor.
  26     * Empty constructor
  27     */
  28     public function __construct() {
  29     }
  30
  31     /**
  32     * sets the object's attributes.
  33     * @param $values should be an array of the form array('SID' => sid, 'type' => type, 'query' => query, 'db' => db).
  34     */
  35     public function set($values) {
  36         $this->setSID($values['SID']);
  37         $this->setType($values['type']);
  38         $this->setQuery($values['query']);
  39         $this->setDb($values['db']);
  40     }
  41
  42
  43     /**
  44     * loads the object's attributes.
  45     * loads the object's attributes by giving a SID as parameter
  46     * @param $id the id of the querycaches row
  47     */
  48     public function load_With_SID( $id) {
  49         $dbl = new DBLayer("lib");
  50         $statement = $dbl->select("ams_querycache", array('id' => $id), "SID=:id");
  51         $row = $statement->fetch();
  52         $this->set($row);
  53     }
  54
  55
  56     /**
  57     * updates the entry.
  58     */
  59     public function update(){
  60         $dbl = new DBLayer("lib");
  61         $dbl->update("ams_querycache", Array('type' => $this->getType(), 'query' => $this->getQuery(), 'db' => $this->getDb(), "SID=$this->getSID()" ));
  62     }
  63
  64     ////////////////////////////////////////////Getters////////////////////////////////////////////////////
  65
  66     /**
  67     * get SID attribute of the object.
  68     */
  69     public function getSID(){
  70         return $this->SID;
  71     }
  72
  73     /**
  74     * get type attribute of the object.
  75     */
  76     public function getType(){
  77         return $this->type;
  78     }
  79
  80     /**
  81     * get query attribute of the object.
  82     */
  83     public function getQuery(){
  84         return $this->query;
  85     }
  86
  87     /**
  88     * get db attribute of the object.
  89     */
  90     public function getDb(){
  91         return $this->db;
  92     }
  93
  94     ////////////////////////////////////////////Setters////////////////////////////////////////////////////
  95
  96     /**
  97     * set SID attribute of the object.
  98     * @param $s integer id
  99     */
 100     public function setSID($s){
 101         $this->SID = $s;
 102     }
 103
 104     /**
 105     * set type attribute of the object.
 106     * @param $t type of the query, could be changePassword, changePermissions, changeEmail, createUser
 107     */
 108     public function setType($t){
 109         $this->type = $t;
 110     }
 111
 112     /**
 113     * set query attribute of the object.
 114     * @param $q query string
 115     */
 116     public function setQuery($q){
 117         $this->query= $q;
 118     }
 119
 120     /**
 121     * set db attribute of the object.
 122     * @param $d the name of the database in the config global var that we want to use.
 123     */
 124     public function setDb($d){
 125         $this->db= $d;
 126     }
 127
 128 }