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_state(self): db.session.commit() db.drop_all() db.create_all() state = State("Texas", "big", "872647", "10000000", "1234567") db.session.add(state) db.session.commit() states = State.query.all() self.assertTrue(state in states) db.drop_all()
def test_state2(self): db.session.commit() db.drop_all() db.create_all() state = State("Florida", "panhandle", "600000", "105036", "9854432") db.session.add(state) db.session.commit() states = State.query.all() self.assertTrue(state in states) db.drop_all()
def test_state3(self): db.session.commit() db.drop_all() db.create_all() state = State("California", "techies", "8000000", "125036", "78542") db.session.add(state) db.session.commit() states = State.query.all() self.assertTrue(state in states) db.drop_all()
def test_campground2(self): db.session.commit() db.drop_all() db.create_all() campground = Campground("Everglades", "lodge", "145.38", "42.45", "go straight", "(555)-555-5555", "*****@*****.**", "78705", None) db.session.add(campground) db.session.commit() campgrounds = Campground.query.all() self.assertTrue(campground in campgrounds) db.drop_all()
def test_campground3(self): db.session.commit() db.drop_all() db.create_all() campground = Campground("Yosemite", "RVs", "46.15", "-53.87", "go left", "(555)-555-5555", "*****@*****.**", "78705", None) db.session.add(campground) db.session.commit() campgrounds = Campground.query.all() self.assertTrue(campground in campgrounds) db.drop_all()
def test_park3(self): db.session.commit() db.drop_all() db.create_all() park = Park("Park3", "13.87", "125.64", "2419 Rio Grande", "(555)-555-5555", "3.5", "google.com", "78705", "google.com", "787", "Texas") db.session.add(park) db.session.commit() parks = Park.query.all() self.assertTrue(park in parks) db.drop_all()
def test_campground(self): db.session.commit() db.drop_all() db.create_all() campground = Campground("Camping", "tents", "45.38", "-53.87", "go right", "(555)-555-5555", "*****@*****.**", "78705", None) db.session.add(campground) db.session.commit() campgrounds = Campground.query.all() self.assertTrue(campground in campgrounds) db.drop_all()
def test_event3(self): db.session.commit() db.drop_all() db.create_all() event = Event("124.56", "-26.76", "Hiking", "2/5/17", "2/6/17", "google.com", "Crohns and Colitis Foundation", "(555)-555-5555", "Austin", "78705", "787", "Texas") db.session.add(event) db.session.commit() events = Event.query.all() self.assertTrue(event in events) db.drop_all()
def test_event(self): db.session.commit() db.drop_all() db.create_all() event = Event("124.56", "-26.76", "Running", "2/5/17", "2/6/17", "google.com", "Relay for Life", "(555)-555-5555", "Austin", "78705", "787", "Texas") db.session.add(event) db.session.commit() events = Event.query.all() self.assertTrue(event in events) db.drop_all()
def test_event2(self): db.session.commit() db.drop_all() db.create_all() event = Event("124.56", "-26.76", "Biking", "1/1/17", "1/2/17", "google.com", "Living Water International", "(555)-555-5555", "Austin", "78705", "787", "Texas") db.session.add(event) db.session.commit() events = Event.query.all() self.assertTrue(event in events) 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_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_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_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_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()
def setUp(self): db.create_all()