1 files changed, 76 insertions, 0 deletions
diff --git a/sql_count b/sql_count
new file mode 100755
index 0000000..8240fd9
--- /dev/null
+++ b/sql_count
@@ -0,0 +1,76 @@
+#!/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.
+
+# This is part of SLOCCount, a toolsuite that counts
+# source lines of code (SLOC).
+# Copyright (C) 2001-2004 David A. Wheeler.
+# 
+# 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; either version 2 of the License, or
+# (at your option) any later version.
+# 
+# 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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+# 
+# To contact David A. Wheeler, see his website at:
+#  http://www.dwheeler.com.
+# 
+# 
+
+$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;
+}