Java PreparedBatch.execute方法代码示例

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
public Consumer<JsonRecord> createSetConsumer() {
    return r -> {
        PreparedBatch insert = getInsertBatch();
        insert.bind("path", r.getPath())
            .bind("value", r.getValue())
            .bind("kind", r.getKind())
            .bind("idx", r.getIndex())
            .add();

        batchSize += r.getPath().length() + r.getValue().length();
        if (batchSize > 512 * 1024) { // Write the batch once we have enough data.
            insert.execute();
            batchSize = 0;
        }
    };
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
@Override
public void loadAlleleCodes(Iterator<AlleleCodeRow> rowIter, boolean reload) {
       try (Handle handle = dbi.open()) {
           if (reload) {
               handle.createStatement("delete from allele_code").execute();
           }
           PreparedBatch batch = handle.prepareBatch("insert or ignore into allele_code(allele_code, allele, family_included) values (?, ?, ?)");
           long i = 0;
           while (rowIter.hasNext()) {
           	AlleleCodeRow g = rowIter.next();
           	batch.add(g.getCode(), g.getAllele(), g.isGeneric());
           	if (0 == ++i % 10000L) {
           		logger.debug("committing " + i + " rows...");
           		batch.execute();
           	}
           }
           if (0 != i % 1000L) batch.execute();
       }
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
public void suspendIntoFlatVertexTable(Long sessId, State state, String table, Set<AmberVertex> set) {
    Set<String> fields = getFields(set, state);
    String sql = String.format("INSERT INTO %s (s_id, state, id, txn_start, txn_end %s) values (:s_id, :state, :id, :txn_start, :txn_end %s)",
            table,
            StringUtils.join(format(fields, ", %s"), ' '),
            StringUtils.join(format(fields, ", :%s"), ' '));

    Handle h = getHandle();
    PreparedBatch preparedBatch = h.prepareBatch(sql);
    for (AmberVertex v: set) {
        PreparedBatchPart preparedBatchPart = preparedBatch.add();
        preparedBatchPart.bind("s_id",       sessId);
        preparedBatchPart.bind("state",      state.name());
        preparedBatchPart.bind("id",         v.getId());
        preparedBatchPart.bind("txn_start",  v.getTxnStart());
        preparedBatchPart.bind("txn_end",    v.getTxnEnd());
        if (state != DEL) {
            for (String field: fields) {
                bindField(v, preparedBatchPart, field);
            }
        }
    }
    preparedBatch.execute();
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
public void suspendIntoFlatEdgeTable(Long sessId, State state, Set<AmberEdge> set) {
    String sql = "INSERT INTO sess_flatedge (s_id, state, id, txn_start, txn_end, v_out, v_in, edge_order, label) values (:s_id, :state, :id, :txn_start, :txn_end, :v_out, :v_in, :edge_order, :label)";

    Handle h = getHandle();
    PreparedBatch preparedBatch = h.prepareBatch(sql);
    for (AmberEdge v: set) {
        PreparedBatchPart preparedBatchPart = preparedBatch.add();
        preparedBatchPart.bind("s_id",       sessId);
        preparedBatchPart.bind("state",      state.name());
        preparedBatchPart.bind("id",         v.getId());
        preparedBatchPart.bind("txn_start",  v.getTxnStart());
        preparedBatchPart.bind("txn_end",    v.getTxnEnd());
        preparedBatchPart.bind("v_out",      v.getOutId());
        preparedBatchPart.bind("v_in",       v.getInId());
        preparedBatchPart.bind("edge_order", v.getOrder());
        preparedBatchPart.bind("label",      v.getLabel());
    }
    preparedBatch.execute();

}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
@Override
public void deleteDepartments(List<Department> departmentsToDelete) {
    try (Handle h = dbi.open()) {
        PreparedBatch preparedBatch = h.prepareBatch("DELETE FROM department WHERE pid = :pid");

        for (Department department : departmentsToDelete) {
            preparedBatch.bind("pid", department.getPid()).add();
        }

        preparedBatch.execute();
    }
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
@Override
public void updateDepartments(List<Department> departmentsToUpdate) {
    try (Handle h = dbi.open()) {
        PreparedBatch preparedBatch = h.prepareBatch("UPDATE department SET company_pid = :company_pid, name = :name WHERE pid = :pid");
        for (Department department : departmentsToUpdate) {
            preparedBatch
                    .bind("company_pid", department.getCompanyPid())
                    .bind("name", department.getName())
                    .bind("pid", department.getPid())
                    .add();
        }
        preparedBatch.execute();
    }
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
@Override
public void insertDepartments(List<Department> departmentsToInsert) {
    try (Handle h = dbi.open()) {
        PreparedBatch preparedBatch = h.prepareBatch("INSERT INTO department (company_pid, name) VALUES (:company_pid, :name)");
        for (Department department : departmentsToInsert) {
            preparedBatch
                    .bind("company_pid", department.getCompanyPid())
                    .bind("name", department.getName())
                    .add();
        }
        preparedBatch.execute();
    }
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
public Consumer<JsonRecord> createSetConsumer() {
    return r -> {
        PreparedBatch insert = getInsertBatch();
        insert.bind("path", r.getPath())
            .bind("value", r.getValue())
            .bind("kind", r.getKind())
            .add();

        batchSize += r.getPath().length() + r.getValue().length();
        if (batchSize > 512 * 1024) { // Write the batch once we have enough data.
            insert.execute();
            batchSize = 0;
        }
    };
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
/**
 * {@inheritDoc}
 */
@Override
public void loadPGroups(Iterator<GroupRow<String>> rowIter, boolean reload) {
	try (Handle handle = dbi.open()) {
		if (reload) {
			handle.createStatement("delete from hla_p_group").execute();
		}
		PreparedBatch batch = handle.prepareBatch("insert or ignore into hla_p_group(p_group, locus, allele) values (?, ?, ?)");
		rowIter.forEachRemaining(g -> batch.add(g.getGroup(), g.getLocus(), g.getAllele()));
		batch.execute();
	}
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
/**
 * {@inheritDoc}
 */
@Override
public void loadGGroups(Iterator<GroupRow<String>> rowIter, boolean reload) {
	try (Handle handle = dbi.open()) {
		if (reload) {
			handle.createStatement("delete from hla_g_group").execute();
		}
		PreparedBatch batch = handle.prepareBatch("insert or ignore into hla_g_group(g_group, locus, allele) values (?, ?, ?)");
		rowIter.forEachRemaining(g -> batch.add(g.getGroup(), g.getLocus(), g.getAllele()));
		batch.execute();
	}
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
/**
 * {@inheritDoc} 
 */
@Override
public void loadAlleles(Iterator<AlleleRow> rowIter, boolean reload) {
    try (Handle handle = dbi.open()) {
        if (reload) {
            handle.createStatement("delete from hla_allele").execute();
        }
        PreparedBatch batch = handle.prepareBatch("insert or ignore into hla_allele(locus, allele) values (?, ?)");
        rowIter.forEachRemaining(g -> batch.add(g.getLocus(), g.getAllele()));
        batch.execute();
    }
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
/** 
 * {@inheritDoc} 
 */
@Override
public void loadImmuneGroups(Iterator<GroupRow<Integer>> rowIter, boolean reload) {
    try (Handle handle = dbi.open()) {
        if (reload) {
            handle.createStatement("delete from allele_group").execute();
        }
        PreparedBatch batch = handle.prepareBatch("insert or ignore into allele_group(locus, allele, immune_group) values (?, ?, ?)");
        rowIter.forEachRemaining(g -> batch.add(g.getLocus(), g.getAllele(), g.getGroup()));
        batch.execute();
    }
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
public static void loadCsv(Connection conn, String sql, String csvResource) throws Exception {
    log.debug("csvResource: " + csvResource);
    URL csvUrl = DbUtil.class.getClassLoader().getResource(csvResource);
    log.debug("csvUrl: " + csvUrl);
	try (Handle handle = DBI.open(conn)) {
		PreparedBatch batch = handle.prepareBatch(sql);
		Iterator<Object[]> it = readCsv(csvUrl);
		while (it.hasNext()) {
		    Object[] row = it.next();
		    log.trace("row: " + Arrays.toString(row));
			batch.add(row);
		}
		batch.execute();
	}
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
@Override
public void putAll(@Nullable Map<? extends K, ? extends V> map) {
    final PreparedBatch batch = handle.prepareBatch(String.format("REPLACE INTO %1$s (row_field, column_field, value_field) VALUES (:row_field, :column_field, :value_field)", tableName));

    for (Map.Entry<? extends K, ? extends V> entry : map.entrySet()) {
        final SelectionMap valueMap = selectionMapFactory.get(entry.getKey());
        batch.add()
                .bindFromMap(selectionMap.asMap())
                .bindFromMap(valueMap.asMap())
                .bind("value_field", entry.getValue());
    }

    batch.execute();
}
 

import org.skife.jdbi.v2.PreparedBatch; //导入方法依赖的package包/类
@Override
public void putAll(@Nullable Table<? extends byte[], ? extends byte[], ? extends byte[]> table) {
    final PreparedBatch batch = handle.prepareBatch(String.format("REPLACE INTO %s VALUES (:row_field, :column_field, :value_field)", tableName));

    for (Table.Cell<? extends byte[], ? extends byte[], ? extends byte[]> cell : table.cellSet()) {
        batch.add()
                .bind("row_field", cell.getRowKey())
                .bind("column_field", cell.getColumnKey())
                .bind("value_field", cell.getValue());
    }

    batch.execute();
}