WordPressQueryProvider - Code Metrics - Qeti/POData - Measure and Improve Code Quality continuously with Scrutinizer

WordPressQueryProvider D
last analyzed 2017-02-19 06:57 UTC

↳ Parent: Project

Complexity

Total Complexity

114

Size/Duplication

Total Lines	891
Duplicated Lines	28.73 %

Coupling/Cohesion

Components	2
Dependencies	9

Importance

Changes

Metric	Value
wmc	114
lcom	2
cbo	9
dl	256
loc	891
rs	4.4444
c	0
b	0
f	0

18 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	10	2
A	handlesOrderedPaging()	0	4	1
A	getExpressionProvider()	0	8	2
C	getResourceSet()	30	70	16
D	getResourceFromResourceSet()	34	98	17
D	getRelatedResourceSet()	78	157	27
D	getResourceFromRelatedResourceSet()	54	122	15
C	getRelatedResourceReference()	0	69	12
A	_serializePosts()	0	9	2
B	_serializePost()	24	54	5
A	_serializeTags()	9	9	2
A	_serializeTag()	0	9	1
A	_serializeCategories()	9	9	2
A	_serializeCategory()	0	9	1
A	_serializeComments()	0	9	2
B	_serializeComment()	12	33	3
A	_serializeUsers()	0	9	2
A	_serializeUser()	6	20	2

How to fix Duplicated Code Complexity

Duplicated Code

Duplicate code is one of the most pungent code smells. A rule that is often used is to re-structure code once it is duplicated in three or more places.

Common duplication problems, and corresponding solutions are:

If you have the same expression in different places: Extract expression to a method
If you have the same method in different sub-classes: Extract method, and pull up field to the parent class
If you have the same code in unrelated classes: Consider extracting the code to a new class, and injecting that class

Complex Class

Tip: Before tackling complexity, make sure that you eliminate any duplication first. This often can reduce the size of classes significantly.

Complex classes like WordPressQueryProvider often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes. You can also have a look at the cohesion graph to spot any un-connected, or weakly-connected components.

Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.

While breaking up the class, it is a good idea to analyze how other classes use WordPressQueryProvider, and based on these observations, apply Extract Interface, too.

<?php


use POData\UriProcessor\ResourcePathProcessor\SegmentParser\KeyDescriptor;
use POData\Providers\Metadata\ResourceSet;
use POData\Providers\Metadata\ResourceProperty;
use POData\Providers\Query\IQueryProvider;
require_once "WordPressMetadata.php";
require_once "POData\Providers\Query\IDataServiceQueryProvider2.php";

/** The name of the database for WordPress */
define('DB_NAME', 'wordpress');

/** MySQL database username */
define('DB_USER', 'root');

/** MySQL database password */
define('DB_PASSWORD', 'root');

/** MySQL hostname */
define('DB_HOST', 'localhost');


class WordPressQueryProvider implements IQueryProvider
namespace YourVendor;

class YourClass { }
{
    /**
     * Handle to connection to Database     
     */
    private $_connectionHandle = null;

    /**
     * Reference to the custom expression provider
     *
     * @var NorthWindDSExpressionProvider
     */
    private $_wordPressMySQLExpressionProvider;
    
    /**
     * Constructs a new instance of WordPressQueryProvider
     * 
     */
    public function __construct()
    {
        $this->_connectionHandle = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, true);
        if ( $this->_connectionHandle ) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
        } else {             
             die(print_r(mysql_error(), true));

        } 

        mysql_select_db(DB_NAME, $this->_connectionHandle);
    }

    /**
     * (non-PHPdoc)
     * @see POData\Providers\Query.IQueryProvider::canApplyQueryOptions()
     */
    public function handlesOrderedPaging()
    {
        return true;
    }

    /**
     * (non-PHPdoc)
     * @see POData\Providers\Query.IQueryProvider::getExpressionProvider()
     */
    public function getExpressionProvider()
    {
    	if (is_null($this->_wordPressMySQLExpressionProvider)) {
    		$this->_wordPressMySQLExpressionProvider = new WordPressDSExpressionProvider();

    	}
    	
    	return $this->_wordPressMySQLExpressionProvider;
    }
    
    /**
     * Gets collection of entities belongs to an entity set
     * 
     * @param ResourceSet      $resourceSet   The entity set whose 
     *                                        entities needs to be fetched
     * @param string           $filterOption  Contains the filter condition
/**
 * @param array $germany
 * @param array $ireland
 */
