public Cursor getCursor() { try { super.open(); return super.db.query( TABLE_NAME, Episode.columns, null, null, null, null, Episodes.DEFAULT_SORT_ORDER); } catch (SQLException e) { return null; } }
public void excludeEpisodesBd(long serieId) { String where = "id_serie = " + serieId; try { super.open(); db.delete(TABLE_NAME, where, null); } catch (SQLException e) { Log.e("SeriesManager", "Error trying to exclude Episode: " + e.toString()); } finally { super.close(); } }
public void addEpisode(Episode episode, Serie serie) { try { super.open(); ContentValues values = new ContentValues(); values.put("id_serie", serie.getId()); values.put("name", episode.getName()); values.put("season", episode.getSeason()); values.put("number", episode.getNumber()); db.insert(TABLE_NAME, null, values); } catch (SQLException e) { Log.e("SeriesManager", "Error trying to include Episode: " + e.toString()); } finally { super.close(); } }
public void updateEpisode(Episode episode, Serie serie) { try { String where = "pk_id = " + episode.getId(); super.open(); ContentValues values = new ContentValues(); values.put("id_serie", serie.getId()); values.put("name", episode.getName()); values.put("season", episode.getSeason()); values.put("number", episode.getNumber()); db.update(TABLE_NAME, values, where, null); } catch (SQLException e) { Log.e("SeriesManager", "Error trying to update Episode: " + e.toString()); } finally { super.close(); } }