cmartello

from sqlite3 import connect

db = connect('All Sets-2011-06-19.db')

mechanics = ['Banding', 'Rampage', 'Cumulative Upkeep', 'Living Weapon', 'Phasing', 'Flanking', 'Storm', 'Affinity', 'Buyback', 'Soulshift', 'Kicker', 'Multikicker', 'Modular', 'Cycling', 'Storm', 'Madness', 'Threshhold', 'Ripple', 'Devour', 'Battle Cry', 'Infect', 'Rebound', 'Cascade', 'Champion', 'Reinforce', 'Provoke', 'Sunburst', 'Frenzy', 'Gravestorm', 'Retrace', 'Annihilator', 'Evoke', 'Hideaway', 'Totem Armor', 'Transmute', 'Ninjutsu', 'Split Second', 'Absorb', 'Convoke', 'Entwine', 'Bushido', 'Soulshift', 'Wither', 'Recover']

# get a list of cards that have been in a core set
corecards = set([x[0] for x in db.execute("SELECT name FROM published WHERE expansion IN ('A', 'B', 'U', 'RV', '4E', '5E', '6E', '7E', '8ED', '9ED', '10E', 'M10', 'M11')")])

# get a list of cards from sets that maro worked on but didn't lead