dea.convert
Class MsgInfoFix

java.lang.Object
  dea.convert.MsgInfoFix

All Implemented Interfaces:

IDebugLevels

public class MsgInfoFix

extends java.lang.Object

implements IDebugLevels

Title: MsgInfo Fix
Description: Cleans up data in the MsgInfo table from old code bugs / tests
Copyright: Copyright (c) 2004
Company: RMRR

@author David Abigt
@version 1.0

Field Summary

Fields inherited from interface dea.common.IDebugLevels

BASIC, DEBUG_ALL, ERROR, METH_DETAIL, METH_ENTER, METH_EXIT, METH_EXT, METH_GET, METH_SET, METH_VARS, SHOW_PASS

Constructor Summary

MsgInfoFix()

Method Summary

static void	cleanupFields() Loop through all the records removing extra spaces from messageIDs and cleaning up email addresses
static void	fixBatchNumbers()
static void	fixSentDates() If batch number represents seconds of a valid date and is before msg_sent date the msg_sent is set to the date the batch number represents.
static void	main(java.lang.String[] args) Entrypoint
static void	removeDupBatch() Removes records that has duplicate entries for a batch number / msg number key
static void	removeDupMessageID() Removes records that has duplicate entries for a MessageID

Methods inherited from class java.lang.Object

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

Constructor Detail

MsgInfoFix

public MsgInfoFix()

Method Detail

fixSentDates

public static void fixSentDates()

If batch number represents seconds of a valid date and is before msg_sent date the msg_sent is set to the date the batch number represents.

fixBatchNumbers

public static void fixBatchNumbers()

removeDupBatch

public static void removeDupBatch()

Removes records that has duplicate entries for a batch number / msg number key

removeDupMessageID

public static void removeDupMessageID()

Removes records that has duplicate entries for a MessageID

cleanupFields

public static void cleanupFields()

Loop through all the records removing extra spaces from messageIDs and cleaning up email addresses

main

public static void main(java.lang.String[] args)

Entrypoint