Book library application.

Rest API with authentication which allows user to manage books with their authors. There are endpoints for create, update, delete, list authors and books. Pagination is implemented. There is a user authentication with a possibility to reset password. App can handle basic database operations using CLI commands.

App was deployed and maintained on AWS cloud EC2 and Elastic Beanstalk and database in RDS.

Table of contents

• Environment
• Technologies
• Documentation: Book Library Api
• 📁 Collection: Authors
• 📁 Collection: Books
• 📁 Collection: Authentication

Environment

Create .env file with:

Variable	Description	Value
SECRET_KEY	Flask secret key
SQLALCHEMY_DATABASE_URI	Database host uri

Technologies

• python
• flask
• jwt
• werkzeug
• marshmallow
• sqlalchemy
• re
• pytest
• AWS EC2
• AWS RDS
• AWS Elastic Beanstalk

Documentation Book Library Api

Backend API for managing authors, books, users etc.

📁 Collection: Authors

End-point: Get All Authors

Get all authors from the database.

Method: GET

{{URL}}/api/v1/authors

Query Params

Param	value
fields	id,first_name
sort	birth_date
first_name	Andrzej
birth_date[gte]	21-06-1960
id[lt]	5
page	3
limit	3

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Create New Author

Add new author to the database.

Method: POST

{{URL}}/api/v1/authors

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Get Single Author

Get single author form the database

Method: GET

{{URL}}/api/v1/authors/10

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Update Author

Update author in database.

Method: PUT

{{URL}}/api/v1/authors/11

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
    "first_name": "Henryk",
    "last_name": "Sienkiewicz",
    "birth_date": "05-05-1846"

}

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Delete Author

Delete author in database.

Method: DELETE

{{URL}}/api/v1/authors/11

Headers

Content-Type	Value
Authorization	Bearer ey...

Query Params

Param	value

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Create New Author Adam Mickiewicz

Method: POST

{{URL}}/api/v1/authors

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{  
    "first_name": "Andrzej",
    "last_name": "Mickiewicz",
    "birth_date": "24-12-2000"
}

Query Params

Param	value
	null

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

📁 Collection Books

End-point: Get All Books

Method: GET

{{URL}}/api/v1/books?fields=id,title,number_of_pages&sort=number_of_pages&number_of_pages[gte]=400

Query Params

Param	value
fields	id,title,number_of_pages
sort	number_of_pages
number_of_pages[gte]	400
id[lt]	5
page	3
limit	3

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Get Single Book

Get Single Book

Method: GET

{{URL}}/api/v1/books/5

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Update Book

Update Book in database

Method: PUT

{{URL}}/api/v1/books/5

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
    "title": "Some book",
    "isbn": 123124,
    "number_of_pages": 723,
    "description": "some description",
    "author_id":10


}

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Delete Book

Delete Book from database

Method: DELETE

{{URL}}/api/v1/books/1

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Get all author books

Get all author books from database.

Method: GET

{{URL}}/api/v1/authors/6/books

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Create New Book

Add a book to the database.

Method: POST

{{URL}}/api/v1/authors/1/books

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
    "title": "New Book",
    "number_of_pages": "478",
    "isbn": 4444444444444,
    "description": "Some description"

}

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

📁 Collection: Authentication

End-point: Get current user

Info about current user

Method: GET

{{URL}}/api/v1/auth/me

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
   "username": "t",
   "password": "123456"

}

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Update user password

Update user password in database

Method: PUT

{{URL}}/api/v1/auth/update/password

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
    "current_password": "123456",
    "new_password": "qwerty"

}

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Register User

Add user to database

Method: POST

{{URL}}/api/v1/auth/register

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
   "username": "next",
   "password": "123456",
   "email": "next@gmail.com"
   

}

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Login User

Logging to database.

Method: POST

{{URL}}/api/v1/auth/login

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
   "username": "next123",
   "password": "qwerty"

}

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃

End-point: Update user data

Updating user name and email

Method: PUT

{{URL}}/api/v1/auth/update/data

Headers

Content-Type	Value
Content-Type	application/json

Body (raw)

{
    "email": "next123@gmail.com",
    "username": "next123"

}

🔑 Authentication bearer

Param	value	Type
token	{{TOKEN}}	string

⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃ ⁃