Esempio n. 1
0
 private void createMissingTickets(Event event) {
   int existingTickets = ticketRepository.countExistingTicketsForEvent(event.getId());
   if (existingTickets < event.getAvailableSeats()) {
     MapSqlParameterSource[] tickets =
         EventUtil.generateEmptyTickets(
                 event, new Date(), event.getAvailableSeats() - existingTickets)
             .toArray(MapSqlParameterSource[]::new);
     jdbc.batchUpdate(ticketRepository.bulkTicketInitialization(), tickets);
   }
 }
Esempio n. 2
0
 void fillTicketsGender() {
   List<String> ticketIds =
       jdbc.queryForList(
           "select uuid from ticket where status not in ('FREE','PENDING', 'PRE_RESERVED') and gender is null and tshirt_size is not null",
           new EmptySqlParameterSource(),
           String.class);
   ticketIds.forEach(
       uuid ->
           transactionTemplate.execute(
               status -> {
                 Ticket ticket = ticketRepository.findByUUID(uuid);
                 String gender = ticket.getTshirtSize().endsWith("-F") ? "F" : "M";
                 jdbc.update(
                     "update ticket set gender = :gender where uuid = :uuid",
                     new MapSqlParameterSource("uuid", uuid).addValue("gender", gender));
                 return null;
               }));
 }