function finale($germany, $island) {
    return "2:1";
}
     * @param string           $select        For future purpose,no need to pass it
     * @param string           $orderby       For future purpose,no need to pass it
     * @param string           $top           For future purpose,no need to pass it
     * @param string           $skip          For future purpose,no need to pass it
     * 
     * @return array(Object)

     */
    public function getResourceSet(ResourceSet $resourceSet,$filter=null,$select=null,$orderby=null,$top=null,$skip=null)
    {   
        $resourceSetName =  $resourceSet->getName();
        if ($resourceSetName !== 'Posts' 

            && $resourceSetName !== 'Tags' 
            && $resourceSetName !== 'Categories' 
            && $resourceSetName !== 'Comments' 
            && $resourceSetName !== 'Users'
        ) {
            die('(WordPressQueryProvider) Unknown resource set ' . $resourceSetName);

        }

       
        $returnResult = array();
        switch ($resourceSetName) {
        case 'Posts':
            $query = "SELECT * FROM `wp_posts` WHERE"
                   ." wp_posts.post_type = 'post'"
                   ." AND wp_posts.post_status = 'publish'";
            if ($filter !== null) {
                $query .= " AND $filter";
            }
            $stmt = mysql_query($query); 
            $returnResult = $this->_serializePosts($stmt);     
            break;                   
        case 'Tags':

            $query = "SELECT t.*, tt.description"
                   ." FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt"
                   ." ON tt.term_id = t.term_id"
                   ." WHERE tt.taxonomy = 'post_tag'";
            if ($filter !== null) {
                $query .= " AND $filter";
            }
            $stmt = mysql_query($query);
            $returnResult = $this->_serializeTags($stmt);       
            break;
        case 'Categories':

            $query = "SELECT t.*, tt.description"
                   ." FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt"
                   ." ON tt.term_id = t.term_id"
                   ." WHERE tt.taxonomy = 'category'";
            if ($filter !== null) {
                $query .= " AND $filter";
            }
            $stmt = mysql_query($query);
            $returnResult = $this->_serializeCategories($stmt);       
            break;
        case 'Comments':
            $query = "SELECT * FROM `wp_comments` WHERE"
                   ." wp_comments.comment_approved = 1";
            if ($filter !== null) {
                $query .= " AND $filter";
            }
            $stmt = mysql_query($query);
            $returnResult = $this->_serializeComments($stmt);       
            break;
        case 'Users':
            $query = "SELECT * FROM `wp_users`";
            //print "<br>Filter:".$filter;

            if ($filter !== null) {
                $query .= " AND $filter";
            }
            $stmt = mysql_query($query);
            //$data = mysql_fetch_assoc($stmt);

            $returnResult = $this->_serializeUsers($stmt);
            break;
        }
        mysql_free_result($stmt);
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
        return $returnResult;
class Author {
    private $name;

    public function __construct($name) {
        $this->name = $name;
    }

    public function getName() {
        return $this->name;
    }
}

abstract class Post {
    public function getAuthor() {
        return 'Johannes';
    }
}

class BlogPost extends Post {
    public function getAuthor() {
        return new Author('Johannes');
    }
}

class ForumPost extends Post { /* ... */ }

function my_function(Post $post) {
    echo strtoupper($post->getAuthor());
}
    }
    
    /**
     * Gets an entity instance from an entity set identifed by a key
     * 
     * @param ResourceSet   $resourceSet   The entity set from which an entity 
     *                                     needs to be fetched
     * @param KeyDescriptor $keyDescriptor The key to identify the entity 
     *                                     to be fetched
     * 
     * @return object|null Returns entity instance if found else null
     */
    public function getResourceFromResourceSet(ResourceSet $resourceSet, KeyDescriptor $keyDescriptor)
    {
        $resourceSetName =  $resourceSet->getName();
        if ($resourceSetName !== 'Posts' 

            && $resourceSetName !== 'Tags' 
            && $resourceSetName !== 'Categories' 
            && $resourceSetName !== 'Comments' 
            && $resourceSetName !== 'Users'
        ) {
            die('(WordPressQueryProvider) Unknown resource set ' . $resourceSetName);

        }

        $namedKeyValues = $keyDescriptor->getValidatedNamedValues();
        $keys = array();
        foreach ($namedKeyValues as $key => $value) {
            $keys[] = "$key = '$value[0]' ";
        }
        $conditionStr = implode(' AND ', $keys);
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        
        switch ($resourceSetName) {
        case 'Posts':
            $query = "SELECT * FROM `wp_posts` WHERE"
                   ." wp_posts.post_type = 'post'"
                   ." AND wp_posts.post_status = 'publish'"
                   ." AND wp_posts.ID = ".$namedKeyValues['PostID'][0];
            $stmt = mysql_query($query);
              
            //If resource not found return null to the library
            if (!mysql_num_rows($stmt)) {
                return null;
            } 
              
            $data = mysql_fetch_assoc($stmt);
            $result = $this->_serializePost($data);
            break;
        case 'Tags':
            $query = "SELECT t.*, tt.description"
                   ." FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt"
                   ." ON tt.term_id = t.term_id"
                   ." WHERE tt.taxonomy = 'post_tag'"
                   ." AND t.term_id = ".$namedKeyValues['TagID'][0];
            $stmt = mysql_query($query);
              
            //If resource not found return null to the library
            if (!mysql_num_rows($stmt)) {
                return null;
            }
              
            $data = mysql_fetch_assoc($stmt);
            $result = $this->_serializeTag($data);
            break;
        case 'Categories':
            $query = "SELECT t.*, tt.description"
                   ." FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt"
                   ." ON tt.term_id = t.term_id"
                   ." WHERE tt.taxonomy = 'category'"
                   ." AND t.term_id = ".$namedKeyValues['CategoryID'][0];
            $stmt = mysql_query($query);
              
            //If resource not found return null to the library
            if (!mysql_num_rows($stmt)) {
                return null;
            }
              
            $data = mysql_fetch_assoc($stmt);
            $result = $this->_serializeCategory($data);
            break;
        case 'Comments':

            $query = "SELECT * FROM `wp_comments`"
                   ." WHERE comment_approved = 1" 
                   ." AND comment_ID = ".$namedKeyValues['CommentID'][0];
            $stmt = mysql_query($query);
              
            //If resource not found return null to the library
            if (!mysql_num_rows($stmt)) {
                return null;
            }
              
            $data = mysql_fetch_assoc($stmt);
            $result = $this->_serializeComment($data);
            break;
        case 'Users':

            $query = "SELECT * FROM `wp_users` WHERE ID = ".$namedKeyValues['UserID'][0];
            $stmt = mysql_query($query);
              
            //If resource not found return null to the library
            if (!mysql_num_rows($stmt)) {
                return null;
            }
              
            $data = mysql_fetch_assoc($stmt);
            $result = $this->_serializeUser($data);
            break;
        }
        
        mysql_free_result($stmt);
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
        return $result;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
    }
    
    /**
     * Get related resource set for a resource
     * 
     * @param ResourceSet      $sourceResourceSet    The source resource set
     * @param mixed            $sourceEntityInstance The resource
     * @param ResourceSet      $targetResourceSet    The resource set of 
     *                                               the navigation property
     * @param ResourceProperty $targetProperty       The navigation property to be 
     *                                               retrieved
     * @param string           $filterOption         Contains the filter condition
/**
 * @param array $germany
 * @param array $ireland
 */
