DDC657Test.php 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118
  1. <?php
  2. namespace Doctrine\Tests\ORM\Functional\Ticket;
  3. require_once __DIR__ . '/../../../TestInit.php';
  4. use Doctrine\Tests\Models\Generic\DateTimeModel;
  5. /**
  6. * @group DDC-657
  7. */
  8. class DDC657Test extends \Doctrine\Tests\OrmFunctionalTestCase
  9. {
  10. const NS = 'Doctrine\Tests\Models\Generic';
  11. protected function setUp()
  12. {
  13. $this->useModelSet('generic');
  14. parent::setUp();
  15. $this->loadFixtures();
  16. }
  17. public function testEntitySingleResult()
  18. {
  19. $query = $this->_em->createQuery('SELECT d FROM ' . self::NS . '\DateTimeModel d');
  20. $datetime = $query->setMaxResults(1)->getSingleResult();
  21. $this->assertTrue($datetime instanceof DateTimeModel);
  22. $this->assertTrue($datetime->datetime instanceof \DateTime);
  23. $this->assertTrue($datetime->time instanceof \DateTime);
  24. $this->assertTrue($datetime->date instanceof \DateTime);
  25. }
  26. public function testScalarResult()
  27. {
  28. $query = $this->_em->createQuery('SELECT d.id, d.time, d.date, d.datetime FROM ' . self::NS . '\DateTimeModel d ORDER BY d.date ASC');
  29. $result = $query->getScalarResult();
  30. $this->assertCount(2,$result);
  31. $this->assertContains('11:11:11', $result[0]['time']);
  32. $this->assertContains('2010-01-01', $result[0]['date']);
  33. $this->assertContains('2010-01-01 11:11:11', $result[0]['datetime']);
  34. $this->assertContains('12:12:12', $result[1]['time']);
  35. $this->assertContains('2010-02-02', $result[1]['date']);
  36. $this->assertContains('2010-02-02 12:12:12', $result[1]['datetime']);
  37. }
  38. public function testaTicketEntityArrayResult()
  39. {
  40. $query = $this->_em->createQuery('SELECT d FROM ' . self::NS . '\DateTimeModel d ORDER BY d.date ASC');
  41. $result = $query->getArrayResult();
  42. $this->assertCount(2,$result);
  43. $this->assertTrue($result[0]['datetime'] instanceof \DateTime);
  44. $this->assertTrue($result[0]['time'] instanceof \DateTime);
  45. $this->assertTrue($result[0]['date'] instanceof \DateTime);
  46. $this->assertTrue($result[1]['datetime'] instanceof \DateTime);
  47. $this->assertTrue($result[1]['time'] instanceof \DateTime);
  48. $this->assertTrue($result[1]['date'] instanceof \DateTime);
  49. }
  50. public function testTicketSingleResult()
  51. {
  52. $query = $this->_em->createQuery('SELECT d.id, d.time, d.date, d.datetime FROM ' . self::NS . '\DateTimeModel d ORDER BY d.date ASC');
  53. $datetime = $query->setMaxResults(1)->getSingleResult();
  54. $this->assertTrue(is_array($datetime));
  55. $this->assertTrue($datetime['datetime'] instanceof \DateTime);
  56. $this->assertTrue($datetime['time'] instanceof \DateTime);
  57. $this->assertTrue($datetime['date'] instanceof \DateTime);
  58. }
  59. public function testTicketResult()
  60. {
  61. $query = $this->_em->createQuery('SELECT d.id, d.time, d.date, d.datetime FROM ' . self::NS . '\DateTimeModel d ORDER BY d.date ASC');
  62. $result = $query->getResult();
  63. $this->assertCount(2,$result);
  64. $this->assertTrue($result[0]['time'] instanceof \DateTime);
  65. $this->assertTrue($result[0]['date'] instanceof \DateTime);
  66. $this->assertTrue($result[0]['datetime'] instanceof \DateTime);
  67. $this->assertEquals('2010-01-01 11:11:11', $result[0]['datetime']->format('Y-m-d G:i:s'));
  68. $this->assertTrue($result[1]['time'] instanceof \DateTime);
  69. $this->assertTrue($result[1]['date'] instanceof \DateTime);
  70. $this->assertTrue($result[1]['datetime'] instanceof \DateTime);
  71. $this->assertEquals('2010-02-02 12:12:12', $result[1]['datetime']->format('Y-m-d G:i:s'));
  72. }
  73. public function loadFixtures()
  74. {
  75. $timezone = new \DateTimeZone('America/Sao_Paulo');
  76. $dateTime1 = new DateTimeModel();
  77. $dateTime2 = new DateTimeModel();
  78. $dateTime1->date = new \DateTime('2010-01-01', $timezone);
  79. $dateTime1->time = new \DateTime('2010-01-01 11:11:11', $timezone);
  80. $dateTime1->datetime= new \DateTime('2010-01-01 11:11:11', $timezone);
  81. $dateTime2->date = new \DateTime('2010-02-02', $timezone);
  82. $dateTime2->time = new \DateTime('2010-02-02 12:12:12', $timezone);
  83. $dateTime2->datetime= new \DateTime('2010-02-02 12:12:12', $timezone);
  84. $this->_em->persist($dateTime1);
  85. $this->_em->persist($dateTime2);
  86. $this->_em->flush();
  87. }
  88. }