Commands

In the project's root directory you can run console commands like this:

php bin/console db-journal {action} [--option1=value] [--option2=value]

This will run a PHP script where {action} can be any of these commands:

Action Description Options
setup Create the internal table required to run the journal -
init Output the journal queries for the given filters time
update Ensure that every table journal will be updated to the current database timestamp (this should be the command called through a cron job) time
dump Output the journal queries filtering by the given options table mintime maxtime
run [WARNING] Apply the given Journal to the current database table mintime maxtime
list List the available DbJournal commands -
schema Dump the database structure like
['Table' => ['column1' => $column1Object, 'column2' => $column2Object, ...], ...]
-
time Show the current database time -
clean Clean the existing journal records and files (warning, you won't be able to run pre-existing journals after this) -
uninstall Remove DbJournal table and files -

You can also use the following options (always preceded by --) combined with the above commands:

  • v, vv or vvv: Verbose level (vvv being the most verbose) for any command
  • time: set the current time for the init or update command (so they'll run with the inputted time)
  • table: restrict the dump or run command to a single table
  • mintime | gt: use it with the dump command to restrict the dump to operations that happened after that timestamp (format YYYY-mm-dd)
  • maxtime | lt: use it with the dump command to restrict the dump to operations that happened before that timestamp (format YYYY-mm-dd)