From 9d4a1a67b110523c36407e391e49fb255f596465 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Wed, 13 Nov 2013 11:07:55 -0800 Subject: [PATCH] remove cards too, try to be extra-safe --- bin/test_scrub | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/bin/test_scrub b/bin/test_scrub index 45a257ab9..e39a28a4e 100644 --- a/bin/test_scrub +++ b/bin/test_scrub @@ -3,6 +3,7 @@ #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. +die "remove this line to run -- NEVER ON A LIVE DATABASE"; #-all exports (all records in part_export, part_export_option export_svc) #-all non-POST invoice destinations (cust_main_invoice) @@ -42,6 +43,17 @@ my $dsth = dbh->prepare("DELETE FROM cust_main_invoice WHERE dest != 'POST'") or die dbh->errstr; $dsth->execute or die $dsth->errstr; +foreach my $table (qw( cust_main + cust_pay_pending cust_pay cust_pay_void cust_pay_batch + cust_refund +)) { + my $ccsth = dbh->prepare(" + UPDATE $table SET payinfo = '4111111111111111' + WHERE payby = 'CARD' OR payby = 'DCRD' + ") or die dbh->errstr; + $ccsth->execute or die $ccsth->errstr; +} + my $sth = dbh->prepare("UPDATE part_event SET disabled = 'Y'"); $sth->execute or die $sth->errstr; -- 2.11.0