How to use

org.skife.jdbi.v2.sqlobject.customizers.Mapper

constructor

@Mapper(AccountMapper.class)
@SqlQuery("SELECT * FROM accounts")
public abstract Iterator<Account> getAll();

@Mapper(AccountMapper.class)
@SqlQuery("SELECT * FROM accounts ORDER BY " + NUMBER + " LIMIT :limit")
public abstract List<Account> getAllFrom(@Bind("limit") int length);

@Mapper(StoredVerificationCodeMapper.class)
@SqlQuery("SELECT verification_code, timestamp FROM pending_accounts WHERE number = :number")
StoredVerificationCode getCodeForNumber(@Bind("number") String number);

@Mapper(AccountMapper.class)
@SqlQuery("SELECT * FROM accounts WHERE " + NUMBER + " = :number")
public abstract Account get(@Bind("number") String number);

@Mapper(StoredVerificationCodeMapper.class)
@SqlQuery("SELECT verification_code, timestamp FROM pending_devices WHERE number = :number")
StoredVerificationCode getCodeForNumber(@Bind("number") String number);

@SqlQuery("SELECT DISTINCT ON (number, device_id) * FROM keys WHERE number = :number ORDER BY number, device_id, key_id ASC")
@Mapper(PreKeyMapper.class)
abstract List<KeyRecord> retrieveFirst(@Bind("number") String number);

@Mapper(AbusiveHostRuleMapper.class)
@SqlQuery("SELECT * FROM abusive_host_rules WHERE :host::inet <<= " + HOST)
public abstract List<AbusiveHostRule> getAbusiveHostRulesFor(@Bind("host") String host);

@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(AccountMapper.class)
@SqlQuery("SELECT * FROM accounts OFFSET :offset LIMIT :limit")
abstract List<Account> getAll(@Bind("offset") int offset, @Bind("limit") int length);

@SqlQuery("SELECT * FROM keys WHERE number = :number AND device_id = :device_id ORDER BY key_id ASC FOR UPDATE")
@Mapper(PreKeyMapper.class)
abstract KeyRecord retrieveFirst(@Bind("number") String number, @Bind("device_id") long deviceId);

@Mapper(AccountMapper.class)
@SqlQuery("SELECT * FROM accounts WHERE " + NUMBER + " > :from ORDER BY " + NUMBER + " LIMIT :limit")
public abstract List<Account> getAllFrom(@Bind("from") String from, @Bind("limit") int length);

@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);

@SqlQuery("SELECT schema_name, table_name, data\n" +
    "FROM views\n" +
    "WHERE (schema_name = :schemaName OR :schemaName IS NULL)")
@Mapper(SchemaTableNameMapper.class)
List<SchemaTableName> listViews(
    @Bind("schemaName") String schemaName);

@SqlQuery("SELECT table_id, last_start_time\n" +
    "   FROM shard_organizer_jobs\n" +
    "   WHERE node_identifier = :nodeIdentifier")
@Mapper(TableOrganizationInfo.Mapper.class)
Set<TableOrganizationInfo> getNodeTableOrganizationInfo(@Bind("nodeIdentifier") String nodeIdentifier);

@SqlQuery("SELECT schema_name, table_name\n" +
    "FROM tables\n" +
    "WHERE (schema_name = :schemaName OR :schemaName IS NULL)")
@Mapper(SchemaTableNameMapper.class)
List<SchemaTableName> listTables(
    @Bind("schemaName") String schemaName);

@SqlQuery("SELECT table_id, last_start_time\n" +
    "   FROM shard_organizer_jobs\n" +
    "   WHERE node_identifier = :nodeIdentifier")
@Mapper(TableOrganizationInfo.Mapper.class)
Set<TableOrganizationInfo> getNodeTableOrganizationInfo(@Bind("nodeIdentifier") String nodeIdentifier);

@SqlQuery("SELECT schema_name, table_name\n" +
    "FROM tables\n" +
    "WHERE (schema_name = :schemaName OR :schemaName IS NULL)")
@Mapper(SchemaTableNameMapper.class)
List<SchemaTableName> listTables(
    @Bind("schemaName") String schemaName);

@SqlQuery("SELECT schema_name, table_name, data\n" +
    "FROM views\n" +
    "WHERE (schema_name = :schemaName OR :schemaName IS NULL)")
@Mapper(SchemaTableNameMapper.class)
List<SchemaTableName> listViews(
    @Bind("schemaName") String schemaName);