使用pg-promise和bluebird的嵌套条件承诺

npm install pg-promise bluebird

const promise = require('bluebird');
const pgp = require('pg-promise')({ promiseLib: promise });

const db = pgp('postgres://username:password@host:port/database');

db.task('get-user', task => {
  return task.one('SELECT * FROM users WHERE id = $1', [userId])
    .then(user => {
      if (user.status === 'active') {
        return task.none('UPDATE users SET status = $1 WHERE id = $2', ['inactive', userId]);
      } else {
        return Promise.resolve();
      }
    });
})
  .then(() => {
    console.log('User status updated successfully');
  })
  .catch(error => {
    console.error('Error updating user status:', error);
  });