diff options
author | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
---|---|---|
committer | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
commit | c82d349f864e6bd9f96fd1156903bc1f7193a203 (patch) | |
tree | e117a87533656110b6acd56fc0ca64289892a9f5 /bin/test_scrub_sql | |
parent | 74e058c8a010ef6feb539248a550d0bb169c1e94 (diff) |
This commit was manufactured by cvs2svn to create tag 'TORRUS_1_0_9'.TORRUS_1_0_9
Diffstat (limited to 'bin/test_scrub_sql')
-rwxr-xr-x | bin/test_scrub_sql | 58 |
1 files changed, 0 insertions, 58 deletions
diff --git a/bin/test_scrub_sql b/bin/test_scrub_sql deleted file mode 100755 index fb26fe940..000000000 --- a/bin/test_scrub_sql +++ /dev/null @@ -1,58 +0,0 @@ -#!/usr/bin/perl -w - -#This drops anything from the database that could cause live things to happen. -#You'd want to do this on a test copy of your live database but NEVER on the -#live database itself. - -#-all exports (all records in part_export, part_export_option export_svc) -#-all non-POST invoice destinations (cust_main_invoice) -#-all payment gateways and agent payment gw overrides (payment_gateway, -# payment_gateway_option, agent_payment_gateway) -#-everything in the job queue (queue and queue_arg) -#-business-onlinepayment and business-onlinepayment-ach config -#AND -#-masks all payment info - -foreach my $table (qw( - part_export_option - payment_gateway - payment_gateway_option - agent_payment_gateway - queue - queue_arg - cust_pay_batch -)) { - print "DELETE FROM $table;\n"; - print "DELETE FROM h_$table;\n"; -} - -foreach my $table (qw( - part_export - export_svc -)) { - print "DELETE FROM $table;\n"; -} - -print "DELETE FROM cust_main_invoice WHERE dest != 'POST';\n"; - -foreach my $item (qw( - business-onlinepayment - business-onlinepayment-ach -)) { - print "DELETE FROM conf WHERE name = '$item';\n"; - print "DELETE FROM h_conf WHERE name = '$item';\n"; -} - -my @ptables = map { ($_, "h_$_") } qw( - cust_main - cust_pay - cust_pay_pending - cust_pay_void - cust_refund -); -foreach my $table (@ptables) { - print "UPDATE $table SET payinfo = paymask WHERE payby IN ( 'CARD','DCRD','CHEK','DCHK' );\n"; -} - -print "UPDATE cust_main set paycvv = NULL;\n"; -print "UPDATE h_cust_main set paycvv = NULL;\n"; |