Food Delivery Platform CRUD App

This is a local browser-based CRUD interface for the Oracle 11g XE database project.

It uses:

• Python standard library only
• Your installed Oracle 11g sqlplus.exe
• No Flask, no Node.js, no Oracle Python driver

Start The App

Easiest option:

Double-click start_crud_app.bat

Or run from PowerShell:

cd "C:\Users\mhamz\OneDrive - FAST National University\Python Files\Food_Delivery_Platform\crud_app"
& "C:\Users\mhamz\.cache\codex-runtimes\codex-primary-runtime\dependencies\python\python.exe" app.py --host 127.0.0.1 --port 5080

Then open:

http://127.0.0.1:5080

Connection Settings

Use the connection panel in the browser:

• Username: system or HR
• Password: your Oracle password
• DSN: localhost:1521/XE
• Table Schema: HR if your project tables are in HR, or SYSTEM if you created them under SYSTEM

The password is not written into the project files. It stays in server memory until you stop the app.

CRUD Coverage

The app supports create, read, update, and delete for:

• app_user
• delivery_zone
• customer
• restaurant_owner
• restaurant
• menu_category
• menu_item
• rider
• customer_order
• order_item
• payment
• coupon
• order_coupon
• rating
• order_status_history

Composite primary keys are supported for order_item and order_coupon.

Oracle 11g Notes

• Uses SQLPlus and Oracle 11g-safe SQL.
• Uses TO_DATE(..., 'YYYY-MM-DD HH24:MI:SS') for date inputs.
• Uses schema-qualified table names like HR.customer_order.
• Creates a local oracle_net_override/sqlnet.ora file to avoid Windows ORA-12638 native authentication errors during SQLPlus login.