Setup
To have DbJournal up & running all you need to do is to create the main journal table, insert the records per-table and run the update command (ideally with a cron job) whenever you want it to be updated until the current time.
Here's how to do it:
1) Create DB structure
php bin/console db-journal setup
Will create the main Journal table (see conf DB_JOURNAL_TABLE
)
2) Create the records (per table being journaled)
php bin/console db-journal init
Will create one record per table to be journaled with a timestamp to control the last time the journal was updated for that table
3) Run the Journal
php bin/console db-journal update
Will run the journal for every table (record) on the main Journal table, meaning each of those tables will have the SQL queries created for operations ran between the last_journal
and the current time, so this is the command to be called regularly through a cron job.