library doctrine-db-patcher

cyberrebell/doctrine-db-patcher

Doctrine-DB-Patcher

doctrine-db-patcher

Gives your ZF2+Doctrine-Project a toolset for database-patches., _(*1)

===================, _(*2)

DoctrineDbPatcher

Requirents:

php >=5.4, _(*3)

ZF2: https://github.com/zendframework/zf2, _(*4)

DoctrineMongoODMModule: https://github.com/doctrine/DoctrineMongoODMModule, _(*5)

or, _(*6)

DoctrineORMModule: https://github.com/doctrine/DoctrineORMModule, _(*7)

Installation via composer:

add to composer.json:, _(*8)

    "repositories": [
        {
            "type": "vcs",
            "url": "https://github.com/Cyberrebell/doctrine-db-patcher"
        }
    ],
    "require": {
        "Cyberrebell/doctrine-db-patcher": "dev-master"
    },

Configuration in project:

add to application.config.php:, _(*9)

return [
    'modules' => [
        'DoctrineDbPatcher'
    ]
];

add to any module.config.php:, _(*10)

return [
    'DoctrineDbPatcher' => [
        'doctrine-objectmanager-service' => 'Doctrine\ODM\Mongo\DocumentManager', //or Doctrine\ORM\EntityManager
        'patches' => include 'doctrine.patches.php'
    ]
];

create doctrine.patches.php and add your patches like this:, _(*11)

<?php 
return [
    '1.0.0' => [
        'insert' => [
            'User\Entity\Resource' => [
                'attributes' => ['route'],
                'values' => [
                    ['login'],
                    ['logout'],
                ]
            ],
            'User\Entity\Permission' => [
                'attributes' => ['description'],
                'values' => [
                    ['Sich einloggen'],
                    ['Sich ausloggen'],
                ]
            ],
        ],
        'update' => [
             'User\Entity\Guestbook' => [
                 [
                     'attributes' => ['title'],
                     'values' => [
                         ['old' => ['This is a niec website'], 'new' => ['This is a nice website']],
                     ]
                 ],
             ],
        ],
        'delete' => [
             'User\Entity\Guestbook' => [
                 [
                     'attributes' => ['title'],
                     'values' => [
                         ['Hello everyone'],
                     ]
                 ],
             ],
        ],
        'connect' => [
            [
                'entities' => ['User\Entity\Permission' => 'User\Entity\Resource'],
                'methods' => ['addResource' => 'removeResource'],
                'targets' => [
                    ['source' => ['description' => 'Sich einloggen'], 'target' => ['route' => 'login']],
                    ['source' => ['description' => 'Sich ausloggen'], 'target' => ['route' => 'logout']],
                ]
            ]
        ]
    ]
];

Configuration in project:

run the patch-tool:, _(*12)

php public/index.php dbpatch