def test_legal_formats() -> None:
swamp = oracle.load_card('Swamp')
think_twice = oracle.load_card('Think Twice')
fork = oracle.load_card('Fork')
d = Deck({'id': 0})
d.maindeck = [{'n': 59, 'card': swamp}]
d.sideboard = []
assert len(d.all_cards()) == 59
formats = legality.legal_formats(d)
assert len(formats) == 0
d.maindeck = [{'n': 60, 'card': swamp}]
formats = legality.legal_formats(d)
assert 'Penny Dreadful' in formats
assert 'Legacy' in formats
assert 'Penny Dreadful EMN' in formats
formats = legality.legal_formats(d, {'Penny Dreadful'})
assert len(formats) == 1
assert 'Penny Dreadful' in formats
assert 'Legacy' not in formats
d.maindeck = [{'n': 55, 'card': swamp}, {'n': 5, 'card': think_twice}]
formats = legality.legal_formats(d)
assert len(d.all_cards()) == 60
assert len(legality.legal_formats(d)) == 0
d.maindeck = [{'n': 56, 'card': swamp}, {'n': 4, 'card': think_twice}]
formats = legality.legal_formats(d)
assert 'Legacy' in formats
assert 'Modern' in formats
d.sideboard = [{'n': 15, 'card': swamp}, {'n': 1, 'card': think_twice}]
formats = legality.legal_formats(d)
assert len(legality.legal_formats(d)) == 0
d.maindeck = [{'n': 56, 'card': swamp}, {'n': 4, 'card': fork}]
d.sideboard = [{'n': 15, 'card': swamp}]
formats = legality.legal_formats(d)
assert 'Legacy' in formats
assert 'Modern' not in formats
d.maindeck = [{'n': 60, 'card': swamp}]
d.sideboard = [{'n': 15, 'card': swamp}]
formats = legality.legal_formats(d)
assert 'Standard' in formats
assert 'Modern' in formats
assert 'Legacy' in formats
assert 'Vintage' in formats
assert 'Penny Dreadful' in formats
assert 'Penny Dreadful EMN' in formats
def load_decks(where='1 = 1', order_by=None, limit='', season_id=None) -> List[Deck]:
if order_by is None:
order_by = 'active_date DESC, d.finish IS NULL, d.finish'
sql = """
SELECT
d.id,
d.name AS original_name,
d.created_date,
d.updated_date,
SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins,
SUM(CASE WHEN dm.games < odm.games THEN 1 ELSE 0 END) AS losses,
SUM(CASE WHEN dm.games = odm.games THEN 1 ELSE 0 END) AS draws,
d.finish,
d.archetype_id,
d.url AS source_url,
d.competition_id,
c.name AS competition_name,
c.end_date AS competition_end_date,
c.top_n AS competition_top_n,
ct.name AS competition_type_name,
d.identifier,
{person_query} AS person,
p.id AS person_id,
p.banned,
p.discord_id,
d.decklist_hash,
d.retired,
s.name AS source_name,
IFNULL(a.name, '') AS archetype_name,
cache.normalized_name AS name,
cache.colors,
cache.colored_symbols,
cache.legal_formats,
season.id AS season_id,
IFNULL(MAX(m.date), d.created_date) AS active_date
FROM
deck AS d
LEFT JOIN
person AS p ON d.person_id = p.id
LEFT JOIN
source AS s ON d.source_id = s.id
LEFT JOIN
archetype AS a ON d.archetype_id = a.id
{competition_join}
LEFT JOIN
deck_cache AS cache ON d.id = cache.deck_id
LEFT JOIN
deck_match AS dm ON d.id = dm.deck_id
LEFT JOIN
`match` AS m ON dm.match_id = m.id
LEFT JOIN
deck_match AS odm ON odm.deck_id <> d.id AND dm.match_id = odm.match_id
{season_join}
WHERE ({where}) AND ({season_query})
GROUP BY
d.id,
season.id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs.
ORDER BY
{order_by}
{limit}
""".format(person_query=query.person_query(), competition_join=query.competition_join(), where=where, order_by=order_by, limit=limit, season_query=query.season_query(season_id), season_join=query.season_join())
db().execute('SET group_concat_max_len=100000')
rows = db().execute(sql)
decks = []
for row in rows:
d = Deck(row)
d.maindeck = []
d.sideboard = []
d.competition_top_n = Top(d.competition_top_n or 0)
d.colored_symbols = json.loads(d.colored_symbols or '[]')
d.colors = json.loads(d.colors or '[]')
d.legal_formats = set(json.loads(d.legal_formats or '[]'))
d.active_date = dtutil.ts2dt(d.active_date)
d.created_date = dtutil.ts2dt(d.created_date)
d.updated_date = dtutil.ts2dt(d.updated_date)
if d.competition_end_date:
d.competition_end_date = dtutil.ts2dt(d.competition_end_date)
d.can_draw = 'Divine Intervention' in [card.name for card in d.all_cards()]
decks.append(d)
load_cards(decks)
load_competitive_stats(decks)
return decks