On Mon, 31 Jan 2022 01:32:15 -0800 (PST), NArshad <narshad....@gmail.com> declaimed the following:
>What about CGI? >Do you know any Library Management System based on CGI just like the one on >Django? Pure CGI is 30 year old technology... https://en.wikipedia.org/wiki/Common_Gateway_Interface To use it will require a properly configured web-server and lots of individual script files. For a monolithic Python application you may want to study https://en.wikipedia.org/wiki/Web_Server_Gateway_Interface (which will still require a properly configured web-server). https://docs.python.org/3/library/cgi.html You'll still have write the HTML for the pages to be displayed (possibly via template engines as used by Django, Flask, Pylons, Zope), and maybe CSS (pure HTML just describes /what/ to render, leaving it up to the browser to do that rendering -- CSS adds lots of overhead to control how the rendering is done). You have now spent a MONTH asking people to provide you with pre-built solutions to a problem description that is so vaguely specified that no one here would even consider a solution on that model. You have been provided links to possible approaches and technologies which might be used by you to write code for your requirements. In this month you have never shown us actual sample data (export your spreadsheet as CSV so you can paste text into a post). You have shown us less than 10 lines of code (which, again, can not be evaluated as they were incomplete and you provided no data against which to run them). You grab at any acronym mentioned in replies as if it will magically create your solution but don't seem to spend time learning about those technologies to understand what they do (CGI is a method by which a web page can send data to a web server, and the web server then starts a program passing the data on to the program... THAT IS ALL IT DOES -- you still have to create the HTML forms AND the scripts that process the data). Your original post(s) stated you were under a time crunch and didn't have time to write everything... But you seem to have lots of time to keep asking others to find a solution for you to copy. A rank beginner in Python* should have been able to write minimal code to access the data, even if the user interface is just a text console: ENTER USERNAME> .... ENTER TITLE OF INTEREST> ... # copies are available for /title/ RESERVE COPY (Y/N)> ... **************************************************** After all this time, my recommendation is that you go to whoever gave you this assignment and flat out tell them you are unable to provide the solution and need to be replaced. It's that, or do a massive editing session to produce a few hundred lines of code that at least attempts to solve part of your assignment and hope for an extension on the due date. You have a number of things to consider: User Interface: 1 text console (maybe with use of curses to create forms) 2 local GUI app (Tkinter, GTK, or wX libraries) 3 web-based app (HTML, web-framework, web-server config) Data Storage: 1 your insistence on an Excel spreadsheet (the most complex solution as it does not handle concurrent access -- so you need some means of locking it to only one user for the entire time of a session) 2 relational database (one time import, and need to provide functions to allow for complete management of the data, not just one "reserve" function. option for on-demand export for post-process reporting) User Management: you need some means to control who can perform operations on the data -- this could be additional tables in a database. **************************************************** * {Given the first edition O'Reilly Python book, and an Amiga port of Python 1.x -- it took me a week to produce a rudimentary SMTP sending daemon using my ISP SMTPd for relay... I had to do this as the first SMTP sending program I'd obtained often hung up trying to send mails (this was back in the day when it was common to send mail directly to the destination host; but it didn't do MX lookup; some addresses didn't run receiving SMTPd); the second program did relay via ISP but never processed CC: or BCC: addresses, only TO: addresses. Oh, this was also back in the days when mail clients only handled local mailboxes, and did not send/receive messages -- one had to invoke scripts to queue outgoing messages for sending, and others to fetch from POP3 servers. I'll admit I couldn't do that now -- the need for SSL/TLS protocols complicates things.} -- Wulfraed Dennis Lee Bieber AF6VN wlfr...@ix.netcom.com http://wlfraed.microdiversity.freeddns.org/ -- https://mail.python.org/mailman/listinfo/python-list