carolines-qa / hwa-game-time-log Goto Github PK

• /getUsersByUsername (works, but breaks if two users have the same name)

• /getYourGameSessions (works, but breaks if two users have the same name)

• /getAllGameSessionsOrderedByTime
  (no time found. just stick to read all for now)

• /createGameSession
  technically works - but theres no relationship saved

• /updateGameSession/{id}

• /deleteGameSession/{id}

as a User, if a pop-up message appears on my screen with information, don't want to have to click 'okay' for it to dismiss, I should just be able to click anywhere on the page, so that I don't get as frustrated

• CRUD of user, with full manual data entry
• CRUD of game sessions, with full manual data entry
• an output visible on front-end for each operation (8)

as a user, I would like the app to calculate the time I have left
'freeTime' - 'totalTimePlayed' = 'timeReamining'

'totalTimePlayed' = sum of 'timePlayed' for all Game Sessions tied to a user

so that I do not have to do the calculations manually.

I have started with some initial Bootstrap styles, would like to center the forms but have the fields inline (the boxes were never alined because labels appear next to them instead of above)

As an end-user, I want to safely exit/shut-down the application, so that it's stopped and no longer using resources when not in use.

-> referring to the Java app, as the Spring app is run via the java -jar. Currently the main method just runs the Spring App, with no conditions for exit without killing it in the IDE. The Spring part shouldn't need to persist if it's just opening up a connection to the GCP each time, whereas the GCP database will need to persist to keep data.

so that users can 'log in'

as part of my MVP I want these fields to be CRUDable, even if it isn't very user friendly, so that I can still use the application until I have a backend calculation working

As an end-user, I want to know if I input something incorrectly so that I can correct it. (JavaScript form input validation?)

As a dev, I want this feature tested with integration tests

As an end-user, I want to be able to create a 'game session', so that I can record my games.

Correct the name in the MIT License & include in the main package-info.java

As an end-user, I want to read all 'game sessions', so I can see what others have been playing recently.
(select * from game sessions order by time of sessions desc)

• FindAll()
• FindAllOrderedByTimeOfSession

Sort.by(Sort.Direction.DESC, "TIME_OF_SESSION")

• /getAllUsers
• /getUserByUsername/{username}
• /getUserById/{id}
  ^not sure this endpoint is actually used in my website
• /createUser
• /updateUser/{id}
• /deleteUser/{id}
• /getAllGameSessions
  (bonus if I can Order the result ByTime)
• /getYourGameSessions/{username}
• /createGameSession
• /updateGameSession/{id}
• /deleteGameSession/{id}

validation should be added on the front end to prevent bad requests

• create a user
• create a game session
• read the sessions
• update a session
• read the newly updated sessions
• delete the sessions

each part can be a separate test, with each step afterward being nested in a method eg.

Remember to build an extent-report!

As an end-user, I want to be able to create a 'user', so that game sessions I create can be tied to me.

in depth readme explaining how to use my hobby web app

test > resources dir > application.properties

could do - games would be added when added to a game session if they did not already exist

As an end-user, I want to delete my 'game sessions', so that I can clear my history.

added function to delete a single session
extension: delete multiple sessions

As an end-user, I want to update my 'user' so that I can correct mistakes / change my 'free time' available.

Make sure it has all the dependencies and plugins required for the project (as far as I know)

As a user, I want to navigate between different pages, to access the different entities / forms

As an end-user, I want to read all 'game sessions', so I can compare myself to other users
(select * from game sessions where user id = ? or ?) [should]

All tests work apart from Integration (delete is the only integration test for CRUD that passes)

--before--

• Update & Create in service and controller
  All tests related to user:
• User
• UserDTO
• Service/Controller (Unit + Integration)

As an end-user, I want to read my 'game sessions' so I can see what I've been playing. (select * from game sessions where user id = ? )

as a dev, I want a entity of 'user' so that I can apply CRUD functionality to users

I also want to test this class with a unit test

As an end-user, I want to delete my 'user' so that my information is no longer in the database.

As an end-user, I want to read 'users' so that I can compare myself to other users. (select * from users)

As a dev, I want to test the classes related to this with unit and integration tests

when converting hours to mins JS is concatenating instead of doing maths!

fixed concatenation but freeTime is null if both boxes are not filled - need input validation/data correction.

Currently must type a 0 instead of leaving blank

As an end-user, I want to delete my 'game sessions', so that I can clear my history.
deleting all sessions associated with a user would feature on the user.html page

Note: function to delete a single session exists
extension: delete multiple sessions

• delete all sessions associated with a user
• delete by a list of sessions a user gives
• delete sessions by a time period created/updated

as a dev, I want an entity of 'game sessions' so that I can apply crud functionality to game sessions

can test to see if pop ups occur if I try to find a user that dosn't exist etc.

As an end-user, I want to update my 'game sessions' so that I can add additional time playing to a game session.

Start with the initial spring example app file and modify for sql connection later

• create a user
• read the user
• update a user
• read the newly updated user
• delete the user

each part can be a separate test, with each step afterward being nested in a method eg.

Remember to build an extent-report!

createUserTest(){
//do test
}

readUserTest(){
createUserTest()
//do other stuff
}