1. populate the SQL database
2. Use pg tools to modify server.js to query the database via endpoints
3. Then connect to the current forms and tabular display

• Creating database tables
• node endpoints
• front end

with pair programming with Maten and Berkeli

Home page currently empty - need to show some highlevel information e.g. total number of schools and students across the foundation. This is info that will be seen by everyone so need to check with the foundation that they are happy with this. Ask Clementine for email of NGO to check with this.

• add credentials for Heroku and share with rest of group

Show fields required with asterisk
School form -> responsible person should be a dropdown of available people.
Add validation

As an admin, I should be able to create new initiatives

AS a Admin
I WANT TO be able to add a school
SO THAT I can have the rest of information

ACCEPTANCE CRITERIA:

1. country (free text)
2. location (free text)
3. school name (free text)
4. responsible name (free text)
5. when deployed (data?)
6. status (autonomous, unknown, other, year 1, year 2)

GIVEN: I am adding a school
WHEN: the school is added
THEN: I can see information about that school

IMPLEMENTATION NOTES

1. Set up the database, create a table for the data
2. Add chakra-ui,
3. Formik
4. PostgreSQL
5. Create the form
6. Create API to send data to backend

CHECKLIST:

• I have defined the user story
• I have defined some acceptance criteria
• I have included any implementation notes
• I have included all relevant links

User information from auth0 should be synchronised with PSQL table 'person', so the information can be used for lookup fields on other tables

Set up the BE and FE environments in the repo so everyone can start working on it.

AS A developer
I WANT the repo to have the basic setups completed
SO THAT I can work on features that depend on basic setup

ACCEPTANCE CRITERIA / Business Rules:

• Setup Prisma for backend

• Setup folder structure for backend

• Ensure the api is running correctly and connects to DB

• Create DB migrations to create tables

• Add Chakra UI to FE

• Add Formik to FE

• Add FE layouts so that everything is standardized

• Ensure FE runs correctly

• Add env variables template for FE and BE

Story

As a user
I Want to be able to visualise the data that has been entered

So That I can see how the overall data relates to each other.

For users' familarisation, the webpage forms need to show some similarity to Breteau Foundation's current spreadsheet view.

Also the user needs to see how Breteau Foundation's schools are progressing on a monthly, quarterly and yearly basis.

The type of data that currently is being viewed consists of information such as Country, School Name, where the school is located, the status of how the school is being run, number of students, number of tablets used by students, number of tablets used by teachers, etc.

Acceptance Criteria

1. Need a Front End HTML/CSS application to view the data
2. The Front End would need to be able to access the information from a SQL Database.

Implementation Notes

1. PostgreSQL
2. REST API as the link between the Front-End and Back-End

Checklist:

• I have defined the user story
• I have defined some acceptance criteria
• I have included any implementation notes
• I have included all relevant links

Configure Heroku to deploy PRs to QA environment and master to main environment.

AS A Developer
I WANT to run a QA environment on heroku
SO THAT changes on my branch can be tested in a live environment

ACCEPTANCE CRITERIA / Business Rules:

• When a PR is opened against the master branch, CI should deploy the app from the branch to qa evnironment
• Run tests and linting
• Server folder should deploy to Heroku
• Client folder should deploy to Netlify

As an admin, I should be able to:

• edit existing users
• block users
• request password reset

Create a GitHub action so PRs are built and tests are ran before deploying to Heroku. When PR is merged into master, deploy code to Heroku master environment.

Replace text "Breteau" with company logo that leads to the home page

add light/dark mode options

Add prisma schema to the backend so devs can start working with backend and database

ACCEPTANCE CRITERIA / Business Rules:

Add schema based on Prismaliser model

As an admin/country manager I would like to see the list of intiiatives

Add possibility to delete/edit initiatives

Add information about surveys related to initiatives

As a user, I should only have access to the pages and components that my role allows.

Add edit/delete functionality to schedule tracker

AS A SuperAdmin
I WANT to create user accounts
SO THAT they can access the platform with correct role

Implement auth0 so they can create a user that can,

ACCEPTANCE CRITERIA / Business Rules:

• Name + Surname: Text only
• Email: validate email
• Country ? this is not confirmed yet
• Role: SuperAdmin, Admin, Country Manager
• Status: Active | Inactive
• createdAt | updatedAt

GIVEN: I am creating a new user
WHENN: the email address is valid
THEN: new user is created in auth0 and assigned the correct role