UI for Query

[TimothyXu]

As a System Administrator I need to have a GUI to query items in a shopcart So that I can find the items with a certain name in a certain shopping cart

Details and Assumptions

• Create button "Search Shopcarts", connect to the query string function
• Input taken in from Item_id text box

• Output given in rows under Shopcart ID

  Acceptance Criteria

  Given a set of items
  | user_id | item_id | item_name | quantity | price   | hold
  | 1001      | 1            |  ring1           |  2            |  1998  | True
  | 1001      | 2            |  ring2          |  1             |  1.5     | False
  | 1002     | 1            |  ring1           |  3             |  3        | True
  When we visit the "home page"
  And we enter "1" to the text box "Item_ID"
  And we press the button "Search-Shopcarts"
  Then we should see message "Successfully listed search results"
  And we should see "1001" in the shopcarts table
  And we should see "1002" in the shopcarts table
  And we should not see "1003" in the shopcarts table
  
  Given a set of items
  | user_id | item_id | item_name | quantity | price   | hold
  | 1001      | 1            |  ring1           |  2            |  1998  | True
  | 1001      | 2            |  ring2          |  1             |  1.5     | False
  | 1002     | 1            |  ring1           |  3             |  3        | True
  When we visit the "home page"
  And we enter "3" to the text box "Item_ID"
  And we press the button "Search-Shopcarts"
  Then we should see message "Successfully listed search results"
  And we should not see "1001" in the shopcarts table
  And we should not see "1002" in the shopcarts table
  And we should not see "1003" in the shopcarts table
  
  Given a set of items
  | user_id | item_id | item_name | quantity | price   | hold
  | 1001      | 1            |  ring1           |  2            |  1998  | True
  | 1001      | 2            |  ring2          |  1             |  1.5     | False
  | 1002     | 1            |  ring1           |  3             |  3        | True
  When we visit the "home page"
  And we enter "2" to the text box "Item_ID"
  And we press the button "Search-Shopcarts"
  Then we should see message "Successfully listed search results"
  And we should see "1001" in the shopcarts table
  And we should not see "1002" in the shopcarts table
  And we should not see "1003" in the shopcarts table
  
  Given a set of items
  | user_id | item_id | item_name | quantity | price   | hold
  | 1001      | 1            |  ring1           |  2            |  1998  | True
  | 1001      | 2            |  ring2          |  1             |  1.5     | False
  | 1002     | 1            |  ring1           |  3             |  3        | True
  When we visit the "home page"
  And we enter "NAME" to the text box "Item_ID"
  And we press the button "Search-Shopcarts"
  Then we should see message "Invalid Item_ID"

[TimothyXu]

for these BDD tests if you need to adjust something (you probably will), please make sure you check for status message confirmation before checking for results in tables. Otherwise they may fail on deployment since our real website has much worse latency than localhost.

Per the latest bug issue, also need to make sure the right error messages are being shown when e.g. user id input is not a number.