def change_user_cards(request):

    rand = random_utils.get_random_number()

    cards_rare = (
        cartas_mtg.all()
        .filter("raridade =", "Rare")
        .filter("disponivel =", True)
        .filter("importance =", 13)
        .filter("random_number > ", rand)
        .fetch(10)
    )

    if len(cards_rare) < 10:
        cards_rare = cards_rare + cartas_mtg.all().filter("raridade =", "Rare").filter("disponivel =", True).filter(
            "importance =", 12
        ).filter("random_number > ", rand).fetch(10 - len(cards_rare))
    if len(cards_rare) < 10:
        cards_rare = cards_rare + cartas_mtg.all().filter("raridade =", "Rare").filter("disponivel =", True).filter(
            "importance =", 11
        ).filter("random_number > ", rand).fetch(10 - len(cards_rare))
    if len(cards_rare) < 10:
        cards_rare = cards_rare + cartas_mtg.all().filter("raridade =", "Rare").filter("disponivel =", True).filter(
            "importance =", 10
        ).filter("random_number > ", rand).fetch(10 - len(cards_rare))
    if len(cards_rare) < 10:
        cards_rare = cards_rare + cartas_mtg.all().filter("raridade =", "Rare").filter("disponivel =", True).filter(
            "importance =", 1
        ).filter("random_number > ", rand).fetch(10 - len(cards_rare))

    cards_uncommon = (
        cartas_mtg.all()
        .filter("raridade =", "Uncommon")
        .filter("disponivel =", True)
        .filter("importance =", 9)
        .filter("random_number > ", rand)
        .fetch(5)
    )
    if len(cards_uncommon) < 5:
        cards_uncommon = cards_uncommon + cartas_mtg.all().filter("raridade =", "Uncommon").filter(
            "disponivel =", True
        ).filter("importance =", 8).filter("random_number > ", rand).fetch(5 - len(cards_uncommon))
    if len(cards_uncommon) < 5:
        cards_uncommon = cards_uncommon + cartas_mtg.all().filter("raridade =", "Uncommon").filter(
            "disponivel =", True
        ).filter("importance =", 7).filter("random_number > ", rand).fetch(5 - len(cards_uncommon))
    if len(cards_uncommon) < 5:
        cards_uncommon = cards_uncommon + cartas_mtg.all().filter("raridade =", "Uncommon").filter(
            "disponivel =", True
        ).filter("importance =", 6).filter("random_number > ", rand).fetch(5 - len(cards_uncommon))
    if len(cards_uncommon) < 5:
        cards_uncommon = cards_uncommon + cartas_mtg.all().filter("raridade =", "Uncommon").filter(
            "disponivel =", True
        ).filter("importance =", 5).filter("random_number > ", rand).fetch(5 - len(cards_uncommon))
    if len(cards_uncommon) < 5:
        cards_uncommon = cards_uncommon + cartas_mtg.all().filter("raridade =", "Uncommon").filter(
            "disponivel =", True
        ).filter("importance =", 1).filter("random_number > ", rand).fetch(5 - len(cards_uncommon))

    cards_common = (
        cartas_mtg.all()
        .filter("raridade =", "Common")
        .filter("disponivel =", True)
        .filter("importance =", 4)
        .filter("random_number > ", rand)
        .fetch(5)
    )
    if len(cards_common) < 5:
        cards_common = cards_common + cartas_mtg.all().filter("raridade =", "Common").filter(
            "disponivel =", True
        ).filter("importance =", 3).filter("random_number > ", rand).fetch(5 - len(cards_common))
    if len(cards_common) < 5:
        cards_common = cards_common + cartas_mtg.all().filter("raridade =", "Common").filter(
            "disponivel =", True
        ).filter("importance =", 2).filter("random_number > ", rand).fetch(5 - len(cards_common))
    if len(cards_common) < 5:
        cards_common = cards_common + cartas_mtg.all().filter("raridade =", "Common").filter(
            "disponivel =", True
        ).filter("importance =", 1).filter("random_number > ", rand).fetch(5 - len(cards_common))

    cards = cards_rare + cards_uncommon + cards_common

    if len(cards) == 20:
        # delete
        q = user_cards.all().fetch(20)
        for card in q:
            card.delete()

            # add
        for card in cards:
            card_toAdd = user_cards(name_card=card.nome)
            card_toAdd.put()

    return HttpResponse("sucess")
def add_card_to_db(request):

    name = ""
    colour = ""
    cost = ""
    type = ""
    power_resistance = ""
    text = ""
    rarity = ""
    edition = ""
    quantidade = None
    importancia = None

    try:
        name = request.POST["name"]
        colour = request.POST["colour"]
        cost = request.POST["cost"]
        type = request.POST["type"]
        power_resistance = request.POST["power_resistance"]
        text = request.POST["text"]
        rarity = request.POST["rarity"]
        edition = request.POST["edition"]
        quantidade = int(request.POST["stock"])
        importancia = int(request.POST["importance"])

    except:
        return HttpResponse("Erro nos dados da carta " + name)

    if len(text) > 500:
        logging.info(name)
        text = text[:500]

        # cleans % from text
    text = text.replace("%", "")

    if rarity == "R" or rarity == "R // R":
        rarity = "Rare"

    if rarity == "M" or rarity == "M // M":
        rarity = "Mytic"

    if rarity == "U" or rarity == "U // U":
        rarity = "Uncommon"

    if rarity == "C" or rarity == "C // C":
        rarity = "Common"

    carta_comparacao = cartas_mtg.all().filter("nome =", name).filter("edicao =", edition).get()

    if carta_comparacao != None:
        return HttpResponse("Carta jah existe " + name)

    card = cartas_mtg(
        nome=name,
        cor=colour,
        custo=cost,
        tipo=type,
        poder_resistencia=power_resistance,
        texto=text,
        raridade=rarity,
        random_number=random_utils.get_random_number(),
        stock=int(quantidade),
        importance=int(importancia),
        edicao=edition,
    )

    card.put_DB()

    return HttpResponse("Success")