/** * @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; }