base_test.js

// Copyright 2018 Google LLC

// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at

//     https://www.apache.org/licenses/LICENSE-2.0

// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

const filesToDelete = [];
function deleteFileOnCleanup(fileId) {
  filesToDelete.push(fileId);
}

function tearDown() {
  for (let i = 0; i < filesToDelete.length; ++i) {
    const presentationId = filesToDelete[i];
    gapi.client.drive.files.delete({
      fileId: presentationId,
    });
  }
}

function createTestSpreadsheet(callback) {
  gapi.client.sheets.spreadsheets.create({
    properties: {
      title: 'Test Spreadsheet',
    },
  }).then(function(sheet) {
    deleteFileOnCleanup(sheet.result.spreadsheetId);
    callback(sheet.result.spreadsheetId);
  });
};

function populateValues(spreadsheetId, callback) {
  gapi.client.sheets.spreadsheets.batchUpdate({
    spreadsheetId: spreadsheetId,
    resource: {
      requests: [{
        repeatCell: {
          range: {
            sheetId: 0,
            startRowIndex: 0,
            endRowIndex: 10,
            startColumnIndex: 0,
            endColumnIndex: 10,
          },
          cell: {
            userEnteredValue: {
              stringValue: 'Hello',
            },
          },
          fields: 'userEnteredValue',
        },
      }],
    },
  }).then((response) => {
    callback(spreadsheetId);
  });
};