gistfile1.php

<?php 

include __DIR__ . '/bootstrap.php';

use DoctrineNaPratica\Model\User;
use DoctrineNaPratica\Model\Course;
use DoctrineNaPratica\Model\Lesson;
use DoctrineNaPratica\Model\Subscription;

// $user = new User;
// $user->setName('Steve Jobs');
// $user->setLogin('sjobs');
// $user->setEmail('sjobs@gmail.com');
// $user->setAvatar('morto.png');

// $subscription = new Subscription;
// $subscription->setStatus(1);
// $subscription->setStarted(\DateTime::createFromFormat('Y-m-d H:i:s', date('Y-m-d H:i:s')));
// $subscription->setUser($user);
// $user->setSubscription($subscription);

// $entityManager->persist($user);
// $entityManager->flush();

// $user = $entityManager->find('DoctrineNaPratica\Model\User', 1);
// echo $user->getName(), "\n";

// $users = $entityManager->getRepository('DoctrineNaPratica\Model\User')
//                        ->findAll();
// foreach ($users as $user) {
//     echo $user->getName(), "\n";
// }

// $feios = $entityManager->getRepository('DoctrineNaPratica\Model\User')
//                        ->findBy(array('avatar' => 'feio.png', 'name' => 'Elton'), $order, $limit, $offset);
// foreach ($feios as $user) {
//     echo $user->getName(), "\n";
// }

// $user = $entityManager->find('DoctrineNaPratica\Model\User', 1);
// $user->setName('Elton Minetto');
// $entityManager->persist($user);
// $entityManager->flush();
// 
// 

// $jobs = $entityManager->getRepository('DoctrineNaPratica\Model\User')
//                        ->findOneBy(array('login' => 'sjobs'));

// $jobs = $entityManager->getRepository('DoctrineNaPratica\Model\User')
//                        ->findOneByLogin('sjobs');

// echo $jobs->getName();

// $course = new Course;
// $course->setName('Computação');
// $course->setValue(100);

// $programacao = new Lesson;
// $programacao->setName('Programação');
// $programacao->setCourse($course);

// $course->getLessonCollection()->add($programacao);

// $jobs->getLessonCollection()->add($programacao);


// $jobs->getLessonCollection()->remove(0);

// $entityManager->persist($jobs);
// $entityManager->flush();



// $query = $entityManager->createQuery('select u.login from DoctrineNaPratica\Model\User u');
// $users = $query->getResult(\Doctrine\ORM\Query::HYDRATE_SINGLE_SCALAR);
// print_r($users);

// foreach ($users as $user) {
//     echo $user['u_name'], "\n";
// }


$db = $entityManager->createQueryBuilder();
$db->select('count(u.login) as c')->from('DoctrineNaPratica\Model\User', 'u');
$query = $db->getQuery();
$users = $query->getSingleScalarResult();
print_r($users);

// foreach ($users as $user) {
//     echo $user->getName(), "\n";
// }