Interface for both db and tx

export type DBRelation = ExtractTablesWithRelations<typeof schema>;
export type DBTransaction = PgTransaction<PostgresJsQueryResultHKT, typeof schema, DbRelation>;

type TokenUser = Token & { user: Omit<User, "passwordHash"> };
export async function getToken<DB extends DBTransaction>(tx: DB, token: string, tokenType: TokenType): Promise<TokenUser | undefined> {
  return await tx.query.tokens.findFirst({
    where: and(
      eq(tokens.token, token),
      isNull(tokens.disabledAt),
      gt(tokens.expiresAt, new Date()),
      eq(tokens.tokenType, tokenType)
    ),
    with: {
      user: {
        columns: {
          passwordHash: false,
        }
      }
    }
  });
}