⚡ 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 { eq, sql } from "drizzle-orm";
import db from "../../database";
import { userTable } from "../../database/schema";
import { ApiError } from "../../errors/api-error";
import { readStoredSettings } from "../../instance-settings/read-stored-settings";
import { isCloud } from "../../utils/is-cloud";
import { isDisposableEmail } from "../../utils/is-disposable-email";
import type { AdminAuditRequest } from "../audit/admin-audit-request";
import { recordAdminAction } from "../audit/record-admin-action";
import { assertAssignableRole } from "../roles/assert-assignable-role";
import { getUserAccess } from "../roles/get-instance-access";
import { emailPasswordLink } from "../users/account-email-links";
import { adminUserColumns, toAdminUser } from "../users/admin-user-columns";
import { createsPasswordAccounts } from "../users/password-sign-in";
type CreateUserInput = {
name: string;
email: string;
/** Defaults to the instance's default role. */
role?: string;
};
export type PasswordSetupEmail =
| "sent"
| "failed"
| "not_configured"
| "not_needed";
function emailTaken() {
return new ApiError(409, {
code: "USER_ALREADY_EXISTS",
message: "A user with this email address already exists.",
});
}
/**
* Create an account without a password. Where password sign-in is available,
* the person gets a single-use link to choose one; otherwise the account is
* meant for single sign-on, which needs a verified email to link to.
*/
async function createUser(input: CreateUserInput, audit: AdminAuditRequest) {
const name = input.name.trim();
const email = input.email.trim().toLowerCase();
if (isCloud() && isDisposableEmail(email)) {
throw new ApiError(400, {
code: "DISPOSABLE_EMAIL_NOT_ALLOWED",
message:
"Use a permanent email address. Disposable addresses cannot create accounts.",
});
}
const withPassword = await createsPasswordAccounts();
const actor = await getUserAccess(audit.actorUserId ?? "");
const userId = await db.transaction(async (tx) => {
const role = input.role ?? (await readStoredSettings(tx)).defaultRole;
await assertAssignableRole(role, actor, tx);
const [existing] = await tx
.select({ id: userTable.id })
.from(userTable)
.where(eq(sql`lower(${userTable.email})`, email))
.limit(1);
if (existing) throw emailTaken();
const [created] = await tx
.insert(userTable)
.values({ name, email, role, emailVerified: !withPassword })
.onConflictDoNothing({ target: userTable.email })
.returning({ id: userTable.id });
if (!created) throw emailTaken();
await recordAdminAction(
{
...audit,
action: "user.created",
targetType: "user",
targetId: created.id,
targetLabel: email,
metadata: {
name,
role,
signIn: withPassword ? "password_link" : "single_sign_on",
},
},
tx,
);
return created.id;
});
let passwordSetupEmail: PasswordSetupEmail = "not_needed";
if (withPassword) {
try {
const result = await emailPasswordLink(
{ id: userId, name, email, locale: null },
"setup",
);
passwordSetupEmail = result.success ? "sent" : "not_configured";
} catch {
passwordSetupEmail = "failed";
}
}
const [row] = await db
.select(adminUserColumns)
.from(userTable)
.where(eq(userTable.id, userId))
.limit(1);
if (!row)
throw new ApiError(404, { code: "NOT_FOUND", message: "User not found" });
return { user: toAdminUser(row), passwordSetupEmail };
}
export default createUser;