core\models\RouteQuery

Complexity

Total Complexity

2

Size/Duplication

Total Lines	26
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	updateParentUrl()	0	7	1
A	deleteWithChildren()	0	4	1

<?php

namespace core\models;

use core\models\Base\RouteQuery as BaseRouteQuery;
use core\models\Map\RouteTableMap;
use Propel\Runtime\ActiveQuery\Criteria;
use Propel\Runtime\Connection\Exception\ConnectionException;
use Propel\Runtime\Exception\PropelException;
use Propel\Runtime\Propel;

/**
 * Skeleton subclass for performing query and update operations on the 'route' table.
 *
 *
 *
 * You should add additional methods to this class to meet the

There must be exactly one blank line between descriptions in a doc comment

 * application requirements.  This class will only be generated as
 * long as it does not already exist in the output directory.
 *
 */

Additional blank lines found at end of doc comment

class RouteQuery extends BaseRouteQuery
{

Opening brace of a class must be on the same line as the definition

    /**
     * @param string $old
     * @param string $new
     * @throws ConnectionException

Comment missing or not on the next line for @throws tag in function comment

     */
    public function updateParentUrl($old, $new) {

        $connection = Propel::getWriteConnection(RouteTableMap::DATABASE_NAME);
        $sql = "UPDATE route SET parent_url = REPLACE(parent_url,:old,:new) WHERE parent_url LIKE CONCAT(:old ,'%')";
        $connection->prepare($sql)->execute([':old' => $old, ':new' => $new]);

    }

    /**
     * @param Route $route
     * @throws PropelException

Comment missing or not on the next line for @throws tag in function comment

     */
    public function deleteWithChildren(Route $route) {
        $this->filterByParentUrl($route->getFullUrl() . '%', Criteria::LIKE)->delete();
        $route->delete();
    }

}