dbvc
dbvc copied to clipboard
jasny
Manage database updates using version control
Running DBVC in an automated environment might cause issues when several machines are updated at the same time. If each machine runs `dbvc update`, than the same script is executed...
The directory structure should be (optionally) compatible with [DBV](/victorstanciu/dbv), since there is a demand among those users for a command line tool like DBVC. victorstanciu/dbv#10
PhpMyAdmin support [Change tracking](https://wiki.phpmyadmin.net/pma/Change_tracking). Since PhpMyAdmin is a common tool among PHP developers, it would be nice to use/automate this. How should this work exectly? Don't know yet.
Using git status, you should be able to find out who commited and when. ``` git status --all --blame ``` Should yield something like ``` Available updates: foobar (13fc728e Arnold...
DBVC should be ale limit the list of updates to a commit or commit range. ``` dbvc status --commit=HASH dbvc status --commit=HASH..HASH dbvc mark --commit=HASH dbvc mark --commit=HASH..HASH ``` Both...
Add a rollback directory where users can optionally add a file that inverts an update. The name of the file in the rollback dir should be the same as in...
[Git hooks](https://github.com/icefox/git-hooks) is a tool to manage git hooks. DBVC should be able to install simple by running ``` dbvc install-hooks [--path=...] [status] [mark] ``` The command should check if...
DBVC should be able to create a dump of the database schema. ``` dbvc dump ``` DBVC should also be able to dump the data. This is useful for adding...
``` Usage: dbvc mark update ... [options] ``` Should be ``` Usage: dbvc mark UPDATE ... [OPTIONS] ``` To differentiate between literals and arguments.