#!/usr/bin/perl
# sql_count - count physical lines of code in SQL.

# SQL is really screwed up in its commenting system.
# In ANSI, "--" means start of comment, but this causes many problems
# with automatically generated SQL queries.  For example, given:
#   UPDATE tbl_name SET credit=credit-!payment!
# If !payment! is automatically substituted for a negative number,
# a comment is unexpectedly generated.

# So, this program accepts "-- " (dash-dash-space) as a comment character.
# It also supports "#" and /* .. */, which are supported by MySQL.

$total_sloc = 0;

# Do we have "-f" (read list of files from second argument)?
if (($#ARGV >= 1) && ($ARGV[0] eq "-f")) {
  # Yes, we have -f
  if ($ARGV[1] eq "-") {
    # The list of files is in STDIN
    while (<STDIN>) {
      chomp ($_);
      &count_file ($_);
    }
  } else {
    # The list of files is in the file $ARGV[1]
    open (FILEWITHLIST, $ARGV[1]) || die "Error: Could not open $filewithlist\n";
    while (<FILEWITHLIST>) {
      chomp ($_);
      &count_file ($_);
    }
    close FILEWITHLIST;
  }
  shift @ARGV; shift @ARGV;
}
# Process all (remaining) arguments as file names
while ($file = shift @ARGV) {
  &count_file ($file);
}

print "Total:\n";
print "$total_sloc\n";

sub count_file {
  my ($file) = @_;
  my $sloc = 0;

 $result = `sed -e "s/#.*//" -e "s/-- .*//" < "$file" | c_count`;
 $result =~ m/^\s*([0-9]+)/;
 $sloc = $1;
 print "$sloc $file\n";
 $total_sloc += $sloc;
}