grs.pds.edr
Class CmdEdrRecord

java.lang.Object
  |
  +--grs.pds.BasePdsRecord
        |
        +--grs.pds.TimeSeriesRecord
              |
              +--grs.pds.edr.CmdEdrRecord

All Implemented Interfaces:

PdsRecord

public class CmdEdrRecord

extends TimeSeriesRecord

Records commands that have been sent to the spacecraft, or executed onboard the CEB.

Version:

$Revision: 1.5 $

Author:

$Author: guym $

Field Summary

int	cmd_id command id, references commanding spreadsheets
byte	delay_flag non-zero if command is delayed
int	exec_code return code
byte	fis_cmd_type zero if noninteractive, one if interactive
Date	fis_send_time time command was sent to flight computer, or value of sc_sent_time if from sequence
long	grs_exec_time CEB time command was executed
short	opcode command opcode, references GRS command dictionary
int	parm1 parameters passed to the command, see the command dictionary
int	parm2 parameters passed to the command, see the command dictionary
int	parm3 parameters passed to the command, see the command dictionary
Date	sc_sent_time time of command (UTC)
long	time_orbit time or orbit:pixel when command is to be executed, zero if immediate
byte	time_orbit_flag zero if to be executed by time, one if by orbit and pixel

Fields inherited from class grs.pds.BasePdsRecord

PdsTimeFormat

Fields inherited from interface grs.pds.PdsRecord

GAMMA_CHANNELS, int10, int12, int2, int3, logger, MESSAGE_LENGTH, NS_MAX_EVENTS, PEF_COMMANDS, prec10, prec12, prec13, prec14, prec15, prec16, prec17, prec5, prec6, prec7, PROFILE_LENGTH, PROFILE_SIZE, PULSER_CHANNELS, QUERY_DATE_FMT, SC_ID

Constructor Summary

CmdEdrRecord(DataInputStream in)
Read record in from a DataInputStream.

CmdEdrRecord(ResultSet rs)
Read record in from a ResultSet.

Method Summary

static String[]	createInsertString(String schema) Create the SQL query used to insert command data into the PDS schema.
static String[]	createSelectString(String schema) Query the command_sent_tab and command_exec_tab by doing a join where grs_exec_time matches.
long	getSCLK() Get the Date (time) of record.
Date	getUTC() Get the UTC time that this record was observed on.
static void	main(String[] args) Demonstrates use of this class to parse an Cmd EDR record.
int	prepareInsert(PreparedStatement pstmt) Bind values to the PreparedStatement
String[]	toStringArray() Display the values in this record.
void	writeTo(DataOutputStream out) Write this record to a DataOutputStream.

Methods inherited from class grs.pds.BasePdsRecord

endianSwapShort

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

cmd_id

public int cmd_id

command id, references commanding spreadsheets

opcode

public short opcode

command opcode, references GRS command dictionary

fis_cmd_type

public byte fis_cmd_type

zero if noninteractive, one if interactive

fis_send_time

public Date fis_send_time

time command was sent to flight computer, or value of sc_sent_time if from sequence

sc_sent_time

public Date sc_sent_time

time of command (UTC)

grs_exec_time

public long grs_exec_time

CEB time command was executed

time_orbit

public long time_orbit

time or orbit:pixel when command is to be executed, zero if immediate

time_orbit_flag

public byte time_orbit_flag

zero if to be executed by time, one if by orbit and pixel

delay_flag

public byte delay_flag

non-zero if command is delayed

parm1

public int parm1

parameters passed to the command, see the command dictionary

parm2

public int parm2

parameters passed to the command, see the command dictionary

parm3

public int parm3

parameters passed to the command, see the command dictionary

exec_code

public int exec_code

return code

Constructor Detail

CmdEdrRecord

public CmdEdrRecord(ResultSet rs)
             throws SQLException

Read record in from a ResultSet.

Parameters:

rs - ResultSet to read from.

Throws:

SQLException - Error reading from resultset.

CmdEdrRecord

public CmdEdrRecord(DataInputStream in)
             throws ParseException,
                    IOException

Read record in from a DataInputStream.

Parameters:

in - Stream to read from.

Throws:

IOException - error reading from stream.

ParseException - UTC date in stream data is invalid.

Method Detail

createSelectString

public static String[] createSelectString(String schema)

Query the command_sent_tab and command_exec_tab by doing a join where grs_exec_time matches.

Parameters:

schema - Database schema to use, e.g. "map1".

Returns:

Query string array.

createInsertString

public static String[] createInsertString(String schema)

Create the SQL query used to insert command data into the PDS schema.

Parameters:

schema - DB Schema to use.

Returns:

SQL query array.

prepareInsert

public int prepareInsert(PreparedStatement pstmt)
                  throws SQLException

Bind values to the PreparedStatement

Specified by:

prepareInsert in class BasePdsRecord

Parameters:

pstmt - prepared statement

Returns:

number of values bound

Throws:

SQLException - Error in binding binding

writeTo

public void writeTo(DataOutputStream out)
             throws IOException

Write this record to a DataOutputStream.

Specified by:

writeTo in class BasePdsRecord

Parameters:

out - Stream to write to.

Throws:

IOException - Error writing to stream.

toStringArray

public String[] toStringArray()

Display the values in this record.

Specified by:

toStringArray in class BasePdsRecord

Returns:

This record as a String array.

getSCLK

public long getSCLK()

Get the Date (time) of record.

Specified by:

getSCLK in class TimeSeriesRecord

Returns:

Date

getUTC

public Date getUTC()

Description copied from class: TimeSeriesRecord

Get the UTC time that this record was observed on.

Specified by:

getUTC in class TimeSeriesRecord

Returns:

UTC.

main

public static final void main(String[] args)

Demonstrates use of this class to parse an Cmd EDR record.

Parameters:

args - path to command data file, e.g. command_list_20020723.dat