app.py

from flask import Flask, render_template, request
from simple_salesforce import Salesforce
import os

# Initialize Flask app
app = Flask(__name__)

# Salesforce credentials (Use environment variables for security in production)
SF_USERNAME = os.getenv("SF_USERNAME", "diggavalli98@gmail.com")
SF_PASSWORD = os.getenv("SF_PASSWORD", "Sati@1020")
SF_SECURITY_TOKEN = os.getenv("SF_SECURITY_TOKEN", "sSSjyhInIsUohKpG8sHzty2q")

# Connect to Salesforce
sf = Salesforce(username="diggavalli98@gmail.com", password="Sati@1020", security_token="sSSjyhInIsUohKpG8sHzty2q")

@app.route("/menu", methods=["GET"])
def menu():
    selected_category = request.args.get("category", "All")

    try:
        query = "SELECT Name, Price__c, Image1__c, Category__c, Description__c FROM Menu_Item__c"
        result = sf.query(query)
        food_items = result['records'] if 'records' in result else []
        categories = {item['Category__c'] for item in food_items if 'Category__c' in item}

        if selected_category != "All":
            food_items = [item for item in food_items if item.get("Category__c") == selected_category]
    except Exception as e:
        food_items = []
        categories = []
        print(f"Error fetching data: {e}")

    return render_template("menu.html", food_items=food_items, categories=categories, selected_category=selected_category)

# Use Gunicorn for production environment. No need for app.run() here.
if __name__ == "__main__":
    pass  # Gunicorn will handle running the application in production