Constant Field Values

Contents

edu.cnm.*

  • edu.cnm.deepdive.viral.model.dao.ActionDao 
    Modifier and Type Constant Field Value
    public static final String SELECT_ACTION_BY_VISIBILITY_QUERY "SELECT * FROM `Action` WHERE public = :isPublic AND demeanor_id = :demeanor"
  • edu.cnm.deepdive.viral.model.dao.ActionResponseDao 
    Modifier and Type Constant Field Value
    public static final String AVAILABLE_RESPONSES_QUERY "SELECT * FROM ActionResponse AS ar INNER JOIN `Action` AS ac ON ar.response_to_id = ac.action_id WHERE ac.action_id = :action AND ac.demeanor_id = :demeanor"
  • edu.cnm.deepdive.viral.model.dao.ActionTakenDao 
    Modifier and Type Constant Field Value
    public static final String FEED_ACTIONS_QUERY "SELECT * FROM ActionTaken AS at INNER JOIN `Action` AS ac ON at.action_id = ac.action_id WHERE ac.public = true ORDER BY timestamp DESC"
    public static final String FRIEND_MESSAGES_QUERY "SELECT * FROM ActionTaken AS at INNER JOIN `Action` AS ac ON at.action_id = ac.action_id WHERE ac.public = false AND friend_id = :friend ORDER BY timestamp ASC"
    public static final String FRIEND_POSTS_QUERY "SELECT * FROM ActionTaken AS at INNER JOIN `Action` AS ac ON at.action_id = ac.action_id WHERE ac.public = true AND friend_id = :friend ORDER BY timestamp DESC"
  • edu.cnm.deepdive.viral.model.dao.DemeanorDao 
    Modifier and Type Constant Field Value
    public static final String SELECT_DEMEANOR_BY_INFECTION_LEVEL_QUERY "SELECT * FROM Demeanor WHERE infection_min >= :min AND infection_max <= :max ORDER BY infection_min ASC"
  • edu.cnm.deepdive.viral.model.dao.GameDao 
    Modifier and Type Constant Field Value
    public static final String AVERAGE_FRIENDS_LEFT_SUMMARY_QUERY "SELECT AVG(friends_left) AS average_friends_left, AVG(moves) as average_moves FROM Game ORDER BY average_friends_left DESC"
    public static final String AVERAGE_MOVES_SUMMARY_QUERY "SELECT AVG(friends_left) AS average_friends_left, AVG(moves) as average_moves FROM Game ORDER BY average_moves ASC"