All projects & work

Book Store Management System

From the catalog to the cart, on the desktop.

Fork · ELJoOker2004 / Book_Store_Managment_System

Book Store Management System workflow diagram
Workflow diagram based on the repository’s implementation.

Python · Tkinter · ttkbootstrap · SQLite

View repository

The idea

I forked ELJoOker2004’s desktop bookstore and followed a book from the catalog to checkout. The number beside a title in the Tkinter window comes from SQLite, and that same inventory record changes when a copy leaves the store.

Two views of one catalog

I followed a title through the upstream Tkinter app. Members and administrators reach the same SQLite records through different controls.Member catalogAdmin inventoryget_booksedit_bookbook_store.db
I followed a title through the upstream Tkinter app. Members and administrators reach the same SQLite records through different controls.

Where the stock count lives

I started with the quantity beside a book cover. The catalog reads it from the books table along with the title and artwork. Editing inventory changes the row that the catalog reads next time.

  • The book ID stays with the item as it moves into the cart.
  • The stock helper checks the available quantity before decrementing it.
  • The admin view can update a title, cover, description and quantity.

A closer look at the code

Loading the catalog

I followed the catalog view to the helper that reads every book in a single query. From db_functions.py.

def get_books():
    conn = sqlite3.connect('book_store.db')
    c = conn.cursor()
    c.execute("SELECT id,name, cover, quantity,author,descreption FROM books")
    books = c.fetchall()
    conn.close()
    return books

Scope & practical notes

  • This is a local desktop application backed by a SQLite file.

Project credits

This repository is a fork of ELJoOker2004 / Book_Store_Managment_System. The upstream authors retain credit for the original application.