/**
* @param characterID
* @return
*/
public CharacterSheetResponse getCharacterSheet(int characterID) {
CharacterSheetResponse characterSheet = new CharacterSheetResponse();
Cursor c =
db.query(
TABLE,
null,
COL_CHARACTER_ID + " = ?",
new String[] {String.valueOf(characterID)},
null,
null,
null);
if (c.moveToFirst()) {
characterSheet.setCharacterID(c.getLong(c.getColumnIndex(COL_CHARACTER_ID)));
characterSheet.setName(c.getString(c.getColumnIndex(COL_NAME)));
// characterSheet.setRace(EveRace.valueOf(c.getString(c.getColumnIndex(COL_RACE)))); TODO Fix
// eve race.
try {
characterSheet.setDateOfBirth(formatter.parse(c.getString(c.getColumnIndex(COL_DOB))));
} catch (ParseException e) {
e.printStackTrace();
}
characterSheet.setBloodLine(
EveBloodline.valueOf(c.getString(c.getColumnIndex(COL_BLOODLINE))));
characterSheet.setAncestry(EveAncestry.valueOf(c.getString(c.getColumnIndex(COL_ANCESTRY))));
characterSheet.setGender(c.getString(c.getColumnIndex(COL_GENDER)));
characterSheet.setCorporationName(c.getString(c.getColumnIndex(COL_CORP_NAME)));
characterSheet.setCorporationID(c.getLong(c.getColumnIndex(COL_CORP_ID)));
characterSheet.setAllianceID(c.getLong(c.getColumnIndex(COL_ALLIANCE_ID)));
characterSheet.setAllianceName(c.getString(c.getColumnIndex(COL_ALLIANCE)));
characterSheet.setCloneName(c.getString(c.getColumnIndex(COL_CLONE_NAME)));
characterSheet.setCloneSkillPoints(c.getLong(c.getColumnIndex(COL_CLONE_SP)));
characterSheet.setBalance(c.getDouble(c.getColumnIndex(COL_BALANCE)));
characterSheet.setIntelligence(c.getInt(c.getColumnIndex(COL_INTELLIGENCE)));
characterSheet.setMemory(c.getInt(c.getColumnIndex(COL_MEMORY)));
characterSheet.setCharisma(c.getInt(c.getColumnIndex(COL_CHARISMA)));
characterSheet.setPerception(c.getInt(c.getColumnIndex(COL_PERCEPTION)));
characterSheet.setWillpower(c.getInt(c.getColumnIndex(COL_WILLPOWER)));
}
c.close();
return characterSheet;
}
/** @param characterInfo */
public void setCharacterSheet(CharacterSheetResponse characterSheet) {
ContentValues insertValues = new ContentValues();
insertValues.put(COL_CHARACTER_ID, characterSheet.getCharacterID());
insertValues.put(COL_NAME, characterSheet.getName());
// insertValues.put(COL_RACE, characterSheet.getRace().name()); TODO figure out why eve race
// breaks
insertValues.put(COL_DOB, formatter.format(characterSheet.getDateOfBirth()));
insertValues.put(COL_BLOODLINE, characterSheet.getBloodLine().name());
insertValues.put(COL_ANCESTRY, characterSheet.getAncestry().name());
insertValues.put(COL_GENDER, characterSheet.getGender());
insertValues.put(COL_CORP_NAME, characterSheet.getCorporationName());
insertValues.put(COL_CORP_ID, characterSheet.getCorporationID());
insertValues.put(COL_ALLIANCE_ID, characterSheet.getAllianceID());
insertValues.put(COL_ALLIANCE, characterSheet.getAllianceName());
insertValues.put(COL_CLONE_NAME, characterSheet.getCloneName());
insertValues.put(COL_CLONE_SP, characterSheet.getCloneSkillPoints());
insertValues.put(COL_BALANCE, characterSheet.getBalance());
insertValues.put(COL_INTELLIGENCE, characterSheet.getIntelligence());
insertValues.put(COL_MEMORY, characterSheet.getMemory());
insertValues.put(COL_CHARISMA, characterSheet.getCharisma());
insertValues.put(COL_PERCEPTION, characterSheet.getPerception());
insertValues.put(COL_WILLPOWER, characterSheet.getWillpower());
db.insertWithOnConflict(TABLE, null, insertValues, SQLiteDatabase.CONFLICT_REPLACE);
}