man8db/MODULEreport
Table of Contents
MODULEreport - database module report generator
MODULEreport
< list_of_tuples > module_report
This program generates a report
on the
LABELREC, DESCREC, and
DATAREC tables. The report is sorted in I/O
module order with I/O address information appearing first followed by Label,
RefName, Offset and size information.
A set of SQL queries and other tools
are used to extract the necessary information from the database and massage
it into a form suitable for use with this program.
The input should contain
one tuple per line. Lines are terminated by a newline. Fields within a tuple
are separated by a |.
The following fields from the
LABELREC,
DESCREC, and
DATAREC tables are used and appear as input to this program
in this order:
DataRec.Driver
DataRec.Crate
DataRec.Slot
DataRec.ChanNo
DataRec.RecId
DataRec.DTkey
DataRec.DevType
DescRec.OffSet
DescRec.Size
DescRec.Label
RefKeys.RefVal
DescRec.RefName
RefKeys.RefAttNme
DescRec.Llabel
DescRec.LrefName
DevKeys.DevTypeV
#
# produce module report
#
# pull all DATARECs out of database in order
#
psql -d testdb -f data1a.pqry -qt -o f1
#
# pull all DATARECs w/ associated DESCRECs
# out of database in order
#
psql -d testdb -f data1b.pqry -qt | uniq > f2
#
# filter out common members of both files
# (leave only differences)
# use gawk to remove extra field (DevTypeV)
# massage output file to clean up comm’s output
# and also to make filer look like output from
# data1.qry
#
/usr/bin/comm -3 f1 f2 | gawk -f field1.awk | sed -f escript1 > f3
#
# pull all DATARECs out of database in Driver,
# C, N, ChNo order
#
psql -d testdb -f data1.pqry -qt -o f4
#
# pull all logical links
#
psql -d testdb -f data1_L.pqry -qt -o f5
#
# merge the DATARECs with null DATAREC list
# sort it to make sure
#
cat f3 f4 f5 | sort > f6
#
# trim trailing whitespace
#
WStrim trimMODULE < f6 > f7
#
# generate report
#
MODULEreport < f7 > Module.lst
$Id: MODULEreport.8,v 1.0 1999/02/09 18:16:21 kitchen
Exp $
Table of Contents
NARA 5SDH-2
