Add TIMESTAMP column

voidAddTimestampColumn(
google::cloud::spanner_admin::DatabaseAdminClientclient,
std::stringconst&project_id,std::stringconst&instance_id,
std::stringconst&database_id){
google::cloud::spanner::Databasedatabase(project_id,instance_id,
database_id);
autometadata=
client
.UpdateDatabaseDdl(
database.FullName(),
{"ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP "
"OPTIONS (allow_commit_timestamp=true)"})
.get();
google::cloud::spanner_testing::LogUpdateDatabaseDdl(//! TODO(#4758)
client,database,metadata.status());//! TODO(#4758)
if(!metadata)throwstd::move(metadata).status();
std::cout << "Added LastUpdateTime column\n";
}

usingGoogle.Cloud.Spanner.Data ;
usingSystem;
usingSystem.Threading.Tasks;
publicclassAddCommitTimestampAsyncSample
{
publicasyncTaskAddCommitTimestampAsync(stringprojectId,stringinstanceId,stringdatabaseId)
{
stringconnectionString=$"Data Source=projects/{projectId}/instances/{instanceId}/databases/{databaseId}";
stringalterStatement="ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP OPTIONS (allow_commit_timestamp=true)";
usingvarconnection=newSpannerConnection (connectionString);
varupdateCmd=connection.CreateDdlCommand (alterStatement);
awaitupdateCmd.ExecuteNonQueryAsync();
Console.WriteLine("Added LastUpdateTime as a commit timestamp column in Albums table.");
}
}

import(
"context"
"fmt"
"io"
database"cloud.google.com/go/spanner/admin/database/apiv1"
adminpb"cloud.google.com/go/spanner/admin/database/apiv1/databasepb"
)
funcaddCommitTimestamp(ctxcontext.Context,wio.Writer,dbstring)error{
adminClient,err:=database.NewDatabaseAdminClient(ctx)
iferr!=nil{
returnerr
}
deferadminClient.Close ()
op,err:=adminClient.UpdateDatabaseDdl(ctx,&adminpb.UpdateDatabaseDdlRequest{
Database:db,
Statements:[]string{
"ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP "+
"OPTIONS (allow_commit_timestamp=true)",
},
})
iferr!=nil{
returnerr
}
iferr:=op.Wait(ctx);err!=nil{
returnerr
}
fmt.Fprintf(w,"Added LastUpdateTime as a commit timestamp column in Albums table\n")
returnnil
}

staticvoidaddCommitTimestamp(DatabaseAdminClientadminClient,DatabaseIddbId){
OperationFuture<Void,UpdateDatabaseDdlMetadata>op=
adminClient.updateDatabaseDdl(
dbId.getInstanceId().getInstance(),
dbId.getDatabase(),
Arrays.asList(
"ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP "
+"OPTIONS (allow_commit_timestamp=true)"),
null);
try{
// Initiate the request which returns an OperationFuture.
op.get();
System.out.println("Added LastUpdateTime as a commit timestamp column in Albums table.");
}catch(ExecutionExceptione){
// If the operation failed during execution, expose the cause.
throw(SpannerException)e.getCause();
}catch(InterruptedExceptione){
// Throw when a thread is waiting, sleeping, or otherwise occupied,
// and the thread is interrupted, either before or during the activity.
throwSpannerExceptionFactory.propagateInterrupt(e);
}
}

// 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
constspanner=newSpanner ({
projectId:projectId,
});
// Gets a reference to a Cloud Spanner Database Admin Client object
constdatabaseAdminClient=spanner.getDatabaseAdminClient ();
constrequest=[
`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]=awaitdatabaseAdminClient.updateDatabaseDdl({
database:databaseAdminClient.databasePath(
projectId,
instanceId,
databaseId,
),
statements:request,
});
console.log('Waiting for operation to complete...');
awaitoperation .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();
}

use Google\Cloud\Spanner\SpannerClient;
/**
 * Adds a commit timestamp column to a table.
 * Example:
 * ```
 * add_timestamp_column($instanceId, $databaseId);
 * ```
 *
 * @param string $instanceId The Spanner instance ID.
 * @param string $databaseId The Spanner database ID.
 */
function add_timestamp_column(string $instanceId, string $databaseId): void
{
 $spanner = new SpannerClient();
 $instance = $spanner->instance($instanceId);
 $database = $instance->database($databaseId);
 $operation = $database->updateDdl(
 'ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP OPTIONS (allow_commit_timestamp=true)'
 );
 print('Waiting for operation to complete...' . PHP_EOL);
 $operation->pollUntilComplete();
 printf('Added LastUpdateTime as a commit timestamp column in Albums table' . PHP_EOL);
}

defadd_timestamp_column(instance_id, database_id):
"""Adds a new TIMESTAMP column to the Albums table in the example database."""
 fromgoogle.cloud.spanner_admin_database_v1.typesimport spanner_database_admin
 spanner_client = spanner.Client()
 database_admin_api = spanner_client.database_admin_api
 request = spanner_database_admin.UpdateDatabaseDdlRequest(
 database=database_admin_api.database_path(
 spanner_client.project, instance_id, database_id
 ),
 statements=[
 "ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP "
 "OPTIONS(allow_commit_timestamp=true)"
 ],
 )
 operation = database_admin_api.update_database_ddl(request)
 print("Waiting for operation to complete...")
 operation.result(OPERATION_TIMEOUT_SECONDS)
 print(
 'Altered table "Albums" on database {} on instance {}.'.format(
 database_id, instance_id
 )
 )

# project_id = "Your Google Cloud project ID"
# instance_id = "Your Spanner instance ID"
# database_id = "Your Spanner database ID"
require"google/cloud/spanner"
require"google/cloud/spanner/admin/database"
database_admin_client=Google::Cloud::Spanner::Admin::Database.database_admin
db_path=database_admin_client.database_pathproject:project_id,
instance:instance_id,
database:database_id
job=database_admin_client.update_database_ddldatabase:db_path,
statements:[
"ALTER TABLE Albums ADD COLUMN LastUpdateTime TIMESTAMP
 OPTIONS (allow_commit_timestamp=true)"
]
puts"Waiting for database update to complete"
job.wait_until_done!
puts"Added the LastUpdateTime as a commit timestamp column in Albums table"