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