X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/af8990a8d34a918fa399d345ccf7e4c370d8e2e9..af553e3433b3c7995776efc6152c5a93ea46b071:/Resources/config/doctrine/Location.orm.yml diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml index 86d86db..9d26144 100644 --- a/Resources/config/doctrine/Location.orm.yml +++ b/Resources/config/doctrine/Location.orm.yml @@ -1,6 +1,6 @@ Rapsys\AirBundle\Entity\Location: type: entity - #repositoryClass: Rapsys\AirBundle\Repository\LocationRepository + repositoryClass: Rapsys\AirBundle\Repository\LocationRepository table: locations id: id: @@ -12,7 +12,10 @@ Rapsys\AirBundle\Entity\Location: fields: title: type: string - length: 24 + length: 32 + description: + type: text + nullable: true address: type: string length: 32 @@ -30,6 +33,10 @@ Rapsys\AirBundle\Entity\Location: type: decimal precision: 9 scale: 6 + indoor: + type: boolean + hotspot: + type: boolean created: type: datetime updated: @@ -38,32 +45,21 @@ Rapsys\AirBundle\Entity\Location: sessions: targetEntity: Rapsys\AirBundle\Entity\Session mappedBy: location - -# manyToOne: -# title: -# targetEntity: Rapsys\UserBundle\Entity\Title -# inversedBy: users -# manyToMany: -# groups: -# targetEntity: Rapsys\UserBundle\Entity\Group -# inversedBy: users -# joinTable: -# name: groups_users -# -# manyToOne: -# site: -# targetEntity: Rapsys\BlogBundle\Entity\Site -# inversedBy: articles -# author: -# targetEntity: Rapsys\BlogBundle\Entity\Author -# inversedBy: articles -# manyToMany: -# keywords: -# targetEntity: Rapsys\BlogBundle\Entity\Keyword -# inversedBy: articles -# joinTable: -# name: articles_keywords -# oneToMany: -# article_translations: -# targetEntity: Rapsys\BlogBundle\Entity\ArticleTranslation -# mappedBy: article + snippets: + targetEntity: Rapsys\AirBundle\Entity\Snippet + mappedBy: location + manyToMany: + users: + targetEntity: Rapsys\AirBundle\Entity\User + mappedBy: locations + indexes: + #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']