Function addTimestampColumn

spanner/timestamp.js:180–231

(instanceId, databaseId, projectId)

}

async function addTimestampColumn(instanceId, databaseId, projectId) {
  // [START spanner_add_timestamp_column]
  // Imports the Google Cloud client library
  const {Spanner} = require('@google-cloud/spanner');

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

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

  // Gets a reference to a Cloud Spanner Database Admin Client object
  const databaseAdminClient = spanner.getDatabaseAdminClient();

  const request = [
    `ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP OPTIONS
    (allow_commit_timestamp=true)`,
  ];

  // Adds a new commit timestamp column to the Albums table
  try {
    const [operation] = await databaseAdminClient.updateDatabaseDdl({
      database: databaseAdminClient.databasePath(
        projectId,
        instanceId,
        databaseId
      ),
      statements: request,
    });

    console.log('Waiting for operation to complete...');

    await operation.promise();

    console.log(
      'Added LastUpdateTime as a commit timestamp column in Albums table.'
    );
  } catch (err) {
    console.error('ERROR:', err);
  } finally {
    // Close the spanner client when finished.
    // The databaseAdminClient does not require explicit closure. The closure of the Spanner client will automatically close the databaseAdminClient.
    spanner.close();
  }
  // [END spanner_add_timestamp_column]
}

async function updateWithTimestamp(instanceId, databaseId, projectId) {
  // [START spanner_update_data_with_timestamp_column]