Function table

packages/core/fumadb/src/schema/create.ts:570–674

(
  name: string | Partial<NameVariants>,
  columns: Columns
)

}

export function table<Columns extends Record<string, AnyColumn>>(
  name: string | Partial<NameVariants>,
  columns: Columns
): Table<Columns, {}> {
  let idCol: AnyColumn | undefined;
  let names: NameVariants | undefined;

  const uniqueConstraints: UniqueConstraint[] = [];
  const policies: StoredTablePolicy[] = [];
  const out: Table<Columns, {}> = {
    ormName: "",
    get names() {
      if (names) return names;

      return typeof name === "string"
        ? nameVariants(name, out.ormName)
        : nameVariants(out.ormName, out.ormName, name);
    },
    set names(v) {
      names = v;
    },
    columns,
    relations: {},
    foreignKeys: [],
    policies,
    getUniqueConstraints(level = "all") {
      const result: UniqueConstraint[] = [];
      if (level === "all" || level === "table")
        result.push(...uniqueConstraints);

      if (level === "all" || level === "column") {
        for (const col of Object.values(this.columns)) {
          if (!col.isUnique) continue;

          result.push({
            name: col.getUniqueConstraintName(),
            columns: [col],
          });
        }
      }

      return result;
    },
    getColumnByName(name, type = "sql") {
      return Object.values(this.columns).find((c) => c.names[type] === name);
    },
    getIdColumn() {
      return idCol!;
    },
    unique(name, columns) {
      uniqueConstraints.push({
        name,
        columns: columns.map((name) => {
          const column = this.columns[name];
          if (!column)
            throw new Error(`Unknown column name ${name.toString()}`);

          return column;