Ejemplo n.º 1
0
 /**
  * @dataProvider getBogusFilters
  * @group Core
  * @group SegmentExpression
  */
 public function testBogusFiltersExpectExceptionThrown($bogus)
 {
     try {
         $segment = new Piwik_SegmentExpression($bogus);
         $segment->parseSubExpressions();
         $segment->getSql();
     } catch (Exception $e) {
         return;
     }
     $this->fail('Expected exception not raised');
 }
Ejemplo n.º 2
0
 public function test_bogusFilters_expectExceptionThrown()
 {
     $boguses = array('A=B', 'C!D', '', '      ', ',;,', ',', ',,', '===', '!=');
     foreach ($boguses as $bogus) {
         $segment = new Piwik_SegmentExpression($bogus);
         try {
             $segment->parseSubExpressions();
             $processed = $segment->getSql();
             $this->fail('expecting exception ' . $bogus);
         } catch (Exception $e) {
             $this->pass();
         }
     }
 }
Ejemplo n.º 3
0
 /**
  * Extend SQL query with segment expressions
  * 
  * @param string select clause
  * @param array of table names (without prefix)
  * @param string where clause
  * @param string (optional) order by clause
  * @param string (optional) group by clause
  * @return string entire select query
  */
 public function getSelectQuery($select, $from, $where = false, $bind = array(), $orderBy = false, $groupBy = false)
 {
     $joinWithSubSelect = false;
     if (!is_array($from)) {
         $from = array($from);
     }
     if (!$this->isEmpty()) {
         $this->segment->parseSubExpressionsIntoSqlExpressions($from);
         $joins = $this->generateJoins($from);
         $from = $joins['sql'];
         $joinWithSubSelect = $joins['joinWithSubSelect'];
         $segmentSql = $this->segment->getSql();
         $segmentWhere = $segmentSql['where'];
         if (!empty($segmentWhere)) {
             if (!empty($where)) {
                 $where = "( {$where} )\n\t\t\t\tAND\n\t\t\t\t({$segmentWhere})";
             } else {
                 $where = $segmentWhere;
             }
         }
         $bind = array_merge($bind, $segmentSql['bind']);
     } else {
         $joins = $this->generateJoins($from);
         $from = $joins['sql'];
         $joinWithSubSelect = $joins['joinWithSubSelect'];
     }
     if ($joinWithSubSelect) {
         $sql = $this->buildWrappedSelectQuery($select, $from, $where, $orderBy, $groupBy);
     } else {
         $sql = $this->buildSelectQuery($select, $from, $where, $orderBy, $groupBy);
     }
     $return = array('sql' => $sql, 'bind' => $bind);
     //var_dump($return);
     return $return;
 }
Ejemplo n.º 4
0
 public function getSql()
 {
     if ($this->isEmpty()) {
         return array('sql' => '', 'bind' => array());
     }
     $this->segment->parseSubExpressionsIntoSqlExpressions();
     return $this->segment->getSql();
 }
Ejemplo n.º 5
0
 public function getSql( $fieldsAvailableInTable = array(), $joinedTableName = false)
 {
 	if($this->isEmpty())
 	{
 		return array('sql' => '', 'bind' => array(), 'sql_join_visits' => '');
 	}
     $this->segment->parseSubExpressionsIntoSqlExpressions($fieldsAvailableInTable, $joinedTableName);
     
     $return = $this->segment->getSql();
     
     $return['sql_join_visits'] = '';
     if(!empty($fieldsAvailableInTable))
     {
     	if(!$this->isSegmentAvailable($fieldsAvailableInTable))
     	{
     		$return['sql_join_visits'] = "LEFT JOIN ".Piwik_Common::prefixTable('log_visit')." AS log_visit USING(idvisit)";
     	}
     }
     return $return;
 }