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

        Andrzej Longosz logged work - 04/Oct/16 11:18 AM
        • Time Spent:
          3 hours
           

          working on doctrine-based creation of schema

        Andrzej Longosz logged work - 05/Oct/16 6:33 PM
        • Time Spent:
          5 hours
           

          working on doctrine-based creation of schema

        Andrzej Longosz logged work - 06/Oct/16 6:33 PM
        • Time Spent:
          6 hours, 30 minutes
           

          working on doctrine-based creation of schema

        Andrzej Longosz logged work - 07/Oct/16 12:56 PM
        • Time Spent:
          5 hours
           

          solving issues with sequence naming

        Andrzej Longosz logged work - 10/Oct/16 12:29 PM
        • Time Spent:
          6 hours
           

          solving issue with unsupported by Doctrine MySQL indexes with length

        Andrzej Longosz logged work - 11/Oct/16 12:30 PM
        • Time Spent:
          6 hours
           

          creating script to reset sequences after cleandata import

        Andrzej Longosz logged work - 01/Mar/17 1:00 PM
        • Time Spent:
          4 hours
           

          working on this issue

        Andrzej Longosz logged work - 02/Mar/17 6:00 PM
        • Time Spent:
          6 hours
           

          working on this issue

        Andrzej Longosz logged work - 03/Mar/17 5:18 PM
        • Time Spent:
          6 hours
           

          working on this issue, WIP PR

        Andrzej Longosz logged work - 23/Mar/17 5:14 PM
        • Time Spent:
          6 hours
           

          working on this issue

        Andrzej Longosz logged work - 20/Apr/17 5:35 PM
        • Time Spent:
          6 hours
           

          rewritting solution

        Andrzej Longosz logged work - 21/Apr/17 5:36 PM
        • Time Spent:
          4 hours, 30 minutes
           

          final fixes, updating PR

        Andrzej Longosz logged work - 12/Jul/17 6:42 PM
        • Time Spent:
          4 hours
           

          rebased PR, testing with PlatformUI behat scenarios

        Andrzej Longosz logged work - 17/Jul/17 7:08 PM
        • Time Spent:
          7 hours
           

          solving side issues related to CI and behat tests

        Andrzej Longosz logged work - 19/Jul/17 7:00 PM - edited
        • Time Spent:
          5 hours
           

          debugging travis/behat failures

        Andrzej Longosz logged work - 20/Jul/17 6:59 PM
        • Time Spent:
          5 hours
           

          debugging travis/docker/behat failure

          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