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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@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 vote down vote up
@SqlBatch(
        "INSERT INTO tables (connector_id, schema_, table_, columns) " +
        "VALUES (:connectorId, :schema, :table, :columns)")
@GetGeneratedKeys
public abstract void createTables(@RosettaBinder Iterable<Table> tables);