Add index for findAllPendingApplication and findBestApplicationById

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

diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml
index 9c89adb927f8e40cbca1eade9459555d8919dab6..cccafa6fa7fdaf79a75259e26086014b21527e58 100644 (file)
--- a/Resources/config/doctrine/Session.orm.yml
+++ b/Resources/config/doctrine/Session.orm.yml
@@ -15,9 +15,38 @@ Rapsys\AirBundle\Entity\Session:
         begin:
             type: time
             nullable: true
-        end:
+        length:
             type: time
             nullable: true
+        premium:
+            type: boolean
+        rainfall:
+            type: float
+            nullable: true
+        rainrisk:
+            type: float
+            nullable: true
+        realfeel:
+            type: float
+            nullable: true
+        realfeelmin:
+            type: float
+            nullable: true
+        realfeelmax:
+            type: float
+            nullable: true
+        temperature:
+            type: float
+            nullable: true
+        temperaturemin:
+            type: float
+            nullable: true
+        temperaturemax:
+            type: float
+            nullable: true
+        locked:
+            type: datetime
+            nullable: true
         created:
             type: datetime
         updated:
@@ -39,3 +68,19 @@ Rapsys\AirBundle\Entity\Session:
     uniqueConstraints:
         date_location_slot:
             columns: [ date, location_id, slot_id ]
+    indexes:
+        #XXX: used in SessionRepository::findAllPendingApplication
+        locked_date_begin_created:
+            columns: [ locked, date, begin, created ]
+        #XXX: used in SessionRepository::findBestApplicationById(s3)
+        application_locked_date_begin_slot_created:
+            columns: [ application_id, locked, date, begin, slot_id, created ]
+#        #XXX: tried for SessionRepository::findBestApplicationById(s2)
+#        location_slot_application_locked_date_begin:
+#            columns: [ location_id, slot_id, application_id, locked, date ]
+#        #XXX: tried for SessionRepository::findBestApplicationById(s3)
+#        application_locked_date:
+#            columns: [ application_id, locked, date ]
+#        #XXX: tried for SessionRepository::findBestApplicationById(s4)
+#        location_application_locked_date:
+#            columns: [ location_id, application_id, locked, date ]