File: addcolumn

package info (click to toggle)
nosql 3.1-4
  • links: PTS
  • area: main
  • in suites: woody
  • size: 1,448 kB
  • ctags: 267
  • sloc: cpp: 1,028; ansic: 915; awk: 732; perl: 502; tcl: 292; sh: 289; makefile: 44
file content (76 lines) | stat: -rwxr-xr-x 2,114 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
#!/usr/bin/mawk -We
# *********************************************************************
#  Written by and copyright Carlo Strozzi <carlos@linux.it>.
#
#  addcolumn: append new empty columns to a NoSQL table.
#  Copyright (C) 1998-2001 Carlo Strozzi <carlos@linux.it>
# 
#  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., 675 Mass Ave, Cambridge, MA 02139, USA.
#
#  2001-01-03 Ported to NoSQL v3 
#  2001-04-17 Added inline help 
#  2001-08-17 Added stdio portability
#
#  $Id$
# *********************************************************************

BEGIN {
  NULL = ""; FS = OFS = "\t"

  while (ARGV[++i] != NULL) {
     if (ARGV[i] == "-i" || ARGV[i] == "--input") i_file = ARGV[++i]
     else if (ARGV[i] == "-o" || ARGV[i] == "--output") o_file = ARGV[++i]
     else if (ARGV[i] == "-h" || ARGV[i] == "--help") {
	system("grep -v '^#' @DOCPATH@/addcolumn.txt")
	rc = 1
	exit(rc)
     }
     else new_cols[++j] = ARGV[i]
  }

  ARGC = 1					# Fix argv[]

  if (o_file == NULL) o_file = "@STDOUT@"
  if (i_file != NULL) { ARGV[1] = i_file; ARGC = 2 }
}

#
# Main loop
#

NR == 1 {
  i = 0
  while (new_cols[++i] != NULL) {
    $0 = $0 OFS new_cols[i]
    padding = padding OFS
  }

  # Remove extra OFS from the beginning of header and dashline.

  sub(/^\t/, NULL, $0)
  sub(/^\t/, NULL, padding)

  # print header and dashline (if not null).

  if ($0 != NULL) { print > o_file; gsub(/[^\t]/, "-"); print > o_file }
}

NR == 2 { next }

NR > 2 { print $0, padding > o_file }

#
# End of program.
#