Uploaded image for project: 'Doctrine 2 - ORM'
  1. Doctrine 2 - ORM
  2. DDC-298

Allow Entity to hold a collection of a single primitive type

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.1
    • Fix Version/s: 2.x
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None

      Description

      Sometimes you want to save arbitrary information for an entity using a key -> value array-structure. JPA supports this by means of the @ElementCollection annotation with allows to specify HashMaps for example.

      I propose a new AssocationMapping called "ElementMapping" / "ElementCollection" and annotations (options):

      ElementCollection
      + elementTable
      + keyType
      + keyLength
      + keyColumnDefinition
      + valueType
      + valueLength
      + valueColumnDefinition
      

      The key and value definitions are necessary for converting and schema generation.

      The implementation would make use of the PersistentCollection at all times and work as any other persistent collection just with primitive types.

      Restrictions for a first implementation:

      • Only available as a Lazy-Load Collection, no hydration with the source entity
      • Can't be used in queries alike "entity.colname.key = ?1"

      Use-Case:

      $entity->options['foo'] = 'bar';
      $entity->options['bar'] = 'baz';
      

      This could be done for 2.0 imho, adding the necessary changes and optimizations could then be scheduled for 2.1

        Issue Links

          Activity

          beberlei Benjamin Eberlei created issue -
          beberlei Benjamin Eberlei made changes -
          Field Original Value New Value
          Description Sometimes you want to save arbitrary information for an entity using a key -> value array-structure. JPA supports this by means of the @ElementCollection annotation with allows to specify HashMaps for example.

          I propose a new AssocationMapping called "ElementMapping" / "ElementCollection" and annotations (options):

          {code}
          ElementCollection
          + elementTable
          + keyType
          + keyLength
          + keyColumnDefinition
          + valueType
          + valueLength
          + valueColumnDefinition
          {code}

          The key and value definitions are necessary for converting and schema generation.

          The implementation would make use of the PersistentCollection at all times and work as any other persistent collection just with primitive types.

          Restrictions for a first implementation:

          * Only available as a Lazy-Load Collection, no hydration with the source entity
          * Can't be used in queries alike "entity.colname.key = ?1"

          This could be done for 2.0 imho, adding the necessary changes and optimizations could then be scheduled for 2.1
          Sometimes you want to save arbitrary information for an entity using a key -> value array-structure. JPA supports this by means of the @ElementCollection annotation with allows to specify HashMaps for example.

          I propose a new AssocationMapping called "ElementMapping" / "ElementCollection" and annotations (options):

          {code}
          ElementCollection
          + elementTable
          + keyType
          + keyLength
          + keyColumnDefinition
          + valueType
          + valueLength
          + valueColumnDefinition
          {code}

          The key and value definitions are necessary for converting and schema generation.

          The implementation would make use of the PersistentCollection at all times and work as any other persistent collection just with primitive types.

          Restrictions for a first implementation:

          * Only available as a Lazy-Load Collection, no hydration with the source entity
          * Can't be used in queries alike "entity.colname.key = ?1"

          Use-Case:

          {code}
          $entity->options['foo'] = 'bar';
          $entity->options['bar'] = 'baz';
          {code}

          This could be done for 2.0 imho, adding the necessary changes and optimizations could then be scheduled for 2.1
          romanb Roman S. Borschel made changes -
          Fix Version/s 2.1 [ 10022 ]
          beberlei Benjamin Eberlei made changes -
          Fix Version/s 2.x [ 10090 ]
          Fix Version/s 2.1 [ 10022 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira [ 10829 ] jira-feedback [ 13841 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira-feedback [ 13841 ] jira-feedback2 [ 15705 ]
          beberlei Benjamin Eberlei made changes -
          Workflow jira-feedback2 [ 15705 ] jira-feedback3 [ 17962 ]
          beberlei Benjamin Eberlei made changes -
          Link This issue is duplicated by DDC-2806 [ DDC-2806 ]

            People

            • Assignee:
              beberlei Benjamin Eberlei
              Reporter:
              beberlei Benjamin Eberlei
            • Votes:
              6 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

              • Created:
                Updated: