@SingleValueResult @SqlQuery("" + "SELECT gitInfo.*, lastBuild.*, inProgressBuild.*, pendingBuild.* " + "FROM branches AS gitInfo " + "LEFT OUTER JOIN repo_builds AS lastBuild ON (gitInfo.lastBuildId = lastBuild.id) " + "LEFT OUTER JOIN repo_builds AS inProgressBuild ON (gitInfo.inProgressBuildId = inProgressBuild.id) " + "LEFT OUTER JOIN repo_builds AS pendingBuild ON (gitInfo.pendingBuildId = pendingBuild.id) " + "WHERE gitInfo.id = :branchId") Optional<RepositoryState> getRepositoryState(@Bind("branchId") int branchId);
@SingleValueResult @SqlQuery("SELECT * FROM instant_message_configs WHERE id = :id") Optional<InstantMessageConfiguration> get(@Bind("id") long id);
@SingleValueResult @SqlQuery("SELECT * FROM module_builds WHERE moduleId = :id AND state != 'SKIPPED' ORDER BY buildNumber DESC LIMIT 1") Optional<ModuleBuild> getPreviousBuild(@BindWithRosetta Module module);
@SingleValueResult @SqlQuery("SELECT * FROM module_builds WHERE id = :id") Optional<ModuleBuild> get(@Bind("id") long id);
@SingleValueResult @SqlQuery("SELECT * FROM module_builds WHERE moduleId = :moduleId AND buildNumber < :buildNumber AND state != 'SKIPPED' ORDER BY buildNumber DESC LIMIT 1") Optional<ModuleBuild> getPreviousBuild(@BindWithRosetta ModuleBuild build);
@SingleValueResult @SqlQuery("SELECT * FROM modules WHERE id = :moduleId") Optional<Module> get(@Bind("moduleId") int moduleId);
@SingleValueResult @SqlQuery("SELECT * FROM branches WHERE id = :id") Optional<GitInfo> get(@Bind("id") int id);
@SingleValueResult @SqlQuery("SELECT * FROM repo_builds WHERE id = :id") Optional<RepositoryBuild> get(@Bind("id") long id);
@SingleValueResult @SqlQuery("SELECT * FROM repo_builds WHERE branchId = :branchId AND buildNumber < :buildNumber ORDER BY buildNumber DESC limit 1") Optional<RepositoryBuild> getPreviousBuild(@BindWithRosetta RepositoryBuild build);
@SingleValueResult @SqlQuery("SELECT * FROM repo_builds WHERE branchId = :branchId AND buildNumber = :buildNumber") Optional<RepositoryBuild> getByBranchAndNumber(@Bind("branchId") int branchId, @Bind("buildNumber") int buildNumber);
@SingleValueResult @SqlQuery("SELECT * FROM branches WHERE repositoryId = :repositoryId AND branch = :branch") Optional<GitInfo> getByRepositoryAndBranch(@Bind("repositoryId") int repositoryId, @Bind("branch") String branch);
@SingleValueResult @SqlQuery("SELECT * FROM module_builds WHERE moduleId = :moduleId AND buildNumber = :buildNumber") Optional<ModuleBuild> getByModuleAndNumber(@Bind("moduleId") int moduleId, @Bind("buildNumber") int buildNumber);
@SqlQuery("select name from something where id = :id") @SingleValueResult public Maybe<String> smartFindNameById(@Bind("id") int id); }
@SqlQuery("select name from something where id = :id") @SingleValueResult public Maybe<T> inheritedGenericFindNameById(@Bind("id") int id); }
@SqlQuery("select name from something where id = :id") @SingleValueResult(String.class) public Maybe<String> findNameById(@Bind("id") int id);
@SqlQuery("select name from something where id = :id") @SingleValueResult public Maybe<T> inheritedGenericFindNameById(@Bind("id") int id); }
@SqlQuery("select name from something where id = :id") @SingleValueResult public Maybe<String> smartFindNameById(@Bind("id") int id); }
@SqlQuery("select name from something where id = :id") @SingleValueResult(String.class) public Maybe<String> findNameById(@Bind("id") int id);