Guest User

Untitled

a guest
Jan 18th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. $birthRepository = new BirthRepository();
  2. $qb = $birthRepository->createQueryBuilder('getDistinctBirths');
  3.  
  4. $qb->distinct()
  5. ->select('IDENTITY(b.species)')
  6. ->from(BirthModel::class, 'b')
  7. ->where('b.public = :public')
  8. ->setParameter('public', true);
  9.  
  10. $entries = $qb->getQuery()->getArrayResult();
  11. trigger_error(print_r($entries, true));
  12.  
  13. An exception occurred while executing 'SELECT a0_.species_id AS sclr_0 FROM aneBirths a1_, aneBirths a0_ WHERE a0_.bPublic = ?' with params [1]:
  14.  
  15. Unknown column 'a0_.species_id' in 'field list'
  16.  
  17. /**
  18. * Class SpeciesModel
  19. * @package aneclassesmodels
  20. * @Entity @Table(name="aneSpecies")
  21. */
  22. class SpeciesModel
  23. {
  24. /**
  25. * @Id
  26. * @Column(name="sId", type="integer")
  27. * @GeneratedValue(strategy="IDENTITY")
  28. * @var int $id
  29. */
  30. private $id;
  31.  
  32. /**
  33. * @Column(name="sName")
  34. * @var string $name
  35. */
  36. private $name;
  37.  
  38. }
  39.  
  40. /**
  41. * Class BirthModel
  42. * @package aneclassesmodels
  43. * @Entity @Table(name="aneBirths")
  44. */
  45. class BirthModel
  46. {
  47. /**
  48. * @Id
  49. * @Column(name="bId", type="integer")
  50. * @GeneratedValue
  51. * @var int
  52. */
  53. private $id;
  54.  
  55. /**
  56. * @Column(name="bName")
  57. * @var string
  58. */
  59. private $name;
  60.  
  61. /**
  62. * @OneToOne(targetEntity="SpeciesModel")
  63. * @ColumnJoin(name="bSpeciesId", type="integer")
  64. * @var SpeciesModel
  65. */
  66. private $species;
  67.  
  68. }
Add Comment
Please, Sign In to add comment