search

shaheenm82 / quest-list

Automatically exported from code.google.com/p/quest-list
0 stars 0 forks source link

Tasks #14

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Tasks Should
Have a name
Have a description
Have a created date
have an experience value for each of the skill trees
have a total experience value equal to the sum of the experience for each skill 
tree.
have a completed date.

Original issue reported on code.google.com by shaheen....@gmail.com on 25 Feb 2015 at 8:02

GoogleCodeExporter commented 8 years ago

Original comment by shaheen....@gmail.com on 25 Feb 2015 at 8:05

GoogleCodeExporter commented 8 years ago 
Created the Task Table using the following SQL statement 

private static final String CREATE_TABLE_TASK = 
        "CREATE TABLE " + TABLE_TASK
        + "(" + KEY_ID + " INTEGER PRIMARY KEY,"
        + COL_TASK_NAME + " TEXT NOT NULL,"
        + COL_TASK_DESC + " TEXT,"
        + COL_TASK_FIT_XP + " INTEGER DEFAULT 0,"
        + COL_TASK_INT_XP + " INTEGER DEFAULT 0,"
        + COL_TASK_ART_XP + " INTEGER DEFAULT 0,"
        + COL_TASK_CHR_XP + " INTEGER DEFAULT 0,"
        + COL_TASK_PER_XP + " INTEGER DEFAULT 0,"
        + COL_TASK_CREATED + " TEXT NOT NULL,"
        + COL_TASK_COMPLETED + " TEXT,"
        + COL_TASK_QUEST + " INTEGER,"
        + COL_TASK_PARENT + " INTEGER "
        + ")";

Original comment by shaheen....@gmail.com on 4 Mar 2015 at 5:17

GoogleCodeExporter commented 8 years ago 
Created a POJO to hold an object with the task data. 

Created a Helper class to write tasks to the database and to read tasks from 
the database.

Original comment by shaheen....@gmail.com on 4 Mar 2015 at 5:18

GoogleCodeExporter commented 8 years ago

Original comment by shaheen....@gmail.com on 4 Mar 2015 at 5:29