Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

717 B
Raw Blame
import type {
  ColumnMetadata,
  TableMetadata,
} from "@/types/proto-es/v1/database_service_pb";

export const findPrimaryKey = (table: TableMetadata) => {
  return table.indexes.find((idx) => idx.primary);
};

export const isPrimaryKey = (table: TableMetadata, column: ColumnMetadata) => {
  const pk = findPrimaryKey(table);
  if (!pk) return false;
  return pk.expressions.includes(column.name);
};

export const findIndexes = (table: TableMetadata, column: ColumnMetadata) => {
  return table.indexes.filter(
    (idx) => !idx.primary && idx.expressions.includes(column.name)
  );
};

export const isIndex = (table: TableMetadata, column: ColumnMetadata) => {
  return findIndexes(table, column).length > 0;
};