C:/xampp/htdocs/moodle/lib/zend/Zend/Service/WindowsAzure/Storage/TableEntityQuery.php

Go to the documentation of this file.

<?php
class Zend_Service_WindowsAzure_Storage_TableEntityQuery
{
        protected $_from  = '';
        
        protected $_where = array();
        
        protected $_orderBy = array();
        
        protected $_top = null;
        
        protected $_partitionKey = null;

        protected $_rowKey = null;
        
        public function select()
        {
                return $this;
        }
        
        public function from($name)
        {
                $this->_from = $name;
                return $this;
        }
        
        public function wherePartitionKey($value = null)
        {
            $this->_partitionKey = $value;
            return $this;
        }
        
        public function whereRowKey($value = null)
        {
            $this->_rowKey = $value;
            return $this;
        }
        
        public function where($condition, $value = null, $cond = '')
        {
            $condition = $this->_replaceOperators($condition);
            
            if (!is_null($value)) {
                $condition = $this->_quoteInto($condition, $value);
            }
            
                if (count($this->_where) == 0) {
                        $cond = '';
                } else if ($cond !== '') {
                        $cond = ' ' . strtolower(trim($cond)) . ' ';
                }
                
                $this->_where[] = $cond . $condition;
                return $this;
        }

        public function andWhere($condition, $value = null)
        {
                return $this->where($condition, $value, 'and');
        }
        
        public function orWhere($condition, $value = null)
        {
                return $this->where($condition, $value, 'or');
        }
        
        public function orderBy($column, $direction = 'asc')
        {
                $this->_orderBy[] = $column . ' ' . $direction;
                return $this;
        }
    
    public function top($top = null)
    {
        $this->_top  = (int)$top;
        return $this;
    }
        
        public function assembleQueryString($urlEncode = false)
        {
                $query = array();
                if (count($this->_where) != 0) {
                    $filter = implode('', $this->_where);
                        $query[] = '$filter=' . ($urlEncode ? urlencode($filter) : $filter);
                }
                
                if (count($this->_orderBy) != 0) {
                    $orderBy = implode(',', $this->_orderBy);
                        $query[] = '$orderby=' . ($urlEncode ? urlencode($orderBy) : $orderBy);
                }
                
                if (!is_null($this->_top)) {
                        $query[] = '$top=' . $this->_top;
                }
                
                if (count($query) != 0) {
                        return '?' . implode('&', $query);
                }
                
                return '';
        }
        
        public function assembleFrom($includeParentheses = true)
        {
            $identifier = '';
            if ($includeParentheses) {
                $identifier .= '(';
                
                if (!is_null($this->_partitionKey)) {
                    $identifier .= 'PartitionKey=\'' . $this->_partitionKey . '\'';
                }
                    
                if (!is_null($this->_partitionKey) && !is_null($this->_rowKey)) {
                    $identifier .= ', ';
                }
                    
                if (!is_null($this->_rowKey)) {
                    $identifier .= 'RowKey=\'' . $this->_rowKey . '\'';
                }
                    
                $identifier .= ')';
            }
                return $this->_from . $identifier;
        }
        
        public function assembleQuery()
        {
                $assembledQuery = $this->assembleFrom();
                
                $queryString = $this->assembleQueryString();
                if ($queryString !== '') {
                        $assembledQuery .= $queryString;
                }
                
                return $assembledQuery;
        }
        
        protected function _quoteInto($text, $value = null)
        {
                if (!is_array($value)) {
                $text = str_replace('?', '\'' . addslashes($value) . '\'', $text);
            } else {
                $i = 0;
                while(strpos($text, '?') !== false) {
                    if (is_numeric($value[$i])) {
                        $text = substr_replace($text, $value[$i++], strpos($text, '?'), 1);
                    } else {
                        $text = substr_replace($text, '\'' . addslashes($value[$i++]) . '\'', strpos($text, '?'), 1);
                    }
                }
            }
            return $text;
        }
        
        protected function _replaceOperators($text)
        {
            $text = str_replace('==', 'eq',  $text);
            $text = str_replace('>',  'gt',  $text);
            $text = str_replace('<',  'lt',  $text);
            $text = str_replace('>=', 'ge',  $text);
            $text = str_replace('<=', 'le',  $text);
            $text = str_replace('!=', 'ne',  $text);
            
            $text = str_replace('&&', 'and', $text);
            $text = str_replace('||', 'or',  $text);
            $text = str_replace('!',  'not', $text);
            
            return $text;
        }
        
        public function __toString()
        {
                return $this->assembleQuery();
        }
}