<h2>Editing File: /usr/bin/mariadb-find-rows</h2><form method='post'><textarea name='content' class='file-edit'>#!/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=&quot;1.02&quot;;

use Getopt::Long;

$opt_help=$opt_Information=$opt_skip_use_db=0;
$opt_regexp=$opt_dbregexp=&quot;.*&quot;;
$opt_start_row=1; $opt_rows=9999999999;

GetOptions(&quot;Information&quot;,&quot;help&quot;,&quot;regexp=s&quot;,&quot;start_row=i&quot;,&quot;rows=i&quot;,
	   &quot;dbregexp=s&quot;, &quot;skip-use-db&quot;)
  || usage();
usage() if ($opt_help || $opt_Information);

$query=$search=$database=$set=&quot;&quot;; $eoq=0;
while (&lt;&gt;)
{
  next if (length($query) == 0 &amp;&amp; /^\#/); # Skip comments
  $query.=search($_);
  if ($eoq)
  {
    if ($query =~ /^use /i || $query =~ /^SET / ||
	($query =~ /$opt_regexp/o &amp;&amp; $database =~ /$opt_dbregexp/o))
    {
      if ($opt_skip_use_db &amp;&amp; $query =~ /^use /i)
      {
	$query=&quot;&quot;;
	next;
      }
      if ($opt_start_row &lt;= 1)
      {
	if ($database)
	{
	  print $database, $set;
	  $database=$set=&quot;&quot;;
	}
	print $query;
	last if (--$opt_rows == 0);
      }
      else
      {
	$opt_start_row--;
	if ($query =~ /^use /)
	{
	  $database=$query;
	  $set=&quot;&quot;;
	}
	elsif ($query =~ /^SET/)
	{
	  $set=$query;
	}
	else
	{
	  $set=&quot;&quot;;
	}
      }
    }
    $query=&quot;&quot;; $search=&quot;&quot;; $eoq=0;
  }
}

exit 0;

sub search
{
  my($row)=shift;
  my($i);

  for ($i=0 ; $i &lt; length($row) ; $i++)
  {
    if (length($search))
    {
      if (length($search) &gt; 1)
      {				# Comment
	next if (substr($row,$i,length($search)) ne $search);
	$i+=length($search)-1;
	$search=&quot;&quot;;
      }
      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 &quot; or '
	{
	  $i++;
	}
	else
	{
	  $search=&quot;&quot;;
	}
      }
      next;	
    }
    if (substr($row,$i,2) eq '/*')	# Comment
    {
      $search=&quot;*/&quot;;
      $i++;
    }
    elsif (substr($row,$i,1) eq &quot;'&quot; || substr($row,$i,1) eq '&quot;')
    {
      $search=substr($row,$i,1);
     }
  }
  $eoq=1 if (!length($search) &amp;&amp; $row =~ /;\s*$/);
  return $row;
}


sub usage
{
    print &lt;&lt;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 &quot;problem_table&quot; &lt; update.log

$0 --regexp &quot;problem_table&quot; update-log.1 update-log.2
EOF
  exit(0);
}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Fbin'>Back to Directory</a>