NodeJS异步等待将数据插入数据库和Google API

npm install mysql

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydb'
});

connection.connect();

function insertData(data) {
  return new Promise((resolve, reject) => {
    const query = 'INSERT INTO mytable SET ?';
    connection.query(query, data, (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
}

insertData({ name: 'John', age: 25 })
  .then(results => {
    console.log('Data inserted:', results);
  })
  .catch(error => {
    console.error('Error inserting data:', error);
  });

async function insertData(data) {
  const query = 'INSERT INTO mytable SET ?';
  return new Promise((resolve, reject) => {
    connection.query(query, data, (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
}

(async () => {
  try {
    const results = await insertData({ name: 'John', age: 25 });
    console.log('Data inserted:', results);
  } catch (error) {
    console.error('Error inserting data:', error);
  }
})();

npm install googleapis

const { google } = require('googleapis');

const client = google.auth.getClient({
  keyFile: 'path/to/keyfile.json',
  scopes: ['https://www.googleapis.com/auth/calendar']
});

function callGoogleAPI() {
  return new Promise((resolve, reject) => {
    const calendar = google.calendar({ version: 'v3', auth: client });
    calendar.events.list({
      calendarId: 'primary',
      timeMin: (new Date()).toISOString(),
      maxResults: 10,
      singleEvents: true,
      orderBy: 'startTime',
    }, (error, response) => {
      if (error) {
        reject(error);
      } else {
        resolve(response.data);
      }
    });
  });
}

callGoogleAPI()
  .then(data => {
    console.log('Google API response:', data);
  })
  .catch(error => {
    console.error('Error calling Google API:', error);
  });

async function callGoogleAPI() {
  const calendar = google.calendar({ version: 'v3', auth: client });
  return new Promise((resolve, reject) => {
    calendar.events.list({
      calendarId: 'primary',
      timeMin: (new Date()).toISOString(),
      maxResults: 10,
      singleEvents: true,
      orderBy: 'startTime',
    }, (error, response) => {
      if (error) {
        reject(error);
      } else {
        resolve(response.data);
      }
    });
  });
}

(async () => {
  try {
    const data = await callGoogleAPI();
    console.log('Google API response:', data);
  } catch (error) {
    console.error('Error calling Google API:', error);
  }
})();