def test_ext_set(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('ktk', "Khans of Tarkir", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() est = db.session.query(MSet).filter_by(code="ktk").first() self.assertEqual(est.code, "ktk") self.assertEqual(est.name, "Khans of Tarkir") self.assertEqual(est.rDate, "1") self.assertEqual(est.block, "none") self.assertEqual(est.numCards, 5) self.assertEqual(est.symbol, "link") self.assertEqual(est.subTypes, [example3]) db.session.commit() db.drop_all()
def test_ext_artist(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('ktk', "Khans of Tarkir", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() example1 = MArtist('Thomas', 5, 5, [exampleSet]) db.session.add(example1) db.session.commit() est = db.session.query(MArtist).filter_by(name="Thomas").first() self.assertEqual(est.name, "Thomas") self.assertEqual(est.numCards, 5) self.assertEqual(est.numSets, 5) self.assertEqual(est.sets, [exampleSet]) db.session.commit() db.drop_all()
def test_many_relations3(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('ktk', "Khans of Tarkir", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() example1 = MArtist('Thomas', 5, 5, [exampleSet]) db.session.add(example1) db.session.commit() example2 = MArtist('Thom', 5, 5, [exampleSet]) db.session.add(example2) db.session.commit() est = db.session.query(MSet).filter_by(code="ktk").first() self.assertEqual(len(est.xartists.all()), 2) db.session.commit() db.drop_all()
def test_ext_card(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() example1 = MCard("123", "name", "Creature", [example3], "flying", 'LEA', 5, "Red", "1", "1", "url", "common", "thomas") db.session.add(example1) db.session.commit() est = db.session.query(MCard).filter_by(cardId="123").first() self.assertEqual(est.cardId, "123") self.assertEqual(est.name, "name") self.assertEqual(est.mainType, "Creature") self.assertEqual(est.subType, [example3]) self.assertEqual(est.text, "flying") self.assertEqual(est.expansionSet, "LEA") self.assertEqual(est.manaCost, 5) self.assertEqual(est.color, "Red") self.assertEqual(est.power, '1') self.assertEqual(est.toughness, '1') self.assertEqual(est.art, "url") self.assertEqual(est.rarity, "common") self.assertEqual(est.artist, "thomas") db.session.commit() db.drop_all()
def test_many_relations2(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('ktk', "Khans of Tarkir", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() exampleSet2 = MSet('LEA', "Khans of Tarkir", "1", "none", 5, "link", [example3]) db.session.add(exampleSet2) db.session.commit() est = db.session.query(MSubtype).filter_by(name="gobbo").first() self.assertEqual(len(est.ssets.all()), 2) db.session.commit() db.drop_all()
def test_many_relations(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('ktk', "Khans of Tarkir", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() example1 = MCard("123", "name", "Creature", [example3], "flying", 'LEA', 5, "Red", "1", "1", "url", "common", "thomas") db.session.add(example1) db.session.commit() example2 = MCard("124", "weewoocardnumber2", "Creature", [example3], "flying", 'ktk', 5, "Red", "1", "1", "url", "common", "thomas") db.session.add(example2) db.session.commit() est = db.session.query(MSubtype).filter_by(name="gobbo").first() self.assertEqual(len(est.xcards.all()), 2) db.session.commit() db.drop_all()
def test_ext_subtype(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() est = db.session.query(MSubtype).filter_by(name="gobbo").first() self.assertEqual(est.name, "gobbo") self.assertEqual(est.numCards, 2) self.assertEqual(est.numSets, 2) db.session.commit() db.drop_all()
def test_set_3(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('LEA', "Limited Edition Alpha", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() est = db.session.query(MSet).filter_by(code="LEA").first() self.assertEqual(est.name, "Limited Edition Alpha") db.session.commit() db.drop_all()
def test_set_2(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('KLD', "Kaladesh", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() est = db.session.query(MSet).filter_by(code="KLD").first() self.assertEqual(est.name, 'Kaladesh') db.session.commit() db.drop_all()
def test_set_1(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() exampleSet = MSet('MM3', "Modern Masters 2017 Edition", "1", "none", 5, "link", [example3]) db.session.add(exampleSet) db.session.commit() est = db.session.query(MSet).filter_by(code="MM3").first() self.assertEqual(est.code, 'MM3') db.session.commit() db.drop_all()
def test_card_3(self): db.session.commit() db.drop_all() db.create_all() example3 = MSubtype("gobbo", 2, 2) db.session.add(example3) db.session.commit() example1 = MCard("123", "name", "Creature", [example3], "flying", 'ktk', 5, "Red", "1", "1", "url", "common", "thomas") db.session.add(example1) db.session.commit() card = db.session.query(MCard).filter_by(name="name").first() self.assertEqual(card.power, '1') self.assertEqual(card.toughness, '1') db.session.commit() db.drop_all()