diff --git a/keyserver/src/fetchers/user-fetchers.js b/keyserver/src/fetchers/user-fetchers.js --- a/keyserver/src/fetchers/user-fetchers.js +++ b/keyserver/src/fetchers/user-fetchers.js @@ -420,6 +420,16 @@ return result.length === 0 ? null : result[0].id.toString(); } +async function fetchUserIDForUsername(username: string): Promise { + const query = SQL` + SELECT id + FROM users + WHERE LOWER(username) = LOWER(${username}) + `; + const [result] = await dbQuery(query); + return result.length === 0 ? null : result[0].id.toString(); +} + export { fetchUserInfos, fetchLoggedInUserInfo, @@ -432,4 +442,5 @@ fetchKnownUserInfos, fetchKeyserverAdminID, fetchUserIDForEthereumAddress, + fetchUserIDForUsername, };