ساخت عرشه MTG با Apache AGE!

SELECT * FROM cypher('MTG', $$
    CREATE(d:Deck {name: 'Bogles', format: 'Pauper', colors:'{G}{W}'})
    RETURN d
$$) as (deck agtype);

SELECT * FROM cypher('MTG', $$
    MATCH (c:Creature)
    WHERE c.oracle_text CONTAINS 'Hexproof' AND (c.mana_cost CONTAINS 'G' OR c.mana_cost CONTAINS 'W') AND
    (toInteger(substring(c.mana_cost, 1, 1)) <= 2 OR toInteger(substring(c.mana_cost, 1, 1)) IS NULL)
    RETURN c.name, c.mana_cost
$$) as (card_name agtype, mana_cost agtype);

       card_name       | mana_cost 
-----------------------+-----------
 "Slippery Bogle"      | "{U/G}"
 "Gladecover Scout"    | "{G}"
 "Silhana Ledgewalker" | "{1}{G}"
(3 rows)

demo=# SELECT * FROM cypher('MTG', $$
    MATCH (d:Deck), (c1:Creature), (c2:Creature), (c3:Creature)
    WHERE d.name = "Bogles" AND c1.name = "Slippery Bogle" AND c2.name = "Gladecover Scout" AND c3.name ="Silhana Ledgewalker"
    CREATE (c1)<-[:CONTAINS {quantity: 4}]-(d)-[:CONTAINS {quantity:4}]->(c2), (c3)<-[:CONTAINS {quantity: 4}]-(d)
$$) as (a agtype);

SELECT * FROM cypher('MTG', $$
    MATCH (c:Enchantment)
    WHERE (c.mana_cost CONTAINS 'G' OR c.mana_cost CONTAINS 'W') AND
          (toInteger(substring(c.mana_cost, 1, 1)) <= 2 OR toInteger(substring(c.mana_cost, 1, 1)) IS NULL)
    RETURN c.name, c.mana_cost, c.oracle_text
$$) as (card_name agtype, mana_cost agtype, oracle_text agtype);

         card_name         |  mana_cost  |                                                                                            oracle_text                                                                          
---------------------------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 "Arrest"                  | "{2}{W}"    | "Enchant creature. Enchanted creature can’t attack or block, and its activated abilities can’t be activated."
 "Abundant Growth"         | "{G}"       | "Enchant land When Abundant Growth enters the battlefield, draw a card. Enchanted land has “{T}: Add one mana of any color.”"
 "Cartouche of Solidarity" | "{W}"       | "Enchant creature you control When Cartouche of Solidarity enters the battlefield, create a 1/1 white Warrior creature token with vigilance. Enchanted creature gets +1/+1 and has first strike."
 "Ethereal Armor"          | "{W}"       | "Enchant creature Enchanted creature gets +1/+1 for each enchantment you control and has first strike."
 "Rancor"                  | "{G}"       | "Enchant creature Enchanted creature gets +2/+0 and has trample. When Rancor is put into a graveyard from the battlefield, return Rancor to its owner’s hand."
 "Spirit Link"             | "{W}"       | "Enchant creature Whenever enchanted creature deals damage, you gain that much life."
 "Utopia Sprawl"           | "{G}"       | "Enchant Forest Whenever As Utopia Sprawl enters the battlefield, choose a color. Whenever enchanted Forest is tapped for mana, its controller adds an additional one mana of the chosen color."
 "Ancestral Mask"          | "{2}{G}"    | "Enchant creature Enchanted creature gets +2/+2 for each other enchantment on the battlefield."
 "Armadillo Cloak"         | "{1}{G}{W}" | "Enchant creature Enchanted creature gets +2/+2 and has trample. Whenever enchanted creature deals damage, you gain that much life."
(9 rows)

SELECT * FROM cypher('MTG', $$
    MATCH (c:Enchantment), (d:Deck)
    WHERE (c.mana_cost CONTAINS 'G' OR c.mana_cost CONTAINS 'W') AND
    (toInteger(substring(c.mana_cost, 1, 1)) <= 2 OR toInteger(substring(c.mana_cost, 1, 1)) IS NULL) 
    AND c.name <> "Arrest" AND d.name = "Bogles"
    CREATE (d)-[:CONTAINS {quantity: 3}]->(c)
$$) as (a agtype);

SELECT * FROM cypher('MTG', $$
    MATCH (c:Sorcery), (d:Deck)
    WHERE c.name = "Commune with Spirits" AND d.name = "Bogles"
    CREATE (d)-[:CONTAINS {quantity: 4}]->(c)
$$) as (a agtype);

SELECT * FROM cypher('MTG', $$
    MATCH (f:Land), (p:Land), (d:Deck)
    WHERE f.name = "Forest" AND p.name = "Plains" AND d.name = "Bogles"
    CREATE (p)<-[:CONTAINS {quantity: 8}]-(d)-[:CONTAINS {quantity: 12}]->(f)    
$$) as (a agtype);