本文整理汇总了Java中org.skife.jdbi.v2.PreparedBatch.execute方法的典型用法代码示例。如果您正苦于以下问题:Java PreparedBatch.execute方法的具体用法?Java PreparedBatch.execute怎么用?Java PreparedBatch.execute使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.skife.jdbi.v2.PreparedBatch
的用法示例。
在下文中一共展示了PreparedBatch.execute方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: createSetConsumer
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;
}
};
}
示例2: loadAlleleCodes
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();
}
}
示例3: suspendIntoFlatVertexTable
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();
}
示例4: suspendIntoFlatEdgeTable
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();
}
示例5: deleteDepartments
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();
}
}
示例6: updateDepartments
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();
}
}
示例7: insertDepartments
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();
}
}
示例8: createSetConsumer
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;
}
};
}
示例9: loadPGroups
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();
}
}
示例10: loadGGroups
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();
}
}
示例11: loadAlleles
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();
}
}
示例12: loadImmuneGroups
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();
}
}
示例13: loadCsv
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();
}
}
示例14: putAll
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();
}
示例15: putAll
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();
}