models/salesforce.py

from simple_salesforce import Salesforce
from config import SALESFORCE_USERNAME, SALESFORCE_PASSWORD, SALESFORCE_SECURITY_TOKEN

# Initialize Salesforce Connection
sf = Salesforce(username='[email protected]', password='Sati@1020', security_token='sSSjyhInIsUohKpG8sHzty2q')

# Example Salesforce Query Functions
def fetch_menu_items():
    try:
        query = "SELECT Name, Price__c, Description__c, Veg_NonVeg__c FROM Menu_Item__c"
        result = sf.query(query)
        # Convert OrderedDict to plain dict
        menu_items = [
            {
                "Name": item["Name"],
                "Price": item["Price__c"],
                "Description": item["Description__c"],
                "Veg_NonVeg": item["Veg_NonVeg__c"]
            }
            for item in result["records"]
        ]
        return menu_items
    except Exception as e:
        print(f"Error fetching menu items: {str(e)}")
        return []



def place_order_in_salesforce(email, order_details, total):
    sf.Order__c.create({
        'Customer_Email__c': email,
        'Order_Items__c': order_details,
        'Total_Amount__c': total
    })