alloy_d_b_admin.execute_sql.js

// Copyright 2024 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.
//
// ** This file is automatically generated by gapic-generator-typescript. **
// ** https://github.com/googleapis/gapic-generator-typescript **
// ** All changes to this file may be overwritten. **



'use strict';

function main(instance, database, user, sqlStatement) {
  // [START alloydb_v1alpha_generated_AlloyDBAdmin_ExecuteSql_async]
  /**
   * This snippet has been automatically generated and should be regarded as a code template only.
   * It will require modifications to work.
   * It may require correct/in-range values for request initialization.
   * TODO(developer): Uncomment these variables before running the sample.
   */
  /**
   *  Optional. The database native user’s password.
   */
  // const password = 'abc123'
  /**
   *  Required. The instance where the SQL will be executed. For the required
   *  format, see the comment on the Instance.name field.
   */
  // const instance = 'abc123'
  /**
   *  Required. Name of the database where the query will be executed.
   *  Note - Value provided should be the same as expected from `SELECT
   *  current_database();` and NOT as a resource reference.
   */
  // const database = 'abc123'
  /**
   *  Required. Database user to be used for executing the SQL.
   *  Note - Value provided should be the same as expected from
   *  `SELECT current_user;` and NOT as a resource reference.
   */
  // const user = 'abc123'
  /**
   *  Required. SQL statement to execute on database. Any valid statement is
   *  permitted, including DDL, DML, DQL statements.
   */
  // const sqlStatement = 'abc123'

  // Imports the Alloydb library
  const {AlloyDBAdminClient} = require('@google-cloud/alloydb').v1alpha;

  // Instantiates a client
  const alloydbClient = new AlloyDBAdminClient();

  async function callExecuteSql() {
    // Construct request
    const request = {
      instance,
      database,
      user,
      sqlStatement,
    };

    // Run request
    const response = await alloydbClient.executeSql(request);
    console.log(response);
  }

  callExecuteSql();
  // [END alloydb_v1alpha_generated_AlloyDBAdmin_ExecuteSql_async]
}

process.on('unhandledRejection', err => {
  console.error(err.message);
  process.exitCode = 1;
});
main(...process.argv.slice(2));