def test_cards_route(self): u1 = User.register(username="******", password="******", first_name="Jon", last_name="Compton", email="*****@*****.**") u2 = User.register(username="******", password="******", first_name="Kyle", last_name="Lewis", email="*****@*****.**") db.session.add_all([u1, u2]) db.session.commit() c1 = Card.create(owner_id=u1.id, player="Ken Griffey Jr", year=1989, set_name="Upper Deck", number="1", desc="PSA 10", has_img=True) c2 = Card.create(owner_id=u2.id, player="Felix Jose", year=1989, set_name="Upper Deck", number="2", desc="PSA 10") db.session.add_all([c1, c2]) db.session.commit() with app.test_client() as client: res = client.get('/cards') html = res.get_data(as_text=True) self.assertIn("Griffey", html) self.assertIn("Felix", html) self.assertIn("All Cards", html)
def test_create_trade_request(self): u1 = User.register(username="******", password="******", email="*****@*****.**", first_name="Wade", last_name="Boggs") u2 = User.register(username="******", password="******", email="*****@*****.**", first_name="Tony", last_name="Gwynn") db.session.add_all([u1, u2]) db.session.commit() c1 = Card.create(owner_id=u1.id, player="Sandy Koufax", year=1955, set_name="Topps", number="123", desc="PSA 7") c2 = Card.create(owner_id=u2.id, player="Mickey Mantle", year=1956, set_name="Topps", number="135", desc="PSA 5") db.session.add_all([c1, c2]) db.session.commit() jsn = json.dumps({"c" : [str(c1.id)]}) data = {'req_data' : jsn} c2_id = c2.id c1_id = c1.id u1_id = u1.id with app.test_client() as client: with client.session_transaction() as change_session: change_session['user_id'] = u1_id res = client.post(f'/cards/{c2_id}/new-request', data=data, follow_redirects=True) html = res.get_data(as_text=True) card1 = Card.query.get(c1_id) card2 = Card.query.get(c2_id) trade_requests = TradeRequest.query.all() self.assertEqual(res.status_code, 200) self.assertEqual(len(trade_requests), 1) self.assertEqual(trade_requests[0].to_id, 2) self.assertEqual(trade_requests[0].from_id, 1) self.assertIn(card1, trade_requests[0].cards) self.assertIn(card2, trade_requests[0].cards)
def test_card_id_route(self): u1 = User.register(username="******", password="******", first_name="Jon", last_name="Compton", email="*****@*****.**") db.session.add(u1) db.session.commit() c1 = Card.create(owner_id=u1.id, player="Ken Griffey Jr", year=1989, set_name="Upper Deck", number="1", desc="PSA 10", has_img=True) c2 = Card.create(owner_id=u1.id, player="Felix Jose", year=1989, set_name="Upper Deck", number="2", desc="PSA 10") db.session.add_all([c1, c2]) db.session.commit() with app.test_client() as client: res = client.get(f'/cards/{c1.id}') html = res.get_data(as_text=True) user1 = User.query.get(u1.id) self.assertIn("Griffey", html) self.assertIn(f"{user1.username}", html) self.assertNotIn("Felix", html)
def setUpClass(cls): cls.u1 = User.register(username="******", password="******", first_name="Jon", last_name="Compton", email="*****@*****.**") cls.u2 = User.register(username="******", password="******", first_name="Kyle", last_name="Lewis", email="*****@*****.**") db.session.add_all([cls.u1, cls.u2]) db.session.commit() cls.c1 = Card.create(owner_id=cls.u1.id, player="Ken Griffey Jr", year=1989, set_name="Upper Deck", number="1", desc="PSA 10", has_img=True) cls.c2 = Card.create(owner_id=cls.u1.id, player="Felix Jose", year=1989, set_name="Upper Deck", number="2", desc="PSA 10") db.session.add_all([cls.c1, cls.c2]) db.session.commit()
def test_accept_trade_request(self): u3 = User.register(username="******", password="******", email="*****@*****.**", first_name="Wade", last_name="Boggs") u4 = User.register(username="******", password="******", email="*****@*****.**", first_name="Tony", last_name="Gwynn") db.session.add_all([u3, u4]) db.session.commit() c3 = Card.create(owner_id=u3.id, player="Sandy Koufax", year=1955, set_name="Topps", number="123", desc="PSA 7") c4 = Card.create(owner_id=u4.id, player="Mickey Mantle", year=1956, set_name="Topps", number="135", desc="PSA 5") db.session.add_all([c3, c4]) db.session.commit() u3_id = u3.id u4_id = u4.id c3_id = c3.id c4_id = c4.id with app.test_client() as client: with client.session_transaction() as change_session: change_session['user_id'] = u3_id tr = TradeRequest(to_id=u3.id, from_id=u4.id) db.session.add(tr) db.session.commit() rc1 = RequestCard(request_id=tr.id, card_id=c3_id, requested=True) rc2 = RequestCard(request_id=tr.id, card_id=c4_id) db.session.add_all([rc1, rc2]) tr_id = tr.id data = {"accept": True, "request_id": f"{tr.id}"} res = client.post(f'/users/{u3_id}/requests', data=data) req = TradeRequest.query.get(tr_id) card3 = Card.query.get(c3_id) card4 = Card.query.get(c4_id) self.assertEqual(req.accepted, True) self.assertFalse(req.valid_items) self.assertEqual(card3.owner_id, u4_id) self.assertEqual(card4.owner_id, u3_id)
def create_vin(request): topics = ['NBA'] for fld in topics: logging.info('Entra en bucle para %s' % fld) directory = "media/%s" % fld root = Folder.create(fld,request.user.profile,None,'/media/example_folder.png') root.save() for serie in os.listdir(directory): logging.info('Entra en bucle series para %s' % serie) if not serie.startswith('.'): s = Folder.create(serie,request.user.profile,root,None) s.pic = None #TODO revisar codigo inutil for season in os.listdir(directory+'/'+serie): if not season.startswith('.'): if fld == 'NBA': pic = '/media/example_folder.png' else: pic = '/'+directory+'/'+serie+'/'+season+'/season.jpeg' if s.pic == None: s.pic = pic s.save() ss = Folder.create(season,request.user.profile,s,pic) ss.save() for episode in os.listdir(directory+'/'+serie+'/'+season+'/'): if not episode.startswith('.') and '.jpeg' not in episode: # if fld == 'NBA': # pic = '/media/example_folder.png' # else: # pic = '/'+directory+'/'+serie+'/'+season+'/season.jpeg' url = open(directory+'/'+serie+'/'+season+'/'+episode,'r').readline() if url.__len__ > 0: c = Card.create(episode,url,ss) if fld == 'NBA': c.pic = fld+'/'+serie+'/'+season +'/'+ episode+'.jpeg' c.save()
def test_card_edit(self): u1 = User.register(username="******", password="******", first_name="Jon", last_name="Compton", email="*****@*****.**") db.session.add(u1) db.session.commit() with app.test_client() as client: with client.session_transaction() as change_session: change_session['user_id'] = u1.id card = Card.create(owner_id=u1.id, player="Fernando Tatis Jr", year=2019, set_name="Topps Series 2", number="410", desc="PSA 10") db.session.add(card) db.session.commit() data = { 'player': 'Ronald Acuna Jr', 'year': 2018, 'set_name': "topps Series 2", "number": "698", "desc": "Short Print" } res = client.post(f'/cards/{card.id}/edit', data=data) self.assertEqual(card.player, data['player']) self.assertEqual(card.year, data['year']) self.assertEqual(card.number, data['number']) self.assertEqual(card.desc, data['desc'])
def import_data(request, parent, data): """ Transform json file into vincula objects Every key of the json input will be transformed to a folder, and every value to links (Even arrays). Maximum depth allowed is 1, for security reasons, at the moment. """ # if not isinstance(data, dict): # data = json.loads(data) for folder, cards in data.iteritems(): f_parent = Folder.create(folder, request.user.profile, parent, '/media/example_folder.png') f_parent.save() for name, url in cards.iteritems(): card = Card.create(name, url, f_parent) card.save() return True
def test_create(self): new_card = Card.create(owner_id=self.u1.id, player="Mickey Mantle", year=1952, set_name="Topps", number="311", desc="PSA 2") db.session.add(new_card) db.session.commit() card = Card.query.get(new_card.id) self.assertEqual(card.owner_id, self.u1.id) self.assertEqual(card.player, new_card.player) self.assertEqual(card.set_name, new_card.set_name) self.assertEqual(card.number, new_card.number) self.assertEqual(card.desc, new_card.desc) self.assertFalse(card.has_img)
def test_serialize(self): new_card = Card.create(owner_id=self.u1.id, player="Willie Mays", year=1952, set_name="Topps", number="261", desc="PSA 4") db.session.add(new_card) db.session.commit() card = Card.query.get(new_card.id) json = card.serialize() self.assertEqual(json.get('player'), new_card.player) self.assertEqual(json.get('year'), new_card.year) self.assertEqual(json.get('set_name'), new_card.set_name) self.assertEqual(json.get('number'), new_card.number) self.assertEqual(json.get('description'), new_card.desc) self.assertEqual(json.get('title'), new_card.title) self.assertEqual(json.get('id'), new_card.id)
def test_card_delete(self): u1 = User.register(username="******", password="******", first_name="Jon", last_name="Compton", email="*****@*****.**") db.session.add(u1) db.session.commit() with app.test_client() as client: with client.session_transaction() as change_session: change_session['user_id'] = u1.id card = Card.create(owner_id=u1.id, player="Fernando Tatis Jr", year=2019, set_name="Topps Series 2", number="410", desc="PSA 10") db.session.add(card) db.session.commit() client.post(f'/cards/{card.id}/delete') res = client.get(f'/cards/{card.id}') self.assertEqual(res.status_code, 404)
def setUp(self): User.query.delete() new_user = User.register(username="******", password="******", email="*****@*****.**", first_name="Ted", last_name="Williams") db.session.add(new_user) db.session.commit() self.user_id = new_user.id Card.query.delete() new_card = Card.create(owner_id=self.user_id, player="Mickey Mantle", year=1952, set_name="Topps", number="311", desc="PSA 2") db.session.add(new_card) db.session.commit() self.user_id = new_user.id self.card_id = new_card.id
def seed_db(): jcom = User.register(username="******", password="******", first_name="Jon", last_name="Compton", email="*****@*****.**", has_img=True) klew = User.register(username="******", password="******", first_name="Kyle", last_name="Lewis", email="*****@*****.**", has_img=True) mgon = User.register(username="******", password="******", first_name="Marco", last_name="Gonzales", email="*****@*****.**") u4 = User.register(username="******", password="******", first_name="Kyle", last_name="Seager", email="*****@*****.**", has_img=True) u5 = User.register(username="******", password="******", first_name="Ty", last_name="France", email="*****@*****.**") u6 = User.register(username="******", password="******", first_name="Shed", last_name="Long", email="*****@*****.**", has_img=True) u7 = User.register(username="******", password="******", first_name="J.P.", last_name="Crawford", email="*****@*****.**", has_img=True) u8 = User.register(username="******", password="******", first_name="Dylan", last_name="Moore", email="*****@*****.**", has_img=True) u9 = User.register(username="******", password="******", first_name="Phil", last_name="Ervin", email="*****@*****.**", has_img=True) u10 = User.register(username="******", password="******", first_name="Justus", last_name="Sheffield", email="*****@*****.**", has_img=True) u11 = User.register(username="******", password="******", first_name="Justin", last_name="Dunn", email="*****@*****.**", has_img=True) u12 = User.register(username="******", password="******", first_name="Yusei", last_name="Kikuchi", email="*****@*****.**", has_img=True) u13 = User.register(username="******", password="******", first_name="Kendall", last_name="Graveman", email="*****@*****.**", has_img=True) u14 = User.register(username="******", password="******", first_name="Joe", last_name="Odom", email="*****@*****.**", has_img=True) u15 = User.register(username="******", password="******", first_name="Luis", last_name="Torrens", email="*****@*****.**", has_img=True) u16 = User.register(username="******", password="******", first_name="Jose", last_name="Marmolejos", email="*****@*****.**", has_img=True) u17 = User.register(username="******", password="******", first_name="Taylor", last_name="Trammell", email="*****@*****.**", has_img=True) u18 = User.register(username="******", password="******", first_name="Jarred", last_name="Kelenic", email="*****@*****.**", has_img=True) u19 = User.register(username="******", password="******", first_name="Joey", last_name="Gerber", email="*****@*****.**", has_img=True) u20 = User.register(username="******", password="******", first_name="Evan", last_name="White", email="*****@*****.**", has_img=True) u21 = User.register(username="******", password="******", first_name="Yosahiso", last_name="Hirano", email="*****@*****.**", has_img=True) u22 = User.register(username="******", password="******", first_name="Taijuan", last_name="Walker", email="*****@*****.**", has_img=True) u23 = User.register(username="******", password="******", first_name="Austin", last_name="Nola", email="*****@*****.**", has_img=True) u24 = User.register(username="******", password="******", first_name="Dee", last_name="Gordon", email="*****@*****.**", has_img=True) u25 = User.register(username="******", password="******", first_name="Nick", last_name="Margevicius", email="*****@*****.**", has_img=True) db.session.add_all([jcom, klew, mgon, u4, u5, u6, u7, u8, u9, u10, u11, u12, u13, u14, u15, u16, u17, u18, u19, u20, u21, u22, u23, u24, u25]) db.session.commit() acuna = Card.create(owner_id=jcom.id, player="Ronald Acuna Jr", year="2018", set_name="Topps Series 2", number="698", desc="PSA 10", has_img=True) tatis = Card.create(owner_id=jcom.id, player="Fernando Tatis Jr", year="2019", set_name="Topps Seris 2", number="410", desc="PSA 10", has_img=True) griffeyUD = Card.create(owner_id=klew.id, player="Ken Griffey Jr", year="1989", set_name="Upper Deck", number="1", desc="PSA 9", has_img=True) griffeyDon = Card.create(owner_id=klew.id, player="Ken Griffey Jr", year="1989", set_name="Donruss", number="33", desc="PSA 10", has_img=True) mantle56 = Card.create(owner_id=mgon.id, player="Mickey Mantle", year="1956", set_name="Topps", number="135", desc="PSA 5.5", has_img=True) mantle52 = Card.create(owner_id=mgon.id, player="Mickey Mantle", year="1952", set_name="Topps", number="311", desc="Authentic", has_img=True) mays52t = Card.create(owner_id=mgon.id, player="Willie Mays", year="1952", set_name="Topps", number="261", desc="PSA 4", has_img=True) mays53t = Card.create(owner_id=mgon.id, player="Willie Mays", year="1953", set_name="Topps", number="244", desc="Very Good", has_img=True) mays54b = Card.create(owner_id=mgon.id, player="Willie Mays", year="1954", set_name="Bowman", number="89", desc="Near Mint", has_img=True) aaron54t = Card.create(owner_id=mgon.id, player="Hank Aaron", year="1954", set_name="Topps", number="128", desc="PSA 7", has_img=True) clemente55t = Card.create(owner_id=mgon.id, player="Roberto Clemente", year="1955", set_name="Topps", number="164", desc="BVG 4", has_img=True) koufax55t = Card.create(owner_id=mgon.id, player="Sandy Koufax", year="1955", set_name="Topps", number="123", desc="PSA 6.5", has_img=True) mays55t = Card.create(owner_id=mgon.id, player="Willie Mays", year="1955", set_name="Topps", number="194", desc="VG-EX", has_img=True) ted56t = Card.create(owner_id=mgon.id, player="Ted Williams", year="1956", set_name="Topps", number="5", desc="PSA 6", has_img=True) ted57t = Card.create(owner_id=mgon.id, player="Ted Williams", year="1957", set_name="Topps", number="1", desc="PSA 7", has_img=True) ted58t = Card.create(owner_id=mgon.id, player="Ted Williams", year="1958", set_name="Topps", number="1", desc="PSA 8.5", has_img=True) musial48b = Card.create(owner_id=mgon.id, player="Stan Musial", year="1948", set_name="Bowman", number="36", desc="PSA 4", has_img=True) berra48b = Card.create(owner_id=mgon.id, player="Yogi Berra", year="1948", set_name="Bowman", number="6", desc="PSA 1 Poor", has_img=True) paige49b = Card.create(owner_id=mgon.id, player="Satchel Paige", year="1949", set_name="Bowman", number="224", desc="PSA 6 EX-MT", has_img=True) mays51b = Card.create(owner_id=mgon.id, player="Willie Mays", year="1951", set_name="Bowman", number="305", desc="PSA 4", has_img=True) mantle53b = Card.create(owner_id=mgon.id, player="Mickey Mantle", year="1953", set_name="Bowman", number="59", desc="PSA 5 EX", has_img=True) nolan68t = Card.create(owner_id=mgon.id, player="Nolan Ryan", year="1968", set_name="Topps", number="177", desc="PSA 7.5 NM+", has_img=True) munson70t = Card.create(owner_id=mgon.id, player="Thurman Munson", year="1970", set_name="Topps", number="189", desc="PSA 5", has_img=True) clem71t = Card.create(owner_id=mgon.id, player="Roberto Clemente", year="1971", set_name="Topps", number="630", desc="PSA 8", has_img=True) brock62t = Card.create(owner_id=mgon.id, player="Lou Brock", year="1962", set_name="Topps", number="387", desc="Excellent", has_img=True) yaz60t = Card.create(owner_id=mgon.id, player="Carl Yastrzemski", year="1960", set_name="Topps", number="148", desc="BVG 6", has_img=True) db.session.add_all([acuna, tatis, griffeyUD, griffeyDon, mantle52, mantle56, mays52t, mays53t, mays54b, aaron54t, clemente55t, koufax55t, mays55t, ted56t, ted57t, ted58t, musial48b, berra48b, paige49b, mays51b, mantle53b, nolan68t, munson70t, clem71t, brock62t, yaz60t]) db.session.commit() req1 = TradeRequest(from_id=1, to_id=2) req2 = TradeRequest(from_id=2, to_id=1) req3 = TradeRequest(from_id=2, to_id=3) req4 = TradeRequest(from_id=2, to_id=3) req5 = TradeRequest(from_id=3, to_id=1) req6 = TradeRequest(from_id=3, to_id=2) db.session.add_all([req1, req2, req3, req4, req5, req6]) db.session.commit() rc1 = RequestCard(request_id=1, card_id=2, requested=False) rc2 = RequestCard(request_id=1, card_id=3, requested=True) rc3 = RequestCard(request_id=2, card_id=3, requested=False) rc4 = RequestCard(request_id=2, card_id=4, requested=False) rc5 = RequestCard(request_id=2, card_id=1, requested=True) rc6 = RequestCard(request_id=3, card_id=3, requested=False) rc7 = RequestCard(request_id=3, card_id=4, requested=False) rc8 = RequestCard(request_id=3, card_id=5, requested=True) rc9 = RequestCard(request_id=4, card_id=4, requested=False) rc10 = RequestCard(request_id=4, card_id=6, requested=True) rc11 = RequestCard(request_id=5, card_id=5, requested=False) rc12 = RequestCard(request_id=5, card_id=1, requested=True) rc13 = RequestCard(request_id=6, card_id=5, requested=False) rc14 = RequestCard(request_id=6, card_id=3, requested=True) rc15 = RequestCard(request_id=6, card_id=4, requested=True) db.session.add_all([rc1, rc2, rc3, rc4, rc5, rc6, rc7, rc8, rc9, rc10, rc11, rc12, rc13, rc14, rc15]) db.session.commit()