| Server IP : 85.214.239.14 / Your IP : 3.135.207.201 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /usr/share/doc/libsql-abstract-perl/examples/ |
Upload File : |
#!/usr/bin/perl
use warnings;
use strict;
use Getopt::Long;
my $p = Getopt::Long::Parser->new(config => [qw( gnu_getopt no_ignore_case )]);
my $opts = { profile => 'console', help => \&showhelp };
$p->getoptions( $opts, qw(
profile|p=s
help|h
)) or showhelp();
sub showhelp {
require Pod::Usage;
Pod::Usage::pod2usage( -verbose => 0, -exitval => 2 );
}
require SQL::Abstract::Tree;
my $sqlat = SQL::Abstract::Tree->new({ profile => $opts->{profile}, fill_in_placeholders => 0 });
my $chunk = '';
my $leftover = '';
do {
$chunk = $leftover . $chunk if length $leftover;
if ($chunk =~ / \A (.+?) (?:
(?<=\S)\:\s+\'[^\n]+ # pasting DBIC_TRACE output directly
|
\;(?: \s | \z)
|
\z
|
^ \s* (?=SELECT|INSERT|UPDATE|DELETE)
) (.*) /smix) {
$leftover = $2;
print $sqlat->format($1);
print "\n";
}
else {
$leftover = $chunk;
}
} while ( (read *STDIN, $chunk, 4096) or length $leftover );
=head1 NAME
sqla-format - An intelligent SQL formatter
=head1 SYNOPSIS
~$ sqla-format << log.sql
~$ myprogram -v | sqla-format -p html > sqltrace.html
=head1 COPYRIGHT AND LICENSE
This software is copyright (c) 2014 by Arthur Axel "fREW" Schmidt.
This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.