function finale($germany, $island) {
    return "2:1";
}
     * @param string           $select               For future purpose,no need to pass it
     * @param string           $orderby              For future purpose,no need to pass it
     * @param string           $top                  For future purpose,no need to pass it
     * @param string           $skip                 For future purpose,no need to pass it
     *                                               
     * @return object[] Array of related resource if exists, if no 
     *                                related resources found returns empty array
     */
    public function  getRelatedResourceSet(ResourceSet $sourceResourceSet, 
        $sourceEntityInstance, 
        ResourceSet $targetResourceSet,
        ResourceProperty $targetProperty,
        $filter=null ,$select=null, $orderby=null, $top=null, $skip=null
    ) {
        $result = array();
        $srcClass = get_class($sourceEntityInstance);
        $navigationPropName = $targetProperty->getName();
        
        switch (true) {
        case ($srcClass == 'Post'):
            if ($navigationPropName == 'Tags') {
                $query = "SELECT t.*, tt.description"
                       ." FROM wp_terms AS t"
                       ." INNER JOIN wp_term_taxonomy AS tt"
                       ." ON tt.term_id = t.term_id"
                       ." INNER JOIN wp_term_relationships AS tr"
                       ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                       ." WHERE tt.taxonomy IN ('post_tag')"
                       ." AND tr.object_id IN ($sourceEntityInstance->PostID)";
                if ($filter !== null) {
                    $query .= " AND $filter";
                }
                $stmt = mysql_query($query);
                if ( $stmt === false) {
                    die(mysql_error());

                }
                        
                $result = $this->_serializeTags($stmt);
            } elseif ($navigationPropName == 'Categories') {
                $query = "SELECT t.*, tt.description"
                       ." FROM wp_terms AS t"
                       ." INNER JOIN wp_term_taxonomy AS tt"
                       ." ON tt.term_id = t.term_id"
                       ." INNER JOIN wp_term_relationships AS tr"
                       ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                       ." WHERE tt.taxonomy IN ('category')"
                       ." AND tr.object_id IN ($sourceEntityInstance->PostID)";
                if ($filter !== null) {
                    $query .= " AND $filter";
                }
                $stmt = mysql_query($query);
                if ( $stmt === false) {            
                       die(mysql_error());

                }
                        
                $result = $this->_serializeCategories($stmt);
            } else if ($navigationPropName == 'Comments') {

                $query = "SELECT * FROM `wp_comments`"
                       ." WHERE comment_approved = 1" 
                       ." AND comment_post_ID = $sourceEntityInstance->PostID";
                if ($filter !== null) {
                    $query .= " AND $filter";
                }
                $stmt = mysql_query($query);
                if ( $stmt === false) {
                    die(mysql_error());

                }
                        
                $result = $this->_serializeComments($stmt);
            } else {
                die('Post does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;

        case ($srcClass == 'Tag'):

            if ($navigationPropName == 'Posts') {
                $query = "SELECT p . *" 
                         ." FROM wp_posts AS p"
                         ." INNER JOIN wp_term_relationships AS tr"
                         ." ON p.ID = tr.object_id"
                         ." INNER JOIN wp_term_taxonomy AS tt"
                         ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                         ." WHERE tt.term_id = $sourceEntityInstance->TagID"
                         ." AND p.post_type = 'post'"
                         ." AND p.post_status = 'publish'";
                if ($filter !== null) {
                    $query .= " AND $filter";
                }
                $stmt = mysql_query($query);
                if ( $stmt === false) {
                            die(mysql_error());

                }
                        
                      $result = $this->_serializePosts($stmt);
            } else {
                die('Tag does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;
                    
        case ($srcClass == 'Category'):

            if ($navigationPropName == 'Posts') {
                $query = "SELECT p . *" 
                         ." FROM wp_posts AS p"
                         ." INNER JOIN wp_term_relationships AS tr"
                         ." ON p.ID = tr.object_id"
                         ." INNER JOIN wp_term_taxonomy AS tt"
                         ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                         ." WHERE tt.term_id = $sourceEntityInstance->CategoryID"
                         ." AND p.post_type = 'post'"
                         ." AND p.post_status = 'publish'";
                if ($filter !== null) {
                    $query .= " AND $filter";
                }
                $stmt = mysql_query($query);
                if ( $stmt === false) {
                    die(mysql_error());

                }
                        
                $result = $this->_serializePosts($stmt);
            } else {
                die('Category does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;
                 
        case ($srcClass == 'Comment'):
            die('Comment does not have navigation porperty with name: ' . $navigationPropName);

            break;
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
                    
        case ($srcClass == 'User'):
            if ($navigationPropName == 'Posts') {
                $query = "SELECT * FROM `wp_posts` WHERE"
                       ." wp_posts.post_type = 'post'"
                       ." AND wp_posts.post_status = 'publish'"
                       ." AND wp_posts.post_author = $sourceEntityInstance->UserID";
                if ($filter !== null) {
                    $query .= " AND $filter";
                }
                $stmt = mysql_query($query);
                if ( $stmt === false) {
                    die(mysql_error());

                }
                            
                $result = $this->_serializePosts($stmt);
            } elseif ($navigationPropName == 'Comments') {

                $query = "SELECT * FROM `wp_comments`"
                     ." WHERE comment_approved = 1" 
                     ." AND wp_comments.user_id = $sourceEntityInstance->UserID";
                if ($filter !== null) {
                    $query .= " AND $filter";
                }
                $stmt = mysql_query($query);
                if ( $stmt === false) {            
                    die(mysql_error());

                }
                        
                $result = $this->_serializeComments($stmt);
            } else {
                die('User does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;
        }
        
        mysql_free_result($stmt);
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
        return $result;
class Author {
    private $name;

    public function __construct($name) {
        $this->name = $name;
    }

    public function getName() {
        return $this->name;
    }
}

abstract class Post {
    public function getAuthor() {
        return 'Johannes';
    }
}

class BlogPost extends Post {
    public function getAuthor() {
        return new Author('Johannes');
    }
}

class ForumPost extends Post { /* ... */ }

function my_function(Post $post) {
    echo strtoupper($post->getAuthor());
}
    }
    
    /**
     * Gets a related entity instance from an entity set identifed by a key
     * 
     * @param ResourceSet      $sourceResourceSet    The entity set related to
     *                                               the entity to be fetched.
     * @param object           $sourceEntityInstance The related entity instance.
     * @param ResourceSet      $targetResourceSet    The entity set from which
     *                                               entity needs to be fetched.
     * @param ResourceProperty $targetProperty       The metadata of the target 
     *                                               property.
     * @param KeyDescriptor    $keyDescriptor        The key to identify the entity 
     *                                               to be fetched.
     * 
     * @return object|null Returns entity instance if found else null
     */
    public function  getResourceFromRelatedResourceSet(ResourceSet $sourceResourceSet, 
        $sourceEntityInstance, 
        ResourceSet $targetResourceSet,
        ResourceProperty $targetProperty,
        KeyDescriptor $keyDescriptor
    ) {
        $result = array();
        $srcClass = get_class($sourceEntityInstance);
        $navigationPropName = $targetProperty->getName();
        
        $keys = array();
        $namedKeyValues = $keyDescriptor->getValidatedNamedValues();
        foreach ($namedKeyValues as $key => $value) {
            $keys[] = "$key = '$value[0]' ";
        }
        $conditionStr = implode(' AND ', $keys);
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        
        switch (true) {
        case ($srcClass == 'Post'):
            if ($navigationPropName == 'Tags') {
                $query = "SELECT t.*, tt.description"
                       ." FROM wp_terms AS t"
                       ." INNER JOIN wp_term_taxonomy AS tt"
                       ." ON tt.term_id = t.term_id"
                       ." INNER JOIN wp_term_relationships AS tr"
                       ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                       ." WHERE tt.taxonomy IN ('post_tag')"
                       ." AND tr.object_id IN ($sourceEntityInstance->PostID)"
                       ." AND tt.term_id = ".$namedKeyValues['TagID'][0];
                $stmt = mysql_query($query);
                $result = $this->_serializeTags($stmt);
            } elseif ($navigationPropName == 'Categories') {
                $query = "SELECT t.*, tt.description"
                       ." FROM wp_terms AS t"
                       ." INNER JOIN wp_term_taxonomy AS tt"
                       ." ON tt.term_id = t.term_id"
                       ." INNER JOIN wp_term_relationships AS tr"
                       ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                       ." WHERE tt.taxonomy IN ('category')"
                       ." AND tr.object_id IN ($sourceEntityInstance->PostID)"
                       ." AND tt.term_id = ".$namedKeyValues['CategoryID'][0];
                $stmt = mysql_query($query);
                $result = $this->_serializeCategories($stmt);
            } else if ($navigationPropName == 'Comments') {

                $query = "SELECT * FROM `wp_comments`"
                       ." WHERE comment_approved = 1" 
                       ." AND comment_post_ID = $sourceEntityInstance->PostID"
                       ." AND comment_ID = ".$namedKeyValues['CommentID'][0];
                $stmt = mysql_query($query);
                $result = $this->_serializeComments($stmt);
            } else {
                die('Post does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;

        case ($srcClass == 'Tag'):

            if ($navigationPropName == 'Posts') {
                $query = "SELECT p . *" 
                         ." FROM wp_posts AS p"
                         ." INNER JOIN wp_term_relationships AS tr"
                         ." ON p.ID = tr.object_id"
                         ." INNER JOIN wp_term_taxonomy AS tt"
                         ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                         ." WHERE tt.term_id = $sourceEntityInstance->TagID"
                         ." AND p.post_type = 'post'"
                         ." AND p.post_status = 'publish'"
                         ." AND p.ID = ".$namedKeyValues['PostID'][0];
                $stmt = mysql_query($query);
                $result = $this->_serializePosts($stmt);
            } else {
                die('Tag does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;
                    
        case ($srcClass == 'Category'):

            if ($navigationPropName == 'Posts') {
                $query = "SELECT p . *" 
                         ." FROM wp_posts AS p"
                         ." INNER JOIN wp_term_relationships AS tr"
                         ." ON p.ID = tr.object_id"
                         ." INNER JOIN wp_term_taxonomy AS tt"
                         ." ON tr.term_taxonomy_id = tt.term_taxonomy_id"
                         ." WHERE tt.term_id = $sourceEntityInstance->CategoryID"
                         ." AND p.post_type = 'post'"
                         ." AND p.post_status = 'publish'"
                         ." AND p.ID = ".$namedKeyValues['PostID'][0];
                $stmt = mysql_query($query);
                $result = $this->_serializePosts($stmt);
            } else {
                die('Category does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;
                 
        case ($srcClass == 'Comment'):
            die('Comment does not have navigation porperty with name: ' . $navigationPropName);

            break;
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
                    
        case ($srcClass == 'User'):
            if ($navigationPropName == 'Posts') {
                 $query = "SELECT * FROM `wp_posts` WHERE"
                        ." wp_posts.post_type = 'post'"
                        ." AND wp_posts.post_status = 'publish'"
                        ." AND wp_posts.post_author = $sourceEntityInstance->UserID"
                        ." AND wp_posts.ID = ".$namedKeyValues['PostID'][0];
                 $stmt = mysql_query($query);
                 $result = $this->_serializePosts($stmt);
            } elseif ($navigationPropName == 'Comments') {

                 $query = "SELECT * FROM `wp_comments`"
                      ." WHERE comment_approved = 1" 
                      ." AND wp_comments.user_id = $sourceEntityInstance->UserID"
                      ." AND wp_comments.comment_ID = ".$namedKeyValues['CommentID'][0];
                 $stmt = mysql_query($query);
                 $result = $this->_serializeComments($stmt);
            } else {
                 die('User does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;
        }
        
        mysql_free_result($stmt);
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
        return empty($result) ? null : $result[0];
    }
    /**
     * Get related resource for a resource
     * 
     * @param ResourceSet      $sourceResourceSet    The source resource set
     * @param mixed            $sourceEntityInstance The source resource
     * @param ResourceSet      $targetResourceSet    The resource set of 
     *                                               the navigation property
     * @param ResourceProperty $targetProperty       The navigation property to be 
     *                                               retrieved
     * 
     * @return object|null The related resource if exists else null
     */
    public function getRelatedResourceReference(ResourceSet $sourceResourceSet, 
        $sourceEntityInstance, 
        ResourceSet $targetResourceSet,
        ResourceProperty $targetProperty
    ) {
        $result = null;
        $srcClass = get_class($sourceEntityInstance);
        $navigationPropName = $targetProperty->getName();
        
        switch (true) {
        case ($srcClass == 'Post'):
            if ($navigationPropName == 'User') {
                $query = "SELECT * FROM `wp_users` WHERE ID = $sourceEntityInstance->Author";
                $stmt = mysql_query($query);
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                $stmt = mysql_query($query);
                $data = mysql_fetch_assoc($stmt);
                $result = $this->_serializeUser($data);
                if ( $stmt === false) {            
                    die(mysql_error());

                }
                        
                if (!mysql_num_rows($stmt)) {
                    $result =  null;
                }
            } else {
                die('Post does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;

        case ($srcClass == 'Comment'):
            if ($navigationPropName == 'User') {
                $query = "SELECT * FROM `wp_users` WHERE ID = $sourceEntityInstance->UserID";
                $stmt = mysql_query($query);
                if ( $stmt === false) {
                    die(mysql_error());

                }
                        
                if (!mysql_num_rows($stmt)) {
                    $result =  null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                }
                        
                $data = mysql_fetch_assoc($stmt);
                $result = $this->_serializeUser($data);
                      
            } elseif ($navigationPropName == 'Post') {
                $query = "SELECT * FROM `wp_posts` WHERE"
                       ." wp_posts.post_type = 'post'"
                       ." AND wp_posts.post_status = 'publish'"
                       ." AND wp_posts.ID = $sourceEntityInstance->PostID";
                $stmt = mysql_query($query);
                if ( $stmt === false) {            
                    die(mysql_error());

                }
                        
                if (!mysql_num_rows($stmt)) {
                    $result =  null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                }
                        
                $data = mysql_fetch_assoc($stmt);
                $result = $this->_serializePost($data);
            } else {
                die('Comment does not have navigation porperty with name: ' . $navigationPropName);

            }
            break;
        }
        
        mysql_free_result($stmt);
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
        return $result;
    }
    
    /**
     * Serialize the mysql result array into Post objects
     * 
     * @param array(array) $result result of the mysql query

     * 
     * @return array(Object)

     */
    private function _serializePosts($result)
    {
        $posts = array();
        while ($record = mysql_fetch_array($result, MYSQL_ASSOC)) {
             $posts[] = $this->_serializePost($record);
        }

        return $posts;
    }

    /**
     * Serialize the mysql row into Post object
     * 
     * @param array $record each post row
     * 
     * @return object
     */
    private function _serializePost($record)
    {
        $post = new Post();
        $post->PostID = $record['ID'];
        $post->Author = $record['post_author'];
        
        if (!is_null($record['post_date'])) {

            $dateTime = new DateTime($record['post_date']);
            $post->Date = $dateTime->format('Y-m-d\TH:i:s');
        } else {
            $post->Date = null;
        }
        
        if (!is_null($record['post_date_gmt'])) {

            $dateTime = new DateTime($record['post_date_gmt']);
            $post->DateGmt = $dateTime->format('Y-m-d\TH:i:s');
        } else {
            $post->DateGmt = null;
        }
        
        $post->Content = $record['post_content'];
        $post->Title = $record['post_title'];
        $post->Excerpt = $record['post_excerpt'];
        $post->Status = $record['post_status'];
        $post->CommentStatus = $record['comment_status'];
        $post->PingStatus = $record['ping_status'];
        $post->Password = $record['post_password'];
        $post->Name = $record['post_name'];
        $post->ToPing = $record['to_ping'];
        $post->Pinged = $record['pinged'];
        
        if (!is_null($record['post_modified'])) {

            $dateTime = new DateTime($record['post_modified']);
            $post->Modified = $dateTime->format('Y-m-d\TH:i:s');
        } else {
            $post->Modified = null;
        }
        
        if (!is_null($record['post_modified_gmt'])) {

            $dateTime = new DateTime($record['post_modified_gmt']);
            $post->ModifiedGmt = $dateTime->format('Y-m-d\TH:i:s');
        } else {
            $post->ModifiedGmt = null;
        }
        
        $post->ContentFiltered = $record['post_content_filtered'];
        $post->ParentID = $record['post_parent'];
        $post->Guid = $record['guid'];
        $post->MenuOrder = $record['menu_order'];
        $post->Type = $record['post_type'];
        $post->MimeType = $record['post_mime_type'];
        $post->CommentCount = $record['comment_count'];
        return $post;
    }
    
    /**
     * Serialize the mysql result array into Tag objects
     * 
     * @param array(array) $result result of the mysql query

     * 
     * @return array(Object)

     */
    private function _serializeTags($result)

    {
        $tags = array();
        while ($record = mysql_fetch_array($result, MYSQL_ASSOC)) {         
             $tags[] = $this->_serializeTag($record);
        }

        return $tags;
    }

    /**
     * Serialize the mysql row into Tag object
     * 
     * @param array $record each tag row
     * 
     * @return object
     */
    private function _serializeTag($record)
    {
        $tag = new Tag();
        $tag->TagID = $record['term_id'];
        $tag->Name = $record['name'];
        $tag->Slug = $record['slug'];
        $tag->Description = $record['description'];
        return $tag;
    }
    
    /**
     * Serialize the mysql result array into Category objects
     * 
     * @param array(array) $result result of the mysql query

     * 
     * @return array(Object)

     */
    private function _serializeCategories($result)

    {
        $cats = array();
        while ($record = mysql_fetch_array($result, MYSQL_ASSOC)) {         
             $cats[] = $this->_serializeCategory($record);
        }

        return $cats;
    }

    /**
     * Serialize the mysql row into Category object
     * 
     * @param array $record each category row
     * 
     * @return object
     */
    private function _serializeCategory($record)
    {
        $cat = new Category();
        $cat->CategoryID = $record['term_id'];
        $cat->Name = $record['name'];
        $cat->Slug = $record['slug'];
        $cat->Description = $record['description'];
        return $cat;
    }
    
    /**
     * Serialize the mysql result array into Comment objects
     * 
     * @param array(array) $result mysql query result

     * 
     * @return array(Object)

     */
    private function _serializeComments($result)
    {
        $comments = array();
        while ( $record = mysql_fetch_array($result, MYSQL_ASSOC)) {         
             $comments[] = $this->_serializeComment($record);
        }

        return $comments;
    }

    /**
     * Serialize the mysql row into Comment object
     * 
     * @param array $record each comment row
     * 
     * @return object
     */
    private function _serializeComment($record)
    {
        $comment = new Comment();
        $comment->CommentID = $record['comment_ID'];
        $comment->PostID = $record['comment_post_ID'];
        $comment->Author = $record['comment_author'];
        $comment->AuthorEmail = $record['comment_author_email'];
        $comment->AuthorUrl = $record['comment_author_url'];
        $comment->AuthorIp = $record['comment_author_IP'];
        
        if (!is_null($record['comment_date'])) {

            $dateTime = new DateTime($record['comment_date']);
            $comment->Date = $dateTime->format('Y-m-d\TH:i:s');
        } else {
            $comment->Date = null;
        }
        
        if (!is_null($record['comment_date_gmt'])) {

            $dateTime = new DateTime($record['comment_date_gmt']);
            $comment->DateGmt = $dateTime->format('Y-m-d\TH:i:s');
        } else {
            $comment->DateGmt = null;
        }
        
        $comment->Content = $record['comment_content'];
        $comment->Karma = $record['comment_karma'];
        $comment->Approved = $record['comment_approved'];
        $comment->Agent = $record['comment_agent'];
        $comment->Type = $record['comment_type'];
        $comment->ParentID = $record['comment_parent'];
        $comment->UserID = $record['user_id'];
        return $comment;
    }
    
    /**
     * Serialize the mysql result array into User objects
     * 
     * @param array(array) $result result of the mysql query

     * 
     * @return array(Object)

     */
    private function _serializeUsers($result)
    {
        $users = array();
        while ($record = mysql_fetch_array($result, MYSQL_ASSOC)) {         
             $users[] = $this->_serializeUser($record);
        }

        return $users;
    }

    /**
     * Serialize the mysql row into User object
     * 
     * @param array $record each user row
     * 
     * @return object
     */
    private function _serializeUser($record)
    {
        $user = new User();
        $user->UserID = $record['ID'];
        $user->Login = $record['user_login'];
        $user->Nicename = $record['user_nicename'];
        $user->Email = $record['user_email'];
        $user->Url = $record['user_url'];
        
        if (!is_null($record['user_registered'])) {

            $dateTime = new DateTime($record['user_registered']);
            $user->Registered = $dateTime->format('Y-m-d\TH:i:s');
        } else {
            $user->Registered = null;
        }
        
        $user->Status = $record['user_status'];
        $user->DisplayName = $record['display_name'];
        return $user;
    }
    
    
}


WordPressQueryProvider D
last analyzed 2017-02-19 06:57 UTC

Complexity

Size/Duplication

Coupling/Cohesion

Importance

18 Methods

How to fix Duplicated Code Complexity

Duplicated Code

Complex Class

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

1			<?php
			0 ignored issues – show Coding Style Compatibility introduced 2016-02-22 16:32 UTC by Report Bug Copy Issue Report For compatibility and reusability of your code, PSR1 recommends that a file should introduce either new symbols (like classes, functions, etc.) or have side-effects (like outputting something, or including other files), but not both at the same time. The first symbol is defined on line 11 and the first side effect is on line 7. The PSR-1: Basic Coding Standard recommends that a file should either introduce new symbols, that is classes, functions, constants or similar, or have side effects. Side effects are anything that executes logic, like for example printing output, changing ini settings or writing to a file. The idea behind this recommendation is that merely auto-loading a class should not change the state of an application. It also promotes a cleaner style of programming and makes your code less prone to errors, because the logic is not spread out all over the place. To learn more about the PSR-1, please see the PHP-FIG site on the PSR-1. Loading history...
2
3			use POData\UriProcessor\ResourcePathProcessor\SegmentParser\KeyDescriptor;
4			use POData\Providers\Metadata\ResourceSet;
5			use POData\Providers\Metadata\ResourceProperty;
6			use POData\Providers\Query\IQueryProvider;
7			require_once "WordPressMetadata.php";
8			require_once "POData\Providers\Query\IDataServiceQueryProvider2.php";
9
10			/** The name of the database for WordPress */
11			define('DB_NAME', 'wordpress');
12
13			/** MySQL database username */
14			define('DB_USER', 'root');
15
16			/** MySQL database password */
17			define('DB_PASSWORD', 'root');
18
19			/** MySQL hostname */
20			define('DB_HOST', 'localhost');
21
22
23			class WordPressQueryProvider implements IQueryProvider
			0 ignored issues – show Coding Style Compatibility introduced 2016-02-22 16:32 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
24			{
25			/**
26			* Handle to connection to Database
27			*/
28			private $_connectionHandle = null;
29
30			/**
31			* Reference to the custom expression provider
32			*
33			* @var NorthWindDSExpressionProvider
34			*/
35			private $_wordPressMySQLExpressionProvider;
36
37			/**
38			* Constructs a new instance of WordPressQueryProvider

Qeti / POData

WordPressQueryProvider D last analyzed 2017-02-19 06:57 UTC

Complexity

Size/Duplication

Coupling/Cohesion

Importance

18 Methods

How to fix Duplicated Code Complexity

Duplicated Code

Complex Class

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like

WordPressQueryProvider D
last analyzed 2017-02-19 06:57 UTC