minor comment fixes for ouiparse.awk

Started by Larry Rosenmanover 25 years ago2 messages
#1Larry Rosenman
ler@lerctr.org

Here's a quick patch for contrib/mac/ouiparse.awk to fix some commenting
changes due to Thomas' updates.

*** ouiparse.awk.old	Wed Aug 23 01:02:23 2000
--- ouiparse.awk	Wed Aug 23 07:44:09 2000
***************
*** 10,19 ****
  #        manufacturer text);
  # the table name is set by setting the AWK variable TABLE
  # 
! # we translate the character apostrophe (') to space inside the company name
! # to avoid SQL errors.
  #
- # match ONLY lines that begin with 2 hex numbers, -, and another hex number
  BEGIN {
  	TABLE="macoui";
--- 10,18 ----
  #        manufacturer text);
  # the table name is set by setting the AWK variable TABLE
  # 
! # we translate the character apostrophe (') to double apostrophe ('') inside 
! # the company name to avoid SQL errors.
  #
  BEGIN {
  	TABLE="macoui";
***************
*** 27,32 ****
--- 26,32 ----
  	printf "COMMIT TRANSACTION;";
  }
+ # match ONLY lines that begin with 2 hex numbers, -, and another hex number
  /^[0-9a-fA-F][0-9a-fA-F]-[0-9a-fA-F]/ { 
  #	if (nrec >= 100) {
  #		printf "COMMIT TRANSACTION;";
***************
*** 47,53 ****
  		Company=Company " " $i;
  	# Modify any apostrophes (') to avoid grief below.
  	gsub("'","''",Company);
! 	# Print out for the 'C' structure in mac.c
  	printf "INSERT INTO %s (addr, name) VALUES (trunc(macaddr \'%s\'),\'%s\');\n",
  		TABLE,OUI,Company;
  }
--- 47,53 ----
  		Company=Company " " $i;
  	# Modify any apostrophes (') to avoid grief below.
  	gsub("'","''",Company);
! 	# Print out for the SQL table insert
  	printf "INSERT INTO %s (addr, name) VALUES (trunc(macaddr \'%s\'),\'%s\');\n",
  		TABLE,OUI,Company;
  }
-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
#2Thomas Lockhart
lockhart@alumni.caltech.edu
In reply to: Larry Rosenman (#1)
Re: minor comment fixes for ouiparse.awk

Here's a quick patch for contrib/mac/ouiparse.awk to fix some commenting
changes due to Thomas' updates.

Thanks. Got it...

- Thomas