/challenge-06-database-queries

Database Queries with NodeJS

Primary LanguageTypeScript

Challenge: 06 - Database Queries 🚀

About the challenge 📌

Test Specification 🔥

  • [UsersRepository] should be able to find user with games list by user's ID
  • [UsersRepository] should be able to list users ordered by first name
  • [UsersRepository] should be able to find user by full name
  • [GamesRepository] should be able find a game by entire or partial given title
  • [GamesRepository] should be able to get the total count of games
  • [GamesRepository] should be able to list users who have given game id

Challenge Details 🔥

In this challenge, you will perform database queries with TypeORM in three ways:

  • Using ORM
  • Using Query Builder
  • Using Raw Query

Necessary Commands to install dependencies 📌


npm install --global yarn

yarn


Command to run teh application

# development
$ yarn dev

Command to test the application

# unit tests
$ yarn test