Auth0 の Automatic Migration を止める about livelog HOT 2 CLOSED

function login(email, password, callback) {
  //this example uses the "pg" library
  //more info here: https://github.com/brianc/node-postgres

  const bcrypt = require('bcrypt');
  const postgres = require('pg');

  postgres.connect(configuration.DATABASE_URL, function(err, client, done) {
    if (err) return callback(err);

    const query = `
        select
            users.id
            , users.email
            , users.password_digest
            , users.subscribing
            , members.id as member_id
            , members.name
            , members.joined_year
        from
            users
            join members on users.member_id = members.id
        where
            users.email = $1
            and users.password_digest is not null
    `;
    client.query(query, [email], function(err, result) {
      // NOTE: always call `done()` here to close
      // the connection to the database
      done();

      if (err || result.rows.length === 0) return callback(err || new WrongUsernameOrPasswordError(email));

      const user = result.rows[0];

      bcrypt.compare(password, user.password_digest, function(err, isValid) {
        if (err || !isValid) return callback(err || new WrongUsernameOrPasswordError(email));

        return callback(null, {
          user_id: user.id.toString(),
          name: user.name,
          email: user.email,
          email_verified: true,
          user_metadata: {
            livelog_email_notifications: user.subscribing,
          },
          app_metadata: {
            joined_year: user.joined_year,
            livelog_member_id: user.member_id,
          },
        });
      });
    });
  });
}

function loginByEmail(email, callback) {
  //this example uses the "pg" library
  //more info here: https://github.com/brianc/node-postgres

  const postgres = require('pg');

  postgres.connect(configuration.DATABASE_URL, function(err, client, done) {
    if (err) return callback(err);

    const query = `
        select
            users.id
            , users.email
            , users.password_digest
            , users.subscribing
            , members.id as member_id
            , members.name
            , members.joined_year
        from
            users
            join members on users.member_id = members.id
        where
            users.email = $1
            and users.password_digest is not null
    `;
    client.query(query, [email], function(err, result) {
      // NOTE: always call `done()` here to close
      // the connection to the database
      done();

      if (err || result.rows.length === 0) return callback(err);

      const user = result.rows[0];

      return callback(null, {
        user_id: user.id.toString(),
        name: user.name,
        email: user.email,
        email_verified: true,
        user_metadata: {
          livelog_email_notifications: user.subscribing,
        },
        app_metadata: {
          joined_year: user.joined_year,
          livelog_member_id: user.member_id,
        },
      });
    });
  });
}