public void insertTravel(Travel travel) {
    SQLiteDatabase db = getReadableDatabase();

    ContentValues values = new ContentValues();
    values.put(TravelsConstants.CITY, travel.getCity());
    values.put(TravelsConstants.COUNTRY, travel.getCountry());
    values.put(TravelsConstants.YEAR, travel.getYear());
    values.put(TravelsConstants.NOTE, travel.getNote());
    values.put(TravelsConstants.IMAGE_VIAJE, travel.getImage());

    db.insert(TABLE_NAME, null, values);
  }
  public ArrayList<Travel> getTravelList() {

    ArrayList<Travel> travels = new ArrayList<Travel>();

    SQLiteDatabase db = getReadableDatabase();

    Cursor c = db.query(TravelsConstants.TRAVELS_TABLE_NAME, null, null, null, null, null, null);

    if (c.moveToFirst()) {

      int idTravelIndex = c.getColumnIndex(TravelsConstants._ID);
      int cityIndex = c.getColumnIndex(TravelsConstants.CITY);
      int countryIndex = c.getColumnIndex(TravelsConstants.COUNTRY);
      int yearIndex = c.getColumnIndex(TravelsConstants.YEAR);
      int noteIndex = c.getColumnIndex(TravelsConstants.NOTE);
      int imageViajeIndex = c.getColumnIndex(TravelsConstants.IMAGE_VIAJE);

      do {
        Integer idTravel = c.getInt(idTravelIndex);
        String city = c.getString(cityIndex);
        String country = c.getString(countryIndex);
        Integer year = c.getInt(yearIndex);
        String note = c.getString(noteIndex);
        String imageViaje = c.getString(imageViajeIndex);

        Travel travel = new Travel(idTravel, city, country, year, note);

        if (imageViaje != null) {
          travel.setImage(imageViaje);
        }

        travels.add(travel);

      } while (c.moveToNext());

      c.close();
    }
    return travels;
  }
  public void updateTravel(Travel travel) {
    SQLiteDatabase db = getReadableDatabase();

    ContentValues values = new ContentValues();
    values.put(TravelsConstants.CITY, travel.getCity());
    values.put(TravelsConstants.COUNTRY, travel.getCountry());
    values.put(TravelsConstants.YEAR, travel.getYear());
    values.put(TravelsConstants.NOTE, travel.getNote());
    values.put(TravelsConstants.IMAGE_VIAJE, travel.getImage());

    db.update(TABLE_NAME, values, TravelsConstants._ID + "=" + travel.getIdTravel(), null);
  }