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

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');constschema='CREATE TABLE Singers ('+'  SingerId INT64 NOT NULL,'+'  FirstName STRING(1024),'+'  LastName STRING(1024),'+'  SingerInfo BYTES(MAX),'+') PRIMARY KEY(SingerId)';table.create(schema,function(err,table,operation,apiResponse){if(err){// Error handling omitted.}operation.on('error',function(err){}).on('complete',function(){// Table created successfully.});});//-// If the callback is omitted, we'll return a Promise.//-table.create(schema).then(function(data){consttable=data[0];constoperation=data[1];returnoperation.promise();}).then(function(){// Table created successfully.});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');table.createReadStream({keys:['1'],columns:['SingerId','name']}).on('error',function(err){}).on('data',function(row){// row = {//   SingerId: '1',//   Name: 'Eddie Wilson'// }}).on('end',function(){// All results retrieved.});//-// Provide an array for `query.keys` to read with a composite key.//-constquery={keys:[['Id1','Name1'],['Id2','Name2']],// ...};//-// If you anticipate many results, you can end a stream early to prevent// unnecessary processing and API requests.//-table.createReadStream({keys:['1'],columns:['SingerId','name']}).on('data',function(row){this.end();});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');table.delete(function(err,operation,apiResponse){if(err){// Error handling omitted.}operation.on('error',function(err){}).on('complete',function(){// Table deleted successfully.});});//-// If the callback is omitted, we'll return a Promise.//-table.delete().then(function(data){constoperation=data[0];returnoperation.promise();}).then(function(){// Table deleted successfully.});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');constkeys=['Id1','Id2','Id3'];table.deleteRows(keys,function(err,apiResponse){});//-// Provide an array for `keys` to delete rows with a composite key.//-constkeys=[['Id1','Name1'],['Id2','Name2']];//-// If the callback is omitted, we'll return a Promise.//-table.deleteRows(keys).then(function(data){constapiResponse=data[0];});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');table.drop(function(err,operation,apiResponse){if(err){// Error handling omitted.}operation.on('error',function(err){}).on('complete',function(){// Table dropped successfully.});});//-// If the callback is omitted, we'll return a Promise.//-table.drop().then(function(data){constoperation=data[0];returnoperation.promise();}).then(function(){// Table dropped successfully.});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');constrow={SingerId:'Id3',Name:'Eddie Wilson'};table.insert(row,function(err,apiResponse){if(err){// Error handling omitted.}// Rows inserted successfully.});//-// Multiple rows can be inserted at once.//-constrow2={SingerId:'Id3b',Name:'Joe West'};table.insert([row,row2],function(err,apiResponse){});//-// If the callback is omitted, we'll return a Promise.//-table.insert(row).then(function(data){constapiResponse=data[0];});

// 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 instance and databaseconstinstance=spanner.instance(instanceId);constdatabase=instance.database(databaseId);// Instantiate Spanner table objectsconstsingersTable=database.table('Singers');constalbumsTable=database.table('Albums');// Inserts rows into the Singers table// Note: Cloud Spanner interprets Node.js numbers as FLOAT64s, so// they must be converted to strings before being inserted as INT64stry{awaitsingersTable.insert([{SingerId:'1',FirstName:'Marc',LastName:'Richards'},{SingerId:'2',FirstName:'Catalina',LastName:'Smith'},{SingerId:'3',FirstName:'Alice',LastName:'Trentor'},{SingerId:'4',FirstName:'Lea',LastName:'Martin'},{SingerId:'5',FirstName:'David',LastName:'Lomond'},]);awaitalbumsTable.insert([{SingerId:'1',AlbumId:'1',AlbumTitle:'Total Junk'},{SingerId:'1',AlbumId:'2',AlbumTitle:'Go, Go, Go'},{SingerId:'2',AlbumId:'1',AlbumTitle:'Green'},{SingerId:'2',AlbumId:'2',AlbumTitle:'Forever Hold your Peace'},{SingerId:'2',AlbumId:'3',AlbumTitle:'Terrified'},]);console.log('Inserted data.');}catch(err){console.error('ERROR:',err);}finally{awaitdatabase.close();}

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');constquery={keys:['1'],columns:['SingerId','name']};table.read(query,function(err,rows){if(err){// Error handling omitted.}constfirstRow=rows[0];// firstRow = [//   {//     name: 'SingerId',//     value: '1'//   },//   {//     name: 'Name',//     value: 'Eddie Wilson'//   }// ]});//-// Provide an array for `query.keys` to read with a composite key.//-constquery={keys:[['Id1','Name1'],['Id2','Name2']],// ...};//-// Rows are returned as an array of object arrays. Each object has a `name`// and `value` property. To get a serialized object, call `toJSON()`.//// Alternatively, set `query.json` to `true`, and this step will beperformed// automatically.//-table.read(query,function(err,rows){if(err){// Error handling omitted.}constfirstRow=rows[0];// firstRow.toJSON() = {//   SingerId: '1',//   Name: 'Eddie Wilson'// }});//-// If the callback is omitted, we'll return a Promise.//-table.read(query).then(function(data){constrows=data[0];});

