Drivers & Rides

This project provides a GraphQL API that manipulates data from Drivers and Rides. The project was divided into 2 modules:

Back end: creates a server to provide API with GraphQL + Prisma

Front end: creates a simple client to access the backend with Apollo Client + React JS

Documentation

type Drivers {
  id: ID!
  name: String!
  age: Int!
  dateCreation: Date!
  rides: [Rides]
}

rides: is the relation to the Rides created by Prisma

type Rides {
  id: Int!
  from: String!
  to: String!
  driverId: Int!
  driver: Drivers
  value: Float!
}

driverId: is a Foreign Key to Drivers

drivers: [Drivers!]!

rides: [Rides!]

createDriver(
  name: String!
  age: Int!
): Drivers

createRide(
  driver: Int!
  from: String!
  to: String!
  value: Float!
): Rides

updateRide(
  id: Int!
  driver: Int!
  from: String!
  to: String!
  value: Float!
): Rides

deleteDriver(
  id: Int!
): Boolean!

deleteRide(
  id: Int!
): Boolean!

Boolean mutations returns true if the query it's sucefully executed otherwise false.

1 - set your database on backend/prisma/.env

postgresql://USER:PASSWORD@HOST:PORT/DATABASE

2 - install dependencies and run.

[Automatic]: at the root of the project and run

chmod +x backend.sh frontend.sh

./backend.sh

./frontend.sh

[Manually]: at the root of the project and run this code:*

cd backend && yarn && npx prisma migration up --experimental && yarn dev

starts back end!

cd frontend && yarn && yarn start

starts front end!

npx prisma studio --experimental

The prisma uses GraphQL and creates the same interface used to access an API, to create an interface to access the database.

http://localhost:5555 prisma studio if you want to interact directly with the database

http://localhost:4000 standard GraphQL API interface

Details