Example usage for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource

List of usage examples for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.namedparam.*
  5. MapSqlParameterSource
  6. MapSqlParameterSource

Introduction

In this page you can find the example usage for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource.

Prototype

public MapSqlParameterSource(String paramName, @Nullable Object value)

Source Link

Document

Create a new MapSqlParameterSource, with one value comprised of the supplied arguments.

Usage

From source file:com.epam.catgenome.dao.reference.ReferenceGenomeDao.java

/**
 * Loads a persisted {@code Reference} entity from the database by a specified Biological dataItemID
 * @param itemID {@code Reference} Biological DataItemID to load
 * @return loaded {@code Reference} instance
 */// w ww  .java  2  s. c  o  m
@Transactional(propagation = Propagation.MANDATORY)
public Reference loadReferenceGenomeByBioItemId(final Long itemID) {
    final List<Reference> list = getNamedParameterJdbcTemplate().query(loadReferenceGenomeByBioIdQuery,
            new MapSqlParameterSource(GenomeParameters.BIO_DATA_ITEM_ID.name(), itemID),
            GenomeParameters.getReferenceGenomeMapper());
    return CollectionUtils.isNotEmpty(list) ? list.get(0) : null;
}

From source file:alfio.manager.system.DataMigrator.java

void fillReservationsLanguage() {
    transactionTemplate.execute(s -> {
        jdbc.queryForList("select id from tickets_reservation where user_language is null",
                new EmptySqlParameterSource(), String.class).forEach(id -> {
                    MapSqlParameterSource param = new MapSqlParameterSource("reservationId", id);
                    String language = optionally(() -> jdbc.queryForObject(
                            "select user_language from ticket where tickets_reservation_id = :reservationId limit 1",
                            param, String.class)).orElse("en");
                    jdbc.update(/*from  w w  w .j  a  v  a 2  s.co  m*/
                            "update tickets_reservation set user_language = :userLanguage where id = :reservationId",
                            param.addValue("userLanguage", language));
                });
        return null;
    });
}

From source file:tds.assessment.repositories.impl.ItemQueryRepositoryImpl.java

@Override
public List<Item> findItemsForSegment(final String segmentKey) {
    SqlParameterSource parameters = new MapSqlParameterSource("segmentKey", segmentKey);

    String SQL = "SELECT" + "   item._key AS itemId,\n" + "   item.itemtype,\n"
            + "   item.scorepoint AS maxScore, \n" + "   item.itemid AS clientId, \n"
            + "   item._efk_item AS itemKey, \n" + "   item._efk_itembank AS bankKey, \n"
            + "   formItem.formposition AS formPosition, \n" + "   adminItems.groupid,\n"
            + "   adminItems.groupkey,\n" + "   adminItems.blockid, \n"
            + "   adminItems.itemposition AS position,\n" + "   adminItems.isfieldtest,\n"
            + "   adminItems.isrequired, \n" + "   adminItems.strandname, \n"
            + "   adminItems.responseMimeType, \n" + "   adminItems.notForScoring, \n"
            + "   adminItems._fk_Item AS itemkey, \n" + "   adminItems.isActive, "
            + "   upper(adminItems.IRT_Model) AS irtModel, \n" + "   adminItems.IRT_b AS irtB, \n"
            + "   adminItems.IRT_a AS irtA, \n" + "   adminItems.IRT_c AS irtC, \n"
            + "   adminItems.bVector, \n" + "   adminItems.clString, \n" + "   adminItems.isPrintable \n"
            + "FROM \n" + "   itembank.tblsetofadminitems AS adminItems \n" + "JOIN \n"
            + "   itembank.tblitem item \n" + "   ON item._key = adminItems._fk_item \n" + "LEFT JOIN \n"
            + "   itembank.testformitem formItem \n" + "   ON formItem._fk_item = item._key \n"
            + "   AND formItem._fk_adminsubject = adminItems._fk_adminsubject \n" + "WHERE \n"
            + "   adminItems._fk_AdminSubject = :segmentKey";

    return jdbcTemplate.query(SQL, parameters, (rs, rowNum) -> {
        Item item = new Item(rs.getString("itemId"));
        item.setItemType(rs.getString("itemtype"));
        item.setGroupId(rs.getString("groupid"));
        item.setGroupKey(rs.getString("groupkey"));
        item.setBlockId((rs.getString("blockid")));
        item.setPosition(rs.getInt("position"));
        item.setFormPosition(rs.getInt("formPosition"));
        item.setFieldTest(rs.getBoolean("isfieldtest"));
        item.setRequired(rs.getBoolean("isrequired"));
        item.setStrand(rs.getString("strandname"));
        item.setPrintable(rs.getBoolean("isprintable"));
        item.setMimeType(rs.getString("responseMimeType"));
        item.setMaxScore(rs.getInt("maxScore"));
        item.setClientId(rs.getString("clientId"));
        item.setNotForScoring(rs.getBoolean("notForScoring"));
        item.setbVector(rs.getString("bVector"));
        item.setItemResponseTheoryModel(rs.getString("irtModel"));
        item.setItemResponseTheoryAParameter((Float) rs.getObject("irtA"));
        item.setItemResponseTheoryBParameter(rs.getString("irtB"));
        item.setItemResponseTheoryCParameter((Float) rs.getObject("irtC"));
        item.setClaims(rs.getString("clString"));
        item.setActive(rs.getBoolean("isActive"));
        item.setItemKey(rs.getLong("itemKey"));
        item.setBankKey(rs.getLong("bankKey"));

        return item;
    });//  ww w .  j  a va2  s.c  o m
}

