Speedrun Sunday - making CRUD app using knex - postgres

🔥CRUD API🔥 This speed run completed after 3 hrs 31 min

API

Sign in

Post name and password. http://localhost:4200/api/v1/users/signin

Sign up

Post name and password. http://localhost:4200/api/v1/users/signup

Update profile

Put new name and new password, require old password. http://localhost:4200/api/v1/users/:id

{
	"name": Name,
	"password": Current_password,
	"newpassword": New_password
}

Delete

Delete require user password. http://localhost:4200/api/v1/users/:id

Get all / one

http://localhost:4200/api/v1/users http://localhost:4200/api/v1/users/:id

# Error such "error: role "admin" does not exist"
$ psql
    psql# CREATE DATABASE <databasename>
# Startup docker
 $ docker-compose up
# Short form to rollback,migrate,and start app.
 $ npm run serve

• Make docker-compose file
• Make knexfile.js
• Test the docker and working
• Make and test a get message for express in src file
• Make table in db migrate file
• Pass data from db via api
• Make table for db seed file
• Make a get for migrate db
• Make a post for migrate db
• Make a update for migrate db
• Make a delete for migrate db