📚 Biblioteka - Online Bookstore API

A comprehensive REST API for managing an online bookstore with advanced search capabilities

🚀 Quick Start • 📖 API Documentation • 🧪 Testing • 🔧 Configuration

---

✨ Features

📖 Book Management ✅ Full CRUD operations ✅ ISBN-based lookups ✅ Stock quantity tracking ✅ Price and publication management ✅ Multi-language support 👨‍💼 Author Management ✅ Author profiles with biographies ✅ Birth date tracking ✅ Book count statistics ✅ Name-based search

🏷️ Genre Management ✅ Genre categorization ✅ Popularity rankings ✅ Description management ✅ Book count per genre 🔍 Advanced Search ✅ Multi-criteria filtering ✅ Price range queries ✅ Date-based filtering ✅ Stock availability checks

🛠️ Technology Stack

Technology	Version	Purpose
	24	Core Language
	3.5.6	Framework
	Latest	Data Access
	Latest	Development DB
	8.0+	Production DB
	8.14.3	Build Tool

🚀 Quick Start

📋 Prerequisites

☑️ Java 24 or higher
☑️ Gradle (included via wrapper)
☑️ Your favorite API testing tool (Postman, curl, etc.)

🏃‍♂️ Running the Application

🔧 Development Setup

# 1️⃣ Clone the repository
git clone <repository-url>
cd Biblioteka

# 2️⃣ Build the project
./gradlew build

# 3️⃣ Run the application
./gradlew bootRun

🎉 Application will start on http://localhost:8080

🗄️ Database Access

🔧 Development (H2) http://localhost:8080/h2-console JDBC URL: jdbc:h2:mem:bookstore Username: sa | Password: password

---

📖 API Documentation

🌟 Base URL: http://localhost:8080/api

📚 Books API

📖 Core Operations

Method	Endpoint	Description	Status
GET	/books	Get all books	✅
GET	/books/{id}	Get book by ID	✅
GET	/books/isbn/{isbn}	Get book by ISBN	✅
POST	/books	Create new book	✅
PUT	/books/{id}	Update book	✅
PATCH	/books/{id}/stock?quantity={qty}	Update stock	✅
DELETE	/books/{id}	Delete book	✅

🔍 Search & Filtering

Method	Endpoint	Description	Status
GET	/books/search/title?title={title}	Search by title	✅
GET	/books/search/author?author={author}	Search by author	✅
GET	/books/search/genre?genre={genre}	Search by genre	✅
GET	/books/search/publisher?publisher={pub}	Search by publisher	✅
GET	/books/search?title={}&author={}...	Advanced multi-search	✅
GET	/books/price-range?minPrice={}&maxPrice={}	Price range filter	✅
GET	/books/published-after?date={yyyy-mm-dd}	Date filter	✅
GET	/books/in-stock	Available books	✅
GET	/books/language/{language}	Books by language	✅
GET	/books/recent	Recently added	✅
GET	/books/low-stock?threshold={num}	Low stock alert	✅

👨‍💼 Authors API

👤 Author Management

Method	Endpoint	Description	Status
GET	/authors	Get all authors	✅
GET	/authors/{id}	Get author by ID	✅
POST	/authors	Create new author	✅
PUT	/authors/{id}	Update author	✅
DELETE	/authors/{id}	Delete author	✅
GET	/authors/search?name={name}	Search by name	✅
GET	/authors/search/firstname?firstName={name}	Search by first name	✅
GET	/authors/search/lastname?lastName={name}	Search by last name	✅
GET	/authors/with-books	Authors with books	✅
GET	/authors/{id}/book-count	Author statistics	✅

🏷️ Genres API

📂 Genre Management

Method	Endpoint	Description	Status
GET	/genres	Get all genres	✅
GET	/genres/{id}	Get genre by ID	✅
GET	/genres/name/{name}	Get genre by name	✅
POST	/genres	Create new genre	✅
PUT	/genres/{id}	Update genre	✅
DELETE	/genres/{id}	Delete genre	✅
GET	/genres/search?name={name}	Search genres	✅
GET	/genres/with-books	Genres with books	✅
GET	/genres/popular	Popular genres	✅
GET	/genres/{id}/book-count	Genre statistics	✅

---

🧪 Testing

🚀 Quick Test Commands

📚 Book Operations

# Create a book
curl -X POST http://localhost:8080/api/books \
  -H "Content-Type: application/json" \
  -d '{
    "title": "The Great Gatsby",
    "isbn": "9780743273565",
    "description": "A classic American novel",
    "publicationDate": "1925-04-10",
    "price": 12.99,
    "stockQuantity": 100,
    "publisher": "Scribner",
    "pageCount": 180,
    "language": "English"
  }'

# Search books by title
curl "http://localhost:8080/api/books/search/title?title=Gatsby"

# Get books in price range
curl "http://localhost:8080/api/books/price-range?minPrice=10&maxPrice=15"

👨‍💼 Author Operations

# Create an author
curl -X POST http://localhost:8080/api/authors \
  -H "Content-Type: application/json" \
  -d '{
    "firstName": "Ernest",
    "lastName": "Hemingway",
    "birthDate": "1899-07-21",
    "biography": "American novelist and journalist"
  }'

# Search authors
curl "http://localhost:8080/api/authors/search?name=Hemingway"

🏷️ Genre Operations

# Create a genre
curl -X POST http://localhost:8080/api/genres \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Biography",
    "description": "Non-fiction books about people'\''s lives"
  }'

# Get popular genres
curl "http://localhost:8080/api/genres/popular"

🎯 Automated Testing

Run the comprehensive test script:

chmod +x api-test-examples.sh
./api-test-examples.sh

---

🔧 Configuration

🏠 Development Environment

🗄️ Database: H2 In-Memory 🌐 Port: 8080 🔍 H2 Console: /h2-console 📊 Logging: DEBUG level

🔧 Auto-reload: Enabled 📝 DDL: create-drop 🔍 SQL Logging: Enabled ⚡ Performance: Development optimized

🚀 Production Setup

🐬 MySQL Configuration

Update application.properties:

# MySQL Production Configuration
spring.datasource.url=jdbc:mysql://localhost:3306/bookstore?useSSL=false&serverTimezone=UTC
spring.datasource.username=your_username
spring.datasource.password=your_password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
spring.jpa.hibernate.ddl-auto=validate

---

🛡️ Error Handling

Status Code	Description	Example
	Successful GET requests	Data retrieved
	Successful POST requests	Resource created
	Successful DELETE requests	Resource deleted
	Validation errors	Invalid input data
	Resource not found	Book ID doesn't exist
	Resource already exists	Duplicate ISBN
	Internal server error	Database connection issue

---

🏗️ Building & Deployment

📦 Local Development

# Build the project
./gradlew build

# Run tests
./gradlew test

# Start application
./gradlew bootRun

🚀 Production Build

# Create production JAR
./gradlew build

# Run production build
java -jar build/libs/Biblioteka-0.0.1-SNAPSHOT.jar

---

📊 Project Statistics

Metric	Count	Status
📚 API Endpoints	32+	✅ Fully Tested
🔍 Search Methods	15+	✅ Working
🛡️ Validation Rules	20+	✅ Active
📝 Entity Classes	3	✅ Complete
🔧 Service Methods	50+	✅ Implemented

---

🤝 Contributing

Found a bug? Report it
Have an idea? Suggest a feature
Want to contribute? Fork the repo

---

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

---

_{Built with ❤️ using Spring Boot | © 2025 Biblioteka}