X-Git-Url: https://git.rapsys.eu/.gitweb.cgi/airbundle/blobdiff_plain/6948e6377b0c7596f60c08f20f65f324f0b56bba..930fbd80c4f8fc07b94b02c73e5720d3a07cf92d:/Resources/config/doctrine/Location.orm.yml diff --git a/Resources/config/doctrine/Location.orm.yml b/Resources/config/doctrine/Location.orm.yml index 0b276fa..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: @@ -13,9 +13,9 @@ Rapsys\AirBundle\Entity\Location: title: type: string length: 32 - short: - type: string - length: 16 + description: + type: text + nullable: true address: type: string length: 32 @@ -33,6 +33,10 @@ Rapsys\AirBundle\Entity\Location: type: decimal precision: 9 scale: 6 + indoor: + type: boolean + hotspot: + type: boolean created: type: datetime updated: @@ -41,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']