owner.ts

/* Get basic information about a user or organization
from the database.  This should be enough to render
a nice "homepage" for that user or organization.
*/

import getPool from "@cocalc/database/pool";
import { isReserved } from "@cocalc/util/db-schema/name-rules";

// Throws an exception if there is no account or org with this name.
// TODO: take into account redirects for when name is changed.

interface Owner {
  type: "account" | "organization";
  owner_id: string;
}

export default async function getOwner(owner: string): Promise<Owner> {
  if (isReserved(owner)) {
    // can't be so save us the trouble of consulting database; these are common
    // so this is a good win.
    throw Error(`no such owner '${owner}'- reserved name`);
  }
  const pool = getPool("long");
  // Is it an account?
  let result = await pool.query(
    "SELECT account_id FROM accounts WHERE LOWER(name)=$1",
    [owner.toLowerCase()]
  );
  if (result.rows.length > 0) {
    return { type: "account", owner_id: result.rows[0].account_id };
  }
  // Is it an organization?
  result = await pool.query(
    "SELECT title, description, organization_id FROM organizations WHERE LOWER(name)=$1",
    [owner.toLowerCase()]
  );
  if (result.rows.length > 0) {
    return { type: "organization", owner_id: result.rows[0].organization_id };
  }
  throw Error(`no account or organization '${owner}'`);
}

export async function getOwnerName(
  owner_id: string
): Promise<string | undefined> {
  const pool = getPool("long");
  let result = await pool.query(
    "SELECT name FROM accounts WHERE account_id=$1",
    [owner_id]
  );
  if (result.rows.length > 0) {
    const { name } = result.rows[0];
    if (!name) return;
    return name;
  }
  result = await pool.query(
    "SELECT name FROM organizations WHERE organization_id=$1",
    [owner_id]
  );
  if (result.rows.length > 0) {
    const { name } = result.rows[0];
    if (!name) return;
    return name;
  }
}