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

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Confirmed Confirmed
        24s 1 Gunnstein Lye 21/Sep/15 11:11 AM
        Confirmed Confirmed Backlog Backlog
        6h 41m 1 André Rømcke 21/Sep/15 5:53 PM
        Development Development Backlog Backlog
        7d 1h 16m 1 Andrzej Longosz 12/Oct/16 10:31 AM
        Backlog Backlog Development Development
        518d 20h 28m 2 Andrzej Longosz 28/Feb/17 2:37 PM
        Development Development Development Review Development Review
        51d 23h 58m 1 Andrzej Longosz 21/Apr/17 3:35 PM
        Development Review Development Review Backlog Backlog
        156d 22h 12m 1 Andrzej Longosz 25/Sep/17 1:48 PM
        Backlog Backlog Specification Specification
        36d 2h 49m 1 Roland Benedetti 31/Oct/17 3:37 PM
        Specification Specification Specification Done Specification Done
        32m 37s 1 Andrzej Longosz 31/Oct/17 4:09 PM
        Specification Done Specification Done Development Development
        386d 12h 24m 2 Andrzej Longosz 18/Jan/19 11:45 AM
        Development Development Specification Done Specification Done
        57d 7h 25m 2 Andrzej Longosz 18/Jan/19 12:00 PM
        Specification Done Specification Done Specification Review Specification Review
        26s 1 Andrzej Longosz 18/Jan/19 12:00 PM
        Specification Review Specification Review Specification Specification
        10s 1 Andrzej Longosz 18/Jan/19 12:00 PM
        Specification Specification Closed Closed
        1m 37s 1 Andrzej Longosz 18/Jan/19 12:02 PM

          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