joaorodriguesgithub / onboardbackend

Backend code for Onboard web application that was developed on Distributing Computing class at @IPCA.

OnboardBackend

Backend code for Onboard web application that was developed on Distributing Computing class @IPCA.

onboardbackend's Issues

doSignin Request

• Test 2 - Recieve token when authenticating
• Test 3 - Wrong authentication attempt with wrong password
• Test 4 - Wrong authentication attempt with wrong user

Deployment of our backend API on Heroku

• Creating Heroku account
• Link github repository on heroku account

deleteTransaction Request

• Test 6 - Remove transaction
• Test 7 - Access transaction from another user

updateUser Request

• Test 6 - Update user
• Test 9 - Restrict edition of another user

updateTransaction Request

• Test 5 - Update transaction

Transactions battery tests

• Test 1 - List only user transactions
• Test 2 - Insert user transactions
  Test 3 - Validation of transaction creation
• Test 3.1 - Insert transaction without Date
• Test 3.2 - Insert transaction without Category
• Test 3.3 - Insert transaction without Amount
• Test 4 - List user transactions by transaction id
• Test 5 - Update transaction
• Test 6 - Remove transaction
• Test 7 - Access transaction from another user
• Test 8 - Transaction ammount must be positive

doSignup Request

• Test 1 - Create user with signup

getUser Request

• Test 1 - List all users
• Test 8 - Restrict the access from another user

Creating the API server

Create DataBase

Create DataBase onBoard in ProstGres.

• Creating Companies table with id(PK) and companyName fields
• Creating Roles table with id(PK) and roleName fields
• Creating Categories table with id(PK) and categoryName
• Creating Users table with id(PK), company_id (FK), name, email, password, role_id fields
• Creating Transactions table with id(PK), user_id(FK), date, category_id, amount fields

getUserTransactions Request

• Test 1 - List only user transactions
• Test 4 - List user transactions by transaction id
• Test 7 - Access transaction from another user

createTransaction Request

• Test 2 - Insert user transactions
  Test 3 - Validation of transaction creation:
• Test 3.1 - Insert transaction without Date
• Test 3.2 - Insert transaction without Category
• Test 3.3 - Insert transaction without Amount
• Test 8 - Transaction ammount must be positive

Auth battery tests

• Test 1 - Create user with signup
• Test 2 - Recieve token when authenticating
• Test 3 - Wrong authentication attempt with wrong password
• Test 4 - Wrong authentication attempt with wrong user
• Test 5 - Access to protected routes

createUser Request

• Test 2 - Insert Users
• Test 3.1 - Insert user without company
• Test 3.2 - Insert user without name
• Test 3.3 - Insert user without email
• Test 3.4 - Insert user without password
• Test 3.5 - Insert user without role
• Test 5 - Insert duplicated users
• Test 11- Insert an user without the role permitions

Creating seeds for database

• Seeds for companies
• Seeds for roles
• Seeds for Categories
• Seeds for Users
• Seeds for Transactions

deleteUser Request

• Test 7 - Delete user
• Test 10 - Restrict deletion of another user
• Test 13 - Restrict delete permitions for roles

Users battery tests

• Test 1 - List all users
• Test 2 - Insert users
• Test 3 - Insert user without company
• Test 4 - Insert user without name
• Test 5 - Insert user without email
• Test 6 - Insert user without password
• Test 7 - Insert user without role
• Test 8 - Save encryped password
• Test 9 - Insert duplicated users
• Test 10 - Update user
• Test 11 - Delete user
• Test 12 - Restrict the access from another user
• Test 13 - Restrict edition of another user
• Test 14 - Restrict deletion of another user
• Test 15 - Insert an user with the right role_id permitions
• Test 16 - Insert an user without the role permitions
• Test 17 - Restrict delete permitions for roles