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()
