Spaces:
Sleeping
Sleeping
File size: 1,139 Bytes
16ab8c3 effb07c cb4f1e3 effb07c 16ab8c3 cb4f1e3 16ab8c3 f94d8de |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
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
})
|