use of com.gianlu.pyxreborn.Models.BlackCard in project PretendYoureXyzzyReborn by devgianlu.
the class CardsDB method loadBlackCards.
/**
* Loads all the black cards.
*/
private Map<Integer, BlackCard> loadBlackCards(Statement statement) throws SQLException {
Map<Integer, BlackCard> blackCards = new HashMap<>();
try (ResultSet result = statement.executeQuery("SELECT * FROM black_cards")) {
while (result.next()) {
BlackCard card = new BlackCard(result.getInt("id"), result.getString("text"), result.getString("watermark"), result.getInt("draw"), result.getInt("pick"));
blackCards.put(card.id, card);
}
}
return blackCards;
}
use of com.gianlu.pyxreborn.Models.BlackCard in project PretendYoureXyzzyReborn by devgianlu.
the class PyxCard method initialize.
@FXML
public void initialize() {
this.text.setText(card.text);
this.watermark.setText(card.watermark);
if (card instanceof BlackCard) {
// Black card
setBackground(new Background(new BackgroundFill(Color.BLACK, new CornerRadii(8), Insets.EMPTY)));
this.text.setTextFill(Color.WHITE);
this.watermark.setTextFill(Color.WHITE);
} else {
// White card
setBackground(new Background(new BackgroundFill(Color.WHITE, new CornerRadii(8), Insets.EMPTY)));
this.text.setTextFill(Color.BLACK);
this.watermark.setTextFill(Color.BLACK);
}
}
use of com.gianlu.pyxreborn.Models.BlackCard 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;
}
Aggregations