projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (from parent 1:
dbd79d0
)
respect payment gatewaynum
author
Mark Wells
<mark@freeside.biz>
Fri, 7 Mar 2014 04:40:42 +0000
(20:40 -0800)
committer
Mark Wells
<mark@freeside.biz>
Fri, 7 Mar 2014 04:40:42 +0000
(20:40 -0800)
bin/test_scrub_sql
patch
|
blob
|
history
diff --git
a/bin/test_scrub_sql
b/bin/test_scrub_sql
index
fe66805
..
30ee1d2
100755
(executable)
--- a/
bin/test_scrub_sql
+++ b/
bin/test_scrub_sql
@@
-16,7
+16,6
@@
foreach my $table (qw(
part_export_option
payment_gateway_option
foreach my $table (qw(
part_export_option
payment_gateway_option
- payment_gateway
agent_payment_gateway
queue_arg
queue
agent_payment_gateway
queue_arg
queue
@@
-26,6
+25,11
@@
foreach my $table (qw(
print "DELETE FROM h_$table;\n";
}
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
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
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";
)) {
print "DELETE FROM conf WHERE name = '$item';\n";
print "DELETE FROM h_conf WHERE name = '$item';\n";