Package helpers :: Module AddIndices :: Class Indexer

Class Indexer

source code

Create table indexes for all programmes.

Nested Classes

[hide private]

Nested Errors and Exceptions

Inherited from wsatools.DbConnect.CuSession.CuSession: CuError

Instance Methods

[hide private]

_onRun(self)
Creates indices for all tables.

source code

Inherited from wsatools.DbConnect.CuSession.CuSession: __del__, __init__, logBrokenFile, run

Inherited from wsatools.DbConnect.CuSession.CuSession (private): _getNextCuEventID, _getNextID, _onException, _prepareDbLock, _scrubACHPlaceHolder, _updateArchiveCurationHistory, _updateProgrammeCurationHistory

Inherited from object: __delattr__, __format__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __sizeof__, __str__, __subclasshook__

Static Methods

[hide private]

Inherited from wsatools.DbConnect.CuSession.CuSession: logException

Class Variables

[hide private]

cuNum = 18
Curation task number.

_autoCommit = True
Should this curation task auto-commit database transactions?

indexName = ''
Select just those indices with this phrase in their name.

releasedOnly = False
Just apply releasable indices?

Inherited from wsatools.DbConnect.CuSession.CuSession: archive, comment, cuEventID, curator, eTypes, isDayStampedLog, onlyNonSurveys, onlySurveys, programme, programmeID, resultsFilePathName, shareFileID, sysc

Inherited from wsatools.DbConnect.CuSession.CuSession (private): _cleanUpDirs, _cuTable, _isPersistent, _lockPathName, _log, _numSessions, _reqCuEventID, _reqDbLock, _rolledBack, _success, _useWorkDir

Properties

[hide private]

Inherited from object: __class__

Method Details

[hide private]

_onRun(self)

source code

Creates indices for all tables.

Method: use the information parsed from the static SQL script WSA_Indices.sql to cycle through every index for every table, creating each one if it does not exist. The underlying assumption is that if an index needs updating, then it will have been dropped by a previous procedure that updated the indexed data, e.g. a bulk load operation, or a recalibration operation.

Overrides: wsatools.DbConnect.CuSession.CuSession._onRun