override fun findWithoutDescription()

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

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

    override fun findWithoutDescription(): 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 project.description IS NULL
            ORDER BY random()
            LIMIT 1
        """.trimIndent()

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