@SqlQuery("SELECT value FROM resource_groups_global_properties WHERE name = 'cpu_quota_period'") @UseRowMapper(ResourceGroupGlobalProperties.Mapper.class) List<ResourceGroupGlobalProperties> getResourceGroupGlobalProperties();
static RowMapper<?> rowMapperFor(UseRowMapper annotation) { Class<? extends RowMapper<?>> mapperClass = annotation.value(); try { return mapperClass.getConstructor().newInstance(); } catch (Exception e) { throw new UnableToCreateStatementException("Could not create mapper " + mapperClass.getName(), e, null); } }
@SqlQuery("SELECT resource_group_id, name, soft_memory_limit, max_queued, soft_concurrency_limit, " + " hard_concurrency_limit, scheduling_policy, scheduling_weight, jmx_export, soft_cpu_limit, " + " hard_cpu_limit, parent\n" + "FROM resource_groups\n" + "WHERE environment = :environment\n") @UseRowMapper(ResourceGroupSpecBuilder.Mapper.class) List<ResourceGroupSpecBuilder> getResourceGroups(@Bind("environment") String environment);
@SqlQuery("SELECT S.resource_group_id, S.priority, S.user_regex, S.source_regex, S.query_type, S.client_tags, S.selector_resource_estimate\n" + "FROM selectors S\n" + "JOIN resource_groups R ON (S.resource_group_id = R.resource_group_id)\n" + "WHERE R.environment = :environment\n" + "ORDER by priority DESC") @UseRowMapper(SelectorRecord.Mapper.class) List<SelectorRecord> getSelectors(@Bind("environment") String environment);
@SqlQuery("select id, name from something order by id desc") @UseRowMapper(SomethingMapper.class) void forEach(Consumer<Something> consumer);
@SqlQuery("" + "SELECT\n" + " suite\n" + ", name\n" + ", test_catalog\n" + ", test_schema\n" + ", test_prequeries\n" + ", test_query\n" + ", test_postqueries\n" + ", test_username\n" + ", test_password\n" + ", control_catalog\n" + ", control_schema\n" + ", control_prequeries\n" + ", control_query\n" + ", control_postqueries\n" + ", control_username\n" + ", control_password\n" + ", session_properties_json\n" + "FROM verifier_queries\n" + "WHERE suite = :suite\n" + "ORDER BY id\n" + "LIMIT :limit") @UseRowMapper(QueryPairMapper.class) List<QueryPair> getQueriesBySuite(@Bind("suite") String suite, @Bind("limit") int limit); }
@SqlQuery("all-something") @UseRowMapper(SomethingMapper.class) List<Something> findAll(); }
@SqlQuery("select * from something where id=:id") @UseRowMapper(SomethingMapper.class) Something get(long id); }
@SqlQuery("select name, id from something") @UseRowMapper(CrashingMapper.class) Iterator<Something> crashOnFirstRead();
@SqlQuery("select id, name from something order by id desc") @UseRowMapper(SomethingMapper.class) Stream<Something> stream();
@SqlQuery("select * from crash now") @UseRowMapper(SomethingMapper.class) Iterator<Something> crashNow();
@SqlQuery("select name, id from something") @UseRowMapper(SomethingMapper.class) ResultIterator<Something> findAll();
@SqlBatch("insert into something(name) values (:name)") @GetGeneratedKeys({"id", "created_on"}) @UseRowMapper(IdCreateTimeMapper.class) List<IdCreateTime> insertBatch(String... name); }
@SqlQuery("select id, name from something where id = :id") @UseRowMapper(SomethingMapper.class) Something findById(@Bind("id") int id); }
@SqlUpdate("insert into something(name) values (:name)") @GetGeneratedKeys({"id", "created_on"}) @UseRowMapper(IdCreateTimeMapper.class) IdCreateTime insert(String name);
@SqlQuery("select id, name from something where id = :id") @UseRowMapper(SomethingMapper.class) Something byId(@Bind("id") long id);
@SqlQuery("select id, name from something where id = :id") @UseRowMapper(SomethingMapper.class) ResultIterable<Something> findByIdWithExplicitMapper(@Bind("id") int id); }
@SqlQuery("select id, name from something where id = :id") @UseRowMapper(SomethingMapper.class) Something byId(@Bind("id") long id);
@SqlQuery("select id, name from something where id = :id") @UseRowMapper(SomethingMapper.class) Something byId(@Bind("id") long id);
@SqlQuery("select id, name from something where id = :it.id") @UseRowMapper(SomethingMapper.class) Something findSame(@BindSomething("it") Something something);