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

   1 Rapsys\AirBundle\Entity\Session:
   2     type: entity
   3     repositoryClass: Rapsys\AirBundle\Repository\SessionRepository
   4     table: sessions
   5     id:
   6         id:
   7             type: integer
   8             generator:
   9                 strategy: AUTO
  10             options:
  11                 unsigned: true
  12     fields:
  13         date:
  14             type: date
  15         begin:
  16             type: time
  17             nullable: true
  18         length:
  19             type: time
  20             nullable: true
  21         premium:
  22             type: boolean
  23             nullable: true
  24         rainfall:
  25             type: float
  26             nullable: true
  27         rainrisk:
  28             type: float
  29             nullable: true
  30         realfeel:
  31             type: float
  32             nullable: true
  33         realfeelmin:
  34             type: float
  35             nullable: true
  36         realfeelmax:
  37             type: float
  38             nullable: true
  39         temperature:
  40             type: float
  41             nullable: true
  42         temperaturemin:
  43             type: float
  44             nullable: true
  45         temperaturemax:
  46             type: float
  47             nullable: true
  48         locked:
  49             type: datetime
  50             nullable: true
  51         created:
  52             type: datetime
  53         updated:
  54             type: datetime
  55     oneToOne:
  56         application:
  57             targetEntity: Rapsys\AirBundle\Entity\Application
  58     manyToOne:
  59         location:
  60             targetEntity: Rapsys\AirBundle\Entity\Location
  61             inversedBy: sessions
  62         slot:
  63             targetEntity: Rapsys\AirBundle\Entity\Slot
  64             inversedBy: sessions
  65     oneToMany:
  66         applications:
  67             targetEntity: Rapsys\AirBundle\Entity\Application
  68             mappedBy: session
  69     uniqueConstraints:
  70         date_location_slot:
  71             columns: [ date, location_id, slot_id ]
  72     indexes:
  73         #XXX: used in SessionRepository::findAllByPeriodAsCalendarArray
  74         date_location:
  75             columns: [ date, location_id ]
  76         #XXX: used in SessionRepository::findAllPendingApplication
  77         locked_date_begin_created:
  78             columns: [ locked, date, begin, created ]
  79         #XXX: used in SessionRepository::findBestApplicationById(s3)
  80         application_locked_date_begin_slot_created:
  81             columns: [ application_id, locked, date, begin, slot_id, created ]
  82         #XXX: candidated in findAllPendingDailyWeather and findAllPendingHourlyWeather
  83         location_date_begin_length_slot:
  84             columns: [ location_id, date, begin, length, slot_id ]
  85 #        #XXX: tried for SessionRepository::findBestApplicationById(s2)
  86 #        location_slot_application_locked_date_begin:
  87 #            columns: [ location_id, slot_id, application_id, locked, date ]
  88 #        #XXX: tried for SessionRepository::findBestApplicationById(s3)
  89 #        application_locked_date:
  90 #            columns: [ application_id, locked, date ]
  91 #        #XXX: tried for SessionRepository::findBestApplicationById(s4)
  92 #        location_application_locked_date:
  93 #            columns: [ location_id, application_id, locked, date ]
  94     lifecycleCallbacks:
  95         preUpdate: ['preUpdate']