Advertisement
Guest User

Untitled

a guest
Apr 19th, 2016
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.33 KB | None | 0 0
  1. Playbook for Project Demo
  2. We will use Chrome to mitigate any JS/CSS issues
  3. We will only use single browser screen available and SQL query window
  4. Confirm all webex clients working properly
  5.  
  6. Sample customer for use with setup data
  7. username: Aisha.Tan@mail.com
  8. password: pzjT1PN4
  9. Sample clerk for demo will be - Add Clerk
  10. username: Troy.Stroup
  11. password: yWmdE1z9
  12.  
  13. Start clean and fresh - drop all tables and refresh new database - phase3\db_gen folder - run command line - ./init_db.sh
  14. Create new user
  15. Our feature to brag about - Make a few new reservations
  16. Pickup
  17. Drop-off
  18. Add service order for tool 81
  19. Add new tool - construction tool - Wheel Barrel - no accessories
  20. Add new tool - power tool - Hammer Drill - with 1 accessory
  21. Sell tool - 92
  22. Try to sell a tool 87 (with an existing future reservation)
  23. Tool 135 is on a reservation which begins on 3/1 and end on 3/3
  24. Tool 87 is on a reservation which begins on 5/1 and ends on
  25. Tool 92 is on a reservation which begins on 4/25 and ends on 6/25
  26. Tool 130 (reservations 18 and 58) have pending future reservations
  27. Add service order for tool in the past: using tool 96 from 2/14/2016 to 2/29/2016
  28.  
  29. SELECT res.resnum, tr.toolid, res.startdate, res.enddate
  30. FROM reservation res
  31. JOIN toolreservation tr ON (tr.resnum = res.resnum)
  32. WHERE curdate() < res.startdate
  33. ORDER BY tr.toolid;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement