Build Restful CRUD API for a blog using Spring Boot, Mysql, JPA and Hibernate.
1. Clone the application
git clone https://github.com/coma123/Spring-Boot-Blog-REST-API.git2. Create Mysql database
create database blogapi- run
src/main/resources/blogapi.sql
3. Change mysql username and password as per your installation
- open
src/main/resources/application.properties - change
spring.datasource.usernameandspring.datasource.passwordas per your mysql installation
4. Run the app using maven
mvn spring-boot:runThe app will start running at http://localhost:8080
The app defines following CRUD APIs.
| Method | Url | Decription | Sample Valid Request Body |
|---|---|---|---|
| POST | /api/auth/signup | Sign up | JSON |
| POST | /api/auth/signin | Log in | JSON |
| Method | Url | Description | Sample Valid Request Body |
|---|---|---|---|
| GET | /api/users/me | Get logged in userEntity profile | |
| GET | /api/users/{username}/profile | Get userEntity profile by username | |
| GET | /api/users/{username}/posts | Get posts created by userEntity | |
| GET | /api/users/{username}/albums | Get albums created by userEntity | |
| GET | /api/users/checkUsernameAvailability | Check if username is available to register | |
| GET | /api/users/checkEmailAvailability | Check if email is available to register | |
| POST | /api/users | Add userEntity (Only for admins) | JSON |
| PUT | /api/users/{username} | Update userEntity (If profile belongs to logged in userEntity or logged in userEntity is admin) | JSON |
| DELETE | /api/users/{username} | Delete userEntity (For logged in userEntity or admin) | |
| PUT | /api/users/{username}/giveAdmin | Give admin role to userEntity (only for admins) | |
| PUT | /api/users/{username}/TakeAdmin | Take admin role from userEntity (only for admins) | |
| PUT | /api/users/setOrUpdateInfo | Update userEntity profile (If profile belongs to logged in userEntity or logged in userEntity is admin) | JSON |
| Method | Url | Description | Sample Valid Request Body |
|---|---|---|---|
| GET | /api/posts | Get all posts | |
| GET | /api/posts/{id} | Get post by id | |
| POST | /api/posts | Create new post (By logged in userEntity) | JSON |
| PUT | /api/posts/{id} | Update post (If post belongs to logged in userEntity or logged in userEntity is admin) | JSON |
| DELETE | /api/posts/{id} | Delete post (If post belongs to logged in userEntity or logged in userEntity is admin) |
| Method | Url | Description | Sample Valid Request Body |
|---|---|---|---|
| GET | /api/posts/{postId}/comments | Get all comments which belongs to post with id = postId | |
| GET | /api/posts/{postId}/comments/{id} | Get comment by id if it belongs to post with id = postId | |
| POST | /api/posts/{postId}/comments | Create new comment for post with id = postId (By logged in userEntity) | JSON |
| PUT | /api/posts/{postId}/comments/{id} | Update comment by id if it belongs to post with id = postId (If comment belongs to logged in userEntity or logged in userEntity is admin) | JSON |
| DELETE | /api/posts/{postId}/comments/{id} | Delete comment by id if it belongs to post with id = postId (If comment belongs to logged in userEntity or logged in userEntity is admin) |
| Method | Url | Description | Sample Valid Request Body |
|---|---|---|---|
| GET | /api/albums | Get all albums | |
| GET | /api/albums/{id} | Get album by id | |
| POST | /api/albums | Create new album (By logged in userEntity) | JSON |
| PUT | /api/albums/{id} | Update album (If album belongs to logged in userEntity or logged in userEntity is admin) | JSON |
| DELETE | /api/albums/{id} | Delete album (If album belongs to logged in userEntity or logged in userEntity is admin) | |
| GET | /api/albums/{id}/photos | Get all photos which belongs to album with id = id |
| Method | Url | Description | Sample Valid Request Body |
|---|---|---|---|
| GET | /api/photos | Get all photos | |
| GET | /api/photos/{id} | Get photo by id | |
| POST | /api/photos | Create new photo (By logged in userEntity) | JSON |
| PUT | /api/photos/{id} | Update photo (If photo belongs to logged in userEntity or logged in userEntity is admin) | JSON |
| DELETE | /api/photos/{id} | Delete photo (If photo belongs to logged in userEntity or logged in userEntity is admin) |
| Method | Url | Description | Sample Valid Request Body |
|---|---|---|---|
| GET | /api/todoEntities | Get all todoEntities which belongs to logged in userEntity | |
| GET | /api/todoEntities/{id} | Get todoEntity by id (If todoEntity belongs to logged in userEntity) | |
| POST | /api/todoEntities | Create new todoEntity (By logged in userEntity) | JSON |
| PUT | /api/todoEntities/{id} | Update todoEntity (If todoEntity belongs to logged in userEntity) | JSON |
| DELETE | /api/todoEntities/{id} | Delete todoEntity (If todoEntity belongs to logged in userEntity) | |
| PUT | /api/todoEntities/{id}/complete | Mark todoEntity as complete (If todoEntity belongs to logged in userEntity) | |
| PUT | /api/todoEntities/{id}/unComplete | Mark todoEntity as uncomplete (If todoEntity belongs to logged in userEntity) |
Test them using postman or any other rest client.
{
"firstName": "Leanne",
"lastName": "Graham",
"username": "leanne",
"password": "password",
"email": "leanne.graham@gmail.com"
}{
"usernameOrEmail": "leanne",
"password": "password"
}{
"firstName": "Ervin",
"lastName": "Howell",
"username": "ervin",
"password": "password",
"email": "ervin.howell@gmail.com",
"address": {
"street": "Victor Plains",
"suite": "Suite 879",
"city": "Wisokyburgh",
"zipcode": "90566-7771",
"geo": {
"lat": "-43.9509",
"lng": "-34.4618"
}
},
"phone": "010-692-6593 x09125",
"website": "http://erwinhowell.com",
"company": {
"name": "Deckow-Crist",
"catchPhrase": "Proactive didactic contingency",
"bs": "synergize scalable supply-chains"
}
}{
"firstName": "Ervin",
"lastName": "Howell",
"username": "ervin",
"password": "updatedpassword",
"email": "ervin.howell@gmail.com",
"address": {
"street": "Victor Plains",
"suite": "Suite 879",
"city": "Wisokyburgh",
"zipcode": "90566-7771",
"geo": {
"lat": "-43.9509",
"lng": "-34.4618"
}
},
"phone": "010-692-6593 x09125",
"website": "http://erwinhowell.com",
"company": {
"name": "Deckow-Crist",
"catchPhrase": "Proactive didactic contingency",
"bs": "synergize scalable supply-chains"
}
}{
"street": "Douglas Extension",
"suite": "Suite 847",
"city": "McKenziehaven",
"zipcode": "59590-4157",
"companyName": "Romaguera-Jacobson",
"catchPhrase": "Face to face bifurcated interface",
"bs": "e-enable strategic applications",
"website": "http://ramiro.info",
"phone": "1-463-123-4447",
"lat": "-68.6102",
"lng": "-47.0653"
}{
"title": "sunt aut facere repellat provident occaecati excepturi optio reprehenderit",
"body": "quia et suscipit suscipit recusandae consequuntur expedita et cum reprehenderit molestiae ut ut quas totam nostrum rerum est autem sunt rem eveniet architecto"
}{
"title": "UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED",
"body": "UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED "
}{
"body": "laudantium enim quasi est quidem magnam voluptate ipsam eos tempora quo necessitatibus dolor quam autem quasi reiciendis et nam sapiente accusantium"
}{
"body": "UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED UPDATED "
}{
"title": "quidem molestiae enim"
}{
"title": "quidem molestiae enim UPDATED"
}{
"title": "accusamus beatae ad facilis cum similique qui sunt",
"url": "https://via.placeholder.com/600/92c952",
"thumbnailUrl": "https://via.placeholder.com/150/92c952",
"albumId": 2
}{
"title": "accusamus beatae ad facilis ",
"url": "https://via.placeholder.com/600/771796",
"thumbnailUrl": "https://via.placeholder.com/150/771796",
"albumId": 4
}{
"title": "delectus aut autem",
"completed": false
}{
"title": "delectus aut autem Updated",
"completed": true
}