Node.js backend api development task

Job ID: 35243081

Budget: $40 – $50 USD

Skill Requirments

• Node.js
• You know how to write database migration code
• You know how to write unit tests
• WebSocket on Node.js



Task Details:

We have a node.js project, it has 1 table and 3 APIs ( for CURD on the table ).
Now we want to modify this project, to fix some issues and add new api.

The issues list
- Code format refactor, fix space, indent issues.
- Add database migration code for 1 table
- Add daily log, use middleware to save daily log of api input/output
- Add .env, the previous code write some security info as plain text in code, such as db password, we want to use .env
- Use middleware to check apikey on each api call.
- Sql inject fix, modify the sql string code, use esacpe() to prevent sql injection.
- Add unit tests for these 3 APIs

- File type changes, discuss in chat.
- Add one WebSocket api, discuss in chat.

This is a long term project, after this task done we will have new features.