X-Git-Url: https://git.rapsys.eu/.gitweb.cgi/airbundle/blobdiff_plain/f110b8ba20232e0ceeb67390f8e672431868d32d..91671b558fea0f751b36a4ae6fb796751af0ca4a:/Resources/config/doctrine/Session.orm.yml?ds=inline diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml index 9c89adb..1367613 100644 --- 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,22 @@ 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: 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 ]