X-Git-Url: https://git.rapsys.eu/.gitweb.cgi/airbundle/blobdiff_plain/af8990a8d34a918fa399d345ccf7e4c370d8e2e9..61e56d402916a10280b733c1644cebd4a28d1f7d:/Resources/config/doctrine/Session.orm.yml?ds=sidebyside diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml index 9c89adb..fb1e962 100644 --- a/Resources/config/doctrine/Session.orm.yml +++ b/Resources/config/doctrine/Session.orm.yml @@ -15,9 +15,39 @@ Rapsys\AirBundle\Entity\Session: begin: type: time nullable: true - end: + length: type: time nullable: true + premium: + type: boolean + nullable: true + 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 +69,27 @@ Rapsys\AirBundle\Entity\Session: uniqueConstraints: 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 ] + #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']