Constant Field Values

Contents

edu.cnm.*

  • edu.cnm.deepdive.scalescroller.model.dao.ScaleChallengeAttemptDao 
    Modifier and Type Constant Field Value
    public static final String SELECT_CHALLENGE_ATTEMPTS_ORDER_BY_DATE_QUERY "SELECT ca.* FROM ChallengeAttempt AS ca INNER JOIN ScaleChallengeAttempt AS sca ON sca.challenge_attempt_id = ca.challenge_attempt_id WHERE sca.scale_id = :scaleId ORDER BY ca.timestamp DESC"
    public static final String SELECT_CHALLENGE_ATTEMPTS_ORDER_BY_SCORE_QUERY "SELECT ca.* FROM ChallengeAttempt AS ca INNER JOIN ScaleChallengeAttempt AS sca ON sca.challenge_attempt_id = ca.challenge_attempt_id WHERE sca.scale_id = :scaleId ORDER BY ca.total_score DESC"
    public static final String SELECT_SCALES_BY_DATE_QUERY "SELECT s.* FROM Scale AS s INNER JOIN ScaleChallengeAttempt AS sca ON sca.scale_id = s.scale_id WHERE sca.challenge_attempt_id = :attemptId ORDER BY sca.timestamp ASC"
    public static final String SELECT_SCALES_BY_NAME_QUERY "SELECT s.* FROM Scale AS s INNER JOIN ScaleChallengeAttempt AS sca ON sca.scale_id = s.scale_id WHERE sca.challenge_attempt_id = :attemptId ORDER BY s.mode AND s.tonic ASC"