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