Package org.springframework.jdbc.object

Examples of org.springframework.jdbc.object.BatchSqlUpdate.declareParameter()

41
42
43
44
45
46
47
48
49
50
51
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("mbid", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("county_code", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("start_year", Types.SMALLINT));
    batchUpdate.declareParameter(new SqlParameter("active", Types.BOOLEAN));
   
    for (MBArtist artist : artists) {
      batchUpdate.update(new Object[]{artist.getName(), artist.getMbid(),
          artist.getCountryCode(), artist.getStartYear(), artist.isActive()});
    }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
  public void createTags(List<String> tags) {
    String sql = "insert into music.tag (tag_name) select distinct (?)"
        + " where not exists (select 1 from music.tag where tag_name = ?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));

    for (String tag : tags) {
      batchUpdate.update(new Object[]{tag, tag});
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
    String sql = "insert into music.tag (tag_name) select distinct (?)"
        + " where not exists (select 1 from music.tag where tag_name = ?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));

    for (String tag : tags) {
      batchUpdate.update(new Object[]{tag, tag});
    }
    batchUpdate.flush();
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    sql = "update music.tag t set corrected_id = tc.id"
        + " from music.tag tc where t.tag_name = ? and tc.tag_name = ?";

    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("t.tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("tc.tag_name", Types.VARCHAR));

    for (String tag : tagCorrections.keySet()) {
      batchUpdate.update(new Object[]{tag, tagCorrections.get(tag)});
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
        + " from music.tag tc where t.tag_name = ? and tc.tag_name = ?";

    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("t.tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("tc.tag_name", Types.VARCHAR));

    for (String tag : tagCorrections.keySet()) {
      batchUpdate.update(new Object[]{tag, tagCorrections.get(tag)});
    }
    batchUpdate.flush();
View Full Code Here
219
220
221
222
223
224
225
226
227
228
229
  private void batchInsert(String tagName, List<Artist> artists) {
    String sql = "insert into music.tagtopartist_import (tag_name, artist_name, rank) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));

    for (int i = 0; i < artists.size(); i++) {
      batchUpdate.update(new Object[]{tagName, artists.get(i).getName(), i});
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
  private void batchInsert(String tagName, List<Artist> artists) {
    String sql = "insert into music.tagtopartist_import (tag_name, artist_name, rank) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));

    for (int i = 0; i < artists.size(); i++) {
      batchUpdate.update(new Object[]{tagName, artists.get(i).getName(), i});
    }
View Full Code Here
221
222
223
224
225
226
227
228
229
230
231
    String sql = "insert into music.tagtopartist_import (tag_name, artist_name, rank) values (?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("tag_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));

    for (int i = 0; i < artists.size(); i++) {
      batchUpdate.update(new Object[]{tagName, artists.get(i).getName(), i});
    }
    batchUpdate.flush();
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    String sql = "insert into music.userrecommendedartist_import"
        + " (lastfm_user, artist_name, rank, contextartist1_name, contextartist2_name)"
        + " values (?,?,?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("lastfm_user", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));
    batchUpdate.declareParameter(new SqlParameter("contextartist1_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("contextartist2_name", Types.VARCHAR));
   
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
        + " (lastfm_user, artist_name, rank, contextartist1_name, contextartist2_name)"
        + " values (?,?,?,?,?)";
    BatchSqlUpdate batchUpdate = new BatchSqlUpdate(jdbcTemplate.getDataSource(), sql);
    batchUpdate.setBatchSize(1000);
    batchUpdate.declareParameter(new SqlParameter("lastfm_user", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("artist_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("rank", Types.INTEGER));
    batchUpdate.declareParameter(new SqlParameter("contextartist1_name", Types.VARCHAR));
    batchUpdate.declareParameter(new SqlParameter("contextartist2_name", Types.VARCHAR));
   
    for (int i = 0; i < artists.size(); i++) {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.