The PhpAudit Program¶
The PhpAudit program is a Symphony console application with four additional commands:
alter-audit-table
audit
diff
drop-triggers
We discuss the additional commands in the sections below.
Some commands provide additional output when in verbose mode (-v
). All commands show the queries been executed in very verbose mode (-vv
).
The alter-audit-table
command¶
The alter-audit-table
command generates SQL statements to align the tables in the audit schema
with the tables in the data schema
and the additional columns section in the audit config file, see The Audit Columns Section.
./vendor/bin/audit alter-audit-table etc/audit.json
Output:
alter table `test_audit`.`FOO_EMPLOYEE`
change column `emp_name` `emp_name` varchar(80) character set utf8 collate utf8_general_ci null
;
You must inspect each SQL statement manually before executing. See Changed Column Type for an explanation about incompatible column types.
The audit
command¶
The audit
command creates and alters audit tables (in the audit schema
and audit triggers on tables in the data schema
.
Usage of the audit
command is discussed ind detail in Getting Started and Schema Changes and Deployment.
The diff
command¶
The diff command show in a graphical manner the differences between the tables in the audit schema
with the tables in the data schema
and the additional columns section in the audit config file, see The Audit Columns Section.
Without the --full
option only tables with differences and only different columns are shown. With the --full
option all tables and all columns are shown.
The drop-triggers
command¶
The drop-triggers
command will drop all triggers in the data schema
.