This is a backend API for managing blog posts. It is built using Node.js and Express framework, with MySQL as the database.

• User authentication: Sign up and sign in functionalities with JWT token generation and verification.
• CRUD operations on blog posts: Create, read, update, and delete blog posts.
• Secure endpoints: JWT token authentication middleware ensures secure access to the API endpoints.

Before running this API, ensure you have the following installed:

• Node.js and npm
• MySQL server

1. Clone this repository:

   git clone https://github.com/SudhanshuAi/Blog_Backend_API

2. Install dependencies:

   npm install

3. Set up MySQL database:

   • Install MySQL server if not already installed.

   • Start MySQL server if it's not running.

   • Access MySQL shell:

     mysql -u root -p

   • Create a MySQL database named blogpost:

     CREATE DATABASE IF NOT EXISTS blogpost;

   • Create tables by running the SQL queries provided in index.js.

   • Update the database configuration in the source code if necessary (host, user, password).

You can configure the following settings in the config.js file:

• JWT_SECRET: Secret key used for JWT token generation and verification.

To run tests, you need to have Mocha and Chai installed globally or as development dependencies in your project:

npm install --save-dev mocha chai

Once installed, you can run the tests with the following command:

mocha test.js

1. Start the server:

   node index.js

• POST /api/v1/signup: User sign up with email and password.
• POST /api/v1/signin: User sign in with email and password.
• POST /api/v1/posts: Create a new blog post (authentication required).
• GET /api/v1/posts/:id: Read a specific blog post.
• PUT /api/v1/posts/:id: Update a specific blog post (authentication required).
• DELETE /api/v1/posts/:id: Delete a specific blog post (authentication required).

• JWT token authentication is used to secure the API endpoints.