Book Tracking System

Project Overview

The Book Tracking System is a personal library management application designed to help organize and locate books in your personal collection. Unlike public library systems, this application is specifically tailored for individual use, allowing you to track the exact location of each book within your home library setup.

Key Features

• Shelf Location Tracking

  Record and track which shelf or location each book is stored in your personal library, making it easy to find books when needed.

• Book Information Management

  Add and edit detailed book information including title, author, genre, and personal notes.

• Quick Search

  Easily find books in your collection using various search criteria including location, title, or author.

• Custom Categories

  Create personalized categories and tags to organize books according to your preferences.

Application Screenshots

Login screen - User authentication interface

Main menu - Options for adding, viewing, searching, and managing books

Book addition screen - Shelf location and detailed information entry

Book list - Overview of added books with their shelf locations

Search interface - Custom category and tag management

Book details - Book information and shelf location view

Technical Details

Development Process

Technical Implementation

import os
import sqlite3
from flask import Flask

def get_db_connection():
    db_path = os.path.abspath("database.db")
    print("📌 Using database at:", db_path)
    conn = sqlite3.connect(db_path)
    conn.row_factory = sqlite3.Row
    return conn
                            

@app.route("/login", methods=["GET", "POST"])
def login():
    if request.method == "POST":
        username = request.form["username"]
        password = request.form["password"]

        conn = get_db_connection()
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM users WHERE username = ?", (username,))
        user = cursor.fetchone()
        conn.close()

        if user and check_password_hash(user["password"], password):
            session["username"] = username
            return redirect(url_for("dashboard"))
                            

@app.route("/add_book", methods=["GET", "POST"])
def add_book():
    if "username" not in session:
        return redirect(url_for("login"))

    if request.method == "POST":
        author_name = request.form["author_name"]
        book_name = request.form["book_name"]
        location = request.form["location"]
        category = request.form["kategori"]

        conn = get_db_connection()
        cursor = conn.cursor()
        cursor.execute("SELECT id FROM users WHERE username = ?", 
                      (session["username"],))
        user = cursor.fetchone()

        if user:
            new_id = get_next_available_id()
            cursor.execute("""INSERT INTO books 
                            (id, author_name, book_name, location, kategori, user_id) 
                            VALUES (?, ?, ?, ?, ?, ?)""",
                            (new_id, author_name, book_name, location, 
                             category, user["id"]))
            conn.commit()
                            

@app.route("/search_books", methods=["GET", "POST"])
def search_books():
    if request.method == "POST":
        search_query = request.form["search_query"]

        conn = get_db_connection()
        cursor = conn.cursor()
        cursor.execute("""
            SELECT * FROM books 
            WHERE (CAST(id AS TEXT) LIKE ? 
            OR author_name LIKE ?
            OR book_name LIKE ?  
            OR location LIKE ?) 
            AND user_id = (SELECT id FROM users WHERE username = ?)
        """, (f"%{search_query}%", f"%{search_query}%", 
              f"%{search_query}%", f"%{search_query}%", 
              session["username"]))
                            

Database Schema