BSA 2023 | .NET | LeetWars

Leetwars is a platform that helps you learn, train, and improve your coding skills by solving challenges of many types and difficulty levels. You choose how you would like to learn. Do you want to take on increasingly difficult challenges? Maybe you prefer training through repetition and by improving your solutions. After solving a task, get a special code analysis by AI system. Improve your rank submitting challenges, participating in code battles and don't forget to make new friends!

Technologies:

Backend:

Platform: .NET 6
Network: REST, SignalR, RabbitMQ
Database: MS SQL Server, Entity Framework Core
Cloud: Azure
Other: JWT, Firebase, Docker, OpenAI

Frontend:

Angular
HTML5/CSS3/SASS

Building sources

By default, apps run on the following ports:

Application	Port
LeetWars.Core	5050
LeetWars.Notifier	5070
LeetWars.Emailer	5080
LeetWars.Builder	5090
LeetWars.CodeAnalyzer	5100
RabbitMQ	5672

Tip: If you want to connect to the specific service outside of docker, then use "localhost" as a service name, but if both services are inside docker, use service_name from a "docker-compose" file instead.

DB Schema

erDiagram
    %%Main
    Users{
        id bigint PK
        country int
        timezone int
        sex int
        status int
        birthDate datetime
        firstName nvarchar
        lastName nvarchar
        userName nvarchar
        email nvarchar
        imagePath nvarchar
        totalScore bigint
        registeredAt datetime
        oathToken nvarchar
        isSubscribed boolean
        isBanned boolean
        uid nvarchar
        reputation int
    }
    Users ||--o{ Challenges : authors_of
    Users ||--o{ UserSolutions : authors_of
    Users ||--o{ UsersPreferredLanguages : users
    Users ||--o{ UsersLanguagesLevels : users
    Users ||--o{ Badges : users

    Challenges {
        id bigint PK
        createdBy bigint FK
        title nvarchar
        instructions string
        levelId int FK
        createdAt datetime
        category int
    }
    Challenges ||--o{ ChallengeVersions : challenge_versions
    Challenges ||--o{ ChallengeTags : challenge
    Challenges ||--o{ ChallengeStars : challenge

    ChallengeVersions{
        id bigint PK
        languageId int FK
        challengeId bigint FK
        initialSolution string
        completeSolution string
        status int
        createdAt datetime
        createdBy bigint FK
        prealodedCode nvarchar
        exampleTestCases nvarchar
        testCases nvarchar
    }
    ChallengeVersions ||--o{ ChallengeVersionLanguageVersions : challenge_version
    ChallengeVersions ||--o{ UserSolutions : challenge_version_solutions
    ChallengeVersions ||--o{ Tests : tests

    UserSolutions{
        id bigint PK
        createdBy bigint FK
        challengeVersionId bigint FK
        code string
        output string
        submittedAt nullable_datetime
        createdAt datetime
    }

    Tests{
        id bigint PK
        challengeVersionId bigint FK
        code string
        isPublic bool
        createdAt datetime
        createdBy bigint FK
    }

    Subscriptions{
        id bigint PK
        userId bigint FK
        paymentSubscriptionId nvarchar
        typeId int FK
        cost decimal
        startDate datetime
        endDate datetime
        subscribedDate datetime
        unsubscribedDate nullable_datetime
        isActive boolean
    }
    Subscriptions }o--|| Users : users_subscription

    %%Secondary
    SubscriptionTypes{
        id int PK
        name nvarchar
        description nvarchar
        cost decimal
        billingPeriod int
    }
    SubscriptionTypes ||--o{ Subscriptions : subscription_type

    Tags{
        id int PK
        name nvarchar
    }
    Tags ||--o{ ChallengeTags : tag

    Languages {
        id int PK
        name nvarchar
    }
    Languages ||--o{ ChallengeVersions : version_language
    Languages ||--o{ UsersPreferredLanguages : languages
    Languages ||--o{ UsersLanguagesLevels : languages
    Languages ||--o{ LanguageVersions : language

    LanguageVersions {
        id int PK
        languageId int FK
        version nvarchar
    }
    LanguageVersions ||--o{ ChallengeVersionLanguageVersions : language_version

    ChallengeLevels{
        id int PK
        skilllevel int
        reward int
    }
    ChallengeLevels ||--o{ Challenges : levels

    Badges{
        id int PK
        name nvarchar
        icon nvarchar
        icongif nvarchar
    }

    %%Junction
    ChallengeTags{
        challengeId bigint PK
        tagId int PK
    }

    ChallengeStars{
        id int PK
        challengeId bigint FK
        authorId bigint FK
    }

    UsersLanguagesLevels{
        userId bigint PK
        languageId int PK
        languageLevel int
    }

    UsersPreferredLanguages{
        userId bigint PK
        languageId int PK
    }

    ChallengeVersionLanguageVersions{
        challengeVersionId bigint PK
        languageVersionId bigint PK
    }

Code quality

Make sure you read and follow .NET Quality Criteria. Also, there are some best practices for frontend development: Angular and Typescript

Docker:

Make sure you have Docker and Docker Compose.
Pull this repo to your machine.
You can build all build-in application containers via docker-compose -f docker-compose.code-runners.yml build command.
You can build and run all application containers via docker-compose -f docker-compose.apps.yml up -d command.
You can pull and run all 3rd-party services (MSSQL Server, RabbitMQ) via docker-compose -f docker-compose.services.yml up -d command.
Happy coding! 😎

Setup environment for local development:

Download and install .NET 6 SDK.
It might be useful to have EF CLI. Install via command: dotnet tool install --global dotnet-ef
Download and install LTS version of Node.js
Install Angular-CLI via: npm install -g @angular/cli. What is Angular-CLI?

Extensions for frontend development (required):

ESLint (analysis tool that checks TypeScript\JavaScript code for readability, maintainability, and functionality errors)
EditorConfig (helps maintain consistent coding styles for multiple developers working on the same project)

Some extra extensions which can significantly help to work with Angular:

Angular Language Service (intelliSense for Angular templates)
Angular Snippets
Angular Schematics (working with Angular schematics via UI)

Environment variables

This is a list of the required environment variables:

RabbitMQ

RABBIT_MQ_USERNAME - RabbitMQ username

RABBIT_MQ_PASSWORD - RabbitMQ user password

MSSQL Server

SA_PASSWORD - MSSQL Server "SA" user password

BinaryStudioAcademy/bsa-2023-leetwars