Function createDatabase

spanner/schema.js:19–75

(instanceID, databaseID, projectID)

// creates a database using Database Admin Client
async function createDatabase(instanceID, databaseID, projectID) {
  // [START spanner_create_database]

  /**
   * TODO(developer): Uncomment the following lines before running the sample.
   */
  // const projectId = 'my-project-id';
  // const instanceId = 'my-instance';
  // const databaseId = 'my-database';

  // Imports the Google Cloud client library
  const {Spanner} = require('@google-cloud/spanner');

  // creates a client
  const spanner = new Spanner({
    projectId: projectID,
  });

  const databaseAdminClient = spanner.getDatabaseAdminClient();

  const createSingersTableStatement = `
  CREATE TABLE Singers (
    SingerId    INT64 NOT NULL,
    FirstName   STRING(1024),
    LastName    STRING(1024),
    SingerInfo  BYTES(MAX),
    FullName    STRING(2048) AS (ARRAY_TO_STRING([FirstName, LastName], " ")) STORED,
  ) PRIMARY KEY (SingerId)`;
  const createAlbumsTableStatement = `
  CREATE TABLE Albums (
    SingerId    INT64 NOT NULL,
    AlbumId     INT64 NOT NULL,
    AlbumTitle  STRING(MAX)
  ) PRIMARY KEY (SingerId, AlbumId),
  INTERLEAVE IN PARENT Singers ON DELETE CASCADE`;

  // Creates a new database
  try {
    const [operation] = await databaseAdminClient.createDatabase({
      createStatement: 'CREATE DATABASE `' + databaseID + '`',
      extraStatements: [
        createSingersTableStatement,
        createAlbumsTableStatement,
      ],
      parent: databaseAdminClient.instancePath(projectID, instanceID),
    });

    console.log(`Waiting for creation of ${databaseID} to complete...`);
    await operation.promise();

    console.log(`Created database ${databaseID} on instance ${instanceID}.`);
  } catch (err) {
    console.error('Failed to create database:', err.message || err);
  }

  // [END spanner_create_database]
}