List of usage examples for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource
public MapSqlParameterSource()
From source file:com.epam.catgenome.dao.reference.ReferenceGenomeDao.java
@Transactional(propagation = Propagation.MANDATORY) public Reference createReferenceGenome(final Reference reference) { final MapSqlParameterSource params = new MapSqlParameterSource(); params.addValue(GenomeParameters.REFERENCE_GENOME_ID.name(), reference.getId()); params.addValue(GenomeParameters.BIO_DATA_ITEM_ID.name(), reference.getBioDataItemId()); params.addValue(GenomeParameters.SIZE.name(), reference.getSize()); params.addValue(GenomeParameters.INDEX_ID.name(), reference.getIndex().getId()); params.addValue(GenomeParameters.GENE_ITEM_ID.name(), reference.getGeneFile() != null ? reference.getGeneFile().getId() : null); getNamedParameterJdbcTemplate().update(createReferenceGenomeQuery, params); return reference; }
From source file:com.epam.catgenome.dao.vcf.VcfFileDao.java
/** * Saves sample metadata to the database. * * @param samples {@code List<Sample>} samples to save * @param vcfFileId {@code long} file ID to save samples for */// w ww . j a v a2 s.co m @Transactional(propagation = Propagation.MANDATORY) public void createSamples(List<VcfSample> samples, long vcfFileId) { List<Long> sampleIds = daoHelper.createIds(vcfSampleSequenceName, samples.size()); for (int i = 0; i < samples.size(); i++) { samples.get(i).setId(sampleIds.get(i)); } final List<MapSqlParameterSource> params = new ArrayList<>(); for (VcfSample sample : samples) { MapSqlParameterSource param = new MapSqlParameterSource(); param.addValue(SampleParameters.VCF_SAMPLE_ID.name(), sample.getId()); param.addValue(SampleParameters.VCF_ID.name(), vcfFileId); param.addValue(SampleParameters.SAMPLE_NAME.name(), sample.getName()); param.addValue(SampleParameters.ORDER_INDEX.name(), sample.getIndex()); params.add(param); } getNamedParameterJdbcTemplate().batchUpdate(createSamplesForFileQuery, params.toArray(new MapSqlParameterSource[params.size()])); }
From source file:org.aksw.gerbil.database.ExperimentDAOImpl.java
private void connectToExperiment(String experimentId, Integer taskId) { MapSqlParameterSource parameters = new MapSqlParameterSource(); parameters.addValue("id", experimentId); parameters.addValue("taskId", taskId); this.template.update(CONNECT_TASK_EXPERIMENT, parameters); }
From source file:com.perry.infrastructure.call.CallDaoServiceImpl.java
@Override public Call edit(Call call) { String sql = "UPDATE calls set customer_first_name = :customerFirstName, \r\n" + // " customer_last_name = :customerLastName, \r\n" + // " pick_up_location = :pickUpLocation, \r\n" + // " drop_off_location =:dropOffLocation, \r\n" + // " customer_vehicle_year=:customerVehicleYear, \r\n" + // " customer_vehicle_make=:customerVehicleMake, \r\n" + // " customer_vehicle_model= :customerVehicleModel, \r\n" + // " customer_vehicle_color=:customerVehicleColor, \r\n" + // " customer_vehicle_license_plate_number=:customerVehicleLiscensePlateNumber, \r\n" + // " customer_phone_number=:customerPhoneNumber, \r\n" + // " customer_vehicle_key_location=:customerVehicleKeyLocation, \r\n" + // " customer_call_type=:customerCallType, \r\n" + // " customer_payment_information=:customerPaymentInformation, \r\n" + // " insert_by=:insertBy, \r\n" + // " update_by=:updateBy, \r\n" + // " update_time=:updateTime WHERE call_id = :callId"; MapSqlParameterSource params = new MapSqlParameterSource(); params.addValue("customerFirstName", call.getCustomer().getFirstName()); params.addValue("customerLastName", call.getCustomer().getLastName()); params.addValue("pickUpLocation", call.getPickUpLocation()); params.addValue("dropOffLocation", call.getDropOffLocation()); params.addValue("customerVehicleYear", call.getCustomer().getVehicle().getYear()); params.addValue("customerVehicleMake", call.getCustomer().getVehicle().getMake()); params.addValue("customerVehicleModel", call.getCustomer().getVehicle().getMake()); params.addValue("customerVehicleColor", call.getCustomer().getVehicle().getColor()); params.addValue("customerVehicleLiscensePlateNumber", call.getCustomer().getVehicle().getLicensePlateNumber()); params.addValue("customerPhoneNumber", call.getCustomer().getPhoneNumber()); params.addValue("customerVehicleKeyLocation", call.getCustomer().getVehicle().getKeyLocationType().getValue()); params.addValue("customerCallType", call.getCallType().getValue()); params.addValue("customerPaymentInformation", call.getCustomer().getVehicle().getMake()); params.addValue("insertBy", 1); params.addValue("updateBy", 1); params.addValue("updateTime", Instant.now().getEpochSecond()); params.addValue("callId", call.getId()); GeneratedKeyHolder keyHolder = new GeneratedKeyHolder(); namedParameterJdbcTemplate.update(sql, params, keyHolder); // update call with primary key returned from DB call.setId((Long) keyHolder.getKeys().get("call_id")); return call;//w ww. ja v a 2 s. c o m }
From source file:org.mulima.internal.freedb.FreeDbJdbcDaoImpl.java
/** * Adds the tracks for the disc id.//from ww w .j a v a2 s . c o m * @param discId the disc's id * @param tracks the tracks to add */ private void addTracks(int discId, SortedSet<Track> tracks) { logger.trace("Entering addTracks"); final String sql = "INSERT INTO `tracks` VALUES(null, :disc_id, :num, :title)"; MapSqlParameterSource[] trackParms = new MapSqlParameterSource[tracks.size()]; int i = 0; for (Track track : tracks) { trackParms[i] = new MapSqlParameterSource(); trackParms[i].addValue("disc_id", discId); trackParms[i].addValue("num", track.getNum()); trackParms[i].addValue("title", track.getFlat(GenericTag.TITLE)); i++; } this.getNamedParameterJdbcTemplate().batchUpdate(sql, trackParms); logger.trace("Exiting addTracks"); }
From source file:com.joliciel.talismane.terminology.postgres.PostGresTerminologyBase.java
void addParents(List<Term> childTerms) { NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource()); String sql = "SELECT " + SELECT_TERM + ", term_expansion_id FROM term" + " INNER JOIN text ON term_text_id=text_id" + " INNER JOIN term_expansions ON term_id = termexp_term_id" + " WHERE term_project_id = :term_project_id" + " AND termexp_expansion_id IN (:child_terms)"; MapSqlParameterSource paramSource = new MapSqlParameterSource(); paramSource.addValue("term_project_id", this.getCurrentProjectId()); List<Integer> termIds = new ArrayList<Integer>(); Map<Integer, PostGresTerm> childTermMap = new HashMap<Integer, PostGresTerm>(); for (Term childTerm : childTerms) { PostGresTerm termInternal = (PostGresTerm) childTerm; if (termInternal.getParentsInternal() == null) { termIds.add(termInternal.getId()); termInternal.setParentsInternal(new TreeSet<Term>()); childTermMap.put(termInternal.getId(), termInternal); }/*from ww w . j a v a 2s .co m*/ } paramSource.addValue("child_terms", termIds); LOG.trace(sql); LogParameters(paramSource); SqlRowSet rs = jt.queryForRowSet(sql, paramSource); TermMapper termMapper = new TermMapper(); List<Term> parentTerms = new ArrayList<Term>(); while (rs.next()) { Term term = termMapper.mapRow(rs); parentTerms.add(term); int childId = rs.getInt("termexp_expansion_id"); PostGresTerm childTerm = childTermMap.get(childId); childTerm.getParentsInternal().add(term); } if (parentTerms.size() > 0) { this.addParents(parentTerms); } }
From source file:com.joliciel.lefff.LefffDaoImpl.java
public void deleteAttribute(int attributeId) { NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource()); MapSqlParameterSource paramSource = new MapSqlParameterSource(); String sql = "DELETE FROM lef_attribute WHERE attribute_id = :attribute_id"; paramSource.addValue("attribute_id", attributeId); LOG.info(sql);/* ww w. j a v a2s .c o m*/ LefffDaoImpl.LogParameters(paramSource); jt.update(sql, paramSource); }
From source file:com.joliciel.jochre.security.SecurityDaoJdbc.java
@Override public Parameters loadParameters(int parametersId) { NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource()); String sql = "SELECT " + SELECT_PARAM + " FROM ocr_param WHERE param_id=:param_id"; MapSqlParameterSource paramSource = new MapSqlParameterSource(); paramSource.addValue("param_id", parametersId); LOG.info(sql);//from w ww.java2 s.c o m logParameters(paramSource); Parameters parameters = null; try { parameters = (Parameters) jt.queryForObject(sql, paramSource, new ParametersMapper(this.getSecurityServiceInternal())); } catch (EmptyResultDataAccessException ex) { ex.hashCode(); } return parameters; }
From source file:com.team3637.service.TeamServiceMySQLImpl.java
@Override public void mergeTags(String oldTag, String newTag) { SqlParameterSource args = new MapSqlParameterSource().addValue("tableName", "teams") .addValue("noTagCols", 4).addValue("oldTag", oldTag).addValue("newTag", newTag); mergeTags.execute(args);/*from w w w. ja v a 2 s . c o m*/ }
From source file:org.aksw.gerbil.database.ExperimentDAOImpl.java
private MapSqlParameterSource createTaskParameters(String annotatorName, String datasetName, String experimentType, String matching) { MapSqlParameterSource parameters = new MapSqlParameterSource(); parameters.addValue("annotatorName", annotatorName); parameters.addValue("datasetName", datasetName); parameters.addValue("experimentType", experimentType); parameters.addValue("matching", matching); return parameters; }