当前位置: 首页>>代码示例>>Java>>正文


Java SingleValueResult类代码示例

本文整理汇总了Java中org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult的典型用法代码示例。如果您正苦于以下问题:Java SingleValueResult类的具体用法?Java SingleValueResult怎么用?Java SingleValueResult使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。


SingleValueResult类属于org.skife.jdbi.v2.sqlobject.customizers包,在下文中一共展示了SingleValueResult类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: lower

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
/**
	 * Returns the last known status of a given task. Absent value means unknown task's status.
	 * @param taskId id of the task to return its last status
	 * @return the last status of the given task.
	 */
	@Nonnull
	@SingleValueResult
	@SqlQuery("SELECT t.uuid as task_uuid, t.name as task_name, task_id, task_status_type_id, status_time, worker_id, pid \n" + 
			  " FROM task_status ts\n" +
	          " JOIN task t ON t.id = ts.task_id and lower(t.uuid) = lower(:taskId)\n" +
	          "WHERE \n" +
//			  " ts.task_id = (SELECT t.id FROM task t WHERE lower(t.uuid) = lower(:taskId)) AND \n" + 
	          " ts.status_time = (SELECT MAX(status_time) FROM task_status tsm WHERE tsm.task_id = ts.task_id) AND \n" +
			  " ts.task_status_type_id = (SELECT max(task_status_type_id) FROM task_status tsm WHERE tsm.task_id = ts.task_id)")
	Optional<TaskStatus> getLastStatusOfTask(@Bind("taskId") String taskId);
 
开发者ID:alessandroleite,项目名称:dohko,代码行数:16,代码来源:TaskStatusRepository.java

示例2: getByLetterHolderId

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SingleValueResult
@SqlQuery(SELECT_FROM_STATEMENT + " WHERE claim.letter_holder_id = :letterHolderId")
Optional<Claim> getByLetterHolderId(@Bind("letterHolderId") String letterHolderId);
 
开发者ID:hmcts,项目名称:cmc-claim-store,代码行数:4,代码来源:ClaimRepository.java

示例3: getClaimByExternalId

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SingleValueResult
@SqlQuery(SELECT_FROM_STATEMENT + " WHERE claim.external_id = :externalId")
Optional<Claim> getClaimByExternalId(@Bind("externalId") String externalId);
 
开发者ID:hmcts,项目名称:cmc-claim-store,代码行数:4,代码来源:ClaimRepository.java

示例4: getByClaimReferenceNumber

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SingleValueResult
@SqlQuery(SELECT_FROM_STATEMENT + " WHERE claim.reference_number = :claimReferenceNumber")
Optional<Claim> getByClaimReferenceNumber(@Bind("claimReferenceNumber") String claimReferenceNumber);
 
开发者ID:hmcts,项目名称:cmc-claim-store,代码行数:4,代码来源:ClaimRepository.java

示例5: getByClaimReferenceAndSubmitter

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SingleValueResult
@SqlQuery(SELECT_FROM_STATEMENT + " WHERE claim.reference_number = :claimReferenceNumber "
    + "AND claim.submitter_id = :submitterId")
Optional<Claim> getByClaimReferenceAndSubmitter(@Bind("claimReferenceNumber") String claimReferenceNumber,
                                                @Bind("submitterId") String submitterId);
 
开发者ID:hmcts,项目名称:cmc-claim-store,代码行数:6,代码来源:ClaimRepository.java

示例6: getById

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SingleValueResult
@SqlQuery(SELECT_FROM_STATEMENT + " WHERE claim.id = :id")
Optional<Claim> getById(@Bind("id") Long id);
 
开发者ID:hmcts,项目名称:cmc-claim-store,代码行数:4,代码来源:ClaimRepository.java

示例7: findEndDateById

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SqlQuery("SELECT end_date FROM tasks WHERE id = :id")
@SingleValueResult
Option<LocalDate> findEndDateById(@Bind("id") int id);
 
开发者ID:dropwizard,项目名称:dropwizard-vavr,代码行数:4,代码来源:VavrDBIFactoryTest.java

