thecodingmachine / tdbm

     *

     * @throws TDBMException

     */

    public function findObject(string $mainTable, $filter = null, array $parameters = array(), array $additionalTablesFetch = array(), string $className = null)

    {

        $objects = $this->findObjects($mainTable, $filter, $parameters, null, $additionalTablesFetch, self::MODE_ARRAY, $className);

        $page = $objects->take(0, 2);

        $pageArr = $page->toArray();

        // Optimisation: the $page->count() query can trigger an additional SQL query in platforms other than MySQL.

        // We try to avoid calling at by fetching all 2 columns instead.

        $count = count($pageArr);

        if ($count > 1) {

            throw new DuplicateRowException("Error while querying an object for table '$mainTable': More than 1 row have been returned, but we should have received at most one.");

        } elseif ($count === 0) {

            return;

        }

        return $pageArr[0];

    }

    /**

     * Returns a unique bean (or null) according to the filters passed in parameter.

     *

     * @throws TDBMException

     */

    public function findObjectFromSql($mainTable, $from, $filter = null, array $parameters = array(), $className = null)

    {

        $objects = $this->findObjectsFromSql($mainTable, $from, $filter, $parameters, null, self::MODE_ARRAY, $className);

        $page = $objects->take(0, 2);

        $count = $page->count();

        if ($count > 1) {

            throw new DuplicateRowException("Error while querying an object for table '$mainTable': More than 1 row have been returned, but we should have received at most one.");

        } elseif ($count === 0) {

            return;

        }

        return $page[0];

    }

    /**

     * @param string $mainTable