📖 The Matilda Library

Table of Contents

• Description
• Features
• Screenshots
• Technologies
• Installation
• Testing
• Architecture
• Database Model
• Team

Description

The Matilda Library is a console-based Java application designed to manage a digital collection of books, authors, and genres — with a focus on feminist literature. It provides an intuitive terminal interface that allows users to add, edit, search, and organize books while maintaining relationships between books, authors, and genres. The application was developed in Java 21 with an MVC architecture and connection to a PostgreSQL database, which will allow the library administrator to perform basic book management operations (CRUD): add, list, update, delete and search for books by title, author or genre.

Features

• Book Management — Add, update, delete, and list books.
• Author Management — Register and manage authors.
• Genre Management — Classify books by genre.
• Search Functionality — Find books by title, author, or genre.
• Database Integration — Uses JDBC for persistent storage.
• Testing — Includes integration and unit tests using JUnit 5, Mockito, and H2 in-memory database.
• Console Styling — Uses color-coded messages for better user interaction.

Screenshots

Tools & Technologies:

• Visual Studio Code
• Git / GitHub
• Java 21
• PostgreSQL 17
• Apache Maven 3.13.0
• JUnit 5
• Mockito
• H2 Database

Installation and Execution:

1️. Clone the repository:

git clone https://github.com/P7-FeministLibrary/P7_FeministLibrary.git

2️. Set up the environment variables:

Create a .env file in the root of the project with your database credentials:

DB_HOST=localhost

DB_PORT=5432

DB_NAME=feminist_library

DB_USER=postgres

DB_PASSWORD=your_password

3️. Compile the project:

mvn compile

4️. Run the application:

mvn exec:java -Dexec.mainClass="com.feministlibrary.App"

Testing

This project includes both unit and integration tests using:

• JUnit 5 – for unit testing DAO methods and controllers
• Mockito – for mocking static classes (like DBManager)
• H2 in-memory database – for testing real SQL queries without affecting PostgreSQL

To run tests:

mvn test

Architecture

The project follows an MVC (Model-View-Controller) architecture and uses the DAO (Data Access Object) pattern.

  src/  
 ├── config/  
 ├── model/  
 │   ├── author/ 
 │   ├── book/
 │   └── genre/ 
 ├── view/    
 └── controller/

Database Model

The database is normalized and consists of the following main tables:

• book (id, title, description, isbn)
• author (id, name, last_name)
• genre (id, genre)
• book_author (id_book, id_author)
• book_genre (id_book, id_genre)

Each book can have multiple authors and genres (many-to-many relationships).

Team

👩‍💻 Estefania Secanell (Scrum Master & Developer) – GitHub

👩‍💻 Suraya Mattar (Product Owner & Developer) – GitHub

👩‍💻 Jashaira (Developer) – GitHub

👩‍💻 Ana Aguilera (Developer) – GitHub