// To create graph
SELECT * FROM ag_catalog.create_graph('menu');

// To add samosas
SELECT * FROM cypher('menu', $$
CREATE (:STARTER {name: "Samosa", type: "Vegan", price: 30})
$$) AS (result agtype);

// To add all other menu items
SELECT * FROM cypher('menu', $$
CREATE (:BEVERAGE {name: "Chai", type: "Vegetarian", price: 10})
CREATE (:CURRY {name: "Dal Makhani", type: "Vegan", price: 60})
CREATE (:CURRY {name: "Kadhai Paneer", type: "Vegetarian", price: 80})
CREATE (:CURRY {name: "Mix Veg", type: "Vegan", price: 70})
CREATE (:CURRY {name: "Butter Chicken", type: "Non Vegetarian", price: 150})
CREATE (:BREAD {name: "Butter Naan", type: "Vegetarian", price: 20})
CREATE (:BREAD {name: "Roti", type: "Vegan", price: 10})
CREATE (:RICE {name: "Rice", type: "Vegan", price: 30})
CREATE (:DESSERT {name: "Ras Malai", type: "Vegetarian", price: 30})
$$) AS (result agtype);

// To view all nodes
SELECT * FROM cypher('menu', $$
MATCH (n) RETURN n
$$) AS (result agtype);

// To create relationship between Chai and Samosa
SELECT * FROM cypher('menu', $$
MATCH (samosa:STARTER {name: "Samosa"}), (chai:BEVERAGE {name: "Chai"})
CREATE (samosa)-[:GOES_WITH]->(chai)
RETURN samosa, chai
$$) AS (samosa agtype, chai agtype);

// To create relationship between all breads and all curries
SELECT * FROM cypher('menu', $$
MATCH (bread:BREAD), (curry:CURRY)
CREATE (bread)-[:GOES_WITH]->(curry)
RETURN bread, curry
$$) AS (bread agtype, curry agtype);

// To create relationship between Rice and Dal
SELECT * FROM cypher('menu', $$
MATCH (rice:RICE), (dal:CURRY {name: "Dal Makhani"})
CREATE (rice)-[:GOES_WITH]->(dal)
RETURN rice, dal
$$) AS (rice agtype, dal agtype);

// To update Dal from Vegan to Vegetarian
SELECT * FROM cypher('menu', $$
MATCH (dal:CURRY {name: "Dal Makhani"})
SET dal.type = "Vegetarian"
RETURN dal
$$) AS (dal agtype);

// To delete all Non Vegetarian food
SELECT * FROM cypher('menu', $$
MATCH (nv {type:"Non Vegetarian"})
DETACH DELETE nv
RETURN nv
$$) AS (nv agtype);

// To output all vegan foods
SELECT * FROM cypher('menu', $$
MATCH (v {type: "Vegan"})
RETURN v
$$) AS (v agtype);

// What goes with naan
SELECT * FROM cypher('menu', $$
MATCH (n:BREAD {name: "Butter Naan"})-[GOES_WITH]-(f)
RETURN f
$$) AS (v agtype);

// Only vegan curries
SELECT * FROM cypher('menu', $$
MATCH (vc:CURRY {type: "Vegan"})
RETURN vc
$$) AS (vc agtype);