NorthWindQueryProvider::getResourceFromRelatedResourceSet() - Code Metrics - Inspection of "Query interface (#16)" - Algo-Web/POData - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( f0e0ca...79ebae )

by Christopher

created 2016-12-15 13:47 UTC

getResourceFromRelatedResourceSet() C

↳ Parent: NorthWindQueryProvider

Complexity

Conditions	9
Paths	20

Size

Total Lines	46
Code Lines	34

Duplication

Lines	26
Ratio	56.52 %

Importance

Changes

Metric	Value
dl	26
loc	46
rs	5.0942
c	0
b	0
f	0
cc	9
eloc	34
nc	20
nop	5

<?php


use POData\UriProcessor\ResourcePathProcessor\SegmentParser\KeyDescriptor;
use POData\Providers\Metadata\ResourceSet;
use POData\Providers\Metadata\ResourceProperty;
use POData\Providers\Query\IQueryProvider;
use POData\Common\ODataException;

require_once 'NorthWindMetadata.php';
require_once "POData\Providers\Query\IDataServiceQueryProvider2.php";
require_once 'NorthWindDSExpressionProvider.php';
define('DATABASE', 'Northwind');
// Note: The instance name of your sql server [How to find instance name]
// Start ->All progrmas->Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager
// In Configuration Manager -> SQL Server 2008 Services -> double click the SQL Service -> click the Service Tab.
define('SERVER', '.\SQLEXPRESS');
// Note: If your database access require credentials then un-comment
// the following two lines [definition of UID and PWD] and provide db user name
// as value for UID and password as value for PWD.
// define('UID',  '');
// define('PWD',  '');

