]> Raphaël G. Git Repositories - airbundle/commitdiff
Add city_zipcode3 index
authorRaphaël Gertz <git@rapsys.eu>
Mon, 24 Oct 2022 08:06:17 +0000 (10:06 +0200)
committerRaphaël Gertz <git@rapsys.eu>
Mon, 24 Oct 2022 08:06:17 +0000 (10:06 +0200)
Resources/config/doctrine/Location.orm.yml

index ba031a0f95b5366f0036e2c1562ba35b99010589..9d261442e0dd6be5c47913e52bba2399cfd8327c 100644 (file)
@@ -56,5 +56,10 @@ Rapsys\AirBundle\Entity\Location:
         #XXX: used in SessionRepository::(findAllPendingDailyWeather|findAllPendingHourlyWeather)
         zipcode:
             columns: [ zipcode ]
         #XXX: used in SessionRepository::(findAllPendingDailyWeather|findAllPendingHourlyWeather)
         zipcode:
             columns: [ zipcode ]
+        city_zipcode3:
+            columns: [ city, zipcode ]
+            #XXX: see https://github.com/doctrine/dbal/pull/2412 and https://stackoverflow.com/questions/32539973/configuring-index-text-length-mysql-in-doctrine
+            options:
+                lengths: [ ~, 3 ]
     lifecycleCallbacks:
         preUpdate: ['preUpdate']
     lifecycleCallbacks:
         preUpdate: ['preUpdate']