Function grantRoleToUserInSchema

src/dataconnect/schemaMigration.ts:353–384

(options: Options, schema: Schema)

}

export async function grantRoleToUserInSchema(options: Options, schema: Schema) {
  const role = options.role as string;
  const email = options.email as string;

  const { serviceName, instanceId, instanceName, databaseId, schemaName } = getIdentifiers(schema);

  await ensureServiceIsConnectedToCloudSql(
    serviceName,
    instanceName,
    databaseId,
    /* linkIfNotConnected=*/ false,
    schemaName,
  );

  // Make sure we have the right setup for the requested role grant.
  const schemaSetupStatus = await setupSchemaIfNecessary(
    instanceId,
    databaseId,
    schemaName,
    options,
  );

  // Edge case: we can't grant firebase owner unless database is greenfield.
  if (schemaSetupStatus !== SchemaSetupStatus.GreenField && role === "owner") {
    throw new FirebaseError(
      `Owner rule isn't available in ${schemaSetupStatus} databases. If you would like SQL Connect to manage and own your database schema, run 'firebase dataconnect:sql:setup'`,
    );
  }

  // Grant the role to the user.
  await grantRoleTo(options, instanceId, databaseId, role, email, schemaName);
}

function diffsEqual(x: Diff[], y: Diff[]): boolean {
  if (x.length !== y.length) {