tomchv / csc-0847 Goto Github PK

• Write endpoints
• Write tests with Postman

• Deploy a local mysql database to work locally.

• Create function to execute vision API and set label on image for animals, flowers, people, and others.

• Command entrypoint using Cobra
• Configure host, port and mode
• Configure logger
• Run server with given configuration

Create a backend client using Axios to communicate from the frontend to the backend.

• Class Client.
• Retrieve configuration from env.
• Create methods to call backend.

• Write a Dockerfile to transform backend into a container
• Write docker-compose to run backend and database locally as in production.

• Create List component
• Create Student component
• Store student data in a state
• Display student data

• Create MySQL, client
• Retrieve configuration to the database from the environment
• Expose client connection
• Test

Create a simple Typescript React using Material UI to produce a cool UI.

Design requirement

• The homepage shall display the list of all students stored in the database
• A button may trigger a form to create a new student
• A search bar should be used to search by name, last name or student_id

Design

A Mockup may be created to create a good UX using Figma

• Setup Google project
• Setup Google Artifact Registry
• Setup IAM for GH runner
• Push image to GAR from Github action

• Create User model structure
• Define CRUD DTO and outputs
• Add CRUD methods
• Write tests

• Create field form component.
• Create Form pop up.
• Create Form trigger button.
• Creat confirmation button.
• Send data to the backend on click
• Display error message if there's

• Use Action from #11 to deploy the frontend
• Use Action from #11 to deploy the backend

• Dockerfile build correctly on amd64 and arm64.
• Make sure GoCode is well written with linter.
• Postman tests are successful. (Solved by #21)
• Deploy backend image on push on main when the backend is updated.

• Create React App.
• Create Dockerfile to containerize the application.
• Setup GitHub action to verify the correct build.

• Create frontend Dockerfile
• Test build in CI
• Build and push to Gcloud Registry on push on main

• Code HTTP resolver
• Link resolver to backed
• Test it

• Create simple API to interact with Google Object storage and manage images
• Create CRUD functions
• Prepare deployment

• Create Cloud SQL database.
• Setup access to the database for local and production.

• Create a search bar component with 3 properties:
  • student _id
  • name
  • firstname
• Filter users and update list in real-time.

Create a simple Golang app using Gin-Gonic and Ent to handle the database.

API

Healtcheck

The API shall have a simple /healthcheck that returns status code 200 to
make sure the API is alive.

💡 Optional: Add Prometheus endpoint for monitoring

Users

The API shall have 4 routes to manage users

• /users with GET to retrieve all users listed.
• /users/:id with GET to retrieve a user by its ID.
• /users with POST to create a new user.
• /users/id with PUT to update a user.
• /users/id with DELETE to delete a user.

Database

The application shall manage students with the following data:

• student_id (unique)
• firstname
• lastname
• email (unique, email pattern)
• mailing_address (address)
• gpa (numeric, 0 < gpa < 4)