zeit/micro w/ sequelize

index.js

const Sequelize = require("sequelize");

const sequelize = new Sequelize(
  process.env.DB_NAME,
  process.env.DB_USER,
  process.env.DB_PASS,
  {
    host: process.env.DB_HOST,
    dialect: "mysql"
  }
);

sequelize.define("user", {
  id: {
    type: DataTypes.INTEGER,
    allowNull: false,
    autoIncrement: true,
    primaryKey: true
  },
  email: {
    type: DataTypes.STRING,
    allowNull: false,
    unique: true,
    validate: {
      isEmail: true
    }
  }
});

sequelize.sync(); // yes, this is an async operation :<

module.exports = async (req, res) => {
  const randomUserId = Math.round(Math.random() * 100);
  const user = await sequelize.model("user").findById(randomUserId);

  return user.get("email");
};