X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Ftest_scrub;h=850801f3b6592c07f8bdc42e11810008dab16d27;hp=45a257ab9d16c0bf4fa6ed1736ccb0731e81a4c1;hb=949a80c148a8bbeeeec54c5a0be5d73b292423a5;hpb=60724f233fbeb9388f4b2cbb68a4e6297c2b2118

diff --git a/bin/test_scrub b/bin/test_scrub
index 45a257ab9..850801f3b 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)
@@ -22,13 +23,13 @@ getopts('h');
 
 adminsuidsetup shift;
 
+#  payment_gateway
+#  payment_gateway_option
+#  agent_payment_gateway
 foreach my $table (qw(
-  part_export
-  part_export_option
   export_svc
-  payment_gateway
-  payment_gateway_option
-  agent_payment_gateway
+  part_export_option
+  part_export
   queue
   queue_arg
 )) {
@@ -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_payby
+                       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;