使用node.js和passport.js将谷歌认证的用户保存到mysql数据库中

npm init
npm install express passport passport-google-oauth2 mysql

const express = require('express');
const passport = require('passport');
const GoogleStrategy = require('passport-google-oauth2').Strategy;
const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ' + err.stack);
    return;
  }
  console.log('Connected to MySQL database as id ' + connection.threadId);
});

passport.use(new GoogleStrategy({
  clientID: 'your_client_id',
  clientSecret: 'your_client_secret',
  callbackURL: 'http://localhost:3000/auth/google/callback'
}, (accessToken, refreshToken, profile, done) => {
  // 在这里可以处理用户认证成功后的逻辑
  // 将用户信息保存到MySQL数据库中
  const user = {
    googleId: profile.id,
    displayName: profile.displayName,
    email: profile.email
  };

  connection.query('INSERT INTO users SET ?', user, (err, result) => {
    if (err) {
      console.error('Error saving user to MySQL database: ' + err.stack);
      return done(err);
    }
    return done(null, user);
  });
}));

const app = express();

app.use(passport.initialize());
app.use(passport.session());

app.get('/auth/google', passport.authenticate('google', { scope: ['profile', 'email'] }));

app.get('/auth/google/callback', passport.authenticate('google', {
  successRedirect: '/profile',
  failureRedirect: '/login'
}));

app.get('/profile', (req, res) => {
  res.send('Welcome, ' + req.user.displayName);
});

app.get('/login', (req, res) => {
  res.send('Login failed');
});

app.listen(3000, () => {
  console.log('Server started on port 3000');
});

node app.js