Add date location index

[airbundle] / Resources / config / doctrine / Session.orm.yml

diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml
index 1367613b15fcb7bff6199d0fee85ae68d8b6f0ff..fb1e962ba00f7f5fd5eb52451995ea9c131db256 100644 (file)
--- a/Resources/config/doctrine/Session.orm.yml
+++ b/Resources/config/doctrine/Session.orm.yml
@@ -20,6 +20,7 @@ Rapsys\AirBundle\Entity\Session:
             nullable: true
         premium:
             type: boolean
+            nullable: true
         rainfall:
             type: float
             nullable: true
@@ -69,6 +70,9 @@ Rapsys\AirBundle\Entity\Session:
         date_location_slot:
             columns: [ date, location_id, slot_id ]
     indexes:
+        #XXX: used in SessionRepository::findAllByPeriodAsCalendarArray
+        date_location:
+            columns: [ date, location_id ]
         #XXX: used in SessionRepository::findAllPendingApplication
         locked_date_begin_created:
             columns: [ locked, date, begin, created ]
@@ -87,3 +91,5 @@ Rapsys\AirBundle\Entity\Session:
 #        #XXX: tried for SessionRepository::findBestApplicationById(s4)
 #        location_application_locked_date:
 #            columns: [ location_id, application_id, locked, date ]
+    lifecycleCallbacks:
+        preUpdate: ['preUpdate']