X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/1b74aba3b3208deed91863e634ca74827dddfdc2..f6e5df0b39d856f05ceea3e3c784ad936530b8c4:/Resources/config/doctrine/Session.orm.yml diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml index 810c4a0..9631e93 100644 --- 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 @@ -44,6 +45,9 @@ Rapsys\AirBundle\Entity\Session: temperaturemax: type: float nullable: true + locked: + type: datetime + nullable: true created: type: datetime updated: @@ -66,5 +70,23 @@ Rapsys\AirBundle\Entity\Session: date_location_slot: columns: [ date, location_id, slot_id ] indexes: - application_date_begin_slot_created: - columns: [ application_id, date, begin, slot_id, created ] + #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: candidated in findAllPendingDailyWeather and findAllPendingHourlyWeather + location_date_begin_length_slot: + columns: [ location_id, date, begin, length, slot_id ] +# #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 ] + lifecycleCallbacks: + preUpdate: ['preUpdate']