Raphaël G. Git Repositories - airbundle/blob - Resources/config/doctrine/Location.orm.yml

   1 Rapsys\AirBundle\Entity\Location:
   2     type: entity
   3     repositoryClass: Rapsys\AirBundle\Repository\LocationRepository
   4     table: locations
   5     id:
   6         id:
   7             type: integer
   8             generator:
   9                 strategy: AUTO
  10             options:
  11                 unsigned: true
  12     fields:
  13         title:
  14             type: string
  15             length: 32
  16         description:
  17             type: text
  18             nullable: true
  19         address:
  20             type: string
  21             length: 32
  22         zipcode:
  23             type: string
  24             length: 5
  25         city:
  26             type: string
  27             length: 64
  28         latitude:
  29             type: decimal
  30             precision: 8
  31             scale: 6
  32         longitude:
  33             type: decimal
  34             precision: 9
  35             scale: 6
  36         indoor:
  37             type: boolean
  38         hotspot:
  39             type: boolean
  40         created:
  41             type: datetime
  42         updated:
  43             type: datetime
  44     oneToMany:
  45         sessions:
  46             targetEntity: Rapsys\AirBundle\Entity\Session
  47             mappedBy: location
  48         snippets:
  49             targetEntity: Rapsys\AirBundle\Entity\Snippet
  50             mappedBy: location
  51     manyToMany:
  52         users:
  53             targetEntity: Rapsys\AirBundle\Entity\User
  54             mappedBy: locations
  55     indexes:
  56         #XXX: used in SessionRepository::(findAllPendingDailyWeather|findAllPendingHourlyWeather)
  57         zipcode:
  58             columns: [ zipcode ]
  59         city_zipcode2:
  60             columns: [ city, zipcode ]
  61             #XXX: see https://github.com/doctrine/dbal/pull/2412 and https://stackoverflow.com/questions/32539973/configuring-index-text-length-mysql-in-doctrine
  62             options:
  63                 lengths: [ ~, 2 ]
  64     lifecycleCallbacks:
  65         preUpdate: ['preUpdate']