From f9250e6d275f98b50b23d404b19b4e7fd01f7f11 Mon Sep 17 00:00:00 2001
From: Darold Gilles <gilles@darold.net>
Date: Mon, 23 Dec 2013 16:08:54 +0100
Subject: [PATCH] Automatic queries formatting is now done on double click
 event, simple click was painful when you want to copy some part of the
 queries. Thanks to Guillaume Smet for the feature request.

---
 pgbadger | 26 +++++++++++++-------------
 1 file changed, 13 insertions(+), 13 deletions(-)

diff --git a/pgbadger b/pgbadger
index 29bf718..7bd67ff 100755
--- a/pgbadger
+++ b/pgbadger
@@ -5424,7 +5424,7 @@ sub print_lock_queries_report
 			<td>$max_time</td>
 			<td>$avg_time</td>
 			<td id="queries-most-frequent-waiting-examples-details-rank-$rank">
-				<div class="sql" onclick="sql_format(this)">$query</div>
+				<div class="sql" ondblclick="sql_format(this)">$query</div>
 				 $example
 			<!-- Examples collapse -->
 			<div id="queries-most-frequent-waiting-examples-rank-$rank" class="collapse">
@@ -5441,7 +5441,7 @@ sub print_lock_queries_report
 				$details .= " - <b>Application:</b> $normalyzed_info{$k}{samples}{$d}{app}" if ($normalyzed_info{$k}{samples}{$d}{app});
 				$details .= " ]";
 				print $fh qq{
-					<dt><div class="sql" onclick="sql_format(this)">$query</div></dt>
+					<dt><div class="sql" ondblclick="sql_format(this)">$query</div></dt>
 					<dd><pre>$details</pre></dd>
 };
 
@@ -5501,7 +5501,7 @@ sub print_lock_queries_report
 				<td>$rank</td>
 				<td>$time</td>
 				<td id="queries-that-waited-most-examples-details-rank-$rank">
-					<div class="sql" onclick="sql_format(this)">$query</div>
+					<div class="sql" ondblclick="sql_format(this)">$query</div>
 					<pre>$details</pre>
 				</td>
 				</tr>
@@ -5570,7 +5570,7 @@ sub print_tempfile_report
 				<td>$max_size</td>
 				<td>$avg_size</td>
 				<td id="queries-generating-most-temporary-files-examples-details-rank-$rank">
-					<div class="sql" onclick="sql_format(this)">$query</div>
+					<div class="sql" ondblclick="sql_format(this)">$query</div>
 					$example
 				<!-- Examples collapse -->
 				<div id="queries-generating-most-temporary-files-examples-rank-$rank" class="collapse">
@@ -5586,7 +5586,7 @@ sub print_tempfile_report
 					$details .= "Remote: $normalyzed_info{$k}{samples}{$d}{remote}<br/>" if ($normalyzed_info{$k}{samples}{$d}{remote});
 					$details .= "Application: $normalyzed_info{$k}{samples}{$d}{app}<br/>" if ($normalyzed_info{$k}{samples}{$d}{app});
 					print $fh qq{
-						<dt><div class="sql" onclick="sql_format(this)">$query</div></dt>
+						<dt><div class="sql" ondblclick="sql_format(this)">$query</div></dt>
 						<dd><pre>$details</pre></dd>
 };
 
@@ -5645,7 +5645,7 @@ sub print_tempfile_report
 				<td>$rank</td>
 				<td>$size</td>
 				<td id="queries-generating-largest-temporary-files-examples-details-rank-$rank">
-					<div class="sql" onclick="sql_format(this)">$query</div>
+					<div class="sql" ondblclick="sql_format(this)">$query</div>
 					<pre>$details</pre>
 				</td>
 				</tr>
@@ -5698,7 +5698,7 @@ sub print_slowest_individual_queries
 				<td>$rank</td>
 				<td>$duration</td>
 				<td id="slowest-individual-queries-examples-rank-$rank">
-					<div class="sql" onclick="sql_format(this)">$query</div>
+					<div class="sql" ondblclick="sql_format(this)">$query</div>
 					<pre>$details</pre>
 				</td>
 				</tr>
@@ -5759,7 +5759,7 @@ sub print_time_consuming
 				<td>$max</td>
 				<td>$avg</td>
 				<td id="time-consuming-queries-examples-details-rank-$rank">
-					<div class="sql" onclick="sql_format(this)">$query</div>
+					<div class="sql" ondblclick="sql_format(this)">$query</div>
 						<!-- Details collapse -->
 					    <div id="time-consuming-queries-details-rank-$rank" class="collapse">
 						<h3>Times Reported <small>Time consuming queries #$rank</small></h3>
@@ -5811,7 +5811,7 @@ sub print_time_consuming
 			$details .= " ]";
 			$query = &highlight_code($normalyzed_info{$k}{samples}{$d}{query});
 			print $fh qq{
-								<dt><div class="sql" onclick="sql_format(this)">$query</div></dt>
+								<dt><div class="sql" ondblclick="sql_format(this)">$query</div></dt>
 								<dd><pre>$details</pre></dd>
 };
 		}
@@ -5880,7 +5880,7 @@ sub print_most_frequent
                                 <td>$max</td>
                                 <td>$avg</td>
                                 <td id="most-frequent-queries-examples-details-rank-$rank">
-                                        <div class="sql" onclick="sql_format(this)">$query</div>
+                                        <div class="sql" ondblclick="sql_format(this)">$query</div>
                                                 <!-- Details collapse -->
                                             <div id="most-frequent-queries-details-rank-$rank" class="collapse">
                                                 <h3>Times Reported <small>Time consuming queries #$rank</small></h3>
@@ -5931,7 +5931,7 @@ sub print_most_frequent
 			$details .= " ]";
 			$query = &highlight_code($normalyzed_info{$k}{samples}{$d}{query});
 			print $fh qq{
-								<dt><div class="sql" onclick="sql_format(this)">$query</div></dt>
+								<dt><div class="sql" ondblclick="sql_format(this)">$query</div></dt>
 								<dd><pre>$details</pre></dd>
 };
 		}
@@ -6000,7 +6000,7 @@ sub print_slowest_queries
                                 </td>
                                 <td>$duration</td>
                                 <td id="normalized-slowest-queries-examples-details-rank-$rank">
-                                        <div class="sql" onclick="sql_format(this)">$query</div>
+                                        <div class="sql" ondblclick="sql_format(this)">$query</div>
                                                 <!-- Details collapse -->
                                             <div id="normalized-slowest-queries-details-rank-$rank" class="collapse">
                                                 <h3>Times Reported <small>Time consuming queries #$rank</small></h3>
@@ -6053,7 +6053,7 @@ sub print_slowest_queries
 			$details .= " ]";
 			$query = &highlight_code($normalyzed_info{$k}{samples}{$d}{query});
 			print $fh qq{
-								<dt><div class="sql" onclick="sql_format(this)">$query</div></dt>
+								<dt><div class="sql" ondblclick="sql_format(this)">$query</div></dt>
 								<dd><pre>$details</pre></dd>
 };
 		}
-- 
2.50.1