override fun findWithoutTags()

in core/project/src/main/kotlin/io/klibs/core/project/repository/ProjectRepositoryJdbc.kt [130:151]

• 21 lines of code
• 1 McCabe index (conditional complexity)

    override fun findWithoutTags(): ProjectEntity? {
        val sql = """
            SELECT project.id,
                   project.scm_repo_id,
                   project.description,
                   project.latest_version,
                   project.latest_version_ts
            FROM project
                     JOIN scm_repo repo on project.scm_repo_id = repo.id
            WHERE repo.has_readme = true
              AND NOT EXISTS (
                    SELECT 1 FROM project_tags pt WHERE pt.project_id = project.id
              )
            ORDER BY random()
            LIMIT 1
        """.trimIndent()

        return jdbcClient.sql(sql)
            .query(PROJECT_ENTITY_ROW_MAPPER)
            .optional()
            .getOrNull()
    }