"MY LIBRARIAN"

Small application with GUI to manage your electronic books collection as library

Application fitures

MENU

• Add New Book
  • Adds new books into library interface, inserts and commits changes into database by OK button.
  • Filepath to books are being generated using Filedialog (Tkinter)
• Delete Books
  • Deletes books from library interface, commits changes into database by OK button.
• Find a Book
  • Shows all current books in the database, lets to add books into Favorites and openes selected book details in separate window
• Favorites
  • Shows all books chosen as favorite previously in new window, lets to delete books from favorite list and commits changes to database, opens fave book details.
• Export to XLSX
  • Creates xlsx file from SQLite tables data, includes all books from database
  • Exports Book's: id, title, year(of release), description, publisher, link with filepath to the book, author's name, genre's name

DATABASE

ebook_sql_db.py

• All information about e-books is stored in the SQLite database.
• There are 4 tables in the database: books, authors, favorite_shelf, genres.

Database relations mapping:

---

Requirements >>>> requirements.txt

Launch my-librarian.py to run this application

Database, tables, xlsx file are being created automatically upon run the application and using GUI first time.