meridius/yadup

Database updator for Nette/Tracy panel

Yadup - Yet Another Database Updator Panel

Database updator for Nette/Tracy panel, _(*1)

How to

For Nette 2.2 support please see the bottom., _(*2)

1. Use the following Composer command in your existing project to add Yadup to it:, _(*3)

   composer require meridius/yadup

2. Register the extension by adding the following to your config.neon (1^st level):, _(*4)

   extensions:
       yadup: Yadup\YadupExtension

3. And at last don't forget to create directory for SQL updates files. Default is %appDir%/sql as specified below., _(*5)

Further configuration

You can tailor the updator to your needs by creating a new section yadup in config.neon (on the same level as extensions). Accepted parameters with their default values are following:, _(*6)

yadup:
    dbUpdateTable: '_db_update'
    dbConnection: '@database.default'
    definerUser: '' # definer can be changed only in queries that already have one defined
    definerHost: ''
    sqlDir: '%appDir%/sql' # directory with sql script files
    sqlExt: '.sql' # extension of sql files; with 'dot'

Notes

For updator to work it is setting its own mapping to Yadup\\*Module\\*Presenter which shouldn't affect you in any way., _(*7)

Full DB update in used terminology is the one that should contain DROP DATABASE or at least DROP TABLE to prevent possible incompatibilities with consequent updates., _(*8)

File naming format for SQL update files is Y-m-d_H-i-s[_full].sql, _(*9)

Nette 2.2 support

Because of incompatible changes in Nette/Database 2.3 the support for 2.2 version is moved to the separate Yadup 1.0 version which will receive support for at least some time., _(*10)

Installation

    composer require "meridius/yadup ~1.0.0"

Further configuration

Same as above, instead of:, _(*11)

yadup:
    dbConnection: '@nette.database.default'