Refine search
@Mapper(MessageMapper.class) @SqlQuery("SELECT * FROM messages WHERE " + DESTINATION + " = :destination AND " + DESTINATION_DEVICE + " = :destination_device ORDER BY " + TIMESTAMP + " ASC LIMIT " + RESULT_SET_CHUNK_SIZE) abstract List<OutgoingMessageEntity> load(@Bind("destination") String destination, @Bind("destination_device") long destinationDevice);
@Mapper(MessageMapper.class) @SqlQuery("DELETE FROM messages WHERE "+ ID + " IN (SELECT " + ID + " FROM MESSAGES WHERE " + GUID + " = :guid AND " + DESTINATION + " = :destination ORDER BY " + ID + " LIMIT 1) RETURNING *") abstract OutgoingMessageEntity remove(@Bind("destination") String destination, @Bind("guid") UUID guid);
@Mapper(MessageMapper.class) @SqlQuery("DELETE FROM messages WHERE " + ID + " IN (SELECT " + ID + " FROM messages WHERE " + DESTINATION + " = :destination AND " + DESTINATION_DEVICE + " = :destination_device AND " + SOURCE + " = :source AND " + TIMESTAMP + " = :timestamp ORDER BY " + ID + " LIMIT 1) RETURNING *") abstract OutgoingMessageEntity remove(@Bind("destination") String destination, @Bind("destination_device") long destinationDevice, @Bind("source") String source, @Bind("timestamp") long timestamp);
@SqlQuery("SELECT b.bucket_number, n.node_identifier\n" + "FROM buckets b\n" + "JOIN nodes n ON (b.node_id = n.node_id)\n" + "WHERE b.distribution_id = :distributionId\n" + "ORDER BY b.bucket_number") @Mapper(BucketNode.Mapper.class) List<BucketNode> getBucketNodes(@Bind("distributionId") long distributionId);