def remove_player_card(player_id, card_id):
"""Function removes a card from a player's deck"""
query = """
delete from MonsterCards.UserCards
where CardID = %s and UserID = %s;
"""
execute(query, (card_id, player_id))
def add_player_card(playerId, cardId):
"""Function adds a card to a player's deck"""
query = """
INSERT INTO MonsterCards.UserCards (UserID, CardID)
VALUES (%s, %s);
"""
execute(query, (playerId, cardId))
def edit_card(card_id, pic_bin, attrs=None, name=None):
"""Function edits an existing card"""
if (name is None):
insert_blob = """
update MonsterCards.Cards
set ImgData = %s, Attributes = %s
where ID = %s;"""
card_id = execute(insert_blob, (pic_bin, attrs, card_id),
insert=True)[0][0]
return card_id
else:
insert_blob = """
update MonsterCards.Cards
set Name = %s, ImgData = %s, Attributes = %s
where ID = %s;"""
card_id = execute(insert_blob, (name, pic_bin, attrs, card_id),
insert=True)[0][0]
return card_id
def new_card(pic_bin, attrs=None, name=None):
"""Function creates a new card"""
insert_blob = """
INSERT INTO MonsterCards.Cards
(Name, ImgData, Attributes)
VALUES (%s, %s, %s);"""
print(type(pic_bin))
card_id = execute(insert_blob, (name, pic_bin, attrs), insert=True)[0][0]
return card_id
def get_card(card_id):
"""Function gets a card"""
query = """
select ID, Name, ImgData, Attributes
from MonsterCards.Cards
where ID = %s;
"""
card = execute(query, (card_id, ))[0]
return card
def get_site_deck():
"""Function gets the site's deck"""
query = """
select ID, Name, Attributes from MonsterCards.Cards
where ID >= 14 and ID <= 42;
"""
cards = execute(query, ())
dict_cards = []
for card_id, card_name, card_attr in cards:
card = {"id": card_id, "name": card_name, "attr": card_attr}
dict_cards.append(card)
return dict_cards
def get_player_deck(playerId):
"""Function gets a player's deck based on their ID"""
query = """
select CardID, Name, Attributes from MonsterCards.UserCards
inner join MonsterCards.Cards
on CardID = ID
where UserID = %s;
"""
cards = execute(query, (playerId, ))
dict_cards = []
for card_id, card_name, card_attr in cards:
card = {"id": card_id, "name": card_name, "attr": card_attr}
dict_cards.append(card)
return dict_cards