| Server IP : 217.18.85.50 / Your IP : 18.219.81.129 Web Server : LiteSpeed System : Linux server50.tr85.dhs.com.tr 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64 User : ferhatgenc ( ) PHP Version : 7.2.34 Disable Function : restore_ini,mail,openbasedir,f_open,system,dl,array_compare,array_user_key_compare,passthru,cat,exec,popen,proc_close,proc_get_status,proc_nice,proc_open,escapeshellcmd,escapeshellarg,show_source,posix_mkfifo,ini_restore,mysql_list_dbs,getmyuid,pconnect,link,symlink,fin,passthruexec,fileread,shell_exec,pcntl_exec,ini_alter,leak,apache_child_terminate,chown,posix_kill,posix_setpgid,posix_setsid,posix_setuid,proc_terminate,syslog,allow_url_fopen,fpassthru,execute,shell,chgrp,passthru,socket_select,socket_create,socket_create_listen,socket_create_pair,socket_listen,socket_accept,socket_bind,foreach,socket_strerror,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,openlog,apache_get_version,apache_getenv,apache_note,apache_setenv,virtualal MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /usr/bin/ |
Upload File : |
#!/usr/bin/perl
# Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335 USA
$version="1.02";
use Getopt::Long;
$opt_help=$opt_Information=$opt_skip_use_db=0;
$opt_regexp=$opt_dbregexp=".*";
$opt_start_row=1; $opt_rows=9999999999;
GetOptions("Information","help","regexp=s","start_row=i","rows=i",
"dbregexp=s", "skip-use-db")
|| usage();
usage() if ($opt_help || $opt_Information);
$query=$search=$database=$set=""; $eoq=0;
while (<>)
{
next if (length($query) == 0 && /^\#/); # Skip comments
$query.=search($_);
if ($eoq)
{
if ($query =~ /^use /i || $query =~ /^SET / ||
($query =~ /$opt_regexp/o && $database =~ /$opt_dbregexp/o))
{
if ($opt_skip_use_db && $query =~ /^use /i)
{
$query="";
next;
}
if ($opt_start_row <= 1)
{
if ($database)
{
print $database, $set;
$database=$set="";
}
print $query;
last if (--$opt_rows == 0);
}
else
{
$opt_start_row--;
if ($query =~ /^use /)
{
$database=$query;
$set="";
}
elsif ($query =~ /^SET/)
{
$set=$query;
}
else
{
$set="";
}
}
}
$query=""; $search=""; $eoq=0;
}
}
exit 0;
sub search
{
my($row)=shift;
my($i);
for ($i=0 ; $i < length($row) ; $i++)
{
if (length($search))
{
if (length($search) > 1)
{ # Comment
next if (substr($row,$i,length($search)) ne $search);
$i+=length($search)-1;
$search="";
}
elsif (substr($row,$i,1) eq '\\') # Escaped char in string
{
$i++;
}
elsif (substr($row,$i,1) eq $search)
{
if (substr($row,$i+1,1) eq $search) # Double " or '
{
$i++;
}
else
{
$search="";
}
}
next;
}
if (substr($row,$i,2) eq '/*') # Comment
{
$search="*/";
$i++;
}
elsif (substr($row,$i,1) eq "'" || substr($row,$i,1) eq '"')
{
$search=substr($row,$i,1);
}
}
$eoq=1 if (!length($search) && $row =~ /;\s*$/);
return $row;
}
sub usage
{
print <<EOF;
$0 Ver $version
Prints all SQL queries that matches a regexp or contains a 'use
database' or 'set ..' command to stdout. A SQL query may contain
newlines. This is useful to find things in a MariaDB update log.
$0 takes the following options:
--help or --Information
Shows this help
--regexp=#
Print queries that matches this.
--start_row=#
Start output from this row (first row = 1)
--skip-use-db
Don\'t include \'use database\' commands in the output.
--rows=#
Quit after this many rows.
Example:
$0 --regexp "problem_table" < update.log
$0 --regexp "problem_table" update-log.1 update-log.2
EOF
exit(0);
}