Constant Field Values
Contents
edu.cnm.*
-
edu.cnm.deepdive.viral.BuildConfig Modifier and Type Constant Field Value public static final String
APPLICATION_ID
"edu.cnm.deepdive.viral"
public static final String
BUILD_TYPE
"debug"
public static final int
VERSION_CODE
1
public static final String
VERSION_NAME
"1.0"
-
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"