// 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 instance and databaseconstinstance=spanner.instance(instanceId);constdatabase=instance.database(databaseId);// Reads rows from the Albums tableconstalbumsTable=database.table('Albums');constquery={columns:['SingerId','AlbumId','AlbumTitle'],keySet:{all:true,},};try{const[rows]=awaitalbumsTable.read(query);rows.forEach(row=>{constjson=row.toJSON();console.log(`SingerId:${json.SingerId}, AlbumId:${json.AlbumId}, AlbumTitle:${json.AlbumTitle}`);});}catch(err){console.error('ERROR:',err);}finally{// Close the database when finished.awaitdatabase.close();}

// 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 instance and databaseconstinstance=spanner.instance(instanceId);constdatabase=instance.database(databaseId);// Reads rows from the Albums tableconstalbumsTable=database.table('Albums');constquery={columns:['SingerId','AlbumId','AlbumTitle','MarketingBudget'],keySet:{all:true,},};constoptions={// Guarantees that all writes committed more than 15 seconds ago are visibleexactStaleness:15,};try{const[rows]=awaitalbumsTable.read(query,options);rows.forEach(row=>{constjson=row.toJSON();constid=json.SingerId;constalbum=json.AlbumId;consttitle=json.AlbumTitle;constbudget=json.MarketingBudget?json.MarketingBudget:'';console.log(`SingerId:${id}, AlbumId:${album}, AlbumTitle:${title}, MarketingBudget:${budget}`);});}catch(err){console.error('ERROR:',err);}finally{// Close the database when finished.awaitdatabase.close();}

// 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 instance and databaseconstinstance=spanner.instance(instanceId);constdatabase=instance.database(databaseId);constalbumsTable=database.table('Albums');constquery={columns:['AlbumId','AlbumTitle'],keySet:{all:true,},index:'AlbumsByAlbumTitle',};// Reads the Albums table using an indextry{const[rows]=awaitalbumsTable.read(query);rows.forEach(row=>{constjson=row.toJSON();console.log(`AlbumId:${json.AlbumId}, AlbumTitle:${json.AlbumTitle}`);});}catch(err){console.error('ERROR:',err);}finally{// Close the database when finished.database.close();}

// "Storing" indexes store copies of the columns they index// This speeds up queries, but takes more space compared to normal indexes// See the link below for more information:// https://cloud.google.com/spanner/docs/secondary-indexes#storing_clause// 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 instance and databaseconstinstance=spanner.instance(instanceId);constdatabase=instance.database(databaseId);constalbumsTable=database.table('Albums');constquery={columns:['AlbumId','AlbumTitle','MarketingBudget'],keySet:{all:true,},index:'AlbumsByAlbumTitle2',};// Reads the Albums table using a storing indextry{const[rows]=awaitalbumsTable.read(query);rows.forEach(row=>{constjson=row.toJSON();letrowString=`AlbumId:${json.AlbumId}`;rowString+=`, AlbumTitle:${json.AlbumTitle}`;if(json.MarketingBudget){rowString+=`, MarketingBudget:${json.MarketingBudget}`;}console.log(rowString);});}catch(err){console.error('ERROR:',err);}finally{// Close the database when finished.database.close();}

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');constrow={SingerId:'Id3',Name:'Joe West'};table.replace(row,function(err,apiResponse){if(err){// Error handling omitted.}// Row replaced successfully.});//-// If the callback is omitted, we'll return a Promise.//-table.replace(row).then(function(data){constapiResponse=data[0];});

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');constrow={SingerId:'Id3',Name:'Joe West'};table.update(row,function(err,apiResponse){if(err){// Error handling omitted.}// Row updated successfully.});//-// If the callback is omitted, we'll return a Promise.//-table.update(row).then(function(data){constapiResponse=data[0];});

// 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 instance and databaseconstinstance=spanner.instance(instanceId);constdatabase=instance.database(databaseId);// Update a row in the Albums table// Note: Cloud Spanner interprets Node.js numbers as FLOAT64s, so they// must be converted to strings before being inserted as INT64sconstalbumsTable=database.table('Albums');try{awaitalbumsTable.update([{SingerId:'1',AlbumId:'1',MarketingBudget:'100000'},{SingerId:'2',AlbumId:'2',MarketingBudget:'500000'},]);console.log('Updated data.');}catch(err){console.error('ERROR:',err);}finally{// Close the database when finished.database.close();}

const{Spanner}=require('@google-cloud/spanner');constspanner=newSpanner();constinstance=spanner.instance('my-instance');constdatabase=instance.database('my-database');consttable=database.table('Singers');constrow={SingerId:'Id3',Name:'Joe West'};table.upsert(row,function(err,apiResponse){if(err){// Error handling omitted.}// Row inserted or updated successfully.});//-// If the callback is omitted, we'll return a Promise.//-table.upsert(row).then(function(data){constapiResponse=data[0];});