本文整理汇总了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);
示例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);
示例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);
示例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);
示例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);
示例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);
示例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);
示例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 );
示例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 );
示例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 );
示例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);
示例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);
示例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);
示例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);
示例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);