⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { and, eq } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import { accountTable } from "../../database/schema";
import { getGithubApp } from "../../plugins/github/utils/github-app";
/** Account IDs come from completed OAuth, never from submitted repository data. */
export async function verifyRepositoryOwner(
userId: string,
repositoryOwner: string,
repositoryName: string,
) {
const account = await getGithubAccount(userId);
const accountId = Number(account.accountId);
const app = getGithubApp();
if (!app)
throw new HTTPException(503, {
message: "GitHub integration is unavailable",
});
try {
const { data: installation } =
await app.octokit.rest.apps.getRepoInstallation({
owner: repositoryOwner,
repo: repositoryName,
});
const octokit = await app.getInstallationOctokit(installation.id);
const { data: user } = await octokit.rest.users.getById({
account_id: accountId,
});
if (user.id !== accountId) throw new Error("GitHub identity mismatch");
const { data: permission } =
await octokit.rest.repos.getCollaboratorPermissionLevel({
owner: repositoryOwner,
repo: repositoryName,
username: user.login,
});
if (permission.permission !== "admin") {
throw new Error("GitHub repository admin permission is required");
}
const { data: repository } = await octokit.rest.repos.get({
owner: repositoryOwner,
repo: repositoryName,
});
return {
installationId: installation.id,
repositoryId: repository.id,
repositoryOwner: repository.owner.login,
repositoryName: repository.name,
verifiedGithubAccountId: account.accountId,
verifiedByUserId: userId,
};
} catch {
// Do not expose installation or repository existence to unauthorized users.
throw new HTTPException(403, {
message:
"Repository access could not be verified. GitHub repository admin permission and an installed Kaneo App are required",
});
}
}
export async function getGithubAccount(userId: string) {
const account = await db.query.accountTable.findFirst({
where: and(
eq(accountTable.userId, userId),
eq(accountTable.providerId, "github"),
),
});
const accountId = Number(account?.accountId);
if (!account || !Number.isSafeInteger(accountId) || accountId <= 0) {
throw new HTTPException(403, {
message: "Connect your GitHub account before linking a repository",
});
}
return account;
}