|| HFSApi ||
___________________________
Daniel Schaaf Mike Manchee Joseph Niles Jeffery Dinsmore
Initiated 11/05/2020.
Project Docs · Report Bug · Request Feature
An API that functions as a statistical database for a Historical Fantasy Sports Simulator.It has data of about 6 seasons of American Football from the years 1999 - 2004. It utilizes RESTful principles, enables Cors, Pagination, and has integrated authentication to keep the API Read-Only for all users except administrators. It also utilizes Pagination The user is able to see the in-use version of the API when using Postman.
- There are no known bugs at this time.
- Visual Studio Code
- C#
- ASP.NET Core MVC
- MySQL 8.0.20
- Entity Framework Core 2.2.6
- Swagger - NSwag 13.3.0
- Postman
- On macOS Mojave or later
- Click here to download the .NET Core SDK from Microsoft Corp for macOS.
- On Windows 10 x64 or later
- Click here to download the 64-bit .NET Core SDK from Microsoft Corp for Windows.
Enter the command dotnet tool install -g dotnet-script in Terminal for macOS or PowerShell for Windows.
Download and install the appropriate version of MySQL Workbench.
(Optional) Download and install Postman.
To view or edit the code, you will need an code editor or text editor. The popular open-source choices for an code editor are Atom and VisualStudio Code.
- Code Editor Download:
- Option 1: Atom
- Option 2: VisualStudio Code
- Click the download most applicable to your OS and system.
- Wait for download to complete, then install -- Windows will run the setup exe and macOS will drag and drop into applications.
- Optionally, create a GitHub Account
- Navigate to the HFSapi Repository here.
- Click 'Clone or download' to reveal the HTTPS url ending with .git and the 'Download ZIP' option.
- Open up your system Terminal or GitBash, navigate to your desktop with the command:
cd Desktop, or whichever location suits you best. - Clone the repository to your desktop:
$ git clone https://github.com/mmanchee/HFSapi.git - Run the command
cd HFSapito enter into the project directory. - View or Edit:
- Code Editor - Run the command
atom .orcode .to open the project in Atom or VisualStudio Code respectively for review and editing. - Text Editor - Open by double clicking on any of the files to open in a text editor.
- Code Editor - Run the command
- Navigate to the HFSapi Repository here.
- Click 'Clone or download' to reveal the HTTPS url ending with .git and the 'Download ZIP' option.
- Click 'Download ZIP' and unextract.
- Open by double clicking on any of the files to open in a text editor.
- Create a new file in the HFSapi/HFSapi directory named
appsettings.json - Add in the following code snippet to the new appsettings.json file:
{
"Logging": {
"LogLevel": {
"Default": "Warning"
}
},
"AllowedHosts": "*",
"ConnectionStrings": {
"DefaultConnection": "Server=localhost;Port=3306;database=hfsapi;uid=root;pwd=YourPassword;"
}
}
- Change the server, port, and user id as necessary. Replace 'YourPassword' with relevant MySQL password (set at installation of MySQL).
- Navigate to HFSapi/HFSapi directory using the MacOS Terminal or Windows Powershell (e.g.
cd Desktop/HFSapi/HFSapi). - Run the command
dotnet ef database updateto generate the database through Entity Framework Core. - (Optional) To update the database with any changes to the code, run the command
dotnet ef migrations add <MigrationsName>which will use Entity Framework Core's code-first principle to generate a database update. After, run the previous commanddotnet ef database updateto update the database.
- Navigate to HFSapi/HFSapi directory using the MacOS Terminal or Windows Powershell (e.g.
cd Desktop/HFSApi/HFSapi). - Run the command
dotnet runto have access to the API in Postman or browser.
Explore the API endpoints in Postman or a browser. You will not be able to utilize authentication in a browser.
To explore the Historical Football Stats api with NSwag, launch the project using dotnet run with the Terminal or Powershell, and input the following URL into your browser: http://localhost:5000/swagger/index.html
In order to be authorized to use the POST, PUT, DELETE functionality of the API, please authenticate yourself through Postman.
- Open Postman and create a POST request using the URL:
http://localhost:5000/api/users/authenticate - Add the following query to the request as raw data in the Body tab:
{
"UserName": "test",
"Password": "test"
}
- The token will be generated in the response. Copy and paste it as the Token parameter in the Authorization tab.
CORS is a W3C standard that allows a server to relax the same-origin policy. It is not a security feature, CORS relaxes security. It allows a server to explicitly allow some cross-origin requests while rejecting others. An API is not safer by allowing CORS. For more information or to see how CORS functions, see the Microsoft documentation.
https://localhost:5000/api/games/
To use default, don't include limit and start or set them equal to zero.
Base URL: https://localhost:5000
GAMES
GET /api/Games
GET /api/Games/{id}
GET /api/Games/search
GET /api/Games/GetGame
PLAYERS
GET /api/players
GET /api/Players{id}
GET /api/Players/search
USERS
POST /Users/authenticate
Get/Users
https://localhost:5000/api/Games/2
{
"data": {
"gameId": 99,
"season": 1999,
"week": 8,
"playerId": 4,
"team": "NOR",
"passYards": 0,
"recYards": 32,
"rushYards": 2,
"interceptions": 0,
"fumbles": 0,
"receptions": 2,
"passTDs": 0,
"rushTDs": 0,
"recTDs": 0
},
"succeeded": true,
"errors": null,
"message": ""
}
..........................................................................................
..........................................................................................
If you have any feedback or concerns, please contact one of the contributors.
This project is licensed under the MIT License. Copyright (C) 2020 Daniel Schaaf and William Donovan-Seid. All Rights Reserved.
MIT License
Copyright (c) 2020 **_Daniel Schaaf, Mike Manchee, Joseph Niles and Jeffery Dinsmore_**
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.
All weekly Statistics were taken from FantasyFootballDataPros
"A school for tech careers... to help people learn the skills they need to get great jobs."
"...The Internet is becoming the town square for the global village of tomorrow..."
- Bill Gates
Return to Top