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