@SqlBatch("INSERT INTO keys (number, device_id, key_id, public_key, last_resort) VALUES " + "(:number, :device_id, :key_id, :public_key, :last_resort)") abstract void append(@PreKeyBinder List<KeyRecord> preKeys);
@SqlBatch void create(@SmartBindBean Iterable<RolledUpUsageModelDao> usages, @SmartBindBean final InternalCallContext context);
@Override @SqlBatch("MERGE INTO deleted_shards (shard_uuid, delete_time)\n" + "VALUES (:shardUuid, CURRENT_TIMESTAMP)") void insertDeletedShards(@Bind("shardUuid") Iterable<UUID> shardUuids);
@Override @SqlBatch("INSERT IGNORE INTO deleted_shards (shard_uuid, delete_time)\n" + "VALUES (:shardUuid, CURRENT_TIMESTAMP)") void insertDeletedShards(@Bind("shardUuid") Iterable<UUID> shardUuids);
@SqlBatch("insert into users (id, type, login, avatar_url, created_at, updated_at) " + "values (:id, :type, :login, :avatarUrl, current_timestamp(), current_timestamp()) " + "on duplicate key update login=values(login), avatar_url=values(avatar_url), updated_at=values(updated_at)") @BatchChunkSize(100) void bulkInsert(@BindBean List<User> users);
@SqlBatch("insert into repository_ranks (stargazers_count, rank, created_at, updated_at) " + "values (:stargazersCount, :rank, current_timestamp(), current_timestamp())") @BatchChunkSize(5000) void bulkInsert(@BindBean List<RepositoryRank> repoRanks); }
@SqlBatch("insert into repositories " + "(id, owner_id, name, full_name, description, fork, homepage, stargazers_count, language, created_at, updated_at, fetched_at) " + "values (:id, :ownerId, :name, :fullName, :description, :fork, :homepage, :stargazersCount, :language, current_timestamp(), current_timestamp(), current_timestamp()) " + "on duplicate key update " + "owner_id=values(owner_id), name=values(name), full_name=values(full_name), description=values(description), homepage=values(homepage), stargazers_count=values(stargazers_count), language=values(language), updated_at=values(updated_at), fetched_at=values(fetched_at)") @BatchChunkSize(100) void bulkInsert(@BindBean List<Repository> repos);
@SqlBatch("insert into user_ranks (stargazers_count, rank, created_at, updated_at) " + "values (:stargazersCount, :rank, current_timestamp(), current_timestamp())") @BatchChunkSize(5000) void bulkInsert(@BindBean List<UserRank> userRanks); }
@SqlBatch("insert into organization_ranks (stargazers_count, rank, created_at, updated_at) " + "values (:stargazersCount, :rank, current_timestamp(), current_timestamp())") @BatchChunkSize(5000) void bulkInsert(@BindBean List<OrganizationRank> orgRanks); }
@SqlBatch void insertEntries(@SmartBindBean Iterable<T> evts, @Define("tableName") final String tableName); }
@SqlBatch ( "UPDATE <type> " + "SET position = :position " + "WHERE entity_id = :entity.id " ) void updatePositions(@Define("type") String type, @BindBean("entity") List<E> entity, @Bind("position") List<Integer> position); }
@SqlBatch @BatchChunkSize(1000) void bulkInsertTimelineChunks(@TimelineChunkBinder Iterator<TimelineChunk> chunkIterator, @InternalTenantContextBinder final InternalCallContext context);
@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);
@SqlBatch("insert into table (a) values (:a)") public int getNames(@Bind("a") String a); }
@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);
@SqlBatch(transactional = false) @Audited(ChangeType.INSERT) void batchCreateFromTransaction(@BindBean final List<InvoicePaymentModelDao> items, @BindBean final InternalCallContext context);
@SqlBatch("insert into something (name) values (:it)") @GetGeneratedKeys public int[] insert(@Bind List<String> names);
@SqlBatch("insert into something (id, name) values (:id, :first || ' ' || :last)") void insertFamily(@Bind("id") List<Integer> ids, @Bind("first") Iterator<String> firstNames, @Bind("last") String lastName);
@SqlBatch("insert into something (id, name) values (:id, :first || ' ' || :last)") @BatchChunkSize(2) void insertFamily(@Bind("id") List<Integer> ids, @Bind("first") Iterator<String> firstNames, @Bind("last") String lastName);
@SqlBatch("insert into something (id, name) values (:id, :first || ' ' || :last)") @BatchChunkSize(2) void insertFamily(@Bind("id") List<Integer> ids, @Bind("first") Iterator<String> firstNames, @Bind("last") String lastName);