man8db/WIRINGreport

Table of Contents

Name

WIRINGreport - database wiring tables intermediate report generator

Synopsis

WIRINGreport [type] < list_of_tuples > intermediate_wiring_table_reports

Description

This program generates individual intermediate reports on the JackRec, RPrecord, and Zrecord tables. The output from this program is used as input to another set of report processors which are used to produce the final report.

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 |.

Type Argument

The following values are valid arguments for type.
JackRec

generates the JackRec table report.
RPrecord

generates the RPrecord table report.
Zrecord

generates the Zrecord table report.
Rpanel

generates the Rpanel report. This is a report by jack number of all connections on the rear panel of the interface.
Zpanel

generates the Zpanel report. This is a report by jack number of all connections on the front panel of the interface.
Buss

generates the Buss report. This is a report by buss jack number of all connections to the internal buss.

JackRec report tuple format

The following fields from the JackRec table are used and appear as input to this program in this order:

JackNo,
JackTypA,
JackTypB.

RPrecord report tuple format

The following fields from the RPrecord table are used and appear as input to this program in this order:

RPdskey_label,
RPdskey_DrefNme,
RPpair,
RPjack,
PinA,
PinB,
ColorA,
ColorB,
SigNameA,
SigNameB,
Buss,
BussP1,
BussP2,
Comments1,
Comments2

If PinB is not used, i.e. if the field contains only whitespace the second line of the report for that record is not output by the program.

Zrecord report tuple format

The following fields from the Zrecord table are used and appear as input to this program in this order:

Zrecord.ZrecId,
DataRec.DTkey,
DataRec.Driver,
DataRec.Crate,
DataRec.Slot,
DataRec.ChanNo,
DataRec.DevType,
Zrecord.Zjack,
Zrecord.Zpair,
Zrecord.PinA,
Zrecord.PinB,
Zrecord.Comments1,
Zrecord.Comments2

Rpanel report tuple format

The following fields from the JackRec, RPrecord, Zrecord, DataRec, and DescRec tables are used and appear as input to this program in this order:

RPrecord.RPjack
RPrecord.PinA
RPrecord.PinB
JackRec.JackTypA
RPrecord.ColorA
RPrecord.ColorB
RPrecord.SigNameA
RPrecord.SigNameB
Zrecord.Zjack
Zrecord.PinA
Zrecord.PinB
RPrecord.RPdskey_label
RPrecord.RPdskey_DrefNme
RPrecord.Buss
RPrecord.BussP1
RPrecord.BussP2
Zrecord.ZrecId
DataRec.Crate
DataRec.Slot
DataRec.ChanNo
DescRec.OffSet + RPrecord.RPpair
RPrecord.Comments1
RPrecord.Comments2

If RPrecord.PinB is not used, i.e. if the field contains only whitespace the second line of the report for that record is not output by the program.

Zpanel report tuple format

The following fields from the JackRec, RPrecord, Zrecord, DataRec, and DescRec tables are used and appear as input to this program in this order:

Zrecord.Zjack
JackRec.JackTypA
Zrecord.PinA
Zrecord.PinB
Zrecord.ZrecId
Zrecord.Zpair
DataRec.Crate
DataRec.Slot
DataRec.ChanNo
DescRec.Label
DescRec.RefName
DescRec.OffSet + RPrecord.RPpair
RPrecord.RPjack
RPrecord.PinA
RPrecord.PinB
RPrecord.ColorA
RPrecord.ColorB
RPrecord.SigNameA
RPrecord.SigNameB
RPrecord.Buss
RPrecord.BussP1
RPrecord.BussP2
RPrecord.Comments1
RPrecord.Comments2

Buss report tuple format

The following fields from the JackRec, RPrecord, Zrecord, DataRec, and DescRec tables are used and appear as input to this program in this order:

RPrecord.RPjack,
RPrecord.PinA,
RPrecord.PinB,
JackRec.JackTypA,
RPrecord.ColorA,
RPrecord.ColorB,
RPrecord.SigNameA,
RPrecord.SigNameB,
Zrecord.Zjack,
Zrecord.PinA,
Zrecord.PinB,
RPrecord.RPdskey_label,
RPrecord.RPdskey_DrefNme,
RPrecord.Buss,
RPrecord.BussP1,
RPrecord.BussP2,
Zrecord.ZrecId,
DataRec.Crate,
DataRec.Slot,
DataRec.ChanNo,
DescRec.OffSet + RPrecord.RPpair,
RPrecord.Comments1,
RPrecord.Comments2

Examples

See Also

Bproc(8) , BprocB(8) , Rproc(8) , RprocB(8) , Zproc(8) , ZprocB(8)

Manual page revision

$Id: WIRINGreport.8,v 1.2 2001/06/20 14:13:04 kitchen Exp $

Table of Contents