in core/scm-repository/src/main/kotlin/io/klibs/core/scm/repository/ScmRepositoryRepositoryJdbc.kt [161:194]
override fun findById(id: Int): ScmRepositoryEntity? {
val sql = """
SELECT repo.id,
repo.id_native,
repo.name,
repo.description,
repo.default_branch,
repo.created_ts,
repo.owner_id,
owner.type owner_type,
owner.login AS owner_login,
repo.homepage,
repo.has_gh_pages,
repo.has_issues,
repo.has_wiki,
repo.has_readme,
repo.license_key,
repo.license_name,
repo.stars,
repo.open_issues,
repo.last_activity_ts,
repo.updated_at,
repo.minimized_readme
FROM scm_repo repo
JOIN scm_owner owner ON repo.owner_id = owner.id
WHERE repo.id = :id
""".trimIndent()
return jdbcClient.sql(sql)
.param("id", id)
.query(SCM_REPO_ENTITY_ROW_MAPPER)
.optional()
.getOrNull()
}