Examples with WhiteCard com.gianlu.pyxreborn.Models.WhiteCard used on opensource projects

Example 1 with WhiteCard

use of com.gianlu.pyxreborn.Models.WhiteCard in project PretendYoureXyzzyReborn by devgianlu.

the class CardsDB method loadWhiteCards.

/**
 * Loads all the white cards.
 */
private Map<Integer, WhiteCard> loadWhiteCards(Statement statement) throws SQLException {
    Map<Integer, WhiteCard> whiteCards = new HashMap<>();
    try (ResultSet result = statement.executeQuery("SELECT * FROM white_cards")) {
        while (result.next()) {
            WhiteCard card = new WhiteCard(result.getInt("id"), result.getString("text"), result.getString("watermark"));
            whiteCards.put(card.id, card);
        }
    }
    return whiteCards;
}

Example 2 with WhiteCard

use of com.gianlu.pyxreborn.Models.WhiteCard in project PretendYoureXyzzyReborn by devgianlu.

the class CardsDB method loadCardSets.

/**
 * Loads all the card sets in the database.
 */
public CardSets loadCardSets() throws SQLException {
    CardSets sets = new CardSets();
    try (Statement statement = db.createStatement()) {
        try (ResultSet result = statement.executeQuery("SELECT * FROM card_set")) {
            while (result.next()) {
                sets.add(new CardSet(result.getInt("id"), result.getInt("active") == 1, result.getString("name"), result.getInt("base_deck") == 1, result.getString("description"), result.getInt("weight")));
            }
        }
        Map<Integer, WhiteCard> whiteCards = loadWhiteCards(statement);
        for (CardSet set : sets) {
            try (ResultSet result = statement.executeQuery("SELECT white_card_id FROM card_set_white_card WHERE card_set_id=" + set.id)) {
                while (result.next()) {
                    set.whiteCards.add(whiteCards.get(result.getInt("white_card_id")));
                }
            }
        }
        Map<Integer, BlackCard> blackCards = loadBlackCards(statement);
        for (CardSet set : sets) {
            try (ResultSet result = statement.executeQuery("SELECT black_card_id FROM card_set_black_card WHERE card_set_id=" + set.id)) {
                while (result.next()) {
                    set.blackCards.add(blackCards.get(result.getInt("black_card_id")));
                }
            }
        }
    }
    sets.sort(new CardSets.WeightComparator());
    return sets;
}