org.skife.jdbi.v2.sqlobject.SqlBatch Java Examples

The following examples show how to use org.skife.jdbi.v2.sqlobject.SqlBatch. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example #1

Source File: H2ShardDao.java From presto with Apache License 2.0

4 votes

@Override
@SqlBatch("MERGE INTO deleted_shards (shard_uuid, delete_time)\n" +
        "VALUES (:shardUuid, CURRENT_TIMESTAMP)")
void insertDeletedShards(@Bind("shardUuid") Iterable<UUID> shardUuids);

Example #2

Source File: MySqlShardDao.java From presto with Apache License 2.0

4 votes

@Override
@SqlBatch("INSERT IGNORE INTO deleted_shards (shard_uuid, delete_time)\n" +
        "VALUES (:shardUuid, CURRENT_TIMESTAMP)")
void insertDeletedShards(@Bind("shardUuid") Iterable<UUID> shardUuids);

Example #3

Source File: ShardDao.java From presto with Apache License 2.0

4 votes

@SqlBatch("DELETE FROM shard_nodes\n" +
        "WHERE shard_id = (SELECT shard_id FROM shards WHERE shard_uuid = :shardUuid)\n" +
        "  AND node_id = :nodeId")
void deleteShardNodes(@Bind("shardUuid") UUID shardUuid, @Bind("nodeId") Iterable<Integer> nodeId);

Example #4

Source File: ShardDao.java From presto with Apache License 2.0

4 votes

@SqlBatch("DELETE FROM created_shards WHERE shard_uuid = :shardUuid")
void deleteCreatedShards(@Bind("shardUuid") Iterable<UUID> shardUuids);

Example #5

Source File: ShardDao.java From presto with Apache License 2.0

4 votes

@SqlBatch("DELETE FROM deleted_shards WHERE shard_uuid = :shardUuid")
void deleteCleanedShards(@Bind("shardUuid") Iterable<UUID> shardUuids);

Example #6

Source File: ShardDao.java From presto with Apache License 2.0

4 votes

@SqlBatch("INSERT INTO buckets (distribution_id, bucket_number, node_id)\n" +
        "VALUES (:distributionId, :bucketNumber, :nodeId)\n")
void insertBuckets(
        @Bind("distributionId") long distributionId,
        @Bind("bucketNumber") List<Integer> bucketNumbers,
        @Bind("nodeId") List<Integer> nodeIds);

Example #7

Source File: MonitorTaskDao.java From SAPNetworkMonitor with GNU General Public License v3.0

4 votes

@SqlBatch("INSERT INTO SNM_MONITOR_TASK(MONITOR_ID, TASK_ID) VALUES (:monitorId, :taskId)")
@BatchChunkSize(1000)
void insertMonitorTask(@Bind("monitorId")List<String> monitorIds, @Bind("taskId") String taskId);

Example #8

Source File: IStoragePostgreSql.java From cassandra-reaper with Apache License 2.0

4 votes

@SqlBatch(SQL_INSERT_REPAIR_SEGMENT)
@BatchChunkSize(500)
void insertRepairSegments(@BindBean Iterator<PostgresRepairSegment> iterator);

Example #9

Source File: JobTableDAO.java From airpal with Apache License 2.0

4 votes

@SqlBatch(
        "INSERT INTO job_tables (job_id, table_id) " +
                "VALUES (:jobId, :tableId)")
public void createJobTables(@BindBean Iterable<JobTableRow> jobTableRows);

Example #10

Source File: TableDAO.java From airpal with Apache License 2.0

4 votes

@SqlBatch(
        "INSERT INTO tables (connector_id, schema_, table_, columns) " +
        "VALUES (:connectorId, :schema, :table, :columns)")
@GetGeneratedKeys
public abstract void createTables(@RosettaBinder Iterable<Table> tables);