From source file:io.lavagna.service.CardRepository.java

public Map<String, Integer> findCardsIds(List<String> cards) {

    List<Object[]> param = new ArrayList<>(cards.size());
    for (String card : cards) {
        String[] splitted = StringUtils.split(card, '-');
        if (splitted.length > 1) {
            try {
                Integer cardSequenceNumber = Integer.valueOf(splitted[splitted.length - 1], 10);
                String boardShortName = StringUtils.join(ArrayUtils.subarray(splitted, 0, splitted.length - 1),
                        '-');
                param.add(new Object[] { boardShortName, cardSequenceNumber });

            } catch (NumberFormatException nfe) {
                // skip
            }/* www .  jav  a  2  s. c  o m*/
        }
    }

    if (param.isEmpty()) {
        return Collections.emptyMap();
    }

    final Map<String, Integer> res = new HashMap<>();
    MapSqlParameterSource paramS = new MapSqlParameterSource("projShortNameAndCardSeq", param);
    jdbc.query(queries.findCardsIs(), paramS, new RowCallbackHandler() {
        @Override
        public void processRow(ResultSet rs) throws SQLException {
            res.put(rs.getString("CARD_IDENTIFIER"), rs.getInt("CARD_ID"));
        }
    });

    return res;
}

From source file:tds.assessment.repositories.impl.AssessmentQueryRepositoryImpl.java

@Override
public Optional<SegmentMetadata> findSegmentMetadata(final String segmentKey) {
    final SqlParameterSource parameters = new MapSqlParameterSource("segmentKey", segmentKey);

    final String SQL = "SELECT \n" + "  _key, \n" + "  virtualtest, \n" + "  _fk_testadmin \n" + "FROM \n"
            + "  tblsetofadminsubjects \n" + "WHERE \n" + "  _key = :segmentKey";

    Optional<SegmentMetadata> maybeSegmentMetadata;
    try {/*from  w  ww .j  a v  a 2 s . c  o m*/
        maybeSegmentMetadata = Optional.of(jdbcTemplate.queryForObject(SQL, parameters,
                (resultSet, i) -> new SegmentMetadata(resultSet.getString("_key"),
                        resultSet.getString("virtualtest"), resultSet.getString("_fk_testadmin"))));
    } catch (EmptyResultDataAccessException e) {
        maybeSegmentMetadata = Optional.empty();
    }

    return maybeSegmentMetadata;
}

