View Code? Open in Web Editor
NEW
Backend for a speedrun.com clone
speedruns.backend's Introduction
This repository contains the backend for a minimal speedrun.com clone. This is a fun project to further learn C#/.NET and build upon those skills.
The backend will consist primarily of C#/ASP.NET following the repository pattern.
- ASP.NET (web API framework)
- Entity Framework (ORM)
- PostgreSQL (relational database)
- xUnit (unit testing framework)
- NSubstitute (mocking library)
- Auth0 (OAuth)
- User (1 to many w/ Runs) - UserName, ImageUrl, YoutubeLink, TwitchLink, Runs
- Game (1 to many w/ Runs) - Name, ImageUrl, ReleaseYear, Series, Players, RunsPublished, Runs
- Run (1 to many w/ User, Game, Console and Comment) - Date, Console, User, Game, Comment, Time
- Comment (1 to many w/ Runs) - Date, Text, Run, User
- Console (1 to many w/ Runs, many to many with Game) - Name
- GameConsole (junction table for Game and Console) - Game, Console
- Series (1 to many w/ Games) - Name, Players
![image](https://private-user-images.githubusercontent.com/86242483/279214375-3c0ef3a1-30cd-4831-8a0e-f5f3fc344635.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM0MjYyNzQsIm5iZiI6MTcyMzQyNTk3NCwicGF0aCI6Ii84NjI0MjQ4My8yNzkyMTQzNzUtM2MwZWYzYTEtMzBjZC00ODMxLThhMGUtZjVmM2ZjMzQ0NjM1LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MTIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODEyVDAxMjYxNFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWI4NTdmYWYxOWRjNTYyYjkyYmQxNWRlYmMwM2VhMTczYmI1ZGQyMjVhODg4NjFiMzk0YTBiNDM0ZTFmNmQyMjMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.GCel_yXDRh8_HPBAWKMwr5yzK8MuR2auZUFOSdMHIEo)
speedruns.backend's People
Contributors
Watchers