Roll The Dice

By **Tanvi Garg, Sheila Stephen, Victoria Martinez, Tavish OKeefe, Ryan Leslie, **

Description

Dice description.

Specifications

• Create database to store information, and test database to test information.
• Create table to hold Users name and id.
• Create table to hold restaurant name, id, and User key id.
• Create class, constructor, and properties for Users.
• create class, constructor, and properties for Restaurants.
• Write method to get Users name.
• Write test for get User name method.
• Write method to get User id.
• Write test for get User id.
• Write method to save User name, and assign id.
• Write method to get User name, and id.
• Write test to check that User GetAll method returns an empty list.
• Write test to check that User GetAll method returns inputed new objects.
• Write test to test User save method is operational.
• Write User Equals method so as to separate primary data table and test data table. (Result in stylist GetAll and Save method tests passing).
• Write method to get Restaurant name.
• Write test for get Restaurant name method.
• Write method to get Restaurant id.
• Write test for get Restaurant id.
• Write method to save Restaurant name, and assign id.
• Write method to get Restaurant name, and id.
• Write test to check that Restaurant GetAll method returns an empty list.
• Write test to check that Restaurant GetAll method returns inputed new objects.
• Write test to test Restaurant save method is operational.
• Write Restaurant Equals method so as to separate primary data table and test data table. (Result in Restaurant GetAll and Save method tests passing).
• Write Find method to locate individual Users based on their unique Id's.
• Write test for Find method to assert that input and result AreEqual based on the use of the Find Method using a unique Id.
• Write a method to return a list of the objects (Restaurants), associated with User specified unique Id's.
• Write test for Get Method, and see that it returns an empty array if no User is associated with a particular Restaurant Id.
• Write test for Get Method, and see that it returns User object list associated with Restaurant, based on the Id of Restaurant, and the id_User of User.

Setup/Installation Requirements

• Clone repository to your desktop
• Open in Atom, or text and source code editor of your choosing.
• CREATE Database Dice.
• CREATE TABLE Dice.User ( id INT NOT NULL AUTO_INCREMENT , name VARCHAR(255) NOT NULL , distance INT NOT NULL , price INT NOT NULL , PRIMARY KEY (id)) ENGINE = InnoDB;
• CREATE TABLE Dice.Restaurants ( id INT NOT NULL AUTO_INCREMENT , name VARCHAR(255) NOT NULL , longitude INT NOT NULL , latitude INT NOT NULL , menu VARCHAR(255) NOT NULL , PRIMARY KEY (id)) ENGINE = InnoDB;
• CREATE TABLE Dice.User_Restaurants ( id INT NOT NULL AUTO_INCREMENT , user_id INT NOT NULL , restaurant_id INT NOT NULL , PRIMARY KEY (id)) ENGINE = InnoDB;

Known Bugs

There are no known bugs at this time.

Support and contact details

Tavish OKeefe: okeefe.tavish@gmail.com

Technologies Used

• CSharp
• JavaScript
• PHPMyAdmin

License

Copyright (c) 2018, Tavish O'Keefe

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE._