DoctrineHelper::executeSQL() - Code Metrics - steevanb/versionsbundle - Measure and Improve Code Quality continuously with Scrutinizer

DoctrineHelper::executeSQL() A
last analyzed 2016-04-04 15:38 UTC

↳ Parent: DoctrineHelper

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Metric	Value
dl	0
loc	10
rs	9.4285
cc	2
eloc	7
nc	2
nop	2

<?php

namespace kujaff\VersionsBundle\Model;

/**
 * Helps your using Doctrine
 * Just needs a property ContainerInterface $container
 */
trait DoctrineHelper
{
    /**
     * Execute a DQL query (only for SELECT, UPDATE or DELETE)
     *
     * @param string $dql
     * @param array $parameters
     * @return mixed
     */
    protected function executeDQL($dql, array $parameters = array())
    {
        $em = $this->container->get('doctrine')->getManager();
class MyClass { }

$x = new MyClass();
$x->foo = true;
        $query = $em->createQuery($dql);
        foreach ($parameters as $name => $value) {
            $query->setParameter($name, $value);
        }
        return $query->getResult();
    }

    /**
     * Execute raw SQL
     *
     * @param string $sql
     * @param array $parameters
     * @return \Doctrine\DBAL\Statement
     */
    protected function executeSQL($sql, array $parameters = array())
    {
        $em = $this->container->get('doctrine')->getManager();
        $stmt = $em->getConnection()->prepare($sql);
        foreach ($parameters as $name => $value) {
            $stmt->bindValue($name, $value);
        }
        $stmt->execute();
        return $stmt;
    }

    /**
     * Drop tables if exists
     *
     * @param array $tables
     */
    protected function dropTables(array $tables)
    {
        foreach ($tables as $table) {
            $this->executeSQL('DROP TABLE IF EXISTS ' . $table);
        }
    }
}


1			<?php
2
3			namespace kujaff\VersionsBundle\Model;
4
5			/**
6			* Helps your using Doctrine
7			* Just needs a property ContainerInterface $container
8			*/
9			trait DoctrineHelper
10			{
11			/**
12			* Execute a DQL query (only for SELECT, UPDATE or DELETE)
13			*
14			* @param string $dql
15			* @param array $parameters
16			* @return mixed
17			*/
18			protected function executeDQL($dql, array $parameters = array())
19			{
20			$em = $this->container->get('doctrine')->getManager();
			0 ignored issues – show Bug introduced 2016-04-04 15:35 UTC by Report Bug Copy Issue Report The property `container` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
21			$query = $em->createQuery($dql);
22			foreach ($parameters as $name => $value) {
23			$query->setParameter($name, $value);
24			}
25			return $query->getResult();
26			}
27
28			/**
29			* Execute raw SQL
30			*
31			* @param string $sql
32			* @param array $parameters
33			* @return \Doctrine\DBAL\Statement
34			*/
35			protected function executeSQL($sql, array $parameters = array())
36			{
37			$em = $this->container->get('doctrine')->getManager();
38			$stmt = $em->getConnection()->prepare($sql);
39			foreach ($parameters as $name => $value) {
40			$stmt->bindValue($name, $value);
41			}
42			$stmt->execute();
43			return $stmt;
44			}
45
46			/**
47			* Drop tables if exists
48			*
49			* @param array $tables
50			*/
51			protected function dropTables(array $tables)
52			{
53			foreach ($tables as $table) {
54			$this->executeSQL('DROP TABLE IF EXISTS ' . $table);
55			}
56			}
57			}
58

steevanb / versionsbundle

DoctrineHelper::executeSQL() A last analyzed 2016-04-04 15:38 UTC

Complexity

Size

Duplication

Duplication Side-by-Side

Filter issues like

DoctrineHelper::executeSQL() A
last analyzed 2016-04-04 15:38 UTC