OSCommerce Product Manager

OSCommerce Product Manager for Windows
Tasklist

FS#168 - Move all SQL code to server-side.

Attached to Project: OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 13 February 2005, 13:11 GMT-6
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Monday, 27 March 2006, 02:33 GMT-6
Task Type New feature
Category Backend / Core
Status Assigned
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity Medium
Priority Immediate
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Votes 0
Private No

Details

We should redesign the application so all SQL queries are build server-side.

So, the application would only send request with the form:
MOVE ID=243 TO CAT=23
Or something like that. We then would forget about supporting other OSCommerce variants in the Delphi code, because most database/tables/fields issues would be moved to the PHP realm. Also, it's a lot easier to find a PHP programmer than a Delphi programmer.

It would make the OSCPMWin application more lightweight, faster, simpler and less prone to failure.

Of course this would require a full HTTP interface. This is related to Bug #66. Actually, it is too related it should be fixed concurrently.
This task depends upon

Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 27 March 2006, 02:33 GMT-6

The Bug #66 has been implemented.

We can start planning how to implement this one.
Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 19 July 2010, 06:05 GMT-6
Identified operations (for current version):

GET CATEGORY (all or by ID)
GET MANUFACTURER (all or by ID)
GET TAX (all or by ID)
GET CURRENCY (all or by ID)
GET LANGUAGE (all or by ID)
GET PRODUCT (all or by ID)
GET OPTION (all)
SEARCH PRODUCT (by multiple criteria)
UPDATE CATEGORY
UPDATE MANUFACTURER
UPDATE CURRENCY
UPDATE PRODUCT
DELETE CATEGORY
DELETE MANUFACTURER
DELETE CURRENCY
DELETE PRODUCT
ADD CATEGORY
ADD MANUFACTURER
ADD CURRENCY
ADD PRODUCT

Comment by Mario A. Valdez-Ramirez (mvaldez) - Saturday, 07 August 2010, 17:27 GMT-6
Done preliminar testing. It works but it will need a rewrite of the server-side script.

Loading...