class NorthWindQueryProvider implements IQueryProvider
namespace YourVendor;

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

    /**
     * Reference to the custom expression provider.
     *
     * @var NorthWindDSExpressionProvider
     */
    private $_northWindSQLSRVExpressionProvider;

    /**
     * Constructs a new instance of NorthWindQueryProvider.
     */
    public function __construct()
    {
        $connectionInfo = array('Database' => DATABASE);
        if (defined('UID')) {
            $connectionInfo['UID'] = UID;
            $connectionInfo['PWD'] = PWD;
        }

        $this->_connectionHandle = sqlsrv_connect(SERVER, $connectionInfo);
        if ($this->_connectionHandle) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
        } else {
            $errorAsString = self::_getSQLSRVError();
            throw ODataException::createInternalServerError($errorAsString);
        }

        $this->_northWindSQLSRVExpressionProvider = null;
    }

    /**
     * (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->_northWindSQLSRVExpressionProvider)) {
            $this->_northWindSQLSRVExpressionProvider = new NorthWindDSExpressionProvider();
        }

        return $this->_northWindSQLSRVExpressionProvider;
    }

    /**
     * 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 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,
        $filterOption = null,
        $select = null,
        $orderby = null,
        $top = null,
        $skip = null
    ) {
        $resourceSetName = $resourceSet->getName();
        if ($resourceSetName !== 'Customers'

            && $resourceSetName !== 'Orders'
            && $resourceSetName !== 'Order_Details'
            && $resourceSetName !== 'Employees'
        ) {
            throw ODataException::createInternalServerError('(NorthWindQueryProvider) Unknown resource set ' . $resourceSetName . '! Contact service provider');
        }

        if ($resourceSetName === 'Order_Details') {
            $resourceSetName = 'Order Details';
        }

        $query = "SELECT * FROM [$resourceSetName]";
        if ($filterOption != null) {

            $query .= ' WHERE ' . $filterOption;
        }
        $stmt = sqlsrv_query($this->_connectionHandle, $query);
        if ($stmt === false) {
            $errorAsString = self::_getSQLSRVError();
            throw ODataException::createInternalServerError($errorAsString);
        }
        $returnResult = array();
        switch ($resourceSetName) {

            case 'Customers':
                $returnResult = $this->_serializeCustomers($stmt);
                break;
            case 'Orders':
                $returnResult = $this->_serializeOrders($stmt);
                break;
            case 'Order Details':
                $returnResult = $this->_serializeOrderDetails($stmt);
                break;
            case 'Employees':
                $returnResult = $this->_serializeEmployees($stmt);
                break;
        }
        sqlsrv_free_stmt($stmt);

        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 !== 'Customers'

            && $resourceSetName !== 'Orders'
            && $resourceSetName !== 'Order_Details'
            && $resourceSetName !== 'Products'
            && $resourceSetName !== 'Employees'
        ) {
            die('(NorthWindQueryProvider) Unknown resource set ' . $resourceSetName);

        }

        if ($resourceSetName === 'Order_Details') {
            $resourceSetName = 'Order Details';
        }

        $namedKeyValues = $keyDescriptor->getValidatedNamedValues();
        $condition = null;
        foreach ($namedKeyValues as $key => $value) {
            $condition .= $key . ' = ' . $value[0] . ' and ';
        }

        $len = strlen($condition);
        $condition = substr($condition, 0, $len - 5);
        $query = "SELECT * FROM [$resourceSetName] WHERE $condition";
        $stmt = sqlsrv_query($this->_connectionHandle, $query);
        if ($stmt === false) {
            $errorAsString = self::_getSQLSRVError();
            throw ODataException::createInternalServerError($errorAsString);
        }

        //If resource not found return null to the library
        if (!sqlsrv_has_rows($stmt)) {
            return null;
        }

        $result = null;
        while ($record = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
            switch ($resourceSetName) {

                case 'Customers':
                    $result = $this->_serializeCustomer($record);
                    break;
                case 'Orders':
                    $result = $this->_serializeOrder($record);
                    break;
                case 'Order Details':
                    $result = $this->_serializeOrderDetail($record);
                    break;
                case 'Employees':
                    $result = $this->_serializeEmployee($record);
                    break;
            }
        }
        sqlsrv_free_stmt($stmt);

        return $result;
    }

    /**
     * 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();
        $key = null;
        foreach ($keyDescriptor->getValidatedNamedValues() as $keyName => $valueDescription) {
            $key = $key . $keyName . '=' . $valueDescription[0] . ' and ';
        }

        $key = rtrim($key, ' and ');
        if ($srcClass === 'Customer') {
            if ($navigationPropName === 'Orders') {

                $query = "SELECT * FROM Orders WHERE CustomerID = '$sourceEntityInstance->CustomerID' and $key";
                $stmt = sqlsrv_query($this->_connectionHandle, $query);
                if ($stmt === false) {
                    $errorAsString = self::_getSQLSRVError();
                    throw ODataException::createInternalServerError($errorAsString);
                }

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

            }
        } elseif ($srcClass === 'Order') {

            if ($navigationPropName === 'Order_Details') {
                $query = "SELECT * FROM [Order Details] WHERE OrderID = $sourceEntityInstance->OrderID";
                $stmt = sqlsrv_query($this->_connectionHandle, $query);
                if ($stmt === false) {
                    $errorAsString = self::_getSQLSRVError();
                    throw ODataException::createInternalServerError($errorAsString);
                }

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

            }
        }

        return empty($result) ? null : $result[0];
    }

    /**
     * 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
     *                                               to append with query
     * @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,
        $filterOption = null,
        $select = null,
        $orderby = null,
        $top = null,
        $skip = null
    ) {
        $result = array();
        $srcClass = get_class($sourceEntityInstance);
        $navigationPropName = $targetProperty->getName();
        if ($srcClass === 'Customer') {
            if ($navigationPropName === 'Orders') {

                $query = "SELECT * FROM Orders WHERE CustomerID = '$sourceEntityInstance->CustomerID'";
                if ($filterOption != null) {

                    $query .= ' AND ' . $filterOption;
                }
                $stmt = sqlsrv_query($this->_connectionHandle, $query);
                if ($stmt === false) {
                    $errorAsString = self::_getSQLSRVError();
                    throw ODataException::createInternalServerError($errorAsString);
                }

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

            }
        } elseif ($srcClass === 'Order') {

            if ($navigationPropName === 'Order_Details') {
                $query = "SELECT * FROM [Order Details] WHERE OrderID = $sourceEntityInstance->OrderID";
                if ($filterOption != null) {

                    $query .= ' AND ' . $filterOption;
                }
                $stmt = sqlsrv_query($this->_connectionHandle, $query);
                if ($stmt === false) {
                    $errorAsString = self::_getSQLSRVError();
                    throw ODataException::createInternalServerError($errorAsString);
                }

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

            }
        }

        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());
}
    }

    /**
     * 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();
        if ($srcClass === 'Order') {
            if ($navigationPropName === 'Customer') {

                if (empty($sourceEntityInstance->CustomerID)) {
                    $result = null;
                } else {
                    $query = "SELECT * FROM Customers WHERE CustomerID = '$sourceEntityInstance->CustomerID'";
                    $stmt = sqlsrv_query($this->_connectionHandle, $query);
                    if ($stmt === false) {
                        $errorAsString = self::_getSQLSRVError();
                        throw ODataException::createInternalServerError($errorAsString);
                    }

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

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                    }

                    $result = $this->_serializeCustomer(sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC));
                }
            } else {
                die('Customer does not have navigation porperty with name: ' . $navigationPropName);

            }
        } elseif ($srcClass === 'Order_Details') {

            if ($navigationPropName === 'Order') {
                if (empty($sourceEntityInstance->OrderID)) {
                    $result = null;
                } else {
                    $query = "SELECT * FROM Orders WHERE OrderID = $sourceEntityInstance->OrderID";
                    $stmt = sqlsrv_query($this->_connectionHandle, $query);
                    if ($stmt === false) {
                        $errorAsString = self::_getSQLSRVError();
                        throw ODataException::createInternalServerError($errorAsString);
                    }

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

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
                    }

                    $result = $this->_serializeOrder(sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC));
                }
            } else {
                die('Order_Details does not have navigation porperty with name: ' . $navigationPropName);

            }
        }

        return $result;
    }

    /**
     * Serialize the sql result array into Customer objects.
     *
     * @param array(array) $result result of the sql query

     *
     * @return array(Object)

     */
    private function _serializeCustomers($result)
    {
        $customers = array();
        while ($record = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $customers[] = $this->_serializeCustomer($record);
        }

        return $customers;
    }

    /**
     * Serialize the sql row into Customer object.
     *
     * @param array $record each row of customer
     *
     * @return Customer
     */
    private function _serializeCustomer($record)
    {
        $customer = new Customer();
        $customer->CustomerID = $record['CustomerID'];
        $customer->CompanyName = $record['CompanyName'];
        $customer->ContactName = $record['ContactName'];
        $customer->ContactTitle = $record['ContactTitle'];
        $customer->Phone = $record['Phone'];
        $customer->Fax = $record['Fax'];
        $customer->Address = new Address();
        $customer->Address->StreetName = ($record['Address']);
        $customer->Address->City = $record['City'];
        $customer->Address->Region = $record['Region'];
        $customer->Address->PostalCode = $record['PostalCode'];
        $customer->Address->Country = $record['Country'];
        //Set alternate address
        $customer->Address->AltAddress = new Address();
        $customer->Address->AltAddress->StreetName = 'ALT_' . $customer->Address->StreetName;
        $customer->Address->AltAddress->City = 'ALT_' . $customer->Address->City;
        $customer->Address->AltAddress->Region = 'ALT_' . $customer->Address->Region;
        $customer->Address->AltAddress->PostalCode = 'ALT_' . $customer->Address->PostalCode;
        $customer->Address->AltAddress->Country = 'ALT_' . $customer->Address->Country;
        $customer->EmailAddresses = array();
        for ($i = 1; $i < 4; ++$i) {
            $customer->EmailAddresses[] = $customer->CustomerID . $i . '@live.com';
        }

        $customer->OtherAddresses = array();
        for ($i = 0; $i < 2; ++$i) {
            $customer->OtherAddresses[$i] = new Address();
            $this->_copyAddress($customer->Address, $customer->OtherAddresses[$i], $i + 1);
        }

        return $customer;
    }

    /**
     * copy address.
     *
     * @param object  &$src    source
     * @param object  &$target target
     * @param int     $tag     tag
     * @param Address $target
     */
    private function _copyAddress(&$src, &$target, $tag)
    {
        $target->StreetName = $src->StreetName . $tag;
        $target->City = $src->City . $tag;
        $target->Region = $src->Region . $tag;
        $target->PostalCode = $src->PostalCode . $tag;
        $target->Country = $src->Country . $tag;

        $target->AltAddress = new Address();
        $target->AltAddress->StreetName = $target->AltAddress->StreetName . $tag;
        $target->AltAddress->City = $target->AltAddress->City . $tag;
        $target->AltAddress->Region = $target->AltAddress->Region . $tag;
        $target->AltAddress->PostalCode = $target->AltAddress->PostalCode . $tag;
        $target->AltAddress->Country = $target->AltAddress->Country . $tag;
    }

    /**
     * Serialize the sql result array into Order objects.
     *
     * @param array(array) $result result of the sql query

     *
     * @return array(Object)

     */
    private function _serializeOrders($result)
    {
        $orders = array();
        while ($record = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $orders[] = $this->_serializeOrder($record);
        }

        return $orders;
    }

    /**
     * Serialize the sql row into Order object.
     *
     * @param array $record each row of customer
     *
     * @return Order
     */
    private function _serializeOrder($record)
    {
        $order = new Order();
        $order->OrderID = $record['OrderID'];
        $order->CustomerID = $record['CustomerID'];
        $order->EmployeeID = $record['EmployeeID'];
        $order->OrderDate = !is_null($record['OrderDate']) ? $record['OrderDate']->format('Y-m-d\TH:i:s') : null;
        $order->RequiredDate = !is_null($record['RequiredDate']) ? $record['RequiredDate']->format('Y-m-d\TH:i:s') : null;
        $order->ShippedDate = !is_null($record['ShippedDate']) ? $record['ShippedDate']->format('Y-m-d\TH:i:s') : null;
        $order->ShipVia = $record['ShipVia'];
        $order->Freight = $record['Freight'];
        $order->ShipName = $record['ShipName'];
        $order->ShipAddress = $record['ShipAddress'];
        $order->ShipCity = $record['ShipCity'];
        $order->ShipRegion = $record['ShipRegion'];
        $order->ShipPostalCode = $record['ShipPostalCode'];
        $order->ShipCountry = $record['ShipCountry'];

        return $order;
    }

    /**
     * Serialize the sql result array into Employee objects.
     *
     * @param array(array) $result result of the sql query

     *
     * @return array(Object)

     */
    private function _serializeEmployees($result)
    {
        $employees = array();
        while ($record = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $employees[] = $this->_serializeEmployee($record);
        }

        return $employees;
    }

    /**
     * Serialize the sql row into Employee object.
     *
     * @param array $record each row of employee
     *
     * @return Employee
     */
    private function _serializeEmployee($record)
    {
        $employee = new Employee();
        $employee->EmployeeID = $record['EmployeeID'];
        $employee->FirstName = $record['FirstName'];
        $employee->LastName = $record['LastName'];
        $employee->Title = $record['Title'];
        $employee->TitleOfCourtesy = $record['TitleOfCourtesy'];
        $employee->BirthDate = !is_null($record['BirthDate']) ? $record['BirthDate']->format('Y-m-d\TH:i:s') : null;
        $employee->HireDate = !is_null($record['HireDate']) ? $record['HireDate']->format('Y-m-d\TH:i:s') : null;
        $employee->Address = $record['Address'];
        $employee->City = $record['City'];
        $employee->Region = $record['Region'];
        $employee->PostalCode = $record['PostalCode'];
        $employee->Country = $record['Country'];
        $employee->HomePhone = $record['HomePhone'];
        $employee->Extension = $record['Extension'];
        $employee->Notes = $record['Notes'];
        $employee->ReportsTo = $record['ReportsTo'];
        //$employee->Photo = $record['Photo'];

        $employee->Emails = array($employee->FirstName . '@hotmail.com', $employee->FirstName . '@live.com');

        return $employee;
    }

    /**
     * Serialize the sql result array into Order_Details objects.
     *
     * @param array(array) $result result of the sql query

     *
     * @return array(Object)

     */
    private function _serializeOrderDetails($result)
    {
        $order_details = array();
        while ($record = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $order_details[] = $this->_serializeOrderDetail($record);
        }

        return $order_details;
    }

    /**
     * Serialize the sql row into Order_Details object.
     *
     * @param array $record each row of order detail
     *
     * @return Order_Details
     */
    private function _serializeOrderDetail($record)
    {
        $order_details = new Order_Details();
        $order_details->Discount = $record['Discount'];
        $order_details->OrderID = $record['OrderID'];
        $order_details->ProductID = $record['ProductID'];
        $order_details->Quantity = $record['Quantity'];
        $order_details->UnitPrice = $record['UnitPrice'];

        return $order_details;
    }

    /**
     * Gets the last sql server error as a string.
     *
     * @return string
     */
    private static function _getSQLSRVError()
    {
        $result = null;
        $errors = sqlsrv_errors();
        self::_getSQLSRVError1($errors, $result);

        return $result;
    }

    /**
     * Rescursive function to get the sql server error as string.
     *
     * @param array/string $errors

     * @param string       $result
     */
    private static function _getSQLSRVError1($errors, &$result)
    {
        if (is_array($errors)) {
            foreach ($errors as $error) {
                self::_getSQLSRVError1($error, $result);
            }
        } else {
            $result .= $errors;
        }
    }

    /**
     * The destructor.
     */
    public function __destruct()
    {
        if ($this->_connectionHandle) {
            sqlsrv_close($this->_connectionHandle);
        }
    }
}


1			<?php
			0 ignored issues – show Coding Style Compatibility introduced 2016-11-04 10:20 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 12 and the first side effect is on line 9. 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			use POData\Common\ODataException;
8
9			require_once 'NorthWindMetadata.php';
10			require_once "POData\Providers\Query\IDataServiceQueryProvider2.php";
11			require_once 'NorthWindDSExpressionProvider.php';
12			define('DATABASE', 'Northwind');
13			// Note: The instance name of your sql server [How to find instance name]
14			// Start ->All progrmas->Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager
15			// In Configuration Manager -> SQL Server 2008 Services -> double click the SQL Service -> click the Service Tab.
16			define('SERVER', '.\SQLEXPRESS');
17			// Note: If your database access require credentials then un-comment
18			// the following two lines [definition of UID and PWD] and provide db user name
19			// as value for UID and password as value for PWD.
20			// define('UID', '');
21			// define('PWD', '');
22
23			class NorthWindQueryProvider implements IQueryProvider
			0 ignored issues – show Coding Style Compatibility introduced 2016-11-04 10:20 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... Bug introduced 2016-11-06 06:54 UTC by Report Bug Copy Issue Report There is at least one abstract method in this class. Maybe declare it as abstract, or implement the remaining methods: createResourceforResourceSet, deleteResource, updateResource 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 $_northWindSQLSRVExpressionProvider;
36
37			/**
38			* Constructs a new instance of NorthWindQueryProvider.

Algo-Web / POData

Push — master ( f0e0ca...79ebae )

getResourceFromRelatedResourceSet() C

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like