com.tivoli.twg.inventory
Class TWGIdeDeviceTable

java.lang.Object
  extended bycom.tivoli.twg.engine.TWGObject
      extended bycom.tivoli.twg.engine.TWGPersistentObject
          extended bycom.tivoli.twg.engine.TWGDatabaseTable
              extended bycom.tivoli.twg.inventory.TWGIdeDeviceTable

public class TWGIdeDeviceTable
extends TWGDatabaseTable

SQL database table for IDE Device information

Primary key - MANAGED_OBJ_ID, IDE_ADAPTER_INDEX, IDE_DEVICE_INDEX

TWG_IDE_DEVICE
Field Name Data Type Description NT/2000 95/98 OS/2 Netware AS/400 SNMP AIX HPUX Solaris Unixware Linux
MANAGED_OBJ_ID INT Managed object id X
IDE_ADAPTER_INDEX INT Adapter index X
IDE_DEVICE_INDEX INT Device index X
DEVICE_TYPE CHAR(32) Device type - ENUM1 X
DEVICE_SIZE INT Device size X
UNIT_STATUS CHAR(32) Unit status - ENUM1 X
MEDIA_STATUS CHAR(32) Media status - ENUM1 X
PRODUCT_ID CHAR(40) Product ID X

1 Note: Data values like Field_name_*; see static variables below


Field Summary
static java.lang.String DEVICE_SIZE
           
static java.lang.String DEVICE_TYPE
           
static java.lang.String DEVICE_TYPE_CDROM
           
static java.lang.String DEVICE_TYPE_CHANGER
           
static java.lang.String DEVICE_TYPE_FIXED
           
static java.lang.String DEVICE_TYPE_FLOPPY
           
static java.lang.String DEVICE_TYPE_OPTICAL_DISK
           
static java.lang.String DEVICE_TYPE_OTHER
           
static java.lang.String DEVICE_TYPE_TAPE
           
static java.lang.String DEVICE_TYPE_UNKNOWN
           
static java.lang.String DEVICE_TYPE_WORM
           
static java.lang.String IDE_ADAPTER_INDEX
           
static java.lang.String IDE_DEVICE_INDEX
           
static java.lang.String MANAGED_OBJ_ID
           
static java.lang.String MEDIA_STATUS
           
static java.lang.String MEDIA_STATUS_NOT_PRESENT
           
static java.lang.String MEDIA_STATUS_OTHER
           
static java.lang.String MEDIA_STATUS_PRESENT
           
static java.lang.String MEDIA_STATUS_UNKNOWN
           
static java.lang.String PRODUCT_ID
           
static java.lang.String TABLE_NAME
           
static java.lang.String TABLE_VERSION
           
static java.lang.String UNIT_STATUS
           
static java.lang.String UNIT_STATUS_DEFECTIVE
           
static java.lang.String UNIT_STATUS_OTHER
           
static java.lang.String UNIT_STATUS_POWERED_OFF
           
static java.lang.String UNIT_STATUS_READY
           
static java.lang.String UNIT_STATUS_UNKNOWN
           
 
Fields inherited from class com.tivoli.twg.engine.TWGDatabaseTable
CLASSNAME, DbKeyWords, DEFAULT_TABLE_BUNDLE_NAME, validChars
 
Fields inherited from class com.tivoli.twg.engine.TWGPersistentObject
CLASS_NAME, SIZEOF_BYTE, SIZEOF_CHAR, SIZEOF_DOUBLE, SIZEOF_FLOAT, SIZEOF_INT, SIZEOF_LONG, SIZEOF_SHORT
 
Constructor Summary
TWGIdeDeviceTable()
           
 
Method Summary
 void create()
          Abstract method must be overriden by subclass to define the table.
 java.lang.String getTableVersion()
          Abstract method must be overriden by subclass to get the version for table
 
Methods inherited from class com.tivoli.twg.engine.TWGDatabaseTable
deleteManagedObject, deleteTable, findTableByClassName, flatten, getAllFullColumnNames, getAllTrue, getAllTrueForSame, getAnyTrue, getBundleName, getBundleString, getColumn, getColumnByColumnRealName, getColumnLength, getColumnLength, getColumnLengths, getColumns, getColumnType, getColumnType, getColumnTypes, getDatabase, getDefaultValue, getDefaultValue, getDefaultValues, getDisplayColumnName, getDisplayFullColumnNames, getDisplayName, getDisplayValues, getEachTrueForAtLeastOne, getFilterColumns, getFilterPrompt, getFilterSQL, getGraphicName, getKey, getMatchingMoids, getMultiLocaleBundle, getMyClassName, getNumberOfColumns, getRealColumnName, getRealColumnName, getRealColumnNames, getRealName, getShortClassName, getTable, getTableBy, getTableByRealTableName, getTableInfo, getTableMultiLocaleBundle, getTableName, getTables, getTokenColumnNames, getTokenName, insertOrDeleteRow, insertRow, isFilterColumn, isMappedColumn, restoreData, saveData, setShortTableName, toString, TWGInitTable, userTableFixClassName
 
