Eli Mesika has submitted this change and it was merged.

Change subject: core:fkvalidator.sh - some args are not honoured
......................................................................


core:fkvalidator.sh - some args are not honoured

Adding -l LOGFILE support

Adding support for -v flag
When -v is used the number of violates records and the query how to get
them is displayed.

Example:

./fkvalidator.sh  -u postgres -d engine_964197
Constraint violation found in  event_subscriber (event_up_name)

./fkvalidator.sh  -u postgres -d engine_964197 -v

Constraint violation found in  event_subscriber (event_up_name)
Please run the following SQL to get the 1 violated record/s:
select  (event_up_name)  from event_subscriber where  (event_up_name) IS
NOT NULL and  (event_up_name)  not in (select (event_up_name) from
event_map);
"

Change-Id: I759dc11424bda345e14e7bc7bdf81d41515a0847
Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=964197
Signed-off-by: Eli Mesika <[email protected]>
---
M packaging/setup/dbutils/fkvalidator.sh
M packaging/setup/dbutils/fkvalidator_sp.sql
2 files changed, 25 insertions(+), 12 deletions(-)

Approvals:
  Eli Mesika: Verified; Looks good to me, approved


-- 
To view, visit http://gerrit.ovirt.org/17015
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: I759dc11424bda345e14e7bc7bdf81d41515a0847
Gerrit-PatchSet: 2
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <[email protected]>
Gerrit-Reviewer: Allon Mureinik <[email protected]>
Gerrit-Reviewer: Eli Mesika <[email protected]>
Gerrit-Reviewer: Yair Zaslavsky <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to