Examples with ReaderRecommendBlogList org.wordpress.android.models.ReaderRecommendBlogList used on opensource projects

Example 1 with ReaderRecommendBlogList

use of org.wordpress.android.models.ReaderRecommendBlogList in project WordPress-Android by wordpress-mobile.

the class ReaderBlogTable method getRecommendedBlogs.

public static ReaderRecommendBlogList getRecommendedBlogs() {
    String sql = " SELECT * FROM tbl_recommended_blogs ORDER BY title";
    Cursor c = ReaderDatabase.getReadableDb().rawQuery(sql, null);
    try {
        ReaderRecommendBlogList blogs = new ReaderRecommendBlogList();
        if (c.moveToFirst()) {
            do {
                ReaderRecommendedBlog blog = new ReaderRecommendedBlog();
                blog.blogId = c.getLong(c.getColumnIndex("blog_id"));
                blog.followRecoId = c.getLong(c.getColumnIndex("follow_reco_id"));
                blog.score = c.getInt(c.getColumnIndex("score"));
                blog.setTitle(c.getString(c.getColumnIndex("title")));
                blog.setBlogUrl(c.getString(c.getColumnIndex("blog_url")));
                blog.setImageUrl(c.getString(c.getColumnIndex("image_url")));
                blog.setReason(c.getString(c.getColumnIndex("reason")));
                blogs.add(blog);
            } while (c.moveToNext());
        }
        return blogs;
    } finally {
        SqlUtils.closeCursor(c);
    }
}