@Override
public List<ThreadInfo> getThreads(String url) {
List<ThreadInfo> list = new ArrayList<ThreadInfo>();
SQLiteDatabase db = mHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("select * from thread_info where url = ?", new String[] {url});
while (cursor.moveToNext()) {
ThreadInfo threadInfo = new ThreadInfo();
threadInfo.setId(cursor.getInt(cursor.getColumnIndex("thread_id")));
threadInfo.setUrl(cursor.getString(cursor.getColumnIndex("url")));
threadInfo.setStart(cursor.getLong(cursor.getColumnIndex("start")));
threadInfo.setEnd(cursor.getLong(cursor.getColumnIndex("end")));
threadInfo.setFinished(cursor.getLong(cursor.getColumnIndex("finished")));
list.add(threadInfo);
}
cursor.close();
db.close();
return list;
}