示例8:

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SqlQuery("select sha256hex, content from \"<schema>\".item where sha256hex=:sha256hex order by sha256hex")
@SingleValueResult(Item.class)
@RegisterMapper(ItemMapper.class)
Optional<Item> getItemBySHA256(@Bind("sha256hex") String sha256Hash, @Define("schema") String schema );
 
开发者ID:openregister,项目名称:openregister-java,代码行数:5,代码来源:ItemQueryDAO.java

示例9: findByEntryNumber

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@RegisterMapper(EntryMapper.class)
@SingleValueResult(Entry.class)
@SqlQuery("select e.entry_number, array_remove(array_agg(ei.sha256hex), null) as sha256hex, e.timestamp, e.key, e.type from \"<schema>\".entry e left join \"<schema>\".entry_item ei on ei.entry_number = e.entry_number where e.entry_number = :entryNumber group by e.entry_number")
Optional<Entry> findByEntryNumber(@Bind("entryNumber") int entryNumber, @Define("schema") String schema );
 
开发者ID:openregister,项目名称:openregister-java,代码行数:5,代码来源:EntryQueryDAO.java

示例10: getLastUpdatedTime

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@RegisterMapper(LongTimestampToInstantMapper.class)
@SingleValueResult(Instant.class)
@SqlQuery("SELECT timestamp FROM \"<schema>\".entry ORDER BY entry_number DESC LIMIT 1")
Optional<Instant> getLastUpdatedTime( @Define("schema") String schema );
 
开发者ID:openregister,项目名称:openregister-java,代码行数:5,代码来源:EntryQueryDAO.java

示例11: in

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@RegisterMapper(EntryMapper.class)
@SingleValueResult(Entry.class)
@SqlQuery("select e.entry_number, array_remove(array_agg(ei.sha256hex), null) as sha256hex, e.timestamp, e.key, e.type from \"<schema>\".<entry_table> e left join \"<schema>\".<entry_item_table> ei on ei.entry_number = e.entry_number where e.key in (<keys>) group by e.entry_number order by e.entry_number asc")
Collection<Entry> getEntriesByKeys(@BindIn("keys") List<String> entryKeys, @Define("schema") String schema, @Define("entry_table") String entryTable, @Define("entry_item_table") String entryItemTable);
 
开发者ID:openregister,项目名称:openregister-java,代码行数:5,代码来源:EntryQueryDAO.java

示例12: lower

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SqlQuery(SQL_SELECT_ALL + " WHERE lower(uuid) = lower (:uuid)")
@SingleValueResult
Optional<ApplicationDescriptor> findByUUID(@Bind("uuid") String id);
 
开发者ID:alessandroleite,项目名称:dohko,代码行数:4,代码来源:JobRepository.java

示例13: in

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SqlQuery(SQL_SELECT_ALL + " WHERE j.id in (SELECT t.job_id FROM task t WHERE lower(t.uuid) = lower(:taskId))")
@SingleValueResult
Optional<ApplicationDescriptor> findJobOfTaskId(@Bind("taskId") String taskId);
 
开发者ID:alessandroleite,项目名称:dohko,代码行数:4,代码来源:JobRepository.java

示例14: getState

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SingleValueResult
@SqlQuery("SELECT id, pid, datetime, percent, sys, user, total FROM task_cpu_stats WHERE pid = :pid AND datetime = :datetime")
Optional<ProcessCpuState> getState(@Bind("pid") long pid, @Bind("datetime") DateTime datetime);
 
开发者ID:alessandroleite,项目名称:dohko,代码行数:4,代码来源:TaskCpuStatsRepository.java

示例15: MAX

import org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult; //导入依赖的package包/类
@SingleValueResult
@SqlQuery("SELECT id, pid, datetime, percent, sys, user, total FROM task_cpu_stats WHERE pid = :pid AND " + 
          " datetime = (SELECT MAX(tc. datetime) FROM task_cpu_stats tc WHERE tc.pid = :pid)")
Optional<ProcessCpuState> getLast(@Bind("pid") long pid);
 
开发者ID:alessandroleite,项目名称:dohko,代码行数:5,代码来源:TaskCpuStatsRepository.java


注:本文中的org.skife.jdbi.v2.sqlobject.customizers.SingleValueResult类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。