From source file:com.exploringspatial.dao.impl.ConflictDaoImpl.java

@Override
public int delete(final Long eventId) {
    final String sql = "DELETE FROM CONFLICT WHERE EVENT_ID_NO_CNTY = :eventId ";
    final MapSqlParameterSource params = new MapSqlParameterSource("eventId", eventId);
    return namedParameterJdbcTemplate.update(sql, params);
}

From source file:io.lavagna.service.CardLabelRepository.java

@Transactional(readOnly = false)
public void moveLabelListValueToOrder(int valueId, int order) {
    LabelListValue value = findListValueById(valueId);
    if (value.getOrder() == order) {
        return;/*from  w w w  . j  av a 2 s . c  o  m*/
    }

    List<LabelListValueWithMetadata> currentValues = findListValuesByLabelId(value.getCardLabelId());
    LabelListValueWithMetadata rval = currentValues.remove(value.getOrder() - 1);
    currentValues.add(order - 1, rval);
    List<SqlParameterSource> vals = new ArrayList<>();
    int currentOrder = 1;
    for (LabelListValue llv : currentValues) {
        if (llv.getOrder() != currentOrder) {
            vals.add(new MapSqlParameterSource("id", llv.getId()).addValue("order", currentOrder));
        }
        currentOrder++;
    }

    jdbc.batchUpdate(queries.updateLabelListValueOrder(), vals.toArray(new SqlParameterSource[vals.size()]));
}

From source file:tds.assessment.repositories.impl.AssessmentWindowQueryRepositoryImpl.java

@Override
public Optional<AssessmentFormWindowProperties> findAssessmentFormWindowProperties(final String clientName,
        final String assessmentId) {
    final MapSqlParameterSource parameters = new MapSqlParameterSource("clientName", clientName)
            .addValue("assessmentId", assessmentId).addValue("sessionType", ONLINE_SESSION_TYPE);

    //NOTE - sessionType is always 0 for the online application
    String SQL = "SELECT " + "   requireRTSFormWindow AS requireFormWindow, \n"
            + "   RTSFormField AS formField, \n" + "   requireRTSForm AS requireForm, \n"
            + "   requireRTSformIfExists AS ifexists \n" + "FROM configs.client_testproperties T \n"
            + "JOIN configs.client_testmode M ON \n" + "   T.clientname = M.clientname AND \n"
            + "   T.testid = M.testid \n" + "WHERE T.clientname = :clientName \n"
            + "   AND T.TestID = :assessmentId \n"
            + "   AND (M.sessionType = -1 OR M.sessionType = :sessionType);";

    Optional<AssessmentFormWindowProperties> maybeAssessmentProperties = Optional.empty();

    try {//from   w w  w.  ja v a2 s . com
        final AssessmentFormWindowProperties properties = jdbcTemplate.queryForObject(SQL, parameters,
                (rs, rowNum) -> new AssessmentFormWindowProperties(rs.getBoolean("requireForm"),
                        rs.getBoolean("ifexists"), rs.getString("formField"),
                        rs.getBoolean("requireFormWindow")));

        maybeAssessmentProperties = Optional.of(properties);
    } catch (EmptyResultDataAccessException e) {
        LOG.debug("Could not find assessment property for client %s and assessment %s", clientName,
                assessmentId);
    }

    return maybeAssessmentProperties;
}

From source file:io.lavagna.service.CardLabelRepository.java

@Transactional(readOnly = false)
public void swapLabelListValues(int first, int second) {
    LabelListValue firstValue = findListValueById(first);
    LabelListValue secondValue = findListValueById(second);
    SqlParameterSource p1 = new MapSqlParameterSource("id", firstValue.getId()).addValue("order",
            secondValue.getOrder());/*w ww  .ja  va 2 s  .co m*/
    SqlParameterSource p2 = new MapSqlParameterSource("id", secondValue.getId()).addValue("order",
            firstValue.getOrder());
    jdbc.batchUpdate(queries.updateLabelListValueOrder(), new SqlParameterSource[] { p1, p2 });
}