org.starhope.appius.user.events
Class EventOutcomeRecordSQLLoader

java.lang.Object
  org.starhope.appius.user.events.EventOutcomeRecordSQLLoader

All Implemented Interfaces:

EventOutcomeRecordLoader, RecordLoader<EventOutcomeRecord>, HasSubversionRevision

public class EventOutcomeRecordSQLLoader
extends Object
implements EventOutcomeRecordLoader

Load an EventOutcomeRecord from the database. TODO: save them, too.

 CREATE TABLE eventOutcomes (
    ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    giveMedal INT NULL,
    CONSTRAINT FOREIGN KEY (giveMedal) REFERENCES medalTypes(ID),
    maxRarity TINYINT NOT NULL DEFAULT 4,
    minRarity TINYINT NOT NULL DEFAULT 1,
    CONSTRAINT FOREIGN KEY (maxRarity) REFERENCES itemRarities(ID),
    CONSTRAINT FOREIGN KEY (minRarity) REFERENCES itemRarities(ID),
    onDupe ENUM ('R','I','N') NOT NULL DEFAULT 'I',
    rewardPoints ENUM ('Y','N') NOT NULL DEFAULT 'Y',
    rewardCurrency CHAR(3) NOT NULL DEFAULT 'xTP',
    rewardCollectionID INT UNSIGNED NULL,
    CONSTRAINT FOREIGN KEY (rewardCollectionID) REFERENCES itemCollections(ID),
    rewardItemID INT NULL,
    CONSTRAINT FOREIGN KEY (rewardItemID) REFERENCES items (ID),
    rewardRatio DECIMAL(10,5) NOT NULL DEFAULT 00001.00000,
          rewardRandom ENUM ('Y','N') NOT NULL DEFAULT 'N',
          rewardMin DECIMAL(5,0) NOT NULL DEFAULT -99999,
          rewardMax DECIMAL(5,0) NOT NULL DEFAULT 99999,
    rewardItemType ENUM('I','C','G','N') NOT NULL DEFAULT 'N'
 ) ENGINE=InnoDB;
 
 

Author:

brpocock@star-hope.org

Constructor Summary

EventOutcomeRecordSQLLoader()

Method Summary

void	changed(EventOutcomeRecord changedRecord) accept a notification from a record that it has been changed.
String	getSubversionRevision() Return the Subversion revision level of this class's source code file, as supplied via the special "$Rev: " sequence.
void	initializeStorage(String storageURL) Prepare the RecordLoader for accessing a given storage medium.
boolean	isRealtime()
EventOutcomeRecord	loadRecord(int id) Load the record with the given ID number from the storage system
EventOutcomeRecord	loadRecord(String identifier) Load the data record identified from the storage system.
void	refresh(EventOutcomeRecord record) Refreshes the record: Re-read the contents of the database into the given record.
void	removeRecord(EventOutcomeRecord record)
void	saveRecord(EventOutcomeRecord record) Save a record back to the storage system

Methods inherited from class java.lang.Object

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

Constructor Detail

EventOutcomeRecordSQLLoader

public EventOutcomeRecordSQLLoader()

Method Detail

changed

public void changed(EventOutcomeRecord changedRecord)

Description copied from interface: RecordLoader

accept a notification from a record that it has been changed.

Specified by:

changed in interface RecordLoader<EventOutcomeRecord>

Parameters:

changedRecord - the record that has been changed

See Also:

RecordLoader.changed(org.starhope.appius.util.DataRecord)

getSubversionRevision

public String getSubversionRevision()

Description copied from interface: HasSubversionRevision

Return the Subversion revision level of this class's source code file, as supplied via the special "$Rev: " sequence.

As an example,the Subversion revision string for this file is "$Rev: 1968 $"

 
 @Override
 public String getSubversionRevision () {
        return "$Rev: ";
 }
 

Specified by:

getSubversionRevision in interface HasSubversionRevision

Returns:

The Subversion revision level for this class's source code file.

See Also:

HasSubversionRevision.getSubversionRevision()

initializeStorage

public void initializeStorage(String storageURL)
                       throws NotReadyException

Description copied from interface: RecordLoader

Prepare the RecordLoader for accessing a given storage medium. Usually identifies a URL for the storage mechanism, but can also pull information from AppiusConfig.

Specified by:

initializeStorage in interface RecordLoader<EventOutcomeRecord>

Parameters:

storageURL - A URL or identifier of the storage engine. The syntax is specific to the RecordLoader implementation.

Throws:

NotReadyException - if the storage engine can't be initialised

See Also:

RecordLoader.initializeStorage(java.lang.String)

isRealtime

public boolean isRealtime()

Specified by:

isRealtime in interface RecordLoader<EventOutcomeRecord>

Returns:

true, if this is a type that requires realtime performance on changes. Note that I/O bound storage such as SQL database saves and file writes will generally return false, whereas RPC mirroring will probably want to return true, unless latency is not an issue.

See Also:

RecordLoader.isRealtime()

loadRecord

public EventOutcomeRecord loadRecord(int id)
                              throws NotFoundException

Description copied from interface: RecordLoader

Load the record with the given ID number from the storage system

Specified by:

loadRecord in interface RecordLoader<EventOutcomeRecord>

Parameters:

id - the ID number for the record

Returns:

the data record in question

Throws:

NotFoundException - if the record can't be loaded

See Also:

RecordLoader.loadRecord(int)

loadRecord

public EventOutcomeRecord loadRecord(String identifier)
                              throws NotFoundException

Description copied from interface: RecordLoader

Load the data record identified from the storage system. The format and interpretation of the identifier is specific to the data record type, but must be a guaranteed-unique

Specified by:

loadRecord in interface RecordLoader<EventOutcomeRecord>

Parameters:

identifier - the identifier for the record

Returns:

the data record in question

Throws:

NotFoundException - if the record can't be loaded

See Also:

RecordLoader.loadRecord(java.lang.String)

removeRecord

public void removeRecord(EventOutcomeRecord record)

Specified by:

removeRecord in interface RecordLoader<EventOutcomeRecord>

Parameters:

record - Record to be deleted/removed

See Also:

RecordLoader.removeRecord(org.starhope.appius.util.DataRecord)

saveRecord

public void saveRecord(EventOutcomeRecord record)

Description copied from interface: RecordLoader

Save a record back to the storage system

Specified by:

saveRecord in interface RecordLoader<EventOutcomeRecord>

Parameters:

record - the record to be saved

See Also:

RecordLoader.saveRecord(org.starhope.appius.util.DataRecord)

refresh

public void refresh(EventOutcomeRecord record)

Description copied from interface: RecordLoader

Refreshes the record: Re-read the contents of the database into the given record. This is a rather cruel hack to work around some of the legacy tools in Tootsville™ that aren't hooked into the game server properly, and might be fiddling around with the SQL backing-store directly. This works together with e.g. SimpleDataRecord.checkStale() to try to reload data when it might have been changed: it's trading elegance and efficiency for expediency, but eventually, it should be removed.

Specified by:

refresh in interface RecordLoader<EventOutcomeRecord>

Parameters:

record - the record to be reloaded.