kujaff\VersionsBundle\Model\DoctrineHelper

Complexity

Total Complexity

6

Size/Duplication

Total Lines	49
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	3
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	executeDQL()	0	9	2
A	executeSQL()	0	10	2
A	dropTables()	0	6	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();

The property container does not exist. Did you maybe forget to declare it?

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