/**
* Updates the image URI for a team member
*
* @param teamMember Team member to change image URI to
*/
public void updateTeamMemberImageURI(TeamMember teamMember) {
Debug.logDebug(
"Updating team member " + teamMember.getId() + " imageURI: " + teamMember.getImageURI());
SQLiteDatabase db = mDbHelper.getWritableDatabase();
ContentValues args = new ContentValues();
args.put(IMAGE_URI_COLUMN, teamMember.getImageURI());
db.update(TEAM_MEMBER_TABLE_NAME, args, ID_COLUMN + "=" + "'" + teamMember.getId() + "'", null);
db.close();
}
/**
* Saves a list of team members into the database
*
* @param teamMembers List of team members to save
*/
public void saveTeamMembers(List<TeamMember> teamMembers) {
Debug.logDebug("Saving team members in the database");
SQLiteDatabase db = mDbHelper.getWritableDatabase();
db.beginTransaction();
db.execSQL(SQL_REMOVE_ALL);
for (TeamMember teamMember : teamMembers) {
ContentValues teamMemberValues = new ContentValues();
teamMemberValues.put(ID_COLUMN, teamMember.getId());
teamMemberValues.put(NAME_COLUMN, teamMember.getName());
teamMemberValues.put(JOB_TITLE_COLUMN, teamMember.getJobTitle());
teamMemberValues.put(BIOGRAPHY_COLUMN, teamMember.getBiography());
teamMemberValues.put(IMAGE_URI_COLUMN, teamMember.getImageURI());
db.insert(TEAM_MEMBER_TABLE_NAME, null, teamMemberValues);
}
db.setTransactionSuccessful();
db.endTransaction();
db.close();
}
