System Admin Manual - Software Engineering II
Contents
1. add a column current_valet_fee create table location location_ID varchar 32 primary key location_name varchar 255 not null location_latitude double not null location_longitude double not null location_address varchar 255 not null Other information needed for check position Check google location API and use their fields PE valet_company_ID int 32 null means it belongs to no valet company current_valet_ID int 32 current_valet_fee float foreign key valet_company_ID references valet_company valet_company_ID foreign key current_valet_ID references valet valet_ID create table valet_request 3 Version Date 03 29 15 System Admin Manual SnapValet Version 2 0 valet_request_ID int 32 primary key auto_increment valet_request_status tinyint 8 not null ticket_number varchar 255 not null timestamp datetime not null payment_method tinyint 8 not null Card Cash tips float not null valet_fee float not null CreditCardInfo can be null may be better to fecth these information from Customer table for security J E customer_ID int 32 not null location_ID varchar 32 not null valet_company_ID int 32 not null for paying money foreign key customer_ID references customer customer_ID foreign key location_ID references location location_ID foreign key valet_company_ID references valet_company valet_company_ID create table valet_check_i2. Install Scala IDE Plugin Install eGIT plugin Clone GIT repo Activator Eclipse Install MySQL Server Install SQL Workbench Update application config file for connection and username password Run the design db folder SQL Scripts Activator Run Cloud Deployment Sign up and login to your account on Clever Cloud On the left hand console click on add an application Select No the source code of your application is hosted on Github e You can also select the github option but problems may occur and therefore this option is not recommended Select Play 2 and Java In the instance page click next Name you app and select Montreal Canada Select MySQL database add on Choose what option max connection limit max database size for your DB Name your MySQL add on and change your zone to North America Click next on the environment variables page Copy the two lines of git code in the deployment page Before you deploy your code go back to the source for the Play Framework project In the conf folder select the app conf file and change the DB configuration settings e On the left console on clever cloud select your DB add on e Click on Configuration e Copy all of the credentials Host User Password and replace them in the app conf e Also copy the Database name for later use in configuring the database Run the two copied git commands from clever cloud to deploy the application Now to configure the databas
3. System Admin Manual lt SNAPVALET gt lt Team No 03 gt Name Role Brian Vanover Project Manager Developer Brian Bousman Operational Concept Engineer Developer Ditong Ding System Architect Developer Molly Karcher TV amp V Quality Focal Point Developer Patrick Horng Feasibility Analyst Developer Ridhima Manjrekar Requirements Engineer Life Cycle Planner Developer lt 03 29 15 gt System Admin Manual SnapValet Version 2 0 ii Version Date 03 29 15 System Admin Manual SnapValet Version 2 0 Version History Date Author Version Changes made Rationale 04 08 15 RM 20 e Added expected information in each e To comply with Instructional ICM Sw section standard 111 Version Date 03 29 15 System Admin Manual SnapValet Version 2 0 Table of Contents VERSION HI TORA aa aid oa ag 200 oa aud a sau ca aa 111 TABLE OF CONTENTS 0000 dd IV TABLE O TAB E O dactilar r ach datate ad ac ee datata c t ue d 3 aaa aa aaae V TABLE OF FIGURES Zirne za ataca ag aaa Data ia ia VI 1 MT ri e is 1 1 1 System OYES Wistusisida a pai lie Bs daia a abel nts Rats Seis Burke 1 1 2 System Requirements ceci a a dat 30 E a a cnet antes 1 2 Deployment Instructions eee ana na en nana eee Error Bookmark not defined 2 1 Get Started on Local Machine o 00 eee nenea eee eee en ne Error Bookmark not defined 2 2 Cloud Deployments css ase cca pacea e aaa ue op aaa aa aa e da de ba Error Bookmark
4. ame 5 Version Date 03 29 15
5. e use the mysql command line under You can use this to connect to your database in Configuration Find the create sql script in the source code under design gt database folder Remove the first two lines in the script and add use Database name you copied previously Push this script to the cloud DB by running mysql command code lt databasel sql You re DONE check if the application is running smoothly by clicking on the domain name of your app 2 Version Date 03 29 15 System Admin Manual SnapValet Version 2 0 3 Database Schema create database snapvalet use snapvalet create table valet_company valet_company_ID int 32 primary key auto_increment user_name varchar 255 not null unique user_password varchar 255 not null valet_company_name varchar 255 not null unique pl create table valet valet_ID int 32 primary key auto_increment user_name varchar 255 unique user_password varchar 255 valet_name varchar 255 valet_state tinyint 8 not null Es valet_company_ID int 32 not null foreign key valet_company_ID references valet_company valet_company_ID alter table valet auto_increment 10000001 make auto increment start from 10 000 001 create table customer customer_ID int 32 primary key auto_increment user_name varchar 255 not null unique user_password varchar 255 not null customer_name varchar 255 not null Other information needed for payment eer
6. n valet_ID int 32 not null location_ID varchar 32 not null timestamp datetime not null only work with MySQL valet_fee float not null foreign key valet_ID references valet valet_ID foreign key location_ID references location location_ID primary key valet_ID location_ID timestamp gt create table valet_company_located_in valet_company_ID int 32 not null location_ID varchar 32 not null timestamp datetime not null only work with MySQL foreign key valet_company_ID references valet_company valet_company_ID foreign key location_ID references location location_ID primary key valet_company_ID location_ID timestamp 4 Version Date 03 29 15 System Admin Manual SnapValet Version 2 0 4 Transaction Summary Instructions 4 1 Transaction Query Per Mona s request Transaction Query SQL statements will take the aggregate total of fee tips for each valet company for a particular week Parameter to change is the TimeDate values ie 2015 04 06 AND 2015 04 11 to view aggregate totals for different weeks Transaction Query is SELECT valet_company valet_company_name SUM valet_request tips valet_request valet_fee FROM snapvalet valet_company snapvalet valet_request WHERE valet_request timestamp BETWEEN 2015 04 06 AND 2015 04 11 AND valet_request valet_company_ID valet_company valet_company_ID AND valet_request valet_request_status 3 GROUP BY valet_company_n
7. not defined 3 Database Schemas iii Error Bookmark not defined 4 Transaction Summary Instr ctio s susi een area iss 5 iv Version Date 03 29 15 System Admin Manual Version 2 0 Table of Tables No table of figures entries found v Version Date 03 29 15 System Admin Manual Version 2 0 Table of Figures No table of figures entries found vi Version Date 03 29 15 System Admin Manual SnapValet Version 2 0 1 Introduction 1 1 System Overview lt lt State the brief purpose of the system to which this manual applies Please note that if your project does not need a user manual but a system administrator s manual you can tailor this template to fit your project On the other hand if you need both End user s manual and System administrators manual please separate into two documents gt gt 1 2 System Requirements lt lt Describe the minimum hardware and software Operating System etc requirements for the system gt gt 1 2 1 Hardware Requirements Hardware requirements are Android Smart phone Customer and Valet PC Laptop Valet Company 1 2 2 Software Requirements Android Operating System Modern browser with JavaScript enabled 1 2 3 Other Requirements Credit Card 1 Version Date 03 29 15 System Admin Manual SnapValet Version 2 0 2 Deployment Instructions N mb O SA DOE ID N PS Get Started on Local Machine Install Play Framework Install Eclipse Luna
Download Pdf Manuals
Related Search