From 1c051d721533307ff9d1879deb3107e3a51058fa Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 19 Feb 2009 06:42:45 +0000
Subject: [PATCH] add profiling to a file OOM situations, RT#4830

---
 httemplate/autohandler            | 24 +++++++++++++++---------
 httemplate/pref/pref-process.html |  2 +-
 httemplate/pref/pref.html         |  4 ++++
 3 files changed, 20 insertions(+), 10 deletions(-)

diff --git a/httemplate/autohandler b/httemplate/autohandler
index ee37934cf..3a2441703 100644
--- a/httemplate/autohandler
+++ b/httemplate/autohandler
@@ -17,16 +17,22 @@ if ( UNIVERSAL::can(dbh, 'sprintProfile') ) {
     #eval "use Text::Wrapper;";
     #die $@ if $@;
 
-    my $wrapper = new Text::Wrapper( columns => 80 );
     my $text = dbh->sprintProfile();
-    #my $text = $wrapper->wrap( dbh->sprintProfile() );
-    $text =~ s/^/                                                          /mg;
-    
-    $profile = '<PRE>'.
-               encode_entities( $text ).
-               #"\n\n". &sprintAutoProfile(). '</PRE>';
-               "\n\n".                        '</PRE>';
-  } 
+    #$text =~ s/^/                                                          /mg;
+
+    $profile = '<PRE>'.  encode_entities( $text ). "\n\n". '</PRE>';
+
+  }
+
+  #well, could do this without sprintProfile, but definiately don't want it on
+  #unless DBIx::Profile is loaded
+  if ( $FS::CurrentUser::CurrentUser->option('save_db_profile') ) {
+    #my $file = %%%FREESIDE_LOG%%%; #substitute here?  maybe get from FS.pm?
+    my $file = '/usr/local/etc/freeside/'; #bah
+    $file .= "dbix_profile..$$.". time;
+    dbh->setLogFile($file);
+    dbh->printProfile();
+  }
 
   dbh->{'private_profile'} = {};
 }
diff --git a/httemplate/pref/pref-process.html b/httemplate/pref/pref-process.html
index 466218947..96615169b 100644
--- a/httemplate/pref/pref-process.html
+++ b/httemplate/pref/pref-process.html
@@ -33,7 +33,7 @@
 % my @paramlist = qw( menu_position
 %                     email_address
 %                     vonage-fromnumber vonage-username vonage-password
-%                     show_pkgnum show_db_profile
+%                     show_pkgnum show_db_profile save_db_profile
 %                     height width availHeight availWidth colorDepth
 %                   );
 %
diff --git a/httemplate/pref/pref.html b/httemplate/pref/pref.html
index 44b844891..57e22b345 100644
--- a/httemplate/pref/pref.html
+++ b/httemplate/pref/pref.html
@@ -68,6 +68,10 @@ Development
     <TH>Show database profiling (when available): </TH>
     <TD><INPUT TYPE="checkbox" NAME="show_db_profile" VALUE="1" <% $curuser->option('show_db_profile') ? 'CHECKED' : '' %>></TD>
   </TR>
+  <TR>
+    <TH>Save database profiling logs (when available): </TH>
+    <TD><INPUT TYPE="checkbox" NAME="save_db_profile" VALUE="1" <% $curuser->option('save_db_profile') ? 'CHECKED' : '' %>></TD>
+  </TR>
 
 </TABLE>
 <BR>
-- 
2.11.0