diff options
| author | Mark Wells <mark@freeside.biz> | 2014-03-06 20:40:42 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2014-03-06 20:40:42 -0800 |
| commit | 049b89c4773ae560e0a38e6bd5cd9faf9233f48d (patch) | |
| tree | bbaab38ec49b7571a4577d36465ba97cfca2ec0b /bin/test_scrub_sql | |
| parent | dbd79d059c9353da8d521fce4ee2ce8cc3349a54 (diff) | |
respect payment gatewaynum
Diffstat (limited to 'bin/test_scrub_sql')
| -rwxr-xr-x | bin/test_scrub_sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/bin/test_scrub_sql b/bin/test_scrub_sql index fe66805d3..30ee1d277 100755 --- a/bin/test_scrub_sql +++ b/bin/test_scrub_sql @@ -16,7 +16,6 @@ foreach my $table (qw( part_export_option payment_gateway_option - payment_gateway agent_payment_gateway queue_arg queue @@ -26,6 +25,11 @@ foreach my $table (qw( print "DELETE FROM h_$table;\n"; } +# don't break foreign keys in cust_pay_*, just scrub fields that could be +# used to access the gateway +print "UPDATE payment_gateway SET gateway_module = 'Test', disabled = 'Y', gateway_username = NULL, gateway_password = 'NULL';\n"; +print "DELETE FROM h_payment_gateway;\n"; + foreach my $table (qw( part_export export_svc @@ -38,6 +42,7 @@ print "DELETE FROM cust_main_invoice WHERE dest != 'POST';\n"; foreach my $item (qw( business-onlinepayment business-onlinepayment-ach + smtpmachine )) { print "DELETE FROM conf WHERE name = '$item';\n"; print "DELETE FROM h_conf WHERE name = '$item';\n"; |