Mysql Views Table in Symfony 2

Question

I have view table in my Database, how can I retrieve the data from this views?

I tried to use

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQuery('SELECT * FROM my_views');
$result = $query->getResult();

but it doesn't work.

What you have written inside your createQuery is native SQL while createQuery expects DQL statements. — Dipen Shah
– Dipen Shah, Commented Jul 21, 2015 at 15:11
Hi @monkeyUser, yes, if you want to map the result in an object you need to write the relative class or use an existing one and map the field as you want — Matteo
– Matteo, Commented Jul 22, 2015 at 8:48

Raphaël Malié · Accepted Answer · 2015-07-21 15:24:50Z

3

If you want to perform a simple SQL query, you can do that :

$con = $this->getDoctrine()->getEntityManager()->getConnection();
$stmt = $con->executeQuery('SELECT * FROM my_views');
foreach ($stmt->fetchAll() as $row){
   print_r($row);
}

When you use $em->createQuery(), you need to work with Doctrine entities.

If you want to use the mapping with your view, juste create an entity :

namespace Your\Bundle\Entity;

/**
 * @ORM\Entity
 * @ORM\Table(name="my_view")
 */
class MyView
{
    /**
     * @ORM\Column(type="integer")
     * @ORM\Id
     */
    protected $id;

    /**
     * @ORM\Column(type="string")
     */
    protected $someVarcharColumn;

    public function getId()
    {
        return $this->id;
    }

    public function getSomeVarcharColumn()
    {
        return $this->someVarcharColumn;
    }
}

And you can query it with DQL like this :

$results = $em->createQuery('
   SELECT v
   FROM YourBundle:MyView v
')->getResult();

edited Jul 21, 2015 at 15:24

answered Jul 21, 2015 at 15:14

Raphaël Malié

4,0221 gold badge24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

monkeyUser Over a year ago

so nice, Can I do also a mapping on Views? I'd like to have getter methods

monkeyUser Over a year ago

Thanks for your time. I have to create an entity in "manually" way, I can't have this entity with some function?

Raphaël Malié Over a year ago

You can generate entities from the database, but I'm not familiar with this, so you should read the documentation here : symfony.com/doc/current/cookbook/doctrine/…

monkeyUser Over a year ago

I already used symfony.com/doc/current/cookbook/doctrine/… for "classic" table, I don't know if is good also for the views... Thanks again !

aniban Over a year ago

After I create the view, I run schema:update and cache:clear and composer update. But it gives me an error No mapping file found named 'MyView.orm.yml' for class 'YourBundle\Entity\MyView. I am using Symfony 2.8...Thanks in advance.

|

Collectives™ on Stack Overflow

Mysql Views Table in Symfony 2

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related