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():
    query = "SELECT Name, Price__c, Description__c, Image1__c, Veg_NonVeg__c, Section__c FROM Menu_Item__c"
    return sf.query(query)['records']

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
    })