models/salesforce.py

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

# Initialize Salesforce Connection
sf = Salesforce(username='diggavalli98@gmail.com', 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)
        return result['records']
    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
    })