public ArrayList<YouTubePlaylist> readAll(){
  ArrayList<YouTubePlaylist> list=new ArrayList<>();
  SQLiteDatabase db=dbHelper.getReadableDatabase();
  Cursor c=db.rawQuery(YouTubePlaylistEntry.SELECT_QUERY_ORDER_DESC,null);
  while (c.moveToNext()) {
    String playlistId=c.getString(c.getColumnIndexOrThrow(YouTubePlaylistEntry.COLUMN_PLAYLIST_ID));
    String title=c.getString(c.getColumnIndexOrThrow(YouTubePlaylistEntry.COLUMN_TITLE));
    long number=c.getLong(c.getColumnIndexOrThrow(YouTubePlaylistEntry.COLUMN_VIDEOS_NUMBER));
    String status=c.getString(c.getColumnIndexOrThrow(YouTubePlaylistEntry.COLUMN_STATUS));
    String thumbnailUrl=c.getString(c.getColumnIndexOrThrow(YouTubePlaylistEntry.COLUMN_THUMBNAIL_URL));
    list.add(new YouTubePlaylist(title,thumbnailUrl,playlistId,number,status));
  }
  c.close();
  return list;
}

public ArrayList < YouTubePlaylist > readAll ( ) { ArrayList < YouTubePlaylist > list = new ArrayList < > ( ) ; SQLiteDatabase db = dbHelper . getReadableDatabase ( ) ; Cursor c = db . rawQuery ( YouTubePlaylistEntry . SELECT_QUERY_ORDER_DESC , null ) ; while ( c . moveToNext ( ) ) { String playlistId = c . getString ( c . getColumnIndexOrThrow ( YouTubePlaylistEntry . COLUMN_PLAYLIST_ID ) ) ; String title = c . getString ( c . getColumnIndexOrThrow ( YouTubePlaylistEntry . COLUMN_TITLE ) ) ; long number = c . getLong ( c . getColumnIndexOrThrow ( YouTubePlaylistEntry . COLUMN_VIDEOS_NUMBER ) ) ; String status = c . getString ( c . getColumnIndexOrThrow ( YouTubePlaylistEntry . COLUMN_STATUS ) ) ; String thumbnailUrl = c . getString ( c . getColumnIndexOrThrow ( YouTubePlaylistEntry . COLUMN_THUMBNAIL_URL ) ) ; list . add ( new YouTubePlaylist ( title , thumbnailUrl , playlistId , number , status ) ) ; } c . close ( ) ; return list ; }
reads all playlists from playlists database
