As of now ,it allows the user to manage (Create,Read,Delete,Update )his inventory details. The file is stored on the local machine.
I was already familiar with creating web applications, but I was curious to experiment with creating desktop applications. I chose Tkinter because it is cross-compatible with popular operating systems like macOS, Windows, and Linux.
Another reason I wanted to explore desktop applications is that they allow data to be stored locally, rather than in the cloud. I wanted to demonstrate that CRUD (Create, Read, Update, Delete) operations are possible with desktop applications.
For this project, I targeted a simple use case: storing records of books, which would include the author, title, ISBN, and year published. At the time of creating this, I incorporated the following functionalities, Create Records, Update Record, Delete Record, View All records, and Search for matching records.1. On Lauch
**2. View All records **
Click "View All" button to retrieve all the records from DB.
**3. Search for matching record**
Can query using the Title or author or year or ISBN. Used a OR matching for different fields. It will return records whose fields match the input.
For sake of demonstration, I added the following record.
Let's search for author "charles".
**4. Add a record**
Enter the details using the fields provided
Click on "add a book" button to save to DB.
It commits to the db, and refresh the list on the left to show the updated records.
**5. Update a record**
Let's update the record of the book i added in point number 4. Select the records from the text box on the left; And Change the title to Sample Edition-2. and hit the "update selected" button.
**6. Delete a record**
Let's delete by selecting the John Doe record.
As you can see, it no longer exists.
Just clone the repository, and run the command in your terminal "python frontend.py"