Function getIdByName

console/src/test/sql/getIdByName.ts:23–48

(
  params: ClusterSearchParameters | ObjectSearchParameters,
)

// This function is used to get the id of an object or cluster by its name.
export async function getIdByName(
  params: ClusterSearchParameters | ObjectSearchParameters,
) {
  const client = await getMaterializeClient();

  if ("schemaName" in params) {
    const {
      rows: [object],
    } = await client.query(
      `
      select id
      from mz_internal.mz_object_fully_qualified_names
      where name = '${params.name}' AND
      schema_name = '${params.schemaName}' AND
      database_name = '${params.databaseName}'`,
    );

    return object.id as string;
  }
  const {
    rows: [cluster],
  } = await client.query(
    `select id from mz_clusters where name = '${params.name}'`,
  );
  return cluster.id as string;
}