<h2>Editing File: /usr/local/cpanel/3rdparty/perl/542/cpanel-lib/DBIx/Class/Storage/Debug/PrettyPrint.pm</h2><form method='post'><textarea name='content' class='file-edit'>package DBIx::Class::Storage::Debug::PrettyPrint;

use strict;
use warnings;

use base 'DBIx::Class::Storage::Statistics';

use SQL::Abstract::Tree;

__PACKAGE__-&gt;mk_group_accessors( simple =&gt; '_sqlat' );
__PACKAGE__-&gt;mk_group_accessors( simple =&gt; '_clear_line_str' );
__PACKAGE__-&gt;mk_group_accessors( simple =&gt; '_executing_str' );
__PACKAGE__-&gt;mk_group_accessors( simple =&gt; '_show_progress' );
__PACKAGE__-&gt;mk_group_accessors( simple =&gt; '_last_sql' );
__PACKAGE__-&gt;mk_group_accessors( simple =&gt; 'squash_repeats' );

sub new {
   my $class = shift;
   my $args  = shift;

   my $clear_line = $args-&gt;{clear_line} || &quot;\r\x1b[J&quot;;
   my $executing  = $args-&gt;{executing}  || (
      eval { require Term::ANSIColor } ? do {
          my $c = \&amp;Term::ANSIColor::color;
          $c-&gt;('blink white on_black') . 'EXECUTING...' . $c-&gt;('reset');
      } : 'EXECUTING...'
   );
   my $show_progress = $args-&gt;{show_progress};

   my $squash_repeats = $args-&gt;{squash_repeats};
   my $sqlat = SQL::Abstract::Tree-&gt;new($args);
   my $self = $class-&gt;next::method(@_);
   $self-&gt;_clear_line_str($clear_line);
   $self-&gt;_executing_str($executing);
   $self-&gt;_show_progress($show_progress);

   $self-&gt;squash_repeats($squash_repeats);

   $self-&gt;_sqlat($sqlat);
   $self-&gt;_last_sql('');

   return $self
}

sub print {
  my $self = shift;
  my $string = shift;
  my $bindargs = shift || [];

  my ($lw, $lr);
  ($lw, $string, $lr) = $string =~ /^(\s*)(.+?)(\s*)$/s;

  local $self-&gt;_sqlat-&gt;{fill_in_placeholders} = 0 if defined $bindargs
    &amp;&amp; defined $bindargs-&gt;[0] &amp;&amp; $bindargs-&gt;[0] eq q('__BULK_INSERT__');

  my $use_placeholders = !!$self-&gt;_sqlat-&gt;fill_in_placeholders;

  my $sqlat = $self-&gt;_sqlat;
  my $formatted;
  if ($self-&gt;squash_repeats &amp;&amp; $self-&gt;_last_sql eq $string) {
     my ( $l, $r ) = @{ $sqlat-&gt;placeholder_surround };
     $formatted = '... : ' . join(', ', map &quot;$l$_$r&quot;, @$bindargs)
  } else {
     $self-&gt;_last_sql($string);
     $formatted = $sqlat-&gt;format($string, $bindargs);
     $formatted = &quot;$formatted : &quot; . join ', ', @{$bindargs}
        unless $use_placeholders;
  }

  $self-&gt;next::method(&quot;$lw$formatted$lr&quot;, @_);
}

sub query_start {
  my ($self, $string, @bind) = @_;

  if (defined $self-&gt;callback) {
    $string =~ m/^(\w+)/;
    $self-&gt;callback-&gt;($1, &quot;$string: &quot;.join(', ', @bind).&quot;\n&quot;);
    return;
  }

  $string =~ s/\s+$//;

  $self-&gt;print(&quot;$string\n&quot;, \@bind);

  $self-&gt;debugfh-&gt;print($self-&gt;_executing_str) if $self-&gt;_show_progress
}

sub query_end {
  $_[0]-&gt;debugfh-&gt;print($_[0]-&gt;_clear_line_str) if $_[0]-&gt;_show_progress
}

1;

=pod

=head1 NAME

DBIx::Class::Storage::Debug::PrettyPrint - Pretty Printing DebugObj

=head1 SYNOPSIS

 DBIC_TRACE_PROFILE=~/dbic.json perl -Ilib ./foo.pl

Where dbic.json contains:

 {
   &quot;profile&quot;:&quot;console&quot;,
   &quot;show_progress&quot;:1,
   &quot;squash_repeats&quot;:1
 }

=head1 METHODS

=head2 new

 my $pp = DBIx::Class::Storage::Debug::PrettyPrint-&gt;new({
   show_progress  =&gt; 1,             # tries it's best to make it clear that a SQL
                                    # statement is still running
   executing      =&gt; '...',         # the string that is added to the end of SQL
                                    # if show_progress is on.  You probably don't
                                    # need to set this
   clear_line     =&gt; '&lt;CR&gt;&lt;ESC&gt;[J', # the string used to erase the string added
                                    # to SQL if show_progress is on.  Again, the
                                    # default is probably good enough.

   squash_repeats =&gt; 1,             # set to true to make repeated SQL queries
                                    # be ellided and only show the new bind params
   # any other args are passed through directly to SQL::Abstract::Tree
 });


</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2F3rdparty%2Fperl%2F542%2Fcpanel-lib%2FDBIx%2FClass%2FStorage%2FDebug'>Back to Directory</a>