Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-24842

As a Maintainer I want eZ Platform installer to use Doctrine Schema files

    Details

    • Story Points:
      5

      Description

      We have https://github.com/ezsystems/ezpublish-kernel/blob/master/data/mysql/schema.sql but no corresponding Postgres schema file - this should be added.
      Perhaps we can use https://github.com/ezsystems/ezpublish-kernel/blob/master/eZ/Publish/Core/Persistence/Legacy/Tests/_fixtures/schema.pgsql.sql as a source?

      As a result of many discussions and reviews of the prototype we decided to make this a part of 2.0 release and use Doctrine Schema files.
      After some investigation we've found out that there's no official schema file format as Doctrine DBAL Schema Tool is PHP API. (Not to be confused with Doctrine ORM which actually has defined Yaml format).
      We've decided to create our own Yaml format of a schema which uses Doctrine Schema Tool.

      The remaining thing to do is to make installer an API, so developers can call it from their own code without a need to call ezplatform:install command. However, of course the command will work as it worked before - there's no reason for BC break on that.

      The major BC break is related to replacing schema.sql with schema.yml file. It's important to make it extensible as developers tend to modify it for custom needs. This can be achieved by creating some schema file provider. TBD.

        Activity

        Gunnstein Lye created issue -
        Gunnstein Lye made changes -
        Field Original Value New Value
        Status Open [ 1 ] Confirmed [ 10037 ]
        André Rømcke made changes -
        Epic Link EZP-23950 [ 43788 ]
        André Rømcke made changes -
        Status Confirmed [ 10037 ] Backlog [ 10000 ]
        André Rømcke made changes -
        Rank Ranked higher
        André Rømcke made changes -
        Fix Version/s Known Issues List [ 14512 ]
        André Rømcke made changes -
        Fix Version/s Enablement Issues [ 14512 ]
        André Rømcke made changes -
        Epic Link EZP-23950 [ 43788 ] EZP-25368 [ 52916 ]
        Andrzej Longosz made changes -
        Status Backlog [ 10000 ] Development [ 3 ]
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 3 hours [ 10800 ]
        Worklog Id 60867 [ 60867 ]
        Andrzej Longosz made changes -
        Time Spent 3 hours [ 10800 ] 1 day [ 28800 ]
        Worklog Id 60883 [ 60883 ]
        Andrzej Longosz made changes -
        Time Spent 1 day [ 28800 ] 1 day, 6 hours, 30 minutes [ 52200 ]
        Worklog Id 60884 [ 60884 ]
        Andrzej Longosz made changes -
        Time Spent 1 day, 6 hours, 30 minutes [ 52200 ] 2 days, 3 hours, 30 minutes [ 70200 ]
        Worklog Id 60906 [ 60906 ]
        Andrzej Longosz made changes -
        Time Spent 2 days, 3 hours, 30 minutes [ 70200 ] 3 days, 1 hour, 30 minutes [ 91800 ]
        Worklog Id 60923 [ 60923 ]
        Andrzej Longosz made changes -
        Time Spent 3 days, 1 hour, 30 minutes [ 91800 ] 3 days, 7 hours, 30 minutes [ 113400 ]
        Worklog Id 60924 [ 60924 ]
        Andrzej Longosz made changes -
        Status Development [ 3 ] Backlog [ 10000 ]
        André Rømcke made changes -
        Labels v2
        André Rømcke made changes -
        Sprint v2 s0 [ 76 ]
        André Rømcke made changes -
        Rank Ranked lower
        André Rømcke made changes -
        Rank Ranked lower
        Andrzej Longosz made changes -
        Status Backlog [ 10000 ] Development [ 3 ]
        André Rømcke made changes -
        Summary Add Postgres schema Prototype adding Postgres schema using Doctrine schema files
        André Rømcke made changes -
        Description We have https://github.com/ezsystems/ezpublish-kernel/blob/master/data/mysql/schema.sql but no corresponding Postgres schema file - this should be added.

        Perhaps we can use https://github.com/ezsystems/ezpublish-kernel/blob/master/eZ/Publish/Core/Persistence/Legacy/Tests/_fixtures/schema.pgsql.sql as a source?
        We have https://github.com/ezsystems/ezpublish-kernel/blob/master/data/mysql/schema.sql but no corresponding Postgres schema file - this should be added.

        Perhaps we can use https://github.com/ezsystems/ezpublish-kernel/blob/master/eZ/Publish/Core/Persistence/Legacy/Tests/_fixtures/schema.pgsql.sql as a source?


        However we might want to use Doctrine schema to start to take advantage of doctrine migrations for schema.
        SO this is about prototyping this to see feasibility of moving to that for Improved storage engine.
        Andrzej Longosz made changes -
        Time Spent 3 days, 7 hours, 30 minutes [ 113400 ] 4 days, 3 hours, 30 minutes [ 127800 ]
        Worklog Id 63011 [ 63011 ]
        Andrzej Longosz made changes -
        Time Spent 4 days, 3 hours, 30 minutes [ 127800 ] 1 week, 1 hour, 30 minutes [ 149400 ]
        Worklog Id 63065 [ 63065 ]
        Andrzej Longosz made changes -
        Time Spent 1 week, 1 hour, 30 minutes [ 149400 ] 1 week, 7 hours, 30 minutes [ 171000 ]
        Worklog Id 63066 [ 63066 ]
        Andrzej Longosz made changes -
        Time Spent 1 week, 7 hours, 30 minutes [ 171000 ] 1 week, 1 day, 5 hours, 30 minutes [ 192600 ]
        Worklog Id 63401 [ 63401 ]
        Andrzej Longosz made changes -
        Status Development [ 3 ] Development Review [ 10006 ]
        Andrzej Longosz made changes -
        Time Spent 1 week, 1 day, 5 hours, 30 minutes [ 192600 ] 1 week, 2 days, 3 hours, 30 minutes [ 214200 ]
        Worklog Id 63726 [ 63726 ]
        Andrzej Longosz made changes -
        Time Spent 1 week, 2 days, 3 hours, 30 minutes [ 214200 ] 1 week, 3 days [ 230400 ]
        Worklog Id 63727 [ 63727 ]
        Sarah Haïm-Lubczanski (Inactive) made changes -
        Rank Ranked higher
        Andrzej Longosz made changes -
        Time Spent 1 week, 3 days [ 230400 ] 1 week, 3 days, 4 hours [ 244800 ]
        Worklog Id 65012 [ 65012 ]
        Andrzej Longosz made changes -
        Time Spent 1 week, 3 days, 4 hours [ 244800 ] 1 week, 4 days, 3 hours [ 270000 ]
        Worklog Id 65052 [ 65052 ]
        Andrzej Longosz made changes -
        Time Spent 1 week, 4 days, 3 hours [ 270000 ] 2 weeks [ 288000 ]
        Worklog Id 65140 [ 65140 ]
        Andrzej Longosz made changes -
        Worklog Id 65140 [ 65140 ]
        Andrzej Longosz made changes -
        Time Spent 2 weeks [ 288000 ] 2 weeks, 5 hours [ 306000 ]
        Worklog Id 65141 [ 65141 ]
        Alex Schuster made changes -
        Workflow EZ* Development Workflow [ 95937 ] EZEE Development Workflow [ 108193 ]
        Andrzej Longosz made changes -
        Status Development Review [ 10006 ] Backlog [ 10000 ]
        Roland Benedetti made changes -
        Issue Type Improvement [ 4 ] Story [ 7 ]
        Workflow EZEE Development Workflow [ 108193 ] EZEE and EZP Story Workflow [ 128512 ]
        Roland Benedetti made changes -
        Status Backlog [ 10000 ] Specification [ 10002 ]
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ] Roland Benedetti [ roland.benedetti@ez.no ]
        Roland Benedetti made changes -
        Original Estimate 0 minutes [ 0 ]
        Assignee Roland Benedetti [ roland.benedetti@ez.no ] Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Summary Prototype adding Postgres schema using Doctrine schema files As a Maintainer I want eZ Platform installer to use Doctrine Schema files
        Andrzej Longosz made changes -
        Description We have https://github.com/ezsystems/ezpublish-kernel/blob/master/data/mysql/schema.sql but no corresponding Postgres schema file - this should be added.

        Perhaps we can use https://github.com/ezsystems/ezpublish-kernel/blob/master/eZ/Publish/Core/Persistence/Legacy/Tests/_fixtures/schema.pgsql.sql as a source?


        However we might want to use Doctrine schema to start to take advantage of doctrine migrations for schema.
        SO this is about prototyping this to see feasibility of moving to that for Improved storage engine.
        {quote}
        We have https://github.com/ezsystems/ezpublish-kernel/blob/master/data/mysql/schema.sql but no corresponding Postgres schema file - this should be added.
        Perhaps we can use https://github.com/ezsystems/ezpublish-kernel/blob/master/eZ/Publish/Core/Persistence/Legacy/Tests/_fixtures/schema.pgsql.sql as a source?
        {quote}

        As a result of many discussions and reviews of the prototype we decided to make this a part of {{2.0}} release and use Doctrine Schema files.
        After some investigation we've found out that there's no official schema file format as Doctrine DBAL Schema Tool is PHP API. (Not to be confused with Doctrine ORM which actually has defined Yaml format).
        We've decided to create our own Yaml format of a schema which uses Doctrine Schema Tool.

        The remaining thing to do is to make installer an API, so developers can call it from their own code without a need to call {{ezplatform:install}} command. However, of course the command will work as it worked before - there's no reason for BC break on that.

        The major BC break is related to replacing {{schema.sql}} with {{schema.yml}} file. It's important to make it extensible as developers tend to modify it for custom needs. This can be achieved by creating some schema file provider. TBD.
        Andrzej Longosz made changes -
        Status Specification [ 10002 ] Specification Done [ 10003 ]
        Component/s Install [ 10820 ]
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Story Points 8
        Roland Benedetti made changes -
        Sprint v2 Rolling sprint [ 76 ] v2 Rolling sprint, Sprint 4 [ 76, 92 ]
        Roland Benedetti made changes -
        Rank Ranked higher
        Andrzej Longosz made changes -
        Status Specification Done [ 10003 ] Development [ 3 ]
        Sylvain Guittard made changes -
        Component/s Platform > Repository & Services (Public API impl) [ 10309 ]
        Roland Benedetti made changes -
        Sprint v2 Rolling sprint, Sprint 4 [ 76, 92 ] v2 Rolling sprint, Sprint 5 [ 76, 93 ]
        Roland Benedetti made changes -
        Rank Ranked lower
        Roland Benedetti made changes -
        Story Points 8 5
        Andrzej Longosz made changes -
        Affects Version/s 2.0.0-beta1 [ 14863 ]
        Andrzej Longosz made changes -
        Fix Version/s 2.0.0 [ 14722 ]
        Roland Benedetti made changes -
        Sprint v2 Rolling sprint, Sprint 5 [ 76, 93 ] v2 Rolling sprint, Sprint 6 [ 76, 94 ]
        Roland Benedetti made changes -
        Rank Ranked higher
        Roland Benedetti made changes -
        Sprint v2 Rolling sprint, Sprint 6 [ 76, 94 ] v2 Rolling sprint [ 76 ]
        Roland Benedetti made changes -
        Rank Ranked lower
        Andrzej Longosz made changes -
        Status Development [ 3 ] Specification Done [ 10003 ]
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Link This issue blocks EZP-29938 [ EZP-29938 ]
        Andrzej Longosz made changes -
        Status Specification Done [ 10003 ] Development [ 3 ]
        Andrzej Longosz made changes -
        Link This issue blocks EZP-29938 [ EZP-29938 ]
        Andrzej Longosz made changes -
        Status Development [ 3 ] Specification Done [ 10003 ]
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Andrzej Longosz made changes -
        Status Specification Done [ 10003 ] Specification Review [ 10038 ]
        Andrzej Longosz made changes -
        Status Specification Review [ 10038 ] Specification [ 10002 ]
        Andrzej Longosz made changes -
        Status Specification [ 10002 ] Closed [ 6 ]
        Assignee Andrzej Longosz [ andrzej.longosz@ez.no ]
        Resolution Obsolete [ 8 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Gunnstein Lye
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 0 minutes
              0m
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 2 weeks, 5 hours
              2w 5h

                Agile