DBSelector::selectDBObjectByField() - Code Metrics - Asymptix/Framework - Measure and Improve Code Quality continuously with Scrutinizer

DBSelector::selectDBObjectByField() A
last analyzed 2018-07-31 14:35 UTC

↳ Parent: DBSelector
Complexity

Conditions	4
Paths	6
Size

Total Lines
Duplication

Lines	10
Ratio	37.04 %
Importance

Changes
Metric	Value
cc	4
nc	6
nop	3
dl	10
loc	27
rs	9.488
c	0
b	0
f	0
<?php

namespace Asymptix\db;

/**
 * Database selecting functionality.
 *
 * @category Asymptix PHP Framework
 * @author Dmytro Zarezenko <[email protected]>
 * @copyright (c) 2009 - 2018, Dmytro Zarezenko
 *
 * @git https://github.com/Asymptix/Framework
 * @license http://opensource.org/licenses/MIT
 */
class DBSelector extends \Asymptix\core\BasicObject {
    protected $fieldsList = [
        'conditions' => "",
        'order' => "",
        'offset' => 0,
        'count' => "all",
        'field' => ""
    ];

    /**
     * Inform DBSelector to select only unique records with DISTINCT.
     *
     * @var bool
     */
    public $unique = false;

    /**
     * Class name of the selector objects.
     *
     * @var string
     */
    private $className = null;

    /**
     * Selector object.
     *
     * @var DBObject
     */
    private $dbObject = null;

    public function __construct($className) {
        if (is_object($className)) {
            $className = get_class($className);
        }
        $this->className = $className;
        $this->dbObject = new $className();
    }

    /**
     * Validate if classname of the selector equal to the select method
     * classname.
     *
     * @param string $className
     */
    private function validateClassName($className) {
        if ($className != $this->className) {
            $classNamespaceParts = explode("\\", $this->className);
            if ($className != $classNamespaceParts[count($classNamespaceParts) - 1]) {
                throw new DBSelectorException(
                    "Invalid DB object classname '" . $className . "' in method name. " .
                    "Valid classname is '" . $this->className . "'"
                );
            }
        }
    }

    /**
     * Reset fields to the initial values.
     */
    public function reset() {
        $this->setFieldsValues([
            'conditions' => "",
            'order' => "",
            'offset' => 0,
            'count' => "all",
            'field' => ""
        ]);
    }

    /**
     * Wrapper setter method for set SQL query conditions.
     *
     * @param mixed $conditions
     */
    public function setConditions($conditions) {
        if (is_array($conditions)) {
            $conditions = DBQueryCondition::getSQLCondition($conditions);
        }
        $this->setFieldValue('conditions', trim($conditions));
    }

    /**
     * Selects DBObject from the database.
     *
     * @param bool $debug Debug flag.
     * @return DBObject
     */
    public function selectDBObject($debug = false) {
        $query = "SELECT * FROM " . $this->dbObject->getTableName()
               . ($this->conditions != "" ? " WHERE " . $this->conditions : "")
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
               . " LIMIT 1";

        if (!$debug) {
            $stmt = DBCore::doSelectQuery($query);
            if ($stmt !== false) {
                $dbObject = DBCore::selectDBObjectFromStatement($stmt, $this->dbObject);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

                $stmt->close();

                return $dbObject;
            }

            return null;
        }
        DBQuery::showQueryDebugInfo($query);

        return null;
    }

    /**
     * Selects DBObject by some field value.
     *
     * @param string $fieldName Name of the field.
     * @param mixed $fieldValue Field value.
     * @param bool $debug Debug mode flag.
     *
     * @return DBObject
     */
    public function selectDBObjectByField($fieldName, $fieldValue, $debug = false) {
        $query = "SELECT * FROM " . $this->dbObject->getTableName() . " WHERE " . $fieldName . " = ?";

        if ($this->conditions != "") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            $query .= " AND " . $this->conditions;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        $query.= $this->getQueryOrderSQL();
        $query.= " LIMIT 1";

        $fieldType = DBField::getType($fieldValue);
        if (!$debug) {

            $stmt = DBCore::doSelectQuery($query, $fieldType, [$fieldValue]);
            if ($stmt != false) {
                $dbObject = DBCore::selectDBObjectFromStatement($stmt, $this->dbObject);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

                $stmt->close();

                return $dbObject;
            }

            return null;
        }
        DBQuery::showQueryDebugInfo($query, $fieldType, [$fieldValue]);

        return null;
    }

    /**
     * Selects DBObject by ID.
     *
     * @param mixed $objectId Id of the DB record (primary index).
     * @param bool $debug Debug mode flag.
     *
     * @return DBObject
     */
    public function selectDBObjectById($objectId = null, $debug = false) {
        if (is_null($objectId)) {
            $objectId = $this->dbObject->id;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return $this->selectDBObjectByField($this->dbObject->getIdFieldName(), $objectId, $debug);
    }

    /**
     * Selects DBObjects by some predefined condition.
     *
     * @param bool $debug Debug mode flag.
     *
     * @return array<DBObject>
     */
    public function selectDBObjects($debug = false) {
        $query = "SELECT" . ($this->unique ? " DISTINCT" : "")
               . " * FROM " . $this->dbObject->getTableName();

        if ($this->conditions != "") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            $query .= " WHERE " . $this->conditions;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        $query.= $this->getQueryOrderSQL();
        $query.= $this->getQueryLimitSQL();

        if (!$debug) {
            $stmt = DBCore::doSelectQuery($query);
            if ($stmt !== false) {
                $dbObjects = DBCore::selectDBObjectsFromStatement($stmt, $this->dbObject);

                $stmt->close();

                return $dbObjects;
            }

            return [];
        }
        DBQuery::showQueryDebugInfo($query);

        return [];
    }

    /**
     * Selects DBObjects by some field value.
     *
     * @param string $fieldName Name of the field.
     * @param mixed $fieldValue Field value.
     * @param bool $debug Debug mode flag.
     *
     * @return array<DBObject>
     */
    public function selectDBObjectsByField($fieldName, $fieldValue, $debug = false) {
        $query = "SELECT * FROM " . $this->dbObject->getTableName();
        $query .= " WHERE " . $fieldName . " = ?";

        if ($this->conditions != "") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            $query .= " AND " . $this->conditions;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        $query.= $this->getQueryOrderSQL();
        $query.= $this->getQueryLimitSQL();

        $fieldType = DBField::getType($fieldValue);
        if (!$debug) {

            $stmt = DBCore::doSelectQuery($query, $fieldType, [$fieldValue]);
            if ($stmt != false) {
                $dbObjects = DBCore::selectDBObjectsFromStatement($stmt, get_class($this->dbObject));

                $stmt->close();

                return $dbObjects;
            }

            return [];
        }
        DBQuery::showQueryDebugInfo($query, $fieldType, [$fieldValue]);

        return [];
    }

    /**
     * Count number of records by some predefined condition.
     *
     * @return int Number of records.
     */
    public function count() {

        $query = "SELECT count(*) FROM " . $this->dbObject->getTableName();

        if ($this->conditions != "") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            $query .= " WHERE " . $this->conditions;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return DBCore::selectSingleValue($query);
    }

    /**
     * Selects max value of some field by some predefined condition.
     *
     * @return int Number of records.
     */
    public function max() {

        $query = "SELECT max(`" . $this->field . "`) FROM " . $this->dbObject->getTableName();
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}

        if ($this->conditions != "") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            $query .= " WHERE " . $this->conditions;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return DBCore::selectSingleValue($query);
    }

    /**
     * Selects min value of some field by some predefined condition.
     *
     * @return int Number of records.
     */
    public function min() {

        $query = "SELECT min(`" . $this->field . "`) FROM " . $this->dbObject->getTableName();
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}

        if ($this->conditions != "") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            $query .= " WHERE " . $this->conditions;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return DBCore::selectSingleValue($query);
    }

    /**
     * Returns SQL ORDER string for current selector.
     *
     * @return string
     */
    private function getQueryOrderSQL() {
        if ($this->order != "") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            return (" ORDER BY " . $this->order);
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return (" ORDER BY " . $this->dbObject->getIdFieldName() . " DESC");
    }

    /**
     * Returns SQL LIMIT string for current selector.
     *
     * @return string
     */
    private function getQueryLimitSQL() {
        if ($this->count !== "all") {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            if ($this->offset > 0) {
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                return (" LIMIT " . $this->offset . "," . $this->count);
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            }

            return (" LIMIT " . $this->count);
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return "";
    }

    /**
     * Magic methods for readable method names.
     *
     * @param string $methodName Name of the method.
     * @param array $methodParams Method parameters.
     *
     * @return mixed
     * @throws DBSelectorException
     */
    public function __call($methodName, $methodParams) {
        /*
         * Selects DBObject record by some field value.
         *
         * @param <mixed> Value of the field
         *
         * @return DBObject
         */
        if (preg_match("#^select([[:alpha:]]+)By([[:alpha:]]+)#", $methodName, $matches)) {
            if (empty($methodParams[0])) {
                return null;
            }
            $this->validateClassName($matches[1]);

            $fieldName = substr(strtolower(preg_replace("#([A-Z]{1})#", "_$1", $matches[2])), 1);
            $fieldValue = $methodParams[0];

            if ($fieldName == "id") {
                return $this->selectDBObjectById($fieldValue);
            }

            return $this->selectDBObjectByField($fieldName, $fieldValue);
        }

        /*
         * Selects all class of DBObject records from database by some order.
         *
         * @param string SQL order string (optional).
         *
         * @return array<DBObject>
         */
        elseif (preg_match("#^selectAll([A-Z]{1}[[:alpha:]]+)s#", $methodName, $matches)) {
            $this->validateClassName(preg_replace("#ie$#", "y", $matches[1]));

            $this->order = "`" . $this->dbObject->getIdFieldName() . "` DESC";
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            if (isset($methodParams[0])) {
                $this->order = (string)$methodParams[0];
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
            }

            $dbObjects = $this->selectDBObjects();
            $this->reset();

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

        /*
         * Selects DBObject records from database.
         *
         * @return array<DBObject>
         */
        elseif (preg_match("#^select([[:alpha:]]+)s#", $methodName, $matches)) {
            $this->validateClassName(preg_replace("#ie$#", "y", $matches[1]));

            return $this->selectDBObjects();
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());
}
        }

        /*
         * Selects DBObject record from database.
         *
         * @return array<DBObject>
         */
        elseif (preg_match("#^select([[:alpha:]]+)#", $methodName, $matches)) {
            $this->validateClassName($matches[1]);

            return $this->selectDBObject();
        }

        /*
         * Try to call parent method __call() with same params by default
         */
        $method = substr($methodName, 0, 3);
        $fieldName = $this->getFieldName(substr($methodName, 3));

        switch ($method) {

            case ("set"):
                $fieldValue = $methodParams[0];

                return $this->setFieldValue($fieldName, $fieldValue);
            case ("get"):
                return $this->getFieldValue($fieldName);
            default:
                throw new DBSelectorException("No method with name '" . $methodName . "'");
        }
    }
}

/**
 * Service exception class.
 */
class DBSelectorException extends \Exception {}


1			<?php
2
3			namespace Asymptix\db;
4
5			/**
6			* Database selecting functionality.
7			*
8			* @category Asymptix PHP Framework
9			* @author Dmytro Zarezenko <[email protected]>
10			* @copyright (c) 2009 - 2018, Dmytro Zarezenko
11			*
12			* @git https://github.com/Asymptix/Framework
13			* @license http://opensource.org/licenses/MIT
14			*/
15			class DBSelector extends \Asymptix\core\BasicObject {
16			protected $fieldsList = [
17			'conditions' => "",
18			'order' => "",
19			'offset' => 0,
20			'count' => "all",
21			'field' => ""
22			];
23
24			/**
25			* Inform DBSelector to select only unique records with DISTINCT.
26			*
27			* @var bool
28			*/
29			public $unique = false;
30
31			/**
32			* Class name of the selector objects.
33			*
34			* @var string
35			*/
36			private $className = null;
37
38			/**
39			* Selector object.
40			*
Asymptix / Framework

DBSelector::selectDBObjectByField() A last analyzed 2018-07-31 14:35 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DBSelector::selectDBObjectByField() A
last analyzed 2018-07-31 14:35 UTC
