@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 valueType as obj_value_type from testBean") @RegisterFieldMapper(value = TestObject.class, prefix = "obj_") List<TestObject> listBeansPrefix(); }
@SqlQuery("select id, name from something where (id, name) in (${keys})") List<Something> get(@BindBeanList(value = "keys", propertyNames = {"id", "name"}) SomethingKey... blarg); }
@SqlQuery("select id, name from something where (id, name) in (<keys>)") List<Something> get(@BindBeanList(value = "keys", propertyNames = {"id", "name"}) SomethingKey... blarg); }
@SqlQuery("select subject from subjects") @Json List<JsonBean> select(); }
@SqlQuery(SELECT_BY_PROPERTY_NAME) @RegisterRowMapperFactory(JpaMapperFactory.class) List<FieldThing> list(); }
@SqlQuery(SELECT_BY_PROPERTY_NAME) @RegisterRowMapperFactory(JpaMapperFactory.class) List<GetterThing> list(); }
@SqlQuery(SELECT_BY_PROPERTY_NAME) @RegisterRowMapperFactory(JpaMapperFactory.class) List<ExtendsMappedSuperclassThing> list(); }
@SqlQuery("select * from something where id = :id") @RegisterRowMapperFactory(JpaMapperFactory.class) QualifiedGetterThing get(int id); }
@SqlQuery("select ordinal from enums") @EnumByOrdinal Foo select(); }
@SqlQuery("select valueType as bean_value_type from testBean") @RegisterBeanMapper(value = TestBean.class, prefix = "bean_") List<TestBean> listBeansPrefix(); }
@SqlQuery("select * from something where id = :id") @RegisterConstructorMapper(QualifiedConstructorParamThing.class) QualifiedConstructorParamThing getConstructorInjected(int id); }
@SqlQuery(SELECT_BY_ANNOTATION_NAME) @RegisterRowMapperFactory(JpaMapperFactory.class) List<NamedFieldThing> list(); }
@SqlQuery(SELECT_BY_ANNOTATION_NAME) @RegisterRowMapperFactory(JpaMapperFactory.class) List<NamedGetterThing> list(); }