Methods inherited from class com.tivoli.twg.engine.TWGPersistentObject
Destroy, enableAsyncWrites, fromPersistID, initialize, isNewPersistentStore, isSaveRequired, PersistID, restore, restoreAll, save, save, setSaveRequired, terminate, toPersistID
 
Methods inherited from class com.tivoli.twg.engine.TWGObject
AllObjects, AllObjects, Delete, DumpTWGObjects, FindObject, isDeleted, isNewObject, isPersistent, isPersistent, isValid, isValid, ObjectID, setDistinctObjectID, SetObjectID
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

TABLE_NAME

public static final java.lang.String TABLE_NAME
See Also:
Constant Field Values

MANAGED_OBJ_ID

public static final java.lang.String MANAGED_OBJ_ID
See Also:
Constant Field Values

IDE_ADAPTER_INDEX

public static final java.lang.String IDE_ADAPTER_INDEX
See Also:
Constant Field Values

IDE_DEVICE_INDEX

public static final java.lang.String IDE_DEVICE_INDEX
See Also:
Constant Field Values

DEVICE_TYPE

public static final java.lang.String DEVICE_TYPE
See Also:
Constant Field Values

DEVICE_SIZE

public static final java.lang.String DEVICE_SIZE
See Also:
Constant Field Values

UNIT_STATUS

public static final java.lang.String UNIT_STATUS
See Also:
Constant Field Values

MEDIA_STATUS

public static final java.lang.String MEDIA_STATUS
See Also:
Constant Field Values

PRODUCT_ID

public static final java.lang.String PRODUCT_ID
See Also:
Constant Field Values

DEVICE_TYPE_OTHER

public static final java.lang.String DEVICE_TYPE_OTHER
See Also:
Constant Field Values

DEVICE_TYPE_UNKNOWN

public static final java.lang.String DEVICE_TYPE_UNKNOWN
See Also:
Constant Field Values

DEVICE_TYPE_FIXED

public static final java.lang.String DEVICE_TYPE_FIXED
See Also:
Constant Field Values

DEVICE_TYPE_FLOPPY

public static final java.lang.String DEVICE_TYPE_FLOPPY
See Also:
Constant Field Values

DEVICE_TYPE_TAPE

public static final java.lang.String DEVICE_TYPE_TAPE
See Also:
Constant Field Values

DEVICE_TYPE_WORM

public static final java.lang.String DEVICE_TYPE_WORM
See Also:
Constant Field Values

DEVICE_TYPE_CDROM

public static final java.lang.String DEVICE_TYPE_CDROM
See Also:
Constant Field Values

DEVICE_TYPE_OPTICAL_DISK

public static final java.lang.String DEVICE_TYPE_OPTICAL_DISK
See Also:
Constant Field Values

DEVICE_TYPE_CHANGER

public static final java.lang.String DEVICE_TYPE_CHANGER
See Also:
Constant Field Values

UNIT_STATUS_OTHER

public static final java.lang.String UNIT_STATUS_OTHER
See Also:
Constant Field Values

UNIT_STATUS_UNKNOWN

public static final java.lang.String UNIT_STATUS_UNKNOWN
See Also:
Constant Field Values

UNIT_STATUS_READY

public static final java.lang.String UNIT_STATUS_READY
See Also:
Constant Field Values

UNIT_STATUS_POWERED_OFF

public static final java.lang.String UNIT_STATUS_POWERED_OFF
See Also:
Constant Field Values

UNIT_STATUS_DEFECTIVE

public static final java.lang.String UNIT_STATUS_DEFECTIVE
See Also:
Constant Field Values

MEDIA_STATUS_OTHER

public static final java.lang.String MEDIA_STATUS_OTHER
See Also:
Constant Field Values

MEDIA_STATUS_UNKNOWN

public static final java.lang.String MEDIA_STATUS_UNKNOWN
See Also:
Constant Field Values

MEDIA_STATUS_PRESENT

public static final java.lang.String MEDIA_STATUS_PRESENT
See Also:
Constant Field Values

MEDIA_STATUS_NOT_PRESENT

public static final java.lang.String MEDIA_STATUS_NOT_PRESENT
See Also:
Constant Field Values

TABLE_VERSION

public static final java.lang.String TABLE_VERSION
See Also:
Constant Field Values
Constructor Detail

TWGIdeDeviceTable

public TWGIdeDeviceTable()
Method Detail

create

public void create()
            throws TWGDbException
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to define the table.

Specified by:
create in class TWGDatabaseTable
Throws:
TWGDbException

getTableVersion

public java.lang.String getTableVersion()
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to get the version for table

Specified by:
getTableVersion in class TWGDatabaseTable
Returns:
the version id for this table