RouteQuery::updateParentUrl() - Code Metrics - Inspection of "Merge branch 'development' of github.com:imagecms/..." - imagecms/ImageCMS - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — development ( 67765c...7029e6 )

by Andrij

created 2016-10-28 09:36 UTC

RouteQuery::updateParentUrl() A

↳ Parent: RouteQuery

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	4
nc	1
nop	2
dl	0
loc	7
rs	9.4285
c	0
b	0
f	0

<?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

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

class RouteQuery extends BaseRouteQuery
{


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

     */
    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

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

}

1			<?php
2
3			namespace core\models;
4
5			use core\models\Base\RouteQuery as BaseRouteQuery;
6			use core\models\Map\RouteTableMap;
7			use Propel\Runtime\ActiveQuery\Criteria;
8			use Propel\Runtime\Connection\Exception\ConnectionException;
9			use Propel\Runtime\Exception\PropelException;
10			use Propel\Runtime\Propel;
11
12			/**
13			* Skeleton subclass for performing query and update operations on the 'route' table.
14			*
15			*
16			*
17			* You should add additional methods to this class to meet the
			0 ignored issues – show introduced 2016-10-28 09:50 UTC by Report Bug Copy Issue Report There must be exactly one blank line between descriptions in a doc comment Loading history...
18			* application requirements. This class will only be generated as
19			* long as it does not already exist in the output directory.
20			*
21			*/
			0 ignored issues – show introduced 2016-10-28 09:50 UTC by Report Bug Copy Issue Report Additional blank lines found at end of doc comment Loading history...
22			class RouteQuery extends BaseRouteQuery
23			{
			0 ignored issues – show introduced 2016-10-28 09:50 UTC by Report Bug Copy Issue Report Opening brace of a class must be on the same line as the definition Loading history...
24
25			/**
26			* @param string $old
27			* @param string $new
28			* @throws ConnectionException
			0 ignored issues – show introduced 2016-10-28 09:50 UTC by Report Bug Copy Issue Report Comment missing or not on the next line for @throws tag in function comment Loading history...
29			*/
30			public function updateParentUrl($old, $new) {
31
32			$connection = Propel::getWriteConnection(RouteTableMap::DATABASE_NAME);
33			$sql = "UPDATE route SET parent_url = REPLACE(parent_url,:old,:new) WHERE parent_url LIKE CONCAT(:old ,'%')";
34			$connection->prepare($sql)->execute([':old' => $old, ':new' => $new]);
35
36			}
37
38			/**
39			* @param Route $route
40			* @throws PropelException
			0 ignored issues – show introduced 2016-10-28 09:50 UTC by Report Bug Copy Issue Report Comment missing or not on the next line for @throws tag in function comment Loading history...
41			*/
42			public function deleteWithChildren(Route $route) {
43			$this->filterByParentUrl($route->getFullUrl() . '%', Criteria::LIKE)->delete();
44			$route->delete();
45			}
46
47			}

imagecms / ImageCMS

Push — development ( 67765c...7029e6 )

RouteQuery::updateParentUrl() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like