const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constbackup=instance.backup('my-backup');

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constbackup=instance.copyBackup('my-source-backup','my-backup',{expireTime:expireTime,encryptionConfig:{encryptionType:'CUSTOMER_MANAGED_ENCRYPTION',kmsKeyName:'projects/my-project-id/my-region/keyRings/my-key-ring/cryptoKeys/my-key',},);

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');functioncallback(err,database,operation,apiResponse){if(err){// Error handling omitted.}operation.on('error',function(err){}).on('complete',function(){// Database created successfully.});}instance.createDatabase('new-database-name',callback);//-// Set the schema for the database.//-instance.createDatabase('new-database-name',{schema:'CREATE TABLE Singers ('+'  SingerId STRING(1024) NOT NULL,'+'  Name STRING(1024),'+') PRIMARY KEY(SingerId)'},callback);//-// If the callback is omitted, we'll return a Promise.//-instance.createDatabase('new-database-name').then(function(data){constdatabase=data[0];constoperation=data[1];returnoperation.promise();}).then(function(){// Database created successfully.});

// Imports the Google Cloud client libraryconst{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 clientconstspanner=newSpanner({projectId:projectId,});// Gets a reference to a Cloud Spanner instanceconstinstance=spanner.instance(instanceId);// Note: Cloud Spanner interprets Node.js numbers as FLOAT64s, so they// must be converted to strings before being inserted as INT64sconstrequest={schema:[`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)`,`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 databaseconst[database,operation]=awaitinstance.createDatabase(databaseId,request);console.log(`Waiting for operation on${database.id} to complete...`);awaitoperation.promise();console.log(`Created database${databaseId} on instance${instanceId}.`);

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');instance.delete(function(err,apiResponse){if(err){// Error handling omitted.}// Instance was deleted successfully.});//-// If the callback is omitted, we'll return a Promise.//-instance.delete().then(function(data){constapiResponse=data[0];});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');instance.exists(function(err,exists){});//-// If the callback is omitted, we'll return a Promise.//-instance.exists().then(function(data){constexists=data[0];});

Instance.formatName_('grape-spaceship-123','my-instance');// 'projects/grape-spaceship-123/instances/my-instance'

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');instance.get(function(err,instance,apiResponse){// `instance.metadata` has been populated.});//-// If the callback is omitted, we'll return a Promise.//-instance.get().then(function(data){constinstance=data[0];constapiResponse=data[0];});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');const[backups]=awaitinstance.getBackups();//-// To manually handle pagination, set autoPaginate:false in gaxOptions.//-letpageToken=undefined;do{const[backups,,response]=awaitinstance.getBackups({pageSize:3,pageToken,gaxOptions:{autoPaginate:false},});backups.forEach(backup=>{// Do something with backup});pageToken=response.nextPageToken;}while(pageToken);

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');instance.getBackupsStream().on('error',console.error).on('data',function(database){// `backups` is a `Backup` object.}).on('end',function(){// All backups retrieved.});//-// If you anticipate many results, you can end a stream early to prevent// unnecessary processing and API requests.//-instance.getBackupsStream().on('data',function(database){this.end();});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');instance.getDatabases(function(err,databases){// `databases` is an array of `Database` objects.});//-// To control how many API requests are made and page through the results// manually, set `autoPaginate` to `false`.//-functioncallback(err,databases,nextQuery,apiResponse){if(nextQuery){// More results exist.instance.getDatabases(nextQuery,callback);}}instance.getDatabases({gaxOptions:{autoPaginate:false}},callback);//-// If the callback is omitted, we'll return a Promise.//-instance.getDatabases().then(function(data){constdatabases=data[0];});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');instance.getDatabasesStream().on('error',console.error).on('data',function(database){// `database` is a `Database` object.}).on('end',function(){// All databases retrieved.});//-// If you anticipate many results, you can end a stream early to prevent// unnecessary processing and API requests.//-instance.getDatabasesStream().on('data',function(database){this.end();});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');instance.getMetadata(function(err,metadata,apiResponse){});//-// Request only `displayName`.//-instance.getMetadata({fieldNames:'displayName'},(err,metadata,apiResponse)=>{// metadata will only contain value for `displayName`constdisplayName=metadata['displayName'];})//-// Request multiple specific field names.//-instance.getMetadata({fieldNames:['displayName','nodeCount']},(err,metadata,apiResponse)=>{// metadata will only contain value for `displayName` and 'nodeCount'constdisplayName=metadata['displayName'];constnodeCount=metadata['nodeCount'];});//-// If the callback is omitted, we'll return a Promise.//-instance.getMetadata().then(function(data){constmetadata=data[0];constapiResponse=data[1];});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constmetadata={displayName:'My Instance'};instance.setMetadata(metadata,function(err,operation,apiResponse){if(err){// Error handling omitted.}operation.on('error',function(err){}).on('complete',function(){// Metadata updated successfully.});});//-// If the callback is omitted, we'll return a Promise.//-instance.setMetadata(metadata).then(function(data){constoperation=data[0];constapiResponse=data[1];});