Guest User

Untitled

a guest
Jun 18th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. cursor = getReadableDatabase().rawQuery(
  2. String.format(
  3. "SELECT a.%s %s, question_id, a.text text, is_correct " +
  4. "FROM %s a JOIN %s q ON a.question_id = q.%s " +
  5. "JOIN %s l ON q.level_id = l.%s WHERE l.level = ? AND q.is_active = 1",
  6. BaseColumns._ID, BaseColumns._ID,
  7. ANSWERS_TABLE_NAME, QUESTIONS_TABLE_NAME, BaseColumns._ID,
  8. LEVELS_TABLE_NAME, BaseColumns._ID
  9. ),
  10. new String[]{Integer.toString(level)}
  11.  
  12. cursor = getReadableDatabase().rawQuery(
  13. String.format(
  14. "SELECT a.%s %s, question_id, a.text text, is_correct " +
  15. "FROM %s a JOIN %s q ON a.question_id = q.%s WHERE q.category = ? AND q.is_active = 1 ",
  16. BaseColumns._ID, BaseColumns._ID,
  17. ANSWERS_TABLE_NAME, QUESTIONS_TABLE_NAME, BaseColumns._ID
  18. ),
  19. new String[]{thisQuestionCategory});
Add Comment
Please, Sign In to add comment