@SqlQuery("SELECT value FROM resource_groups_global_properties WHERE name = 'cpu_quota_period'") @UseRowMapper(ResourceGroupGlobalProperties.Mapper.class) List<ResourceGroupGlobalProperties> getResourceGroupGlobalProperties();
@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);
/** * Returns the most specific exact-match selector for a given environment, source and query type. * NULL values in the environment and query type fields signify wildcards. */ @SqlQuery("SELECT resource_group_id\n" + "FROM exact_match_source_selectors\n" + "WHERE source = :source\n" + " AND (environment = :environment OR environment IS NULL)\n" + " AND (query_type = :query_type OR query_type IS NULL)\n" + "ORDER BY environment IS NULL, query_type IS NULL\n" + "LIMIT 1") String getExactMatchResourceGroup( @Bind("environment") String environment, @Bind("source") String source, @Bind("query_type") String queryType); }
@Override @SqlQuery("select * from something where id = :id") @RegisterBeanMapper(Something.class) Something get(long id); }
@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("select t.name as teamName, " + " t.mascot as mascot, " + " p.name as personName, " + " p.role as role " + "from team t inner join person p on (t.name = p.team)") @RegisterBeanMapper(TeamPersonJoinRow.class) Iterator<TeamPersonJoinRow> findAllTeamsAndPeople();
@SqlQuery("select u.id u_id, u.name u_name, p.id p_id, p.phone p_phone " + "from user u left join phone p on u.id = p.user_id") @RegisterConstructorMapper(value = User.class, prefix = "u") @RegisterConstructorMapper(value = Phone.class, prefix = "p") Map<User, Phone> getMap(); // end::joinRow[]
@SqlQuery("select u.id u_id, u.name u_name, p.id p_id, p.phone p_phone " + "from user u left join phone p on u.id = p.user_id") @RegisterConstructorMapper(value = User.class, prefix = "u") @RegisterConstructorMapper(value = Phone.class, prefix = "p") Multimap<User, Phone> getMultimap(); // end::joinRowMultimap[]
@SqlQuery("select name from stuff order by id") @Reversed @SingleValue List<String> singleRow(); }
@SqlQuery("select * from beans where id = :id") @RegisterConstructorMapper(Bean.class) @RegisterColumnMapper(ValueTypeMapper.class) Bean getById(int id); }
@SqlQuery("select key, value from config") @KeyColumn("key") @ValueColumn("value") Map<String, String> getAll(); // end::keyValue[]
@MaxRows(ROWS) @SqlQuery(QUERY) @RegisterRowMapper(MapMapper.class) List<Map<String, Object>> bar(); }
@MaxRows(0) @SqlQuery(QUERY) @RegisterRowMapper(MapMapper.class) List<Map<String, Object>> bar(); }
@SqlQuery("select * from column_mappers") @RegisterColumnMapper(StringValueColumnMapper.class) @RegisterColumnMapper(LongValueColumnMapper.class) @RegisterConstructorMapper(ValueTypeEntity.class) List<ValueTypeEntity> list(); }
@SqlQuery("select * from column_mappers") @RegisterColumnMapperFactory(StringValueColumnMapperFactory.class) @RegisterColumnMapperFactory(LongValueColumnMapperFactory.class) @RegisterConstructorMapper(ValueTypeEntity.class) List<ValueTypeEntity> list(); }
@Override @UseRowMapper(SomethingMapper.class) @SqlQuery("select id, name from something where id = :id") Something insertAndReturn(@Bind int id, @Bind String name); }
@SqlQuery("select f.id f_id, f.name f_name, " + "d.id d_id, d.name d_name, d.contents d_contents " + "from folders f left join documents d " + "on f.id = d.folder_id " + "where f.id = :folderId") @RegisterBeanMapper(value = Folder.class, prefix = "f") @RegisterBeanMapper(value = Document.class, prefix = "d") @UseRowReducer(FolderDocReducer.class) Optional<Folder> getFolder(int folderId);
@SqlQuery("select * from column_mappers") @RegisterRowMapperFactory(StringValueRowMapperFactory.class) @RegisterRowMapperFactory(LongValueRowMapperFactory.class) @RegisterJoinRowMapper({StringValue.class, LongValue.class}) List<JoinRow> list(); }
@SqlQuery("select * from something") @RegisterRowMapper(SomethingMapper.class) default List<Something> list() { return getHandle().createQuery("select * from something") .map(new SomethingMapper()